Hello, i got this error when i try to populate the Identity service database of keystone in ubuntu 15.04
No handlers could be found for logger "oslo_config.cfg" 2015-11-07 09:13:11.470 3429 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 10 attempts left.
I'm having the same problem too!
I'm following the installation guide on http://docs.openstack.org/mitaka/inst... with Ubuntu 16.04.
Whenever I execute the command
I would get the following error: nnection failed. 10 attempts left. 2016-08-10 11:27:41.023 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 9 attempts left. 2016-08-10 11:27:51.035 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 8 attempts left. 2016-08-10 11:28:01.043 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 7 attempts left. 2016-08-10 11:28:11.052 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 6 attempts left. 2016-08-10 11:28:21.064 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 5 attempts left. 2016-08-10 11:28:31.076 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 4 attempts left. 2016-08-10 11:28:41.085 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 3 attempts left. 2016-08-10 11:28:51.088 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 2 attempts left. 2016-08-10 11:29:01.099 20906 WARNING oslo_db.sqlalchemy.engines [-] SQL connection failed. 1 attempts left. 2016-08-10 11:29:11.101 20906 CRITICAL keystone [-] DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'controller' ([Errno -2] Name or service not known)") 2016-08-10 11:29:11.101 20906 ERROR keystone Traceback (most recent call last): 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module> 2016-08-10 11:29:11.101 20906 ERROR keystone sys.exit(main()) 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 47, in main 2016-08-10 11:29:11.101 20906 ERROR keystone cli.main(argv=sys.argv, config_files=config_files) 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 992, in main 2016-08-10 11:29:11.101 20906 ERROR keystone CONF.command.cmd_class.main() 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 371, in main 2016-08-10 11:29:11.101 20906 ERROR keystone migration_helpers.sync_database_to_version(extension, version) 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 210, in sync_database_to_version 2016-08-10 11:29:11.101 20906 ERROR keystone _sync_common_repo(version) 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 132, in _sync_common_repo 2016-08-10 11:29:11.101 20906 ERROR keystone with sql.session_for_write() as session: 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ 2016-08-10 11:29:11.101 20906 ERROR keystone return self.gen.next() 2016-08-10 11:29:11.101 20906 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 759, in _transaction_scope 2016-08-10 11:29:11.101 20906 ERROR keystone allow_async=self._allow_async) as resource ...
Asked: 2015-11-07 11:13:49 -0600
Seen: 1,170 times
Last updated: Aug 10 '16
"No handlers could be found for logger "oslo_config.cfg" "
Probably harmless
"SQL connection failed"
Check if your database connection string is correct, the DB port on the controller is open, and the DB is running.
netstat -taunp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 4621/mysqld
grep -rn bind /etc/mysql
/etc/mysql/conf.d/openstack.cnf:2:bind-address = 0.0.0.0 /etc/mysql/mariadb.conf.d/50-server.cnf:29:bind-address = 0.0.0.0
service mysql restart