1.9.7+ Not reading zabbix_server.conf?

[sbsjclark]

I have 1.9.6 running on ubuntu 10 with mysql. It works fine except for known bugs which I am try to resolve by upgrading.

However, when I compile and install 1.9.7, /tmp/zabbix_server.log reports...

[Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' (using password: NO)

/etc/zabbix/zabbix_server.conf clearly has the DBUsername as zabbix, and so it appears the new release is not reading this config file, but may be reading another file somewhere.

I assumed this was a 1.9.7 problem, so recompiled and installed 1.9.6, and the problem was resolved. As a test, while on 1.9.6, I changed the DBUser password and verified that zabbix_server could indeed NOT connect, proving it was reading and I was modifying the correct config file.

Assuming this was a 1.9.7 release issue, I was happy to try again when 1.9.8 released, however I experienced the same issue. This time after compiling and installing 1.9.8, and getting the wrong database user error again, I decided to change the log file name in /etc/zabbix/zabbix_server.conf to /tmp/zabbix_server2.log, and as suspected it had no effect. /tmp/zabbix_server2.log was not created and the database was still failing connection due to wrong user "root@" being used.

I also tried changing the debug level in /etc/zabbix/zabbix_server.conf and saw no change in logging either, with the full log stating....
8045:20111128:195006.147 IPMI monitoring: NO
8045:20111128:195006.147 WEB monitoring: YES
8045:20111128:195006.147 Jabber notifications: NO
8045:20111128:195006.147 Ez Texting notifications: YES
8045:20111128:195006.147 ODBC: NO
8045:20111128:195006.147 SSH2 support: NO
8045:20111128:195006.147 IPv6 support: YES
8045:20111128:195006.147 ******************************
8045:20111128:195006.151 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' (using password: NO)

It seems obvious that zabbix server daemon is not looking at this config file for some reason, although one would also think that if it couldn't read it's config, and by default logged to /tmp/zabbix_server2.log and used also default logins anyway, that it would have an entry stating as much. Since it doesn't state an error reading the config in the log it is generating, it makes me think it is reading another file somewhere.

To assure there was no problem with the config file itself, I copied the template from the install source to /etc/zabbix/zabbix_server.conf and updated the database connections and enabled debug, but got the same error.

As another test I renamed /etc/zabbix/zabbix_server.conf to another name and tried starting the server daemon. Expecting an error not finding the config file, I instead got the same error. Again, I recompiled 1.9.6 and installed, and everything started fine.

Additionally, on 1.9.7 and 1.9.8, before and after copying the frontend files, I was able to login to the web interface and run the database configuration with no errors. After entering the correct database credentials zabbix configuration completed successfully.

I tried on a second system (a proxy), and had the exact same issue.

I am at loss, since I doubt seriously two versions got out with this problem not being noticed, yet I can find no record of others experincing or resolving this issue.

Any suggestions would be appreciated.

[JayJay]

Hi,

I can confirm that I am experiencing the exact same problem. It started on version 1.9.7, as you stated, and is still not fixed on 1.9.8.

What I have not tried is an update from 1.9.6 to 1.9.7/8. This may be what other users are doing.

[richlv]

http://www.zabbix.com/documentation/...on_directories

[sbsjclark]

Zabbix file locations have changed...

Thanks! I knew I was missing something.

[0siris]

hmmm.... I must be doing something wrong then:

root@zbxtst:/usr/local/etc# grep -v ^\# zabbix_server.conf | grep [a-Z]
 NodeID=1
LogFile=/tmp/zabbix_server.log
 DebugLevel=4
DBName=zabbix_db
DBUser=zabbix
 DBPassword=yes

output of /tmp/zabbix-server.log:

 11518:20121002:155003.497 Starting Zabbix Server. Zabbix 2.0.3rc2 (revision 30451).
 11518:20121002:155003.497 ****** Enabled features ******
 11518:20121002:155003.497 SNMP monitoring:           YES
 11518:20121002:155003.497 IPMI monitoring:           YES
 11518:20121002:155003.497 WEB monitoring:            YES
 11518:20121002:155003.497 Jabber notifications:      YES
 11518:20121002:155003.497 Ez Texting notifications:  YES
 11518:20121002:155003.497 ODBC:                       NO
 11518:20121002:155003.497 SSH2 support:              YES
 11518:20121002:155003.497 IPv6 support:               NO
 11518:20121002:155003.497 ******************************
 11518:20121002:155003.499 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' (using password: NO)
 11518:20121002:155003.499 Database is down. Reconnecting in 10 seconds.
 11518:20121002:155013.500 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'root'@'localhost' (using password: NO)
...and so on

My DB name is different then the name I can find in the log.... so apparently zabbix-server isn't using the configfile?
Would be nice if at startup, you can see what config file is used (or that the process is using default values because it couldn't find a config file at location x). It's just one extra line of logging

Meanwhile, I seem to have "solved" it by adding --sysconfdir=/etc/zabbix to the ./configure string

[richlv]

vote for https://support.zabbix.com/browse/ZBXNEXT-1105