If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to REGISTER before you can post. To start viewing messages, select the forum that you want to visit from the selection below.
I can't login to the admin account for the first time.
I tried blank, and the zabbiz user password, etc.
Mysql shows that Admin is an alias for the Zabbix account, and it has a password (but since it is encrypted, I can't tell what it is - if if it is non-blank).
I am on Ubuntu Linux, and Debian had a bug report for this initial login problem last year, but allegedly it was fixed.
Again, there was a Debian bug report on this, but allegedly it was fixed.
(Debian Bug report logs - #503452 -unable to authenticate with the default login/password)
Humm, I thought I saw it in the pdf manual I got from the zabbix.com site but maybe I found it here in the forums. Either way, the default for mine was admin and zabbix. It may be different depending on where you got the install files, I used the gz file from the web site, not using apt-get or anything like that (which probably would have been much easier!)
I know almost zero about mysql, you can probably access those user accounts directly if you know enough about it and maybe clear out the password field so you can log in and reset it.
Thanks for the note - yes, I used apt-get to install, and as noted as of a few months ago it was broken, maybe still is - I'll contact that Debian package provider.
I did try to manually reset the password in the zabbix.users table, but didn't get it to work. I was of course making assumptions about how it stores passwords, and how it uses them - but it seemed logical, although wrong! :-)
I tried setting the admin passwd to both PASSWORD(''), and just '', both seem to give the same result, and neither allows ne to login with admin/(nothing).
mysql> select userid, alias, name, passwd from users;
+--------+-------+---------+----------------------------------+
| userid | alias | name | passwd |
+--------+-------+---------+----------------------------------+
| 1 | Admin | Zabbix | |
| 2 | guest | Default | d41d8cd98f00b204e9800998ecf8427e |
+--------+-------+---------+----------------------------------+
2 rows in set (0.00 sec)
It is curious to me that the name in mysql is Admin, and the documentation (and web page) say to use "admin".
[I tried both.]
I don't know if you can put that hash in through mysql and use admin/zabbix, I don't know how the authentication works and if it would be different on every installation but that's what mine looks like if I set it to admin/zabbix.
You might want to search the forums if you haven't already done it (I assume you have) because I think I've seen other people have this problem.
You guys were right, the pdf manual said admin with no password so I must have found the other combination in the forum, I had to look it up when I first set up my demo server several months ago.
Sorry I'm not much help, if using that hash doesn't get you in with admin/zabbix you'll have to rattle somebody's cage who knows zabbix better than I do - shouldn't be hard to do!
@guthrie, it looks like you may have a Debian centric problem. The Debian devs always like to do things a little differently. ;-) You may have to put an enctrypted password into the passwords table.
I don't know which function is used but if the encrypt function is the right one you would do something similar to the following
update users set passwd=encrypt('My_New_Password') where alias='Admin';
Might be a bit late for the OP, but for anyone else finding this thread...
You can reset your Zabbix admin password from MySQL thus:
Code:
USE zabbix;
UPDATE users SET passwd=md5('newpassword') WHERE alias='Admin';
Thanks, just moving off the virtual appliance with Zabbix 2.0.1 and migrated the DB accordingly, only to realise the passwords needed resetting because of the encryption. Couldn't find how to do this through MySQL in the Zabbix manual so this really helped.
I've had the same problem with Zabbix/Debian. In the end my problem was the capital "A" of "Admin" user (I was typing "admin" instead of "Admin"). "zabbix" was the default password. Debian 6 here.
I downloaded an appliance and the login to the frontend is "Admin / zabbix". at the documentation say it is "admin/zabbix". I tiny error that causes big problems!!
Comment