This link might be helpful as well, it includes the old name of LogAnalyzer, but this doesn't matter: http://wiki.rsyslog.com/index.php/PhpLogCon_Use_cases#Enabling_the_ProcessID_ column_with_Rsyslog_and_MySQL_logging
The template variable you are looking for is %procid%. best regards, Andre Lorbach > -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Alexandre Chapellon > Sent: Dienstag, 9. August 2011 12:01 > To: [email protected] > Subject: Re: [rsyslog] loganalyser > > 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 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
