I think it's the reset procedure of MySql Password but not JFFNMS. I want to change the admin password of JFFNMS web interface .
Best Regards, Moshiur Rahman Khan ----- Original Message ----- From: "Dijk, Sebastian van" <[EMAIL PROTECTED]> To: "Moshiur Rahman Khan" <[EMAIL PROTECTED]> Sent: Thursday, September 20, 2007 3:33 PM Subject: RE: [jffnms-users] Reset JFFNMS Admin password http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html Probably you'll find your answer here. Met vriendelijke groet, Sebastian van Dijk -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Moshiur Rahman Khan Verzonden: donderdag 20 september 2007 11:19 Aan: jffnms-users@lists.sourceforge.net CC: [EMAIL PROTECTED] Onderwerp: [jffnms-users] Reset JFFNMS Admin password 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 ------------------------------------------------------------------------- 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
