marwenb
January 9, 2018, 8:24am
1
Hello all,
I have created two containers (Mysql/web)
The matter is when i want execute docker exec web php bin/console doctrine:schema:update --force
I got :
[Doctrine\DBAL\Exception\ConnectionException]
An exception occured in driver: SQLSTATE[HY000] [2002] Connection refused
[Doctrine\DBAL\Driver\PDOException]
SQLSTATE[HY000] [2002] Connection refused
[PDOException]
SQLSTATE[HY000] [2002] Connection refused
The probléme is in the database host, it’s unknown to the web container,
I tried with myhost.mydomain.com
But it seems that it’s not correct
The database is a container running inside myhost.mydomain.com
sdetweil
January 9, 2018, 11:34am
2
how did you start (docker run) the two containers?
marwenb
January 9, 2018, 12:56pm
3
Thank you for your response,
sdetweil
January 9, 2018, 1:06pm
4
ok, thanks…
now do a docker inspect db
you can also do
docker exec web env
note also that mysql by default ONLY allows local system access, unless YOU change it.
marwenb
January 9, 2018, 1:12pm
5
Thank you ,
docker exec web env
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
docker exec db env
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
How can i connect to 30ac0a9df6dd (the hostname --> it’s a container)
sdetweil
January 9, 2018, 1:35pm
6
mysql connectionshttps://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql
linking worked
in your web app, how do you find the DB info to connect?
MYSQL_ENV_MYSQL_USER=user
MYSQL_ENV_MYSQL_PASSWORD=user
MYSQL_ENV_GOSU_VERSION=1.7
MYSQL_ENV_MYSQL_MAJOR=5.7
MYSQL_NAME=/cattle/mysql
MYSQL_PORT_3306_TCP_PORT=3306
the hostname as shown are the docker generated hostnames.
marwenb
January 9, 2018, 1:39pm
7
I added the DB info by my self in the BD container under /var/www/html/app/config/parameters/parameters-demo.yml and after linking the two containers so it’s normally to found it in the web container
What i should add to be pushed in a dns server?
sdetweil
January 9, 2018, 1:40pm
8
sadly there is no mechanism to push names to dns server other than DHCP… but that doesn’t work on docker.
I added the DB info by my self in the BD container under
and what is that info for DB? (ie, what is the ‘db server’ address?
marwenb
January 9, 2018, 1:47pm
9
About the info :
And about the ‘db server adresse’ that what i’m serarshing for ,bind-adresse line it’s commented in the mysql config file
sdetweil
January 9, 2018, 1:52pm
10
from the web environment variables, due to the linking
MYSQL_PORT_3306_TCP_ADDR=mysql
if you do
docker exec web cat /etc/hosts
you should see mysql listed as a host with its container ip address
and in the env you have the database name
passed from the db container
you can change the db container hostname when you do the docker run by adding the
--hostname parm
for example
--hostname db
marwenb
January 9, 2018, 2:00pm
11
This is what ifound in the web container /etc/hosts
docker exec 2c90a575ed68 cat /etc/hosts
10.42.119.126 2c90a575ed68
This is the mysql db container :
2c90a575ed68 is the web container not the mysql container
root@dockerslave:~# docker exec 30ac0a9df6dd cat /etc/hosts
10.42.1.2 30ac0a9df6dd
sdetweil
January 9, 2018, 2:02pm
12
hmm…
try
docker exec web ping mysql
should work
because u gave the containers names, --name xxxx, when u did the run, you can use the name instead of the container id
marwenb
January 9, 2018, 2:04pm
13
I got this :
So now what i should add in the database_host in /var/www/html/app/config/parameters/parameters-demo.yml?
sdetweil
January 9, 2018, 2:09pm
14
use the environment variables
and it was there all the time… doah…
your link parm set the db host name (which showed up in the environment)
-link db:mysql
marwenb
January 9, 2018, 2:22pm
15
Thank you very much for your help,
