Dear Ruud, You are great !!!!!
Now system is working fine :) :) I used the command: NMS:~# mysql -ujffnms -pjffnms jffnms Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 76131 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> REPAIR TABLE interfaces; +-------------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------+--------+----------+----------+ | jffnms.interfaces | repair | status | OK | +-------------------+--------+----------+----------+ 1 row in set (0.25 sec) mysql> exit Bye NMS:~# Thank you very much. Best Regards, Moshiur Rahman Khan ----- Original Message ----- From: "Ruud Hop" <[EMAIL PROTECTED]> To: <[email protected]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 20, 2007 2:01 PM Subject: Re: Need help for JFFNMS > Moshiur, > > You logged on to the wrong database. You should logon to the jffnms > database > with a user/password that has all rights for that database. So if you have > a > user jffnms with password jffnms, it should be: > mysql -ujffnms -pjffnms jffnms > > And then the repair tables command.... > > regards, > > Ruud > >> -----Oorspronkelijk bericht----- >> Date: Thu, 20 Sep 2007 12:51:03 +0600 >> From: "Moshiur Rahman Khan" <[EMAIL PROTECTED]> >> Subject: Re: [jffnms-users] Need help for JFFNMS. >> To: "Singleton,Jeff" <[EMAIL PROTECTED]>, >> <[EMAIL PROTECTED]>, <[email protected]> >> Message-ID: <[EMAIL PROTECTED]> >> Content-Type: text/plain; charset="utf-8" >> >> Dear Sir, >> >> I used the command >> >> REPAIR TABLE interfaces; >> >> in MySQL but problem is same. details are in below: Please help me. >> >> Best Regards, >> >> Moshiur Rahman Khan >> >> -------------------------------------------------- >> <------After using this command: (Error in jffnms): --------> >> 23:12:36 db_ping(mysql) Connection to DB Restored... 23:12:37 >> db_ping(mysql) Connection to DB Restored... 23:12:38 >> db_ping(mysql) Connection to DB Restored... 23:12:39 >> db_ping(mysql) Connection to DB Restored... 23:12:40 >> db_ping(mysql) Connection to DB Restored... >> Warning: join() [function.join]: Bad arguments. in >> /usr/share/jffnms/lib/api.events.inc.php on line 246 >> Query Failed - events_list() - Table './jffnms/interfaces' is >> marked as crashed and should be repaired >> >> >> <----Before using this command: (Error in jffnms):-------> >> >> "22:49:34 db_ping(mysql) Connection to DB Restored... >> 22:49:35 db_ping(mysql) Connection to DB Restored... 22:49:36 >> db_ping(mysql) Connection to DB Restored... 22:49:37 >> db_ping(mysql) Connection to DB Restored... 22:49:38 >> db_ping(mysql) Connection to DB Restored... >> Warning: join() [function.join]: Bad arguments. in >> /usr/share/jffnms/lib/api.events.inc.php on line 246 >> Query Failed - events_list() - Table './jffnms/interfaces' is >> marked as crashed and should be repaired" >> --------------------------------------------------- >> >> NMS:~# mysql -u root mysql -p >> Enter password: XXXXXXX >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 74303 >> Server version: 5.0.32-Debian_7etch1-log Debian etch distribution >> >> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >> >> mysql> show tables; >> +---------------------------+ >> | Tables_in_mysql | >> +---------------------------+ >> | columns_priv | >> | db | >> | func | >> | help_category | >> | help_keyword | >> | help_relation | >> | help_topic | >> | host | >> | proc | >> | procs_priv | >> | tables_priv | >> | time_zone | >> | time_zone_leap_second | >> | time_zone_name | >> | time_zone_transition | >> | time_zone_transition_type | >> | user | >> +---------------------------+ >> 17 rows in set (0.00 sec) >> >> mysql> REPAIR TABLE interfaces; >> +------------------+--------+----------+---------------------- >> ------------------+ >> | Table | Op | Msg_type | Msg_text >> | >> +------------------+--------+----------+---------------------- >> ------------------+ >> | mysql.interfaces | repair | error | Table >> 'mysql.interfaces' doesn't exist | >> +------------------+--------+----------+---------------------- >> ------------------+ >> 1 row in set, 1 warning (0.00 sec) >> >> >> ============================================================== >> ============================================================= >> ----- Original Message ----- >> From: "Singleton,Jeff" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Monday, September 17, 2007 12:06 AM >> Subject: Re: [jffnms-users] Need help for JFFNMS. >> >> > That is the command >> > >> > -------------------------- >> > Jeff Singleton, Network System Admin >> > Secure Computing Corp (Trusted Source) >> > C: (770)820-2909 >> > NASDAQ: SCUR >> > >> > ----- Original Message ----- >> > From: [EMAIL PROTECTED] >> > <[EMAIL PROTECTED]> >> > To: [email protected] >> <[email protected]> >> > Sent: Sun Sep 16 13:02:59 2007 >> > Subject: [jffnms-users] Need help for JFFNMS. >> > >> > Hi Craig ! Can you please tell me more details about >> > >> > "login using your MySQL database cli >> > REPAIR TABLE interfaces; >> > " >> > because I am not that much sound in MySQL. I can easily >> access database but >> > what will be the command for "REPAIR TABLE interfaces ? >> > >> > If you kindly advice me , it would be a great help for me. >> > >> > Best Regards, >> > >> > Moshiur Rahman Khan >> > >> > >> > >> > >> > Re: [jffnms-users] Requesting for support. >> > > <http://sourceforge.net/mailarchive/message.php?msg_name=20070916131137.GA13 >> 761%40enc.com.au> >> From: Craig Small <[EMAIL PROTECTED]> - 2007-09-16 13:12 >> >> >> On Sun, Sep 16, 2007 at 11:57:41AM +0600, Moshiur Rahman Khan wrote: >>> Query Failed - events_list() - Table './jffnms/interfaces' is marked as >> crashed and should be repaired" >> >> login using your MySQL database cli >> REPAIR TABLE interfaces; >> > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
