Fresh install. Cannot connect to the database. No such file or directory

[Del.Mar]

Hello mates!
On the step "Configure DB connection" I get an error with connection to DB (MySQL).

I've edited /etc/zabbix/zabbix_server.conf wrote user,db and password. Also add mysql socket path.
If I try to connect via console with zabbix user, login and pass works fine.
I don't have any errors with connection in /var/log/zabbix/zabbix_server.log
I can't understand where find the error. Please help!

[Markku]

Were all prerequisites met ("OK") in the previous page?

Markku

[markfree]

You are getting a Frontend error, not Server. So, you need to make sure your DB host, port, name, user and password are correctly set in this DB connection form.

I assume you are using a standalone installation, but, if your Zabbix Frontend uses a different host than MySQL, make sure your DB and user can receive connections from different hosts.

[Del.Mar]

Were all prerequisites met ("OK") in the previous page?
Markku

Yes!

You are getting a Frontend error, not Server. So, you need to make sure your DB host, port, name, user and password are correctly set in this DB connection form.
I assume you are using a standalone installation, but, if your Zabbix Frontend uses a different host than MySQL, make sure your DB and user can receive connections from different hosts.

I couldn't figure out if it was a front or back error. There was nothing in the logs, even with zabbix extended debugging enabled. All database settings were made correctly and I could connect directly to the database in the console. The database was also created and imported during the initial installation.
I've found solution. The problem was in php.ini config file with path to mysql socket. I changed today path to

mysqli.default_socket = /var/lib/mysql/mysql.sock

from

mysqli.default_socket = /run/mysql.sock

And finish installation.
Thanks for help.

[habibsalhi]

dears

After adding DBSocket= /run/mysql.sock to /etc/zabbix/zabbix_server.conf file the zabbix-server.service is active but still the same error appear;
and I restart the httpd and PHP and restart also the server but not solving the problem ??
if there is any solutions?

[vladimir_lv]

dears

After adding DBSocket= /run/mysql.sock to /etc/zabbix/zabbix_server.conf file the zabbix-server.service is active but still the same error appear;
and I restart the httpd and PHP and restart also the server but not solving the problem ??
if there is any solutions?

Are you sure that you had used the correct path to sock fille?
Just check the path:
find / -name "mysql.sock"

[tim.mooney]

After adding DBSocket= /run/mysql.sock to /etc/zabbix/zabbix_server.conf file the zabbix-server.service is active but still the same error appear;
and I restart the httpd and PHP and restart also the server but not solving the problem ??

The Zabbix web interface (the "front end") is a separate application from the Zabbix server. In large installations, the web front end may be installed on a completely separate server from the zabbix-server package(s).

Because they are separate applications, each application has a separate configuration file. The web front end does not use /etc/zabbix/zabbix_server.conf, so if you're having configuration problems with the web front end, making changes in /etc/zabbix/zabbix_server.conf is unlikely to fix anything.

If you want to specify database connection parameters for the web front end, that's done within the conf/zabbix.conf.php file that's within the Zabbix web root.

[venkatesh.samineni]

my soultion was, DBPassword no special charecter in password for zabbix DBuser