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