These are chat archives for azukiapp/azk

27th
Jan 2016
Djamy
@Djamy
Jan 27 2016 11:41
$ azk shell web php app/console doctrine:database:create
Could not create database `symfony` for connection named default
SQLSTATE[HY000] [2003] Can't connect to MySQL server on '192.168.50.4' (111)
I think it's an issue with mysql server not running or something
Gullit Miranda
@gullitmiranda
Jan 27 2016 11:46
you have run azk start mysql before the azk shell?
Djamy
@Djamy
Jan 27 2016 11:48
Yes I had the grid with both web and mysql container up
Gullit Miranda
@gullitmiranda
Jan 27 2016 11:49
and you changed the database configuration file to use ENVs instead of fixed values?
Djamy
@Djamy
Jan 27 2016 11:51
No, I used the fixed value 192.168.50.4 in the database configuration file
$ azk shell mysql /etc/init.d/mysql restart
Stopping MySQL Community Server 5.7.9.
MySQL Community Server 5.7.9 is already stopped.
Re-starting MySQL Community Server 5.7.9.
........................................
I also tried this but it's not ending..
Gullit Miranda
@gullitmiranda
Jan 27 2016 11:57
the mysql start command is different.
azk shell mysql -c "/azk-entrypoint.sh mysqld"
Djamy
@Djamy
Jan 27 2016 12:01
2016-01-27T11:47:11.970098Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2016-01-27T11:47:11.970160Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:02
mysql is already started. :D
Djamy
@Djamy
Jan 27 2016 12:02
And in my database configuration file I forgot to change the port, so with the correct port it tells me this
$ azk shell web php app/console doctrine:database:create
Could not create database `symfony` for connection named default
SQLSTATE[HY000] [1130] Host '172.17.42.1' is not allowed to connect to this MySQL server
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:04
let me see your configuration file.
and his Azkfile again.
Djamy
@Djamy
Jan 27 2016 12:05
This message was deleted
The database configuration file : https://gist.github.com/Djamy/43df797297e4136e514c
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:08
symfony does not use a database.php?
Djamy
@Djamy
Jan 27 2016 12:09
it uses a parameters.yml
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:09
:(
Djamy
@Djamy
Jan 27 2016 12:10
it's possible to transform this yml in a php file but it's a pain to do so
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:10
there a little more complicated because you need to use ENVs and not static values.
Djamy
@Djamy
Jan 27 2016 12:10
if I change this yml file into a php file with getenv, it should work ?
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:12
in theory, yes.
Djamy
@Djamy
Jan 27 2016 12:12
but why adminer.php does not work ?
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:13
you changed the adminer to use ENVs?
Djamy
@Djamy
Jan 27 2016 12:13
And is it possible to use a MySQL client like MySQL Workbench or SqlYog or such
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:13
it's possible
Djamy
@Djamy
Jan 27 2016 12:14
What should I put in the host fields then ?
And, no I did not change the adminer to use envs but I'll try :)
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:15
the way in which the Azkfile is configured, each can start using a different port.
you can fix the port
Djamy
@Djamy
Jan 27 2016 12:28
Okay cool! I'll do more tests tonight
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:30
nice @Djamy
when my English is very bad, but I can ask someone with better fluency make a call with you.
Djamy
@Djamy
Jan 27 2016 12:33
Thanks @gullitmiranda for your time!
Oh my english is not better!
I'll make my tests and if I cannot find the solution, I'll come back here with more questions but I do not want to waste more of your time
Gullit Miranda
@gullitmiranda
Jan 27 2016 12:43
ok. can come back.
not waste our time. These questions help improve the documentation.