The DBMS server said: SQLSTATE[HY000] [2002] error while installing Dadabik10

johan

Member
Hello Euginio,

Today I tried to make an new Hyper-V Windows 10pro VM with an new installation of Dadabik.
And I run into an arror I can't fix.


######################################
Requirements check
Current PHP version: 7.3.12 OK

mbsgtring extension: Installed

ioncube extension: Installed

ioncube extension version: 10.3 OK

Check DB connection: [06] Error: during database connection. Please check $host, $user, $pass and $db_name in your config.php
The DBMS server said: SQLSTATE[HY000] [2002]
######################################

I have tried a lot and googled a lot but nothing seems to work.

I can connect to the mysql database with phpmyadmin, and made a whole new DB.
it seems to be a connection issue, but i can't see the problem.
I tried to add apache/php/mysql to the windows firewall whitout succes.

Does the application use poort 3306 for the connection to the database or 3308?
I tried to set 3308 in the php.ini file, but is still not works.

######################################
php.info:
mysqli
MysqlI Support enabled
Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
Directive Local Value Master Value
mysqli.allow_local_infile Off Off
mysqli.allow_persistent On On
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.max_persistent Unlimited Unlimited
mysqli.reconnect Off Off
mysqli.rollback_on_cached_plink Off Off
########################################
What can I do?

regards Johan
 

eugenio

Administrator
Staff member
Hello Johan,
about the port, if you don't specify anything the connection uses the default port, otherwise you can specify the port with the $host parameter in config.php

for example

$host = '127.0.0.1:3308';

will use the 3308 port.

If you get a connection error it means that $host and/or $user and/or $pass and/or $db_name are not correct; or that everything is correct but the computer that hosts DaDaBIK cannot reach the computer that hosts your MySQL server.

Best,
 
Top