Package: keystone Version: 2:10.0.0-2 Severity: important Trying to start over, this time using Stretch (no backports).
When I try to pre-seed keystone, I endup with no database. Running dpkg-reconfigure keystone manually to try to figure out if there's something _I_ did, I eventually end up with: ----- s n i p ----- Running su keystone -s /bin/sh -c 'keystone-manage --noverbose db_sync'... 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'") 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last): 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return fn() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return _ConnectionFairy._checkout(self) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters fairy = _ConnectionRecord.checkout(pool) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters rec = pool._do_get() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters self._dec_overflow() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters compat.reraise(exc_type, exc_value, exc_tb) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return self._create_connection() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return _ConnectionRecord(self) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__ 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters self.connection = self.__connect() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters connection = self.__pool._invoke_creator(self) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return dialect.connect(*cargs, **cparams) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return self.dbapi.connect(*cargs, **cparams) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 90, in Connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters return Connection(*args, **kwargs) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 688, in __init__ 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters self.connect() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 906, in connect 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters self._request_authentication() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1114, in _request_authentication 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters auth_packet = self._read_packet() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error() 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval) 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters InternalError: (1049, u"Unknown database 'keystone'") 2016-12-04 19:33:36.357 28208 ERROR oslo_db.sqlalchemy.exc_filters 2016-12-04 19:33:36.362 28208 CRITICAL keystone [-] DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'") 2016-12-04 19:33:36.362 28208 ERROR keystone Traceback (most recent call last): 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/bin/keystone-manage", line 10, in <module> 2016-12-04 19:33:36.362 28208 ERROR keystone sys.exit(main()) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/manage.py", line 44, in main 2016-12-04 19:33:36.362 28208 ERROR keystone cli.main(argv=sys.argv, config_files=config_files) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 1254, in main 2016-12-04 19:33:36.362 28208 ERROR keystone CONF.command.cmd_class.main() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/cmd/cli.py", line 445, in main 2016-12-04 19:33:36.362 28208 ERROR keystone CONF.command.version) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 207, in offline_sync_database_to_version 2016-12-04 19:33:36.362 28208 ERROR keystone expand_schema() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 232, in expand_schema 2016-12-04 19:33:36.362 28208 ERROR keystone _sync_common_repo(version=None) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/keystone/common/sql/migration_helpers.py", line 123, in _sync_common_repo 2016-12-04 19:33:36.362 28208 ERROR keystone with sql.session_for_write() as session: 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ 2016-12-04 19:33:36.362 28208 ERROR keystone return self.gen.next() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 874, in _transaction_scope 2016-12-04 19:33:36.362 28208 ERROR keystone allow_async=self._allow_async) as resource: 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ 2016-12-04 19:33:36.362 28208 ERROR keystone return self.gen.next() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 518, in _session 2016-12-04 19:33:36.362 28208 ERROR keystone bind=self.connection, mode=self.mode) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 277, in _create_session 2016-12-04 19:33:36.362 28208 ERROR keystone self._start() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 363, in _start 2016-12-04 19:33:36.362 28208 ERROR keystone engine_args, maker_args) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 387, in _setup_for_connection 2016-12-04 19:33:36.362 28208 ERROR keystone sql_connection=sql_connection, **engine_kwargs) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 155, in create_engine 2016-12-04 19:33:36.362 28208 ERROR keystone test_conn = _test_connection(engine, max_retries, retry_interval) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/oslo_db/sqlalchemy/engines.py", line 331, in _test_connection 2016-12-04 19:33:36.362 28208 ERROR keystone return engine.connect() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2018, in connect 2016-12-04 19:33:36.362 28208 ERROR keystone return self._connection_cls(self, **kwargs) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 72, in __init__ 2016-12-04 19:33:36.362 28208 ERROR keystone if connection is not None else engine.raw_connection() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2104, in raw_connection 2016-12-04 19:33:36.362 28208 ERROR keystone self.pool.unique_connection, _connection) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2078, in _wrap_pool_connect 2016-12-04 19:33:36.362 28208 ERROR keystone e, dialect, self) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1401, in _handle_dbapi_exception_noconnection 2016-12-04 19:33:36.362 28208 ERROR keystone util.raise_from_cause(newraise, exc_info) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause 2016-12-04 19:33:36.362 28208 ERROR keystone reraise(type(exception), exception, tb=exc_tb, cause=cause) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2074, in _wrap_pool_connect 2016-12-04 19:33:36.362 28208 ERROR keystone return fn() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318, in unique_connection 2016-12-04 19:33:36.362 28208 ERROR keystone return _ConnectionFairy._checkout(self) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 713, in _checkout 2016-12-04 19:33:36.362 28208 ERROR keystone fairy = _ConnectionRecord.checkout(pool) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 480, in checkout 2016-12-04 19:33:36.362 28208 ERROR keystone rec = pool._do_get() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1060, in _do_get 2016-12-04 19:33:36.362 28208 ERROR keystone self._dec_overflow() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2016-12-04 19:33:36.362 28208 ERROR keystone compat.reraise(exc_type, exc_value, exc_tb) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 1057, in _do_get 2016-12-04 19:33:36.362 28208 ERROR keystone return self._create_connection() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 323, in _create_connection 2016-12-04 19:33:36.362 28208 ERROR keystone return _ConnectionRecord(self) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 449, in __init__ 2016-12-04 19:33:36.362 28208 ERROR keystone self.connection = self.__connect() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 607, in __connect 2016-12-04 19:33:36.362 28208 ERROR keystone connection = self.__pool._invoke_creator(self) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line 97, in connect 2016-12-04 19:33:36.362 28208 ERROR keystone return dialect.connect(*cargs, **cparams) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 385, in connect 2016-12-04 19:33:36.362 28208 ERROR keystone return self.dbapi.connect(*cargs, **cparams) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/__init__.py", line 90, in Connect 2016-12-04 19:33:36.362 28208 ERROR keystone return Connection(*args, **kwargs) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 688, in __init__ 2016-12-04 19:33:36.362 28208 ERROR keystone self.connect() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 906, in connect 2016-12-04 19:33:36.362 28208 ERROR keystone self._request_authentication() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1114, in _request_authentication 2016-12-04 19:33:36.362 28208 ERROR keystone auth_packet = self._read_packet() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet 2016-12-04 19:33:36.362 28208 ERROR keystone packet.check_error() 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error 2016-12-04 19:33:36.362 28208 ERROR keystone err.raise_mysql_exception(self._data) 2016-12-04 19:33:36.362 28208 ERROR keystone File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception 2016-12-04 19:33:36.362 28208 ERROR keystone raise errorclass(errno, errval) 2016-12-04 19:33:36.362 28208 ERROR keystone DBError: (pymysql.err.InternalError) (1049, u"Unknown database 'keystone'") 2016-12-04 19:33:36.362 28208 ERROR keystone ----- s n i p ----- And a 'mysqlshow' doesn't show the 'keystone' database.. -- System Information: Debian Release: stretch/sid APT prefers testing-updates APT policy: (500, 'testing-updates'), (500, 'testing-proposed-updates'), (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 3.16.0-4-amd64 (SMP w/16 CPU cores) Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages keystone depends on: ii adduser 3.115 ii apache2 2.4.23-8 ii dbconfig-common 2.0.6 ii debconf [debconf-2.0] 1.5.59 ii init-system-helpers 1.46 ii libapache2-mod-wsgi 4.5.7-1 ii lsb-base 9.20161125 ii python-keystone 2:10.0.0-2 ii python-q-text-as-data [q-text-as-data] 1.4.0-1 ii sqlite3 3.15.1-1 ii ssl-cert 1.0.38 keystone recommends no packages. Versions of packages keystone suggests: pn apparmor <none> -- debconf information: * keystone/admin-password: (password omitted) * keystone/mysql/admin-pass: (password omitted) * keystone/admin-password-confirm: (password omitted) * keystone/auth-token: (password omitted) * keystone/app-password-confirm: (password omitted) * keystone/mysql/app-pass: (password omitted) * keystone/password-confirm: (password omitted) * keystone/rabbit_password: (password omitted) * keystone/dbconfig-remove: true * keystone/db/app-user: keystone * keystone/upgrade-backup: true * keystone/missing-db-package-error: abort * keystone/remote/port: * keystone/dbconfig-install: true * keystone/remote/host: openstack.bayour.com * keystone/register-endpoint: true * keystone/internal/reconfiguring: true * keystone/remove-error: abort * keystone/rabbit_userid: openstack * keystone/install-error: abort * keystone/mysql/admin-user: root * keystone/configure_db: true * keystone/remote/newhost: openstack.bayour.com * keystone/admin-role-name: admin * keystone/internal/skip-preseed: true * keystone/purge: true keystone/passwords-do-not-match: * keystone/create-admin-tenant: true * keystone/dbconfig-reinstall: false * keystone/mysql/method: TCP/IP * keystone/dbconfig-upgrade: true * keystone/region-name: europe-london * keystone/database-type: mysql * keystone/admin-user: admin * keystone/upgrade-error: abort * keystone/admin-email: tu...@bayour.com * keystone/endpoint-ip: 10.0.4.1 * keystone/db/dbname: keystone * keystone/admin-tenant-name: admin
