On Mon, Jul 02, 2007 at 11:04:37AM -0500, Smith, Jeff wrote:
> C:\jffnms\engine>consolidate.php
> Cannot find module (IP-MIB): At line 0 in (none)
> Cannot find module (IF-MIB): At line 0 in (none)
Oh dear, none of the SNMP modules can be found. This should not be
too much of a problem.. but

> 10:15:50 db_ping(mysql) Connection to DB Restored...
> 10:15:51 db_ping(mysql) Connection to DB Restored...
> 10:15:52 db_ping(mysql) Connection to DB Restored...
> 10:15:53 db_ping(mysql) Connection to DB Restored...
> 10:15:54 db_ping(mysql) Connection to DB Restored...
> Query failed - TAC1
> C:\jffnms\engine>
That's the problem.

Run this query in a mysql command line tool:
SELECT  acct.id as id_tacacs, acct.date,acct.usern as value_user, acct.c_name 
as source_ip, acct.elapsed_time, acct.type, acct.cmd as command, hosts.id as 
id_host FROM    acct, hosts WHERE   (hosts.ip_tacacs = acct.s_name OR hosts.ip 
= acct.s_name) AND analized = 0 ORDER BY acct.id asc

 - Craig
(It's best to send replies to the list, that way others can benefit  if
they get this problem and I know where to find it)
-- 
Craig Small      GnuPG:1C1B D893 1418 2AF4 45EE  95CB C76C E5AC 12CA DFA5
http://www.enc.com.au/                             csmall at : enc.com.au
http://www.debian.org/          Debian GNU/Linux, software should be Free 

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
jffnms-users mailing list
jffnms-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jffnms-users

Reply via email to