Yes, you are right and I already fix it. I
forgot to create the table. Thanks for the response.
From: Ranjeet Kumar
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006
2:04 AM
To: [EMAIL PROTECTED]
Cc:
jffnms-users@lists.sourceforge.net
Subject: Re:Connection to DB
Restored
Gerard Gacusan,
I think you have not created
the tables in mysql database.
Please create it then you
will not get this error.
Create the Databases
Loging to MySql database and run below mentioned command. Replace x with version.
# mysql -u jffnms -pjffnms jffnms < /opt/jffnms/docs/jffnms-0.8.x.mysql
Thanks,
Ranjeet
Message: 1
Date: Mon, 21 Aug 2006
18:05:52 -0500
From: "Gerard
Gacusan" <[EMAIL PROTECTED]>
Subject: [jffnms-users]
Connection to DB Restored
To:
<[EMAIL PROTECTED]>,
<jffnms-users@lists.sourceforge.net>
Message-ID:
<[EMAIL PROTECTED]>
Content-Type: text/plain;
charset="us-ascii"
Hello,
Database is working so far
but the only thing I am getting in my status is the SNMP Module not loaded and the
GD module. When I login with admin/admin, I got this error below.
17:48:56 db_ping(mysql)
Connection to DB Restored... 17:48:57 db_ping(mysql) Connection to DB
Restored... 17:48:58 db_ping(mysql) Connection to DB Restored... 17:48:59
db_ping(mysql) Connection to DB Restored... 17:49:00
db_ping(mysql) Connection to
DB Restored... 17:49:01 db_ping(mysql) Connection to DB Restored... 17:49:02
db_ping(mysql) Connection to DB Restored... 17:49:03 db_ping(mysql) Connection
to DB Restored... 17:49:04
db_ping(mysql) Connection to
DB Restored... 17:49:05 db_ping(mysql) Connection to DB Restored... 17:49:06
db_ping(mysql) Connection to DB Restored... 17:49:07 db_ping(mysql) Connection
to DB Restored... 17:49:08
db_ping(mysql) Connection to
DB Restored... 17:49:09 db_ping(mysql) Connection to DB Restored... 17:49:10
db_ping(mysql) Connection to DB Restored... 17:49:10 Query Failed -
table_insert(events) - insert into events
(date,type,host,interface,state,username,info) VALUES ('2006-08-21
17:49:05','43','1','Login','failed','admin','from 10.10.1.66') - Table
'jffnms.events' doesn't exist17:49:11 db_ping(mysql) Connection to DB
Restored... 17:49:12 db_ping(mysql) Connection to DB Restored... 17:49:13
db_ping(mysql) Connection to
DB Restored... 17:49:14 db_ping(mysql) Connection to DB Restored... 17:49:15
db_ping(mysql) Connection to DB Restored... Query Failed - events_list() -
Table 'jffnms.hosts' doesn't exist
Thanks,
Gerard