Hello,
I encountered an error while installing ProjeQtor.
the following message tells me a port problem.
I have a LAMB installation under CentOs 7. with MariaDB
SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (13)
Dsn = mysql:host=localhost:port=
Thanks for your help
Kamel
The port is not specified.
For mysql, default port is 3306
Thank you for your answer.
yes in "database port" I enter "3306" for the configuration of projeqtor at the time of installation
Check parameters.php file (default location is files/config)
Is paramDbPort correctly stored ?
sorry I'm wrong message here is the good error message (again thank you for your answers ...)
SQLSTATE[HY000] [2003] Can’t connect to MySQL server on '127.0.0.1' (13)
Dsn = mysql:host = 127.0.0.1:port = 3306
thanks
In complement, the file parameters.php is absent for the moment.
Check your install of MariaDB
Sometimes, MariaDB is configured to listen on port 3307
Thank you for your reply.
This command works : # mysql -u root -p
After they ask me the password and it works I connect to mysql
But this command does not work : # mysql -u root -p 3306 (or 3307)
After they ask me the password and it does not work !
Thanks
You have to check your config file (my.ini or my.cnf) to check which port is used.
Also check that the user you user (root ?) can connect from "localhost"
Check access rights of user you use to log in to db through projector.
It must be granted to connect from localhost.