zabbix setup throws DB error, Ubuntu 16.04 64 bit, through command DB user can log

[bisana]

Hi All,
I have been trying out Zabbix installation and was successful for Ubuntu 14.04 and earlier versions also. Recently I wanted to try out with Ubuntu 16.04 64 bit. I had used the repository to install Zabbbix 3.0 on 64 bit Ubuntu 16.04

http://repo.zabbix.com/zabbix/3.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.0-1+xenial_all.deb

Now next step I created databse “zabbix” in MySQL and full permission to “zaabix” mysql user. I have checked the mysql user by logging in using command line as well as through phpadmin web interface. This way I made sure that I mysql “zabbix” user can log in and have access to “zabbix” database

For testing purpose I disabled the firewall settings by “sudo ufw disable”

Now when I do “http://localhost/zabbix/setup.php” I get error while connecting to the DB, the error message is
“Cannot connect to the database. Details
The frontend does not match Zabbix database. “

I am sure the DB credentials which I have given is correct and I have tried in different pc and instance all was giving the same result. I have been trying it on Ubuntu 16.04 64 bit

Like to request guidance and feedback from others
Thanks
Joseph John

[registration_is_lame]

I am sure the DB credentials which I have given is correct and I have tried in different pc and instance all was giving the same result. I have been trying it on Ubuntu 16.04 64 bit

Check /var/log/zabbix/zabbix_server.log

paste the last few lines (50 lines). Database version mismatch will be logged in the zabbix_server.log
There might be a chance zabbix is updating database at this point. If it has failed or updating then it'll be in logs.

Also locate zabbix.conf.php
and see if username is zabbix and your password is set.

[Atsushi]

If you are upgrading from a previous version,
the database upgrade process will start when you start the zabbix_server.

Until the database upgrade process is completed, the new version of the Web frontend is not available.

[bisana]

If you are upgrading from a previous version,
the database upgrade process will start when you start the zabbix_server.

Until the database upgrade process is completed, the new version of the Web frontend is not available.

Thanks it was a fresh install [ All the time ] it was a fresh install. Have any one tried a fresh install on Ubuntu 16.04 64bit , requesting the feedback
thanks
Joseph John

[bisana]

Check /var/log/zabbix/zabbix_server.log

paste the last few lines (50 lines). Database version mismatch will be logged in the zabbix_server.log
There might be a chance zabbix is updating database at this point. If it has failed or updating then it'll be in logs.

Also locate zabbix.conf.php
and see if username is zabbix and your password is set.

The log was empty
the zabbix.conf.php file was soft link file which was dangling, ie the soruce of the softlink was not there.
I think there is some issue with the package manager the way it installed, we need to hear from others who had done it on Ubuntu 16.04 64 bit

[registration_is_lame]

The log was empty
the zabbix.conf.php file was soft link file which was dangling, ie the soruce of the softlink was not there.
I think there is some issue with the package manager the way it installed, we need to hear from others who had done it on Ubuntu 16.04 64 bit

I'm on 16.04 64 bit. This has nothing to do with that. Don't waste time waiting... Start digging into it. Lots of them had this issue before. There are some forum posts regarding it I believe. Google! and keep Googling. That's how I resolved my issues. If you're gonna wait for a response form others, good luck for 10 days. Nobody answers on this forum. I just had this issue last week or so and so I'm aware of it.

The log shouldn't be empty... maybe its in /var/log/zabbix-server/zabbix_server.log or edit the zabbix_server.conf and make sure DebugLevel=3 (its default)
create a conf.php

example in /usr/share/doc/zabbix-frontend-php/examples/zabbix.conf.php.example

it should be created under /usr/share/zabbix/conf/

Fix the LOG file first... Enable debug level 4 if you have to or 5 since its zabbix 3.0.

It makes much more sense and easy to troubleshoot if you look at the logs