Great that did the trick!What should be placed in the processid? Is rsyslog sql template natively able the fill this field?
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
