Thanks you very much Mr. Hop. After using the command mysql -ujffnms -pjffnms jffnms
Web Interface is working fine but Admin password is not working right now. Now I want to change admin password of web interface that's why I used the command mysql> UPDATE auth SET passwd = "123" WHERE usern = "admin"; I think this command is not suitable to change the admin password. Can you pls tell me the correct command ? ========================================================================== NMS:~# mysql -u root mysql -p Enter password: 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 76424 Server version: 5.0.32-Debian_7etch1-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> mysql> use jffnms; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> mysql> show tables; +-----------------------------+ | Tables_in_jffnms | +-----------------------------+ | acct | | actions | | alarm_states | | alarms | | auth | | autodiscovery | | clients | | events | | events_latest | | filters | | filters_cond | | filters_fields | | graph_types | | hosts | | hosts_config | | hosts_config_types | | interface_types | | interface_types_field_types | | interface_types_fields | | interfaces | | interfaces_values | | journal | | maps | | maps_interfaces | | nad_hosts | | nad_ips | | nad_networks | | pollers | | pollers_backend | | pollers_groups | | pollers_poller_groups | | profiles | | profiles_options | | profiles_values | | satellites | | severity | | slas | | slas_cond | | slas_sla_cond | | syslog | | syslog_types | | tools | | trap_receivers | | traps | | traps_varbinds | | triggers | | triggers_rules | | triggers_users | | types | | zones | +-----------------------------+ 50 rows in set (0.00 sec) mysql> mysql> show tables; +-----------------------------+ | Tables_in_jffnms | +-----------------------------+ | acct | | actions | | alarm_states | | alarms | | auth | | autodiscovery | | clients | | events | | events_latest | | filters | | filters_cond | | filters_fields | | graph_types | | hosts | | hosts_config | | hosts_config_types | | interface_types | | interface_types_field_types | | interface_types_fields | | interfaces | | interfaces_values | | journal | | maps | | maps_interfaces | | nad_hosts | | nad_ips | | nad_networks | | pollers | | pollers_backend | | pollers_groups | | pollers_poller_groups | | profiles | | profiles_options | | profiles_values | | satellites | | severity | | slas | | slas_cond | | slas_sla_cond | | syslog | | syslog_types | | tools | | trap_receivers | | traps | | traps_varbinds | | triggers | | triggers_rules | | triggers_users | | types | | zones | +-----------------------------+ 50 rows in set (0.02 sec) mysql> select * from auth; +----+---------+------------------------------------+----------------------------------+--------+ | id | usern | passwd | fullname | router | +----+---------+------------------------------------+----------------------------------+--------+ | 1 | No User | $1$tsVdymrd$i782jbsd8234bjdfhvc0-kljkjs | No User Name | 0 | | 2 | admin | $1$^bns* ljjjk$sjnjjk)Ik8hKqqIo7pYYScFSS/ | Administrator | 0 | | 3 | moshiur | $1$XhjgYesbUhjkjhasjhasfygweyuygyygjkhjkh| moshiur | 0 | +----+---------+------------------------------------+----------------------------------+--------+ 3 rows in set (0.00 sec) ------------------------------------------------------------------------- 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
