Re: [Php-syslog-ng-support] Installation guide
Hi Tapas, Sounds like you're on the right track, but I'm not sure what's missing? Are you able to login to the interface and view events? On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> wrote: > > Dear List, > > I am very new to syslog-ng and php-syslog-ng. I am > trying to implement syslog-ng with php-syslog-ng on my > RHEL-4 ES system. > > I have installed syslog-ng-2.0.4-1.rpm and it is > getting log messages from remote Linux systems. I have > untar php-syslog-ng-2.9.3.c and configured apache and > run http:///install to configure the database and > syslog user/admin. Till this step the installation > goes smooth and I am getting the loging page. I have > append the ../scripts/syslog.conf content into > /etc/syslog-ng.conf. Mysql database shows that it is > getting the remote logs too in its log table. > > Could you please tell me what to do next or > step-by-step guide to finuish this project. > > Waiting for your kind help. > > Regards, > Tapas Mallick > > > > > > Luggage? GPS? Comic books? > Check out fitting gifts for grads at Yahoo! Search > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > - > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > ___ > Php-syslog-ng-support mailing list > Php-syslog-ng-support@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > -- __ C I S C O S Y S T E M S Clayton Dukes Network Management Consulting Engineer Advanced Services - Central Engineering Phone :+1 919.392.6122 Mobile :+1 813-545-7373 Fax :+1 919-869-1580 7025-3 Kitt Creek Road RTP, NC 27709-4987 __ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
[Php-syslog-ng-support] Installation guide
Dear List, I am very new to syslog-ng and php-syslog-ng. I am trying to implement syslog-ng with php-syslog-ng on my RHEL-4 ES system. I have installed syslog-ng-2.0.4-1.rpm and it is getting log messages from remote Linux systems. I have untar php-syslog-ng-2.9.3.c and configured apache and run http:///install to configure the database and syslog user/admin. Till this step the installation goes smooth and I am getting the loging page. I have append the ../scripts/syslog.conf content into /etc/syslog-ng.conf. Mysql database shows that it is getting the remote logs too in its log table. Could you please tell me what to do next or step-by-step guide to finuish this project. Waiting for your kind help. Regards, Tapas Mallick Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
Re: [Php-syslog-ng-support] New version 2.3a released
Greetings Thomas; Would there be any way to limit the hosts that a users is able to view logs from? In my environment I do not want to let the Mail Admins see the logs from the firewalls, and vice-versa. Thank you, .vp >From: "Thomas Cort" <[EMAIL PROTECTED]> >Here's a status update on the LDAP/AD login stuff I've been working on >for php-syslog-ng > >I've posted a work in progress patch that I'll update as I finish >things up. Please don't merge it just yet, I need to finish the >configuration page and get some user feedback. More details below. The >URL is: > >http://tomcort.com/patches/php-syslog-ng-2.9.3c-tcort.patch > >I made some changes to the LDAP/AD code I'd written to allow you to >define multiple authentication servers if you want. For example, you >could have user 'foo' authenticate against server 'ldap00' and user >'bar' could authenticate against 'ldap01'. As a result, I didn't have >quite enough time to finish the configuration page. I thought I'd post >the patch to show that some progress is being made and that it really >isn't vaporware. > >My patch requires some database changes. An update script is available >here: > >http://tomcort.com/patches/php-syslog-ng-2.9.3c-tcort.sql > >Since the configuration page isn't done yet, you'll need to manually >set things up in the database if you want to do any testing with my >patch. The configuration file (config.php) also needs to be updated. >I've tested the code successfully with IBM Tivoli Directory Server on >AIX 5.3 and Active Directory running on Win2k (I think). Here are the >instructions... > >config.php changes >= >add these 4 lines: > >define('AUTHSERVERSTABLENAME', 'auth_servers'); >define('USERSAUTHSERVERSTABLENAME', 'users_auth_servers'); >define('AUTHTYPESTABLENAME', 'auth_types'); >define('USERSAUTHTYPESTABLENAME', 'users_auth_types'); > >Database changes > >Run the SQL linked to above. > >For an active directory user >=== >Setup the server... >INSERT INTO auth_servers (host,binddn,user,passwd) VALUES >('DOMAIN_CONTROLLER_HOSTNAME_HERE','WINDOWS_DOMAIN_NAME_HERE','',''); > >Look up the user's id from the 'users' table and the server's id from >the auth_servers table... >SELECT id FROM users WHERE username = 'INSERT_USERNAME_HERE'; >SELECT id FROM auth_servers WHERE host = >'DOMAIN_CONTROLLER_HOSTNAME_HERE' and binddn = >'WINDOWS_DOMAIN_NAME_HERE'; > >Set the user's server >INSERT INTO users_auth_servers (userid, serverid) VALUES >('USERID_FROM_ABOVE', 'SERVERID_FROM_ABOVE'); > >Look up the user's id and the "AD" auth type id... >SELECT id FROM users WHERE username = 'INSERT_USERNAME_HERE'; >SELECT id FROM auth_types WHERE method = "AD"; > >Set the user's authentication type >INSERT INTO users_auth_types (userid,typeid) VALUES >('USERID_FROM_ABOVE', 'TYPEID_FROM_ABOVE'); > >For an ldap user >== > >Setup the server... >INSERT INTO auth_servers (host,binddn,user,passwd) VALUES >('LDAP_SERVER_HOSTNAME_HERE','BINDDN_HERE','LDAP_USER','LDAP_PASS'); > >Look up the user's id from the 'users' table and the server's id from >the auth_servers table... >SELECT id FROM users WHERE username = 'INSERT_USERNAME_HERE'; >SELECT id FROM auth_servers WHERE host = 'LDAP_SERVER_HOSTNAME_HERE' >and binddn = 'BINDDN_HERE'; > >Set the user's server >INSERT INTO users_auth_servers (userid, serverid) VALUES >('USERID_FROM_ABOVE', 'SERVERID_FROM_ABOVE'); > >Look up the user's id and the "AD" auth type id... >SELECT id FROM users WHERE username = 'INSERT_USERNAME_HERE'; >SELECT id FROM auth_types WHERE method = "LDAP"; > >Set the user's authentication type >INSERT INTO users_auth_types (userid,typeid) VALUES >('USERID_FROM_ABOVE', 'TYPEID_FROM_ABOVE'); > >- >This SF.net email is sponsored by: Splunk Inc. >Still grepping through log files to find problems? Stop. >Now Search log events and configuration files using AJAX and a browser. >Download your FREE copy of Splunk now >> http://get.splunk.com/ >___ >Php-syslog-ng-support mailing list >Php-syslog-ng-support@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
Re: [Php-syslog-ng-support] Installation guide
Hello Dukes, I can log in php-syslog-ng web interface but not getting any events. I have selected everything to display, but it shows : Top of the output Screen: "Notice: Undefined variable: msg1 in /var/www/syslogng/html/includes/regularresult.php on line 279 Use this link to reference this query directly: QUERY" In SQL query section : "SELECT SQL_CALC_FOUND_ROWS * FROM logs WHERE host in ('as-3550-2','srv-www-001') and facility in ('daemon','kern','mail') and priority in ('debug','info','notice','warning','err','crit','alert','emerg') and datetime > '2007-07-31 00:00:00' ORDER BY datetime DESC LIMIT 0, 100" Bottom of the screen: "Notice: Undefined variable: result_array in /var/www/syslogng/html/includes/regularresult.php on line 390 No results found." I think I am missing something. Please guide. CC: I have modified first line of ..scripts/syslog2mysql.sh and it looks like: config="/var/www/syslogng/html/config/config.php" and executing it in background too. Waiting for your valuable response. Regards, Tapas Mallick --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > Hi Tapas, > Sounds like you're on the right track, but I'm not > sure what's missing? > Are you able to login to the interface and view > events? > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > wrote: > > > > Dear List, > > > > I am very new to syslog-ng and php-syslog-ng. I am > > trying to implement syslog-ng with php-syslog-ng > on my > > RHEL-4 ES system. > > > > I have installed syslog-ng-2.0.4-1.rpm and it is > > getting log messages from remote Linux systems. I > have > > untar php-syslog-ng-2.9.3.c and configured apache > and > > run http:///install to configure the database > and > > syslog user/admin. Till this step the installation > > goes smooth and I am getting the loging page. I > have > > append the ../scripts/syslog.conf content into > > /etc/syslog-ng.conf. Mysql database shows that it > is > > getting the remote logs too in its log table. > > > > Could you please tell me what to do next or > > step-by-step guide to finuish this project. > > > > Waiting for your kind help. > > > > Regards, > > Tapas Mallick > > > > > > > > > > > Luggage? GPS? Comic books? > > Check out fitting gifts for grads at Yahoo! Search > > > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > > > > - > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? > Stop. > > Now Search log events and configuration files > using AJAX and a browser. > > Download your FREE copy of Splunk now >> > http://get.splunk.com/ > > ___ > > Php-syslog-ng-support mailing list > > Php-syslog-ng-support@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > > > > > > -- > __ > C I S C O S Y S T E M S > Clayton Dukes > Network Management Consulting Engineer > Advanced Services - Central Engineering > Phone :+1 919.392.6122 > Mobile :+1 813-545-7373 > Fax :+1 919-869-1580 > 7025-3 Kitt Creek Road RTP, NC 27709-4987 > __ > Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
Re: [Php-syslog-ng-support] Installation guide
Try using the dbgen.pl file to veryify that events will be displayed. This file is used to insert fake events into the database to ensure that it does have some for viewing. On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> wrote: > > Hello Dukes, > > I can log in php-syslog-ng web interface but not > getting any events. I have selected everything to > display, but it shows : > > Top of the output Screen: > "Notice: Undefined variable: msg1 in > /var/www/syslogng/html/includes/regularresult.php on > line 279 > Use this link to reference this query directly: QUERY" > > In SQL query section : > > "SELECT SQL_CALC_FOUND_ROWS * FROM logs WHERE host in > ('as-3550-2','srv-www-001') and facility in > ('daemon','kern','mail') and priority in > ('debug','info','notice','warning','err','crit','alert','emerg') > and datetime > '2007-07-31 00:00:00' ORDER BY > datetime DESC LIMIT 0, 100" > > Bottom of the screen: > "Notice: Undefined variable: result_array in > /var/www/syslogng/html/includes/regularresult.php on > line 390 > No results found." > > I think I am missing something. Please guide. > > CC: I have modified first line of > ..scripts/syslog2mysql.sh and it looks like: > config="/var/www/syslogng/html/config/config.php" and > executing it in background too. > > Waiting for your valuable response. > > Regards, > Tapas Mallick > > > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > Hi Tapas, > > Sounds like you're on the right track, but I'm not > > sure what's missing? > > Are you able to login to the interface and view > > events? > > > > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > > wrote: > > > > > > Dear List, > > > > > > I am very new to syslog-ng and php-syslog-ng. I am > > > trying to implement syslog-ng with php-syslog-ng > > on my > > > RHEL-4 ES system. > > > > > > I have installed syslog-ng-2.0.4-1.rpm and it is > > > getting log messages from remote Linux systems. I > > have > > > untar php-syslog-ng-2.9.3.c and configured apache > > and > > > run http:///install to configure the database > > and > > > syslog user/admin. Till this step the installation > > > goes smooth and I am getting the loging page. I > > have > > > append the ../scripts/syslog.conf content into > > > /etc/syslog-ng.conf. Mysql database shows that it > > is > > > getting the remote logs too in its log table. > > > > > > Could you please tell me what to do next or > > > step-by-step guide to finuish this project. > > > > > > Waiting for your kind help. > > > > > > Regards, > > > Tapas Mallick > > > > > > > > > > > > > > > > > > > Luggage? GPS? Comic books? > > > Check out fitting gifts for grads at Yahoo! Search > > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > > > > > > > > - > > > This SF.net email is sponsored by: Splunk Inc. > > > Still grepping through log files to find problems? > > Stop. > > > Now Search log events and configuration files > > using AJAX and a browser. > > > Download your FREE copy of Splunk now >> > > http://get.splunk.com/ > > > ___ > > > Php-syslog-ng-support mailing list > > > Php-syslog-ng-support@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > > > > > > > > > > > -- > > > __ > > C I S C O S Y S T E M S > > Clayton Dukes > > Network Management Consulting Engineer > > Advanced Services - Central Engineering > > Phone :+1 919.392.6122 > > Mobile :+1 813-545-7373 > > Fax :+1 919-869-1580 > > 7025-3 Kitt Creek Road RTP, NC 27709-4987 > > > __ > > > > > > > > > Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user > panel and lay it on us. > http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 > > -- __ C I S C O S Y S T E M S Clayton Dukes Network Management Consulting Engineer Advanced Services - Central Engineering Phone :+1 919.392.6122 Mobile :+1 813-545-7373 Fax :+1 919-869-1580 7025-3 Kitt Creek Road RTP, NC 27709-4987 __ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/___ Php-syslog-ng-support mailing list Php-syslog-ng-support@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
Re: [Php-syslog-ng-support] Installation guide
Hi, # perl dbgen.pl show the error as follows: Can't locate Net/MySQL.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/i686-linux /usr/local/lib/perl5/5.8.8 /usr/local/lib/perl5/site_perl/5.8.8/i686-linux /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl .) at dbgen.pl line 22. BEGIN failed--compilation aborted at dbgen.pl line 22. Regards, Tapas --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > Try using the dbgen.pl file to veryify that events > will be displayed. > This file is used to insert fake events into the > database to ensure that it > does have some for viewing. > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > wrote: > > > > Hello Dukes, > > > > I can log in php-syslog-ng web interface but not > > getting any events. I have selected everything to > > display, but it shows : > > > > Top of the output Screen: > > "Notice: Undefined variable: msg1 in > > /var/www/syslogng/html/includes/regularresult.php > on > > line 279 > > Use this link to reference this query directly: > QUERY" > > > > In SQL query section : > > > > "SELECT SQL_CALC_FOUND_ROWS * FROM logs WHERE > host in > > ('as-3550-2','srv-www-001') and facility in > > ('daemon','kern','mail') and priority in > > > ('debug','info','notice','warning','err','crit','alert','emerg') > > and datetime > '2007-07-31 00:00:00' ORDER BY > > datetime DESC LIMIT 0, 100" > > > > Bottom of the screen: > > "Notice: Undefined variable: result_array in > > /var/www/syslogng/html/includes/regularresult.php > on > > line 390 > > No results found." > > > > I think I am missing something. Please guide. > > > > CC: I have modified first line of > > ..scripts/syslog2mysql.sh and it looks like: > > config="/var/www/syslogng/html/config/config.php" > and > > executing it in background too. > > > > Waiting for your valuable response. > > > > Regards, > > Tapas Mallick > > > > > > > > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > > > Hi Tapas, > > > Sounds like you're on the right track, but I'm > not > > > sure what's missing? > > > Are you able to login to the interface and view > > > events? > > > > > > > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > Dear List, > > > > > > > > I am very new to syslog-ng and php-syslog-ng. > I am > > > > trying to implement syslog-ng with > php-syslog-ng > > > on my > > > > RHEL-4 ES system. > > > > > > > > I have installed syslog-ng-2.0.4-1.rpm and it > is > > > > getting log messages from remote Linux > systems. I > > > have > > > > untar php-syslog-ng-2.9.3.c and configured > apache > > > and > > > > run http:///install to configure the > database > > > and > > > > syslog user/admin. Till this step the > installation > > > > goes smooth and I am getting the loging page. > I > > > have > > > > append the ../scripts/syslog.conf content into > > > > /etc/syslog-ng.conf. Mysql database shows that > it > > > is > > > > getting the remote logs too in its log table. > > > > > > > > Could you please tell me what to do next or > > > > step-by-step guide to finuish this project. > > > > > > > > Waiting for your kind help. > > > > > > > > Regards, > > > > Tapas Mallick > > > > > > > > > > > > > > > > > > > > > > > > > > > > Luggage? GPS? Comic books? > > > > Check out fitting gifts for grads at Yahoo! > Search > > > > > > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > > > > > > > > > > > > > - > > > > This SF.net email is sponsored by: Splunk Inc. > > > > Still grepping through log files to find > problems? > > > Stop. > > > > Now Search log events and configuration files > > > using AJAX and a browser. > > > > Download your FREE copy of Splunk now >> > > > http://get.splunk.com/ > > > > > ___ > > > > Php-syslog-ng-support mailing list > > > > Php-syslog-ng-support@lists.sourceforge.net > > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > > > > > > > > > > > > > > > > -- > > > > > > __ > > > C I S C O S Y S T E M S > > > Clayton Dukes > > > Network Management Consulting Engineer > > > Advanced Services - Central Engineering > > > Phone :+1 919.392.6122 > > > Mobile :+1 813-545-7373 > > > Fax :+1 919-869-1580 > > > 7025-3 Kitt Creek Road RTP, NC 27709-4987 > > > > > > __ > > > > > > > > > > > > > > > > Fussy? Opinionated? Impossible to please? Perfect. > Join Yahoo!'s user > > panel and lay it on us. > > > http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 > > > > > > > -- > __ > C I S C O S Y S T E M S > Cl
Re: [Php-syslog-ng-support] Installation guide
That means you are missing the perl library, do a search on cpan for it :-) On 7/31/07, Tapas Mallick <[EMAIL PROTECTED]> wrote: > > Hi, > > # perl dbgen.pl show the error as follows: > > Can't locate Net/MySQL.pm in @INC (@INC contains: > /usr/local/lib/perl5/5.8.8/i686-linux > /usr/local/lib/perl5/5.8.8 > /usr/local/lib/perl5/site_perl/5.8.8/i686-linux > /usr/local/lib/perl5/site_perl/5.8.8 > /usr/local/lib/perl5/site_perl .) at dbgen.pl line 22. > BEGIN failed--compilation aborted at dbgen.pl line 22. > > > Regards, > Tapas > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > Try using the dbgen.pl file to veryify that events > > will be displayed. > > This file is used to insert fake events into the > > database to ensure that it > > does have some for viewing. > > > > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > > wrote: > > > > > > Hello Dukes, > > > > > > I can log in php-syslog-ng web interface but not > > > getting any events. I have selected everything to > > > display, but it shows : > > > > > > Top of the output Screen: > > > "Notice: Undefined variable: msg1 in > > > /var/www/syslogng/html/includes/regularresult.php > > on > > > line 279 > > > Use this link to reference this query directly: > > QUERY" > > > > > > In SQL query section : > > > > > > "SELECT SQL_CALC_FOUND_ROWS * FROM logs WHERE > > host in > > > ('as-3550-2','srv-www-001') and facility in > > > ('daemon','kern','mail') and priority in > > > > > > ('debug','info','notice','warning','err','crit','alert','emerg') > > > and datetime > '2007-07-31 00:00:00' ORDER BY > > > datetime DESC LIMIT 0, 100" > > > > > > Bottom of the screen: > > > "Notice: Undefined variable: result_array in > > > /var/www/syslogng/html/includes/regularresult.php > > on > > > line 390 > > > No results found." > > > > > > I think I am missing something. Please guide. > > > > > > CC: I have modified first line of > > > ..scripts/syslog2mysql.sh and it looks like: > > > config="/var/www/syslogng/html/config/config.php" > > and > > > executing it in background too. > > > > > > Waiting for your valuable response. > > > > > > Regards, > > > Tapas Mallick > > > > > > > > > > > > > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > > > > > Hi Tapas, > > > > Sounds like you're on the right track, but I'm > > not > > > > sure what's missing? > > > > Are you able to login to the interface and view > > > > events? > > > > > > > > > > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > > > > wrote: > > > > > > > > > > Dear List, > > > > > > > > > > I am very new to syslog-ng and php-syslog-ng. > > I am > > > > > trying to implement syslog-ng with > > php-syslog-ng > > > > on my > > > > > RHEL-4 ES system. > > > > > > > > > > I have installed syslog-ng-2.0.4-1.rpm and it > > is > > > > > getting log messages from remote Linux > > systems. I > > > > have > > > > > untar php-syslog-ng-2.9.3.c and configured > > apache > > > > and > > > > > run http:///install to configure the > > database > > > > and > > > > > syslog user/admin. Till this step the > > installation > > > > > goes smooth and I am getting the loging page. > > I > > > > have > > > > > append the ../scripts/syslog.conf content into > > > > > /etc/syslog-ng.conf. Mysql database shows that > > it > > > > is > > > > > getting the remote logs too in its log table. > > > > > > > > > > Could you please tell me what to do next or > > > > > step-by-step guide to finuish this project. > > > > > > > > > > Waiting for your kind help. > > > > > > > > > > Regards, > > > > > Tapas Mallick > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Luggage? GPS? Comic books? > > > > > Check out fitting gifts for grads at Yahoo! > > Search > > > > > > > > > > > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > > > > > > > > > > > > > > > > > > > - > > > > > This SF.net email is sponsored by: Splunk Inc. > > > > > Still grepping through log files to find > > problems? > > > > Stop. > > > > > Now Search log events and configuration files > > > > using AJAX and a browser. > > > > > Download your FREE copy of Splunk now >> > > > > http://get.splunk.com/ > > > > > > > ___ > > > > > Php-syslog-ng-support mailing list > > > > > Php-syslog-ng-support@lists.sourceforge.net > > > > > > > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > __ > > > > C I S C O S Y S T E M S > > > > Clayton Dukes > > > > Network Management Consulting Engineer > > > > Advanced Services - Central Engineering > > > > Phone :+1 919.392.6122 > > > > Mobile :+1 813-545-7373 > > > > Fax :+1 919-869-1580 > > > > 7025-3 Kitt Creek Road RTP,
Re: [Php-syslog-ng-support] Installation guide
Hi, I have update the Net::MySQL module from cpan. Now when I execute the dbgen.pl script it shows: Debug off, showing only inserted data... Host: linux-40-tN6 Facility: local1 Priority: debug Level: notice Tag: Tag YMDHMS: 2007-07-31 05:47:12 Program: Test Script Message: %C6KENV-2-FANUPGREQ: Fan 1 had a rotation error reported. Affected row: 0 send: Cannot determine peer address at /usr/local/lib/perl5/site_perl/5.8.8/Net/MySQL.pm line 293 === Plesae debug. Regards, Tapas --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > That means you are missing the perl library, do a > search on cpan for it :-) > > > On 7/31/07, Tapas Mallick <[EMAIL PROTECTED]> > wrote: > > > > Hi, > > > > # perl dbgen.pl show the error as follows: > > > > Can't locate Net/MySQL.pm in @INC (@INC contains: > > /usr/local/lib/perl5/5.8.8/i686-linux > > /usr/local/lib/perl5/5.8.8 > > /usr/local/lib/perl5/site_perl/5.8.8/i686-linux > > /usr/local/lib/perl5/site_perl/5.8.8 > > /usr/local/lib/perl5/site_perl .) at dbgen.pl line > 22. > > BEGIN failed--compilation aborted at dbgen.pl line > 22. > > > > > > Regards, > > Tapas > > > > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > > > Try using the dbgen.pl file to veryify that > events > > > will be displayed. > > > This file is used to insert fake events into the > > > database to ensure that it > > > does have some for viewing. > > > > > > > > > On 7/30/07, Tapas Mallick <[EMAIL PROTECTED]> > > > wrote: > > > > > > > > Hello Dukes, > > > > > > > > I can log in php-syslog-ng web interface but > not > > > > getting any events. I have selected everything > to > > > > display, but it shows : > > > > > > > > Top of the output Screen: > > > > "Notice: Undefined variable: msg1 in > > > > > /var/www/syslogng/html/includes/regularresult.php > > > on > > > > line 279 > > > > Use this link to reference this query > directly: > > > QUERY" > > > > > > > > In SQL query section : > > > > > > > > "SELECT SQL_CALC_FOUND_ROWS * FROM logs WHERE > > > host in > > > > ('as-3550-2','srv-www-001') and facility in > > > > ('daemon','kern','mail') and priority in > > > > > > > > > > ('debug','info','notice','warning','err','crit','alert','emerg') > > > > and datetime > '2007-07-31 00:00:00' ORDER > BY > > > > datetime DESC LIMIT 0, 100" > > > > > > > > Bottom of the screen: > > > > "Notice: Undefined variable: result_array in > > > > > /var/www/syslogng/html/includes/regularresult.php > > > on > > > > line 390 > > > > No results found." > > > > > > > > I think I am missing something. Please guide. > > > > > > > > CC: I have modified first line of > > > > ..scripts/syslog2mysql.sh and it looks like: > > > > > config="/var/www/syslogng/html/config/config.php" > > > and > > > > executing it in background too. > > > > > > > > Waiting for your valuable response. > > > > > > > > Regards, > > > > Tapas Mallick > > > > > > > > > > > > > > > > > > > > --- Clayton Dukes <[EMAIL PROTECTED]> wrote: > > > > > > > > > Hi Tapas, > > > > > Sounds like you're on the right track, but > I'm > > > not > > > > > sure what's missing? > > > > > Are you able to login to the interface and > view > > > > > events? > > > > > > > > > > > > > > > On 7/30/07, Tapas Mallick > <[EMAIL PROTECTED]> > > > > > wrote: > > > > > > > > > > > > Dear List, > > > > > > > > > > > > I am very new to syslog-ng and > php-syslog-ng. > > > I am > > > > > > trying to implement syslog-ng with > > > php-syslog-ng > > > > > on my > > > > > > RHEL-4 ES system. > > > > > > > > > > > > I have installed syslog-ng-2.0.4-1.rpm and > it > > > is > > > > > > getting log messages from remote Linux > > > systems. I > > > > > have > > > > > > untar php-syslog-ng-2.9.3.c and configured > > > apache > > > > > and > > > > > > run http:///install to configure the > > > database > > > > > and > > > > > > syslog user/admin. Till this step the > > > installation > > > > > > goes smooth and I am getting the loging > page. > > > I > > > > > have > > > > > > append the ../scripts/syslog.conf content > into > > > > > > /etc/syslog-ng.conf. Mysql database shows > that > > > it > > > > > is > > > > > > getting the remote logs too in its log > table. > > > > > > > > > > > > Could you please tell me what to do next > or > > > > > > step-by-step guide to finuish this > project. > > > > > > > > > > > > Waiting for your kind help. > > > > > > > > > > > > Regards, > > > > > > Tapas Mallick > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Luggage? GPS? Comic books? > > > > > > Check out fitting gifts for grads at > Yahoo! > > > Search > > > > > > > > > > > > > > > > > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz > > > > > > > > > > > > > > > > > > > > > > > > > > > -