QUOTE (krlloyd @ Sep 22 2007, 02:18 AM)

I am using the non rpm build for the beta and I am running into a mysql.sock error. I was able to see that my mysql socket name and location is different from what SYSyog expects.
So i altered my.cnf and changed it from /var/run/mysqld/mysqld.sock to /var/lib/mysql/mysql.sock and it works fine. But this fix broke phpMyAdmin.
So i need to recompile SYSyog to change the sock location? I want it to match what is on my system. Thanks!
Hi krlloyd,
I am assuming that 'your SYSyog'='our MONyog'.
There are two ways you can solve this problem on your own.
This error comes up because, if you give 'localhost' as the host, mysql client library will try to use the unix domain socket(file based) instead of the TCP one.
And every mysql client library has one path to the Unix domain socket.
In MONyog's mysql client library it is: '/var/lib/mysql/mysql.sock'
And in your "phpMyAdmin", it is '/var/run/mysqld/mysqld.sock'
So if one software works the other breaks.
To solve this problem:
1.
You can create a symbolic link to your original '/var/run/mysqld/mysqld.sock' in '/var/lib/mysql/mysql.sock'
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
The command to create this is:-
ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock
This will create a symbolic link '/var/lib/mysql/mysql.sock' to '/var/run/mysqld/mysqld.sock'
So both the applications will work.
2.
You can keep '/var/run/mysqld/mysqld.sock' as it is. And you can force MONyog to use TCP based connection specifying "127.0.0.1" as the host instead of 'localhost'