Zabbix reset password: Difference between revisions
From Newroco Tech Docs
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
<pre> | <pre> | ||
Logon to the postgreSQL with: | Logon to the postgreSQL with: | ||
<pre>sudo su postgres psql</pre> | |||
In case you don't remember the user name also use: | In case you don't remember the user name also use: | ||
<pre>select * from users;</pre> | |||
Connect to the zabbix database | Connect to the zabbix database | ||
<pre>\c zabbix</pre> | |||
Change the password of the Admin user to a blank one: | Change the password of the Admin user to a blank one: | ||
<pre>update users set passwd=md5('') where alias='Admin';</pre> | |||
You can verify this has worked by checking the password hash for the Admin user is the same as the guest user by listing the users in the users table: | You can verify this has worked by checking the password hash for the Admin user is the same as the guest user by listing the users in the users table: | ||
<pre>select * from users;</pre> | |||
NB. Logout from postgreSQL with | NB. Logout from postgreSQL with | ||
<pre>\q</pre> | |||
If it’s the same hash you should then be able to logon to the GUI with ‘Admin’ and a blank password (hopefully!) and change your password within the web GUI - hurrah! | If it’s the same hash you should then be able to logon to the GUI with ‘Admin’ and a blank password (hopefully!) and change your password within the web GUI - hurrah! | ||
If not you may need to restart the zabbix server service. On Ubuntu 16 it’s: | If not you may need to restart the zabbix server service. On Ubuntu 16 it’s: | ||
<pre>service zabbix-server restart</pre> | |||
service zabbix-server restart | |||
</pre> | |||
Revision as of 12:33, 21 August 2017
Change the Admin account for the zabbix GUI password on a system with a postgreSQL database
Logon to the postgreSQL with: <pre>sudo su postgres psql
In case you don't remember the user name also use:
select * from users;
Connect to the zabbix database
\c zabbix
Change the password of the Admin user to a blank one:
update users set passwd=md5('') where alias='Admin';
You can verify this has worked by checking the password hash for the Admin user is the same as the guest user by listing the users in the users table:
select * from users;
NB. Logout from postgreSQL with
\q
If it’s the same hash you should then be able to logon to the GUI with ‘Admin’ and a blank password (hopefully!) and change your password within the web GUI - hurrah!
If not you may need to restart the zabbix server service. On Ubuntu 16 it’s:
service zabbix-server restart
