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 or webserver > view)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
