Etinc Bandwidth manager problems

ganninu · 11-06-2003, 07:34 AM

I installed "successfully" the etinc bwmgr (http://www.etinc.com/bwmgr.htm) on a redhat 7.1 box. However I cannot make it interface sucessfully with MySQL server. Believe me, I tried every way and means but I still get this error:
bandwidth manager mysql cannot connect through socket

Could connect to database.
Cannot connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I've tried setting permissions and ownership (mysql) but to no avail.... Has anyone encountered this problem??????????

david_ross · 11-06-2003, 02:02 PM

It sounds like the mysql server isn't running.

ganninu · 11-06-2003, 02:38 PM

no... mysql is running, and i can actually connect to it using mysql -p and make queries to it, etc...

david_ross · 11-06-2003, 02:41 PM

Does:
/tmp/mysql.sock

exist?

ganninu · 11-07-2003, 12:27 AM

strangely enough it doesn't exist.... mysql.sock existed only in /var/lib/mysql if i remember well.

david_ross · 11-07-2003, 12:41 PM

Well you can either point your app to that sock file or chang ethe defualt on it /etc/my.cnf

ganninu · 11-10-2003, 02:43 AM

I created a sym. link to that socket but it still didn't work

Moreover, the /etc/my.cnf file doesn't exist, nor the my.cnf file when searched through all system. Neither the /etc/my.conf file exists in my system... should i create it?

ganninu · 11-10-2003, 03:45 AM

Ok i solved my problem - this is what i did - I created two files: /etc/my.cnf and /etc/my.conf (since i didn't know which one was the valid one... I'll rename one of them and by elimination i will determine which one is the valid one that mysql reads config. settings from), and added these lines:

[client]
socket=/tmp/mysql.sock

[mysqld]
socket=/tmp/mysql.sock

Believe me, i was really happy when it worked