[syslog-ng] Syslog-ng log viewer for Postgres

[Paul Robert Marino]

try perl syslog-ng
with only a few modifications it will work with postgresql

http://sourceforge.net/projects/perl-syslog-ng/

one warning it does require a slight code modification the dropdown menu 
for the year is staticly coded and ends a few years ago
the line is number 78 in the FORMS.pm file
popup_menu(-name => "pStartYear", -value => getNumbers(2002..2004), 
-default => $tToday{year}), "</td>",
to
popup_menu(-name => "pStartYear", -value => getNumbers(2002..2012), 
-default => $tToday{year}), "</td>",

additionaly you will need to edit line 42 in the COMMON.pm file to use 
the pgsql instead of mysql
unless ($dbh = DBI->connect("DBI:mysql:$tDatabase:$tHostname", 
$tUsername, $tPassword)) {
to
unless ($dbh = DBI->connect("DBI:Pg:dbname=$tDatabase;host=$tHostname;", 
$tUsername, $tPassword)) {

Clayton Dukes wrote:
> Hi Craig,
> I know it won't help you now, but the new version (of php-syslog-ng)
> we're planning to start work on soon is planned to have support for
> pgsql (and oracle).
>
> So, if you can't find anything, keep in touch and maybe we'll have it by then.
> Sorry I didn't have a perfect answer for you :-)
>
>
> On Wed, Jul 22, 2009 at 8:03 PM, Craig Ayliffe<cayliffe at gmail.com> wrote:
>   
>> Hi All,
>>
>> Does anyone have any suggestions for a web based viewer like php-syslog-ng
>> but for a Postgres backend?
>>
>> Regards,
>>
>> --
>> Craig Ayliffe
>>
>> ______________________________________________________________________________
>> Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng
>> Documentation:
>> http://www.balabit.com/support/documentation/?product=syslog-ng
>> FAQ: http://www.campin.net/syslog-ng/faq.html
>>
>>
>>
>>     
>
>
>
>