Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'controller' (111)") None Nonestal

Hi after install nova, run the command,i can see only nova-consoleauth is up . After check the log i can see /var/log/nova/nova-cert.log : OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'controller' (111)")

I think it's right in Nova.conf connection=mysql://nova:openstack@controller/nova

So how can i troubleshooting ? First time to install openstack.

root@controller:~# nova service-list +----+------------------+------------+----------+---------+-------+----------------------------+-----------------+ | Id | Binary | Host | Zone | Status | State | Updated_at | Disabled Reason | +----+------------------+------------+----------+---------+-------+----------------------------+-----------------+ | 1 | nova-cert | controller | internal | enabled | down | 2014-11-13T10:08:42.000000 | - | | 2 | nova-consoleauth | controller | internal | enabled | up | 2014-11-13T12:27:42.000000 | - | | 3 | nova-scheduler | controller | internal | enabled | down | 2014-11-13T10:08:42.000000 | - | | 4 | nova-conductor | controller | internal | enabled | down | 2014-11-13T10:08:40.000000 | - | | 5 | nova-compute | compute01 | nova | enabled | down | 2014-11-13T10:08:35.000000 | - | | 6 | nova-network | controller | internal | enabled | down | 2014-11-13T10:08:39.000000 | - | +----+------------------+------------+----------+---------+-------+----------------------------+-----------------+

OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'controller' (111)") None Nonestal

Hi after install nova, run the command,i can see only nova-consoleauth is up . After check the log i can see /var/log/nova/nova-cert.log : OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on 'controller' (111)")

I think it's right in Nova.conf connection=mysql://nova:openstack@controller/nova

So how can i troubleshooting ? First time to install openstack.

root@controller:~# nova service-list
+----+------------------+------------+----------+---------+-------+----------------------------+-----------------+
| Id | Binary           | Host       | Zone     | Status  | State | Updated_at                 | Disabled Reason |
+----+------------------+------------+----------+---------+-------+----------------------------+-----------------+
| 1  | nova-cert        | controller | internal | enabled | down  | 2014-11-13T10:08:42.000000 | -               |
| 2  | nova-consoleauth | controller | internal | enabled | up    | 2014-11-13T12:27:42.000000 | -               |
| 3  | nova-scheduler   | controller | internal | enabled | down  | 2014-11-13T10:08:42.000000 | -               |
| 4  | nova-conductor   | controller | internal | enabled | down  | 2014-11-13T10:08:40.000000 | -               |
| 5  | nova-compute     | compute01  | nova     | enabled | down  | 2014-11-13T10:08:35.000000 | -               |
| 6  | nova-network     | controller | internal | enabled | down  | 2014-11-13T10:08:39.000000 | -               |
+----+------------------+------------+----------+---------+-------+----------------------------+-----------------+

+----+------------------+------------+----------+---------+-------+----------------------------+-----------------+