Hi all, I am trying to install syslog-ng + phpsyslogng in Linux box. Syslog-ng is working properly. It pipes all the log messages to a pipe file mysql.pipe in sql statement format.
But now the problem is mysql can not read from the pipe file. When I give the command: $ mysql -u sysloguser -p xxxx syslog < mysql.pipe It does not give any error message. The is no error message in MySQL log, either. When I execute the INSERT statement manually, it works. I have MySQL-server-4.1.19 installed from rpm. Can anyone tell me, what is the problem? Best Regards, Baynaa.
