[syslog-ng]Issues logging into MySQL - SOLVED

[Ronnie Clark]

I found a solution. I ended up having to make some minor edits on the
SQLsyslogd.c file before I could even compile. Now, it is working just fine.

Thanks,
Ron Clark
rclark@brookshadow.net


-----Original Message-----
From: syslog-ng-admin@lists.balabit.hu
[mailto:syslog-ng-admin@lists.balabit.hu] On Behalf Of Ronnie Clark
Sent: Tuesday, November 16, 2004 10:33 AM
To: syslog-ng@lists.balabit.hu
Cc: Ronnie Clark
Subject: [syslog-ng]Issues logging into MySQL

Hello all, 

I have a system loaded with FreeBSD 4.10 STABLE and syslog-ng, logging into
MySQL. I have used the templates for syslog-ng and syslog-ng2. The issue is
that now the time and machine name fields are correct, but the first few
characters of the actual message are being chopped off. 
Examples: 
yslog-ng version 1.6.5 going down
eboot by rclark:
AD SU rclark to root on /dev/ttyv0
TATS: dropped 0

Is there a fix for this? 

I also have tried to compile and load the same sqlsyslogd for syslog-ng on
FreeBSD 5.3, but get the following errors:
sqlsyslogd.c: In function `usage':
sqlsyslogd.c:38: error: missing terminating "
character
sqlsyslogd.c:39: error: stray '\' in program
sqlsyslogd.c:39: error: syntax error before "n"
sqlsyslogd.c:39: error: stray '\' in program
sqlsyslogd.c:39: error: missing terminating "
character
sqlsyslogd.c: In function `main':
sqlsyslogd.c:162: error: missing terminating "
character
sqlsyslogd.c:163: error: syntax error before '%' token
sqlsyslogd.c:163: error: stray '\' in program
sqlsyslogd.c:163: error: missing terminating "
character
sqlsyslogd.c:191: error: missing terminating "
character
sqlsyslogd.c:192: error: syntax error before '%' token
sqlsyslogd.c:192:42: warning: character constant too long for its type
sqlsyslogd.c:192:54: warning: multi-character character constant
sqlsyslogd.c:192: error: missing terminating "
character
*** Error code 1

Anyone else have this running on FreeBSD 5.3 Release or STABLE?

Thanks in advance,
Ron Clark


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
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