Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

devstack install fails with mysql connection refused

Hi,

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/

I have added an extra line in the local.conf: FIXED_RANGE=10.0.0.0/24

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.

devstack install fails with mysql connection refused

Hi,

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/

I have added an extra line in the local.conf: FIXED_RANGE=10.0.0.0/24

local.conf:

FIXED_RANGE=10.0.0.0/24

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

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.

devstack install fails with mysql connection refused

Hi,

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/

I have added an extra line in the local.conf:

FIXED_RANGE=10.0.0.0/24

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.

local.conf:

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                |
+--------------------+