Syslog-ng log viewer for Postgres
Hi All, Does anyone have any suggestions for a web based viewer like php-syslog-ng but for a Postgres backend? Regards, -- Craig Ayliffe
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@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
-- ______________________________________________________________ Clayton Dukes ______________________________________________________________
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@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
participants (3)
-
Clayton Dukes
-
Craig Ayliffe
-
Paul Robert Marino