change the (shell I assume) script to ouput to stdout instead of the mysql (just add an echo in front. Then run it and check it outputs it. If nothing is output, your problem is syslog-ng/pipe to script. If you see output then feed one of those lines into the mysql manually and see how the template is misaligned with the table structure/permissions.

-h

Hari Sekhon

Chris Killian wrote:

All

I have a script that takes the data collected by syslog-ng and inputs into mysql database, which is then viewable using something like phpsyslog. However although this works for all hosts there is one that it wont do. I can see the data coming in if and get added to the syslog log file, however will not go into the data. COuld this be down to the format that the data is received in.

Anyone got any ideas?

Regards

CK
_______________________________________________
syslog-ng maillist  -  syslog-ng@lists.balabit.hu
https://lists.balabit.hu/mailman/listinfo/syslog-ng
Frequently asked questions at http://www.campin.net/syslog-ng/faq.html

  