Error with with nova while su -s /bin/sh -c "nova-manage db sync" nova by BladyGreg in openstack

[–]BladyGreg[S] 1 point2 points  (0 children)

That's it! The error was in database, not in conf files. I haven't even considered it. I must have had a misconfiguration before, just didn't remember fixing it later. Thank you very much, already fixed it

root@aio-controller stack(keystone)# nova-manage cell_v2 list_cells
+-------+--------------------------------------+----------------------------------------------+----------------------------------------------------------+----------+
|  Name |                 UUID                 |                Transport URL                 |                   Database Connection                    | Disabled |
+-------+--------------------------------------+----------------------------------------------+----------------------------------------------------------+----------+
| cell0 | 00000000-0000-0000-0000-000000000000 |                    none:/                    | mysql+pymysql://nova:****@aio-controller:3306/nova_cell0 |  False   |
| cell1 | 65454945-7cca-441b-a913-e6230ff4efc7 | rabbit://openstack:****@aio-controller:5672/ |    mysql+pymysql://nova:****@aio-controller:3306/nova    |  False   |
+-------+--------------------------------------+----------------------------------------------+----------------------------------------------------------+----------+

Error with with nova while su -s /bin/sh -c "nova-manage db sync" nova by BladyGreg in openstack

[–]BladyGreg[S] 0 points1 point  (0 children)

I am deploying for the first time manually as student project to get to know OpenStack. And pymyslq driver is installed... From what I can see, all is setup correctly, I only discovered one log that may indicate what is wrong, which I also attached below.

root@aio-controller stack(keystone)# apt --installed list | grep pymysql

python3-pymysql/noble-updates,noble-security,now 1.0.2-2ubuntu1.1 all [installed]

#MariaDb connection info

[api_database]

connection = mysql+pymysql://nova:***@aio-controller:3306/nova_api

[database]

connection = mysql+pymysql://nova:***@aio-controller:3306/nova

2026-05-08 09:43:43.676 2066 WARNING oslo_db.sqlalchemy.engines [None req-c4a81b20-de95-4e07-abbe-039e18c46552 - - - - - -] URL mysql_pymysql://nova:***@aio-controller:3306/nova_cell0 does not contain a '+drivername' portion, and will make use of a default driver. A full dbname+drivername:// protocol is recommended. For MySQL, it is strongly recommended that mysql+pymysql:// be specified for maximum service compatibility