What does the [database] section of the configs look like? Not only was the string changed but it was moved from the Default section to [database]: # The SQLAlchemy connection string used to connect to the # database (string value) # Deprecated group/name - [DEFAULT]/sql_connection # Deprecated group/name - [DATABASE]/sql_connection # Deprecated group/name - [sql]/connection #connection = <None> ____________________________________________
Kris Lindgren Senior Linux Systems Engineer GoDaddy, LLC. From: Nathan Stratton <[email protected]<mailto:[email protected]>> Date: Monday, March 23, 2015 at 8:50 AM To: "openstack-oper." <[email protected]<mailto:[email protected]>> Subject: [Openstack-operators] Glance issues after rdo icehouse -> juno Followed: http://docs.openstack.org/openstack-ops/content/upgrade-icehouse-juno.html On the surface everything looked great, I can do a glance image-list, can import an image into glance, but I can't cinder create from glance --image-id. I get the following error: 2015-03-23 10:35:57.703 2954 INFO urllib3.connectionpool [-] Starting new HTTP connection (1): 10.71.0.218 2015-03-23 10:35:57.719 2954 INFO keystonemiddleware.auth_token [-] Auth Token confirmed use of v3.0 apis 2015-03-23 10:35:58.129 2954 INFO glance.wsgi.server [44e7b400-64bc-4042-a699-7bf6ed7118e5 b4397deb6a884a8c8e70fbc255ce6d80 0ebcdedac0a3480 ca81050bfedd97cf1 - - -] Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/eventlet/wsgi.py", line 433, in handle_one_response result = self.application(self.environ, start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python2.7/site-packages/glance/common/wsgi.py", line 394, in __call__ response = req.get_response(self.application) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1296, in send application, catch_exc_info=False) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1260, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python2.7/site-packages/osprofiler/web.py", line 99, in __call__ return request.get_response(self.application) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1296, in send application, catch_exc_info=False) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1260, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/site-packages/keystonemiddleware/auth_token.py", line 748, in __call__ return self._call_app(env, start_response) File "/usr/lib/python2.7/site-packages/keystonemiddleware/auth_token.py", line 684, in _call_app return self._app(env, _fake_start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python2.7/site-packages/glance/common/wsgi.py", line 394, in __call__ response = req.get_response(self.application) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1296, in send application, catch_exc_info=False) File "/usr/lib/python2.7/site-packages/webob/request.py", line 1260, in call_application app_iter = application(self.environ, start_response) File "/usr/lib/python2.7/site-packages/paste/urlmap.py", line 203, in __call__ return app(environ, start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__ return resp(environ, start_response) File "/usr/lib/python2.7/site-packages/routes/middleware.py", line 131, in __call__ response = self.app(environ, start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 144, in __call__ return resp(environ, start_response) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 130, in __call__ resp = self.call_func(req, *args, **self.kwargs) File "/usr/lib/python2.7/site-packages/webob/dec.py", line 195, in call_func return self.func(req, *args, **kwargs) File "/usr/lib/python2.7/site-packages/glance/common/wsgi.py", line 683, in __call__ request, **action_args) File "/usr/lib/python2.7/site-packages/glance/common/wsgi.py", line 707, in dispatch return method(*args, **kwargs) File "/usr/lib/python2.7/site-packages/glance/api/v2/images.py", line 111, in show return image_repo.get(image_id) File "/usr/lib/python2.7/site-packages/glance/api/authorization.py", line 106, in get image = self.image_repo.get(image_id) File "/usr/lib/python2.7/site-packages/glance/domain/proxy.py", line 86, in get return self.helper.proxy(self.base.get(item_id)) File "/usr/lib/python2.7/site-packages/glance/api/policy.py", line 179, in get return super(ImageRepoProxy, self).get(image_id) File "/usr/lib/python2.7/site-packages/glance/domain/proxy.py", line 86, in get return self.helper.proxy(self.base.get(item_id)) File "/usr/lib/python2.7/site-packages/glance/domain/proxy.py", line 86, in get return self.helper.proxy(self.base.get(item_id)) File "/usr/lib/python2.7/site-packages/glance/domain/proxy.py", line 86, in get return self.helper.proxy(self.base.get(item_id)) File "/usr/lib/python2.7/site-packages/glance/db/__init__.py", line 67, in get db_api_image = dict(self.db_api.image_get(self.context, image_id)) File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 191, in image_get force_show_deleted=force_show_deleted) File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 214, in _image_get session = session or get_session() File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 97, in get_session facade = _create_facade_lazily() File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 82, in _create_facade_lazily _FACADE = session.EngineFacade.from_config(CONF) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 816, in from_config retry_interval=conf.database.retry_interval) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 732, in __init__ **engine_kwargs) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 409, in create_engine _test_connection(engine, max_retries, retry_interval) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 549, in _test_connection return exc_filters.handle_connect_error(engine) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 351, in handle_connect_error handler(ctx) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler context.is_disconnect) File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_operational_errors_directly_filter raise operational_error OperationalError: (OperationalError) (1045, "Access denied for user 'glance'@'localhost' (using password: YES)") None None I also found I can't even do a simple glance-manage db_sync because of the same error: 2015-03-23 10:36:28.212 3497 CRITICAL glance [-] OperationalError: (OperationalError) (1045, "Access denied for user 'glance'@'localhost' ( using password: YES)") None None 2015-03-23 10:36:28.212 3497 TRACE glance Traceback (most recent call last): 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/bin/glance-manage", line 10, in <module> 2015-03-23 10:36:28.212 3497 TRACE glance sys.exit(main()) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 279, in main 2015-03-23 10:36:28.212 3497 TRACE glance return CONF.command.action_fn() 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 157, in sync 2015-03-23 10:36:28.212 3497 TRACE glance CONF.command.current_version) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/glance/cmd/manage.py", line 113, in sync 2015-03-23 10:36:28.212 3497 TRACE glance migration.db_sync(db_api.get_engine(), 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 92, in get_engine 2015-03-23 10:36:28.212 3497 TRACE glance facade = _create_facade_lazily() 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/glance/db/sqlalchemy/api.py", line 82, in _create_facade _lazily 2015-03-23 10:36:28.212 3497 TRACE glance _FACADE = session.EngineFacade.from_config(CONF) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 816, in from_config 2015-03-23 10:36:28.212 3497 TRACE glance retry_interval=conf.database.retry_interval) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 732, in __init__ 2015-03-23 10:36:28.212 3497 TRACE glance **engine_kwargs) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 409, in create_engi ne 2015-03-23 10:36:28.212 3497 TRACE glance _test_connection(engine, max_retries, retry_interval) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/session.py", line 549, in _test_conne ction 2015-03-23 10:36:28.212 3497 TRACE glance return exc_filters.handle_connect_error(engine) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 351, in handle_ connect_error 2015-03-23 10:36:28.212 3497 TRACE glance handler(ctx) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 323, in handler 2015-03-23 10:36:28.212 3497 TRACE glance context.is_disconnect) 2015-03-23 10:36:28.212 3497 TRACE glance File "/usr/lib/python2.7/site-packages/oslo/db/sqlalchemy/exc_filters.py", line 254, in _raise_ operational_errors_directly_filter 2015-03-23 10:36:28.212 3497 TRACE glance raise operational_error 2015-03-23 10:36:28.212 3497 TRACE glance OperationalError: (OperationalError) (1045, "Access denied for user 'glance'@'localhost' (using p assword: YES)") None None 2015-03-23 10:36:28.212 3497 TRACE glance This all looks like sql issues, so I started digging and found that sql_connection was changed to just connection so I made that change in glance-api.conf and glance-registry.conf so it now looks like: connection=mysql://glance:[email protected]/glance<http://glance:[email protected]/glance> If btw, I try connecting to mysql with that pass everything is fine: [root@nathan glance(keystone)]# mysql -uglance -pbe801f9b56ea40f4 -h10.71.0.218 Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 66 Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026 Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> ><> nathan stratton | vp technology | broadsoft, inc | +1-240-404-6580 | www.broadsoft.com<http://www.broadsoft.com>
_______________________________________________ OpenStack-operators mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
