[syslog-ng] syslog-ng 3.0.1, open source edition, fails write to MySQL DB

[Balazs Scheidler]

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