Hey Everyone:
I just wanted to pass on some learned knowledge about trying to implement
SQLAcct on CentOS 5.5 with the pre-compiled GnuGK 2.3.2.
So as a precursor, I installed mysql using yum:
*$yum install mysql*
Once all was installed and setup all dandy, and my gnugk config had my
SQLAcct stuff in it, I tried starting the server. It failed. This was the
error I continued to get:
gksql_mysql.cxx(385) SQLAcct MySQL connection to g...@localhost[data]
failed (mysql_real_connect failed): Can't connect to local MySQL server
through socket '/var/run/mysqld/mysqld.sock' (2)
After looking to make sure localhost was listening for mysql, and making
sure my iptables rules were set, it dawned on me to check for the actual
socket. So I tried to locate the "mysqld.sock". This turned up nothing.
So I decided to check "my.cnf".
This is what "my.cnf" had for the socket file:
*socket=/var/lib/mysql/mysql.sock*
So not only was it not in the location that GnuGK was looking, but it was
named different.
In summary; On CentOS 5.5, if you install MySql through yum, the MySql
socket file is named mysql.sock and is located in /var/lib/mysql which is
different than what the pre-compiled executable for GnuGK looks for, which
is mysqld.sock located in /var/run/mysqld
Hopefully someone finds this useful. :-)
Nick~
--
"They that can give up essential liberty to obtain a little safety deserve
neither liberty nor safety.." -Ben Franklin
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________________
Posting: mailto:[email protected]
Archive:
http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users
Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users
Homepage: http://www.gnugk.org/
