can't get into SugarCRM mysql

[sugar43geek]

Using SugarCRM Community Edition 6.1.4 on a SLES server.

Two related problems: I can't get into the mysql db and I can't get phpmyadmin to open.

at /opt/sugarcrm-5.5.4/mysql/bin is enter ./mysql -u root -p and get prompted for the password. On entering the password I get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I get the same error when I try to use mysqldump.

With phpmyadmin, when I enter into Firefox: localhost/phpmyadmin, I get prompted for a username and password and have tried every possible combination that it might be. Shouldn't it be the same username and password as the mysql user?

[AlexAv]

You need to use other socket.

For example
mysql -u root -p 123 -s path to socket

[kbrill]

What stack are you using, could the first username/password be coming from an .htaccess file maybe?

If you are using the bitrock stack (it looks like you might be) is it possible that mysql is not started?

[sugar43geek]

I finally got in. For some reason--I'm guessing it has to do with how sugarcrm starts mysql--I had to use the -h 127.0.0.1 switch, based on a suggestion from a different forum.

So, from /opt/sugar..../mysql/bin> mysqldump -u root -p -h 127.0.0.1 >/home/eric/Desktop/sugar_mysql_backup.sql

Why that would be necessary I can't guess, except perhaps has something to do with how Sugarcrm runs mysql.

[sugar43geek]

@AlexAv
Acc to ps -ef, that is the "path to socket", I would think:


lagohsl03:~ # ps -ef |grep mysql*
root 3170 1 0 Jun05 ? 00:00:00 /bin/sh /opt/sugarcrm-5.5.4/mysql/bin/safe_mysqld --port=3306 --socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock --old-passwords --datadir=/opt/sugarcrm-5.5.4/mysql/data --log-error=/opt/sugarcrm-5.5.4/mysql/data/mysqld.log --pid-file=/opt/sugarcrm-5.5.4/mysql/data/mysqld.pid
mysql 3338 3170 0 Jun05 ? 00:00:00 /opt/sugarcrm-5.5.4/mysql/bin/mysqld --basedir=/opt/sugarcrm-5.5.4/mysql --datadir=/opt/sugarcrm-5.5.4/mysql/data --user=mysql --pid-file=/opt/sugarcrm-5.5.4/mysql/data/mysqld.pid --skip-external-locking --port=3306 --socket=/opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock --old-passwords
root 13044 13027 0 12:02 pts/0 00:00:00 grep mysql*
lagohsl03:~ # cd /opt/sugarcrm-5.5.4/mysql/tmp
lagohsl03:/opt/sugarcrm-5.5.4/mysql/tmp # ls

[kbrill]

Are you using the SugarStack or something, cant really tell from the paths. If not how did you load Apache/Mysql on the system?

[AlexAv]

This should help


mysql -u root -p 123 -s /opt/sugarcrm-5.5.4/mysql/tmp/mysql.sock

[sugar43geek]

From here and there I've pieced together this insight:

Apparently the mysql command line client (running 'mysql' or 'mysqldump' or other such) on linux by default looks for a socket at /tmp/mysql.sock.

Sugarcrm creates its own socket for communicating with its "pet" mysql, which is why AlexAv's suggested command-cum-socket would work.

Using the -h 127.0.0.1 switch induces the mysql command line client to make a tcp/ip connection to localhost rather than using the socket. This is what finally worked for me.

Apache, like mysql, has been installed and is running under the auspices of Sugarcrm. For example this is one of the returned processes:

root 3405 1 0 13:37 ? 00:00:00 /opt/sugarcrm-5.5.4/apache2/bin/httpd -f /opt/sugarcrm-5.5.4/apache2/conf/httpd.conf