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;
>
> --
> Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5
>
>
>
-------------------------------------------------------------------------
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
