Oops, I have the same with checksum column... what type is that column?
More generally, I created the database using the createDb.sql script contained in the rsyslog 4.6.4 tarball. Is there any other fields I need to create?
Regards. Le 09/08/2011 11:55, Andre Lorbach a écrit :
Hi, sorry I didn't read this post before. Ok this could explain why you are not seeing data using the Syslog VIEW. There is a field which was added into LogAnalyzer some time ago. Usually LogAnalyzer will automatically add missing fields into the logstream database, if the database user has sufficient rights to the table. This works of course only if the database user has sufficient rights to the table. You can manually add the field "processid" as varchar(60). Best regards, Andre Lorbach-----Original Message----- From: [email protected] [mailto:rsyslog- [email protected]] On Behalf Of Alexandre Chapellon Sent: Dienstag, 9. August 2011 11:32 To: [email protected] Subject: Re: [rsyslog] loganalyser I want to add that when I click on a log entry (when in EventLog orwebserverview)I get the following error: No syslog records found (code 8 ) - Error Details: Unknown or unhandeled error occured. Extra Error Details: ER_BAD_FIELD_ERROR - SQL Statement: ERREUR: la colonne « processid » n'existe pas LINE 1: ...mhost, infounitid, facility, priority, syslogtag, processid,... ^ Detail error: 42703;7;ERREUR: la colonne « processid » n'existe pas LINE 1: ...mhost, infounitid, facility, priority, syslogtag, processid,... ^ Error Code: 42703_______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
-- <http://www.horoa.net>
<<attachment: a_chapellon.vcf>>
_______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
