Nova Configuration (DBConnection Error) (2003 "Cant to MySQL Server"
Hi All,
As I was trying to configure Rocky Flavor of Openstack in my ONPrem Server. As i Follow the Document which is available with Openstack Installation Guide.
I am facing a issue for configuring nova. The issue is
When I execute the command
su -s /bin/sh -c "nova-manage api_db sync" nova
My system throw the error
DBConnectionError: (pymysql.err.OperationalError) (2003, "Can't Connect to MYSQL server on 'openstack-controller' ([Errno -21] No address found)") (Background on this error at: http://sqlalche.me/e/e3q8)
But the intresting thing is I have also configure Glance and when i used the su command there this error didnt poped up
Please help me to resolve this issue
Regards Vikas Kanojia
nova-manage uses the MySQL connection string from nova.conf, whereas Glance uses the connection string from glance.conf. You seem to have an erroneous connection string in nova.conf.
Can you resolve openstack-controller to an IP address?
Hi Bemd Bausch,
Yes I can resolve the openstack-controller to an IP ADDRESS
Then something else is wrong with the connection string.
This is my connection string
connection = mysql+pymysql://nova:admin@123@openstack-controller/nova_api connection = mysql+pymysql://nova:admin@123@openstack-controller/nova connection = mysql+pymysql://placement:admin@123@openstack-controller/placement
One troubleshooting technique is comparing a working configuration with the non-working one. So, does this look like the Glance connection string?
By the way, while I am not certain, I don’t think a connection string can have two @ signs.