[syslog-ng] Feeding data into MYSQL

[Hari Sekhon]

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 at lists.balabit.hu
> https://lists.balabit.hu/mailman/listinfo/syslog-ng
> Frequently asked questions at http://www.campin.net/syslog-ng/faq.html
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20070104/de70297f/attachment.htm