Error: No sql_connection parameter is established when creating VM instance on openstack pike devstack

asked 2020-02-06 07:49:05 -0500

shivank01 gravatar image

I have setup an openstack by following this https://www.udemy.com/course/deep-dive-the-openstack-cloud/ (tutorial). I am facing error on creating vm instance. The error is:

Message
No sql_connection parameter is established
Code
    500
Details
    File "/opt/stack/nova/nova/conductor/manager.py", line 553, in build_instances context, spec_obj, instance_uuids) File "/opt/stack/nova/nova/conductor/manager.py", line 624, in _schedule_instances scheduler_utils.setup_instance_group(context, request_spec) File "/opt/stack/nova/nova/scheduler/utils.py", line 565, in setup_instance_group group_info = _get_group_details(context, instance_uuid, group_hosts) File "/opt/stack/nova/nova/scheduler/utils.py", line 522, in _get_group_details instance_uuid) File "/usr/local/lib/python2.7/dist-packages/oslo_versionedobjects/base.py", line 184, in wrapper result = fn(cls, context, *args, **kwargs) File "/opt/stack/nova/nova/objects/instance_group.py", line 331, in get_by_instance_uuid db_group = cls._get_from_db_by_instance(context, instance_uuid) File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 978, in wrapper with self._transaction_scope(context): File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ return self.gen.next() File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 1028, in _transaction_scope context=context) as resource: File "/usr/lib/python2.7/contextlib.py", line 17, in __enter__ return self.gen.next() File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 633, in _session bind=self.connection, mode=self.mode) File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 398, in _create_session self._start() File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 484, in _start engine_args, maker_args) File "/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/enginefacade.py", line 506, in _setup_for_connection "No sql_connection parameter is established")

I have configured the sql following this https://docs.openstack.org/mitaka/install-guide-ubuntu/nova-controller-install.html (link). My nova.conf file looks like this:

Note: I am not connecting the vm to public network as given in this https://stackoverflow.com/questions/48648094/error-no-sql-connection-parameter-is-established-when-creating-instances-on-ope (answer)

edit retag flag offensive close merge delete