devstack install fails with mysql connection refused
I am banging my head on this problem.
I am following this process on an utterly clean Ubuntu xenial VM. I have created a vagrant machine.
Then I followed this process to install everything on the VM: https://docs.openstack.org/developer/devstack/ (https://docs.openstack.org/developer/...)
I have added an extra line in the local.conf:
The error while running stack.sh is this:
+lib/databases/mysql:recreate_database_mysql:56 local db=glance +lib/databases/mysql:recreate_database_mysql:57 mysql -uroot -psecret -h127.0.0.1 -e 'DROP DATABASE IF EXISTS glance;' mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) +lib/databases/mysql:recreate_database_mysql:1 exit_trap +./stack.sh:exit_trap:487 local r=1 ++./stack.sh:exit_trap:488 jobs -p +./stack.sh:exit_trap:488 jobs= +./stack.sh:exit_trap:491 [[ -n '' ]] +./stack.sh:exit_trap:497 kill_spinner +./stack.sh:kill_spinner:383 '[' '!' -z '' ']' +./stack.sh:exit_trap:499 [[ 1 -ne 0 ]] +./stack.sh:exit_trap:500 echo 'Error on exit' Error on exit +./stack.sh:exit_trap:501 generate-subunit 1490014762 1437 fail +./stack.sh:exit_trap:502 [[ -z /opt/stack/logs ]] +./stack.sh:exit_trap:505 /home/stack/devstack/tools/worlddump.py -d /opt/stack/logs World dumping... see /opt/stack/logs/worlddump-2017-03-20-132319.txt for details +./stack.sh:exit_trap:511 exit 1
When I lookup that function recreate_database_mysql , line 57, I see two mysql calls in there. When I run them by hand, they run fine.
I was about to learn openstack but I can't continue for the last two days and this is really irritating.
stack@ubuntu-xenial:~/devstack$ cat local.conf [[local|localrc]] ADMIN_PASSWORD=secret DATABASE_PASSWORD=$ADMIN_PASSWORD RABBIT_PASSWORD=$ADMIN_PASSWORD SERVICE_PASSWORD=$ADMIN_PASSWORD FIXED_RANGE=10.0.0.0/24
manually it works fine:
stack@ubuntu-xenial:~/devstack$ mysql -uroot -psecret -h127.0.0.1 -e 'show databases' mysql: [Warning] Using a password on the command line interface can be insecure. +--------------------+ | Database | +--------------------+ | information_schema | | keystone | | mysql | | performance_schema | | sys | +--------------------+