Parameter is not running after migration to 2.0

[pccruz]

Dear,

I have a problem after I updated my environment zabbix from 1.8 to 2.0 I realized that my dashboard in the value of the parameter value is "NO" that is not already running.

And it's weird, because I already took a look at
/etc/zabbix/zabbix_server.conf and this right, this one with the same
user and password set on the first installation, did not move at all.

DBUser=zabbix

### Option: DBPassword
# Database password. Ignored for SQLite.
# Comment this line if no password is used.
#
# Mandatory: no
# Default:
DBPassword=zabbix

Depois dei o comando:

[root@omega ~]# ps -ef | grep mysql
root 2640 1 0 May30 ? 00:00:00 /bin/sh
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
--socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log
--pid-file=/var/run/mysqld/mysqld.pid --user=mysql
mysql 2690 2640 0 May30 ? 00:00:05 /usr/libexec/mysqld
--basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking
--socket=/var/lib/mysql/mysql.sock
root 11967 11037 0 09:06 pts/0 00:00:00 grep mysql

Another test performed:

[root@omega ~]# 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 6453
Server version: 5.0.95 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show tables;
+-----------------------+
| Tables_in_zabbix |
+-----------------------+
| acknowledges |
| actions |
| alerts |
| applications |
| auditlog |
| auditlog_details |
| autoreg_host |
| conditions |
| config |
| dchecks |
| dhosts |
| drules |
| dservices |
| escalations |
| events |
| expressions |
| functions |
| globalmacro |
| globalvars |
| graph_discovery |
| graph_theme |
| graphs |
| graphs_items |
| groups |
| help_items |
| history |
| history_log |
| history_str |
| history_str_sync |
| history_sync |
| history_text |
| history_uint |
| history_uint_sync |
| host_inventory |
| hostmacro |
| hosts |
| hosts_groups |
| hosts_templates |
| housekeeper |
| httpstep |
| httpstepitem |
| httptest |
| httptestitem |
| icon_map |
| icon_mapping |
| ids |
| images |
| interface |
| item_discovery |
| items |
| items_applications |
| maintenances |
| maintenances_groups |
| maintenances_hosts |
| maintenances_windows |
| mappings |
| media |
| media_type |
| node_cksum |
| nodes |
| opcommand |
| opcommand_grp |
| opcommand_hst |
| opconditions |
| operations |
| opgroup |
| opmessage |
| opmessage_grp |
| opmessage_usr |
| optemplate |
| profiles |
| proxy_autoreg_host |
| proxy_dhistory |
| proxy_history |
| regexps |
| rights |
| screens |
| screens_items |
| scripts |
| service_alarms |
| services |
| services_links |
| services_times |
| sessions |
| slides |
| slideshows |
| sysmap_element_url |
| sysmap_url |
| sysmaps |
| sysmaps_elements |
| sysmaps_link_triggers |
| sysmaps_links |
| timeperiods |
| trends |
| trends_uint |
| trigger_depends |
| trigger_discovery |
| triggers |
| user_history |
| users |
| users_groups |
| usrgrp |
| valuemaps |
+-----------------------+
103 rows in set (0.00 sec)

And I see that the root is not connecting to mysql database ...

[Root @ omega sbin] # tail / tmp / zabbix_server.log
2480:20120531:102204.365 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root' @ 'localhost' (using password: NO)
2480:20120531:102204.365 Database is down. Reconnecting in 10 seconds.
2480:20120531:102214.367 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root' @ 'localhost' (using password: NO)
2480:20120531:102214.367 Database is down. Reconnecting in 10 seconds.
2480:20120531:102224.370 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root' @ 'localhost' (using password: NO)
2480:20120531:102224.370 Database is down. Reconnecting in 10 seconds.
2480:20120531:102234.372 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root' @ 'localhost' (using password: NO)
2480:20120531:102234.372 Database is down. Reconnecting in 10 seconds.
2480:20120531:102244.375 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root' @ 'localhost' (using password: NO)
2480:20120531:102244.375 Database is down. Reconnecting in 10 seconds

Can anyone give me a help?

[pccruz]

Parameter is not running after migration to 2.0

By default Zabbix 2.0.0 does not consider the settings made in files that are inside the directory /etc/zabbix. He believes that the files are in /usr/local/etc.

So I copied the configuration file /etc/zabbix to /usr/local/etc/. After restarted the agent and the Zabbix server but to no avail.

[andreazza]

hi did you fix it?

first copy zabbix_server.conf and zabbix_agentd.conf to /usr/local/etc/

check in /tmp/zabbix_server.log if there is no error in mysql...
this configuration is inside zabbix_server.conf
DBName=zabbix
DBUser= your mysql user...
DBPassword= password that you configured..
DBSocket=/var/lib/mysql/mysql.sock

it should work... but, if still dont work try set selinux to permissive:
vi /etc/selinux/config
SELINUX=permissive

reboot you server... it will probably work.

[ploochan]

thank you! that worked!
for some reason I had no password writen

[tchjts1]

it should work... but, if still dont work try set selinux to permissive:
vi /etc/selinux/config
SELINUX=permissive

reboot you server... it will probably work.

An alternative to rebooting your server, is to temporarily disable selinux using this command: (selinux will go back to being enforced on next reboot)

Run as root:
echo 0 > /selinux/enforce

No reboot needed for this to take affect, but again, it is only temporary until next reboot. Good for testing purposes.