Query on Mariadb Charm Deployment on Ubuntu Power ppc64le

[Kevin Monroe]

Hi Prabakaran,

If you executed these commands as written, you were trying to run mysql on
your juju host machine (versus the mariadb unit):

*Commands:*
*juju deploy mariadb*
*juju set mariadb dataset-size="256M"*
*mys**ql -u root -p$(sudo cat /var/lib/mysql/mysql.passwd)*

I think you just need to preface that 3rd command with 'juju run
--service=mariadb'.  I was able to deploy, set config, and verify on
ppc64le using this in place of your 3rd command:

$ juju run --service=mariadb 'mysql -u root -p$(sudo cat
/var/lib/mysql/mysql.passwd) -e status'
--------------
mysql  Ver 15.1 Distrib 5.5.46-MariaDB, for debian-linux-gnu (ppc64le)
using readline 5.2

Connection id: 28
Current database:
Current user: root at localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 5.5.46-MariaDB-1ubuntu0.14.04.2-log (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db     characterset: latin1
Client characterset: latin1
Conn.  characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 38 sec

Hopefully that helps!
-Kevin

On Wed, Dec 9, 2015 at 5:25 AM, Prabakaran Chandrasekaran <
prabacha at in.ibm.com> wrote:

> Hello Team,
>
> I have deployed Mariadb charm from charm store on Ubuntu Power ppc64le.
>
> Post deployment I got it into the container where mariadb is installed and
> tried to access Mariadb by running the command "*mysql -u root -p$(sudo
> cat /var/lib/mysql/mysql.passwd)*" and I was getting an error stating "*ERROR
> 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)*". Below are the command which i ran to
> deploy and check mariadb.
>
> *Commands:*
> * juju deploy mariadb*
> * juju set mariadb dataset-size="256M"*
> *mys**ql -u root -p$(sudo cat /var/lib/mysql/mysql.passwd)*
>
> *Charm Link* : https://jujucharms.com/mariadb/
>
> Can you give me some directions on how to resolve this issue? And also
> advise should i raise bug against this charm?
>
> *Note:* *I am facing this issue while deploying mariadb charm in Power
> machine only*
>
> Thanks and Regards,
> Prabakaran
>
>
>
> --
> Juju mailing list
> Juju at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/juju
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/juju/attachments/20151209/63ec4e3e/attachment.html>