Ask Your Question
1

i can't populate the Identity service database during keystone installation

asked 2015-11-07 11:13:49 -0500

bentekouk gravatar image

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.

edit retag flag offensive close merge delete

Comments

"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.

Bernd Bausch gravatar imageBernd Bausch ( 2015-11-08 22:30:00 -0500 )edit

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

yaroslav gravatar imageyaroslav ( 2016-09-12 03:05:05 -0500 )edit

2 answers

Sort by ยป oldest newest most voted
0

answered 2016-06-16 03:47:37 -0500

Muhammad Bayat gravatar image

I Have the same problem

edit flag offensive delete link more
0

answered 2016-08-09 21:00:22 -0500

openstacking gravatar image

updated 2016-08-10 15:31:40 -0500

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

su -s /bin/sh -c "keystone-manage db_sync" keystone

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 ... (more)

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

5 followers

Stats

Asked: 2015-11-07 11:13:49 -0500

Seen: 1,127 times

Last updated: Aug 10 '16