Re: [Php-syslog-ng-support] Installation guide

2007-07-30 Thread Clayton Dukes
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

2007-07-30 Thread Tapas Mallick
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

2007-07-30 Thread Vadim Pushkin
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

2007-07-30 Thread Tapas Mallick
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

2007-07-30 Thread Clayton Dukes
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

2007-07-30 Thread Tapas Mallick
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

2007-07-30 Thread Clayton Dukes
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

2007-07-30 Thread Tapas Mallick
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
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
-