Checksum is an integer field, there should be no more other new fields
> -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Alexandre Chapellon > Sent: Dienstag, 9. August 2011 12:07 > To: [email protected] > Subject: Re: [rsyslog] loganalyser > > 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 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 > > -- > <http://www.horoa.net> _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
