Web interface

[omikron]

Hi i just managed to start Zabbix but i`m having trouble logging in.

I've edited the mysql settings and according to the manual i should use Admin followed by a blank password. Well it's not working.

See http://monitor.webgesture.com/

P.S.: register_globals are off, safe mode temporarily Off

[James Wells]

Greetings,

I am thinking that you still have the $DB_TYPE entry commented out. If that is not the case, then use the command line sql tool to attempt to connect to the database using the settings as listed in the include/db.inc.php

Generally when you have that error, it is indicating that the Zabbix PHP UI is unable to talk to the database.

[omikron]

I have $DB_TYPE ="MYSQL";

[root@monitor httpdocs]# mysql -u zabbix -p zabbix
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 914 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables
-> ;
+------------------+
| Tables_in_zabbix |
+------------------+
| actions |
| alarms |
| alerts |
| audit |
| config |
| escalation_log |
| escalation_rules |
| escalations |
| functions |
| graphs |
| graphs_items |
| groups |
| history |
| history_log |
| history_str |
| hosts |
| hosts_groups |
| hosts_profiles |
| hosts_templates |
| images |
| items |
| media |
| media_type |
| profiles |
| rights |
| screens |
| screens_items |
| service_alarms |
| services |
| services_links |
| sessions |
| stats |
| sysmaps |
| sysmaps_hosts |
| sysmaps_links |
| trends |
| trigger_depends |
| triggers |
| users |
| users_groups |
| usrgrp |
+------------------+
41 rows in set (0.01 sec)

mysql>

[marc]

another common mistake.. do you have data.sql imported 2?
there are 2 .sql files, one for strcutures wich is obviously imported, but how about the data.sql?
select * from users;
any admin record in the table?

[Nate Bell]

Since your version of Zabbix shows you have the trigger and item templates installed, it looks like you added data.sql to your database. If you haven't already fixed your problem, you might look at the users table in mysql. Make sure the Admin user does not have a password set, or if they do, then run: update users set passwd = '' where alias = 'Admin'; to erase the password.

Nate