On Thu, 2009-04-23 at 21:01 +0000, Arnold Wang wrote:
I figured out the problem. I have to use "host="127.0.0.1" to force it using TCP connection. I have tried "(host="localhost", port=("3306")" and it didn't work neither. I guess it is hard coded to use socket for localhost which seems reasonable. There is a related question on this. If I want to use socket connection, how can I specify the socket file? It is by default using "/var/run/mysqld/mysqld.sock" which is different than the one in RHEL.
The binaries we supply use the libmysqlclient binaries copied from Debian, thus it uses the default UNIX domain socket from Debian, that might differ from RHEL. However you can override the path to the UNIX domain socket by setting the MYSQL_UNIX_PORT environment variable before starting syslog-ng. -- Bazsi