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]>, <jffnms-users@lists.sourceforge.net> > 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: jffnms-users@lists.sourceforge.net > <jffnms-users@lists.sourceforge.net> > > 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 jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
