settingsLogin | Registersettings

[Openstack] Nova DB sync Operational error

0 votes

Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got in
in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost' (using
password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send it) -
I think this maybe a bug within openstack as this is the second time I have
gotten the exact same error on a totally new install? Ive checked MaraiDB
and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it back
following the insturctions again via the install guide and same error. I
was hoping anyone had any pointers before I go ahead and report this as a
bug. Ive tried everything that Ask Openstack answers have shown and no go.
I am suprised that Im the only one getting this error repeatedly...I see
that root % is in there twice and no idea how to get rid of it but since
its using user nova anyways I dont see how that would affect anyting.
Please help!! Thanks!


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
asked Nov 25, 2014 in openstack by Amit_Anand (1,340 points)   1 5 8
retagged Feb 25, 2015 by admin

24 Responses

0 votes

On 11/25/2014 05:10 PM, Amit Anand wrote:
Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
in in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'
(using password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send
it) - I think this maybe a bug within openstack as this is the second
time I have gotten the exact same error on a totally new install? Ive
checked MaraiDB and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it
back following the insturctions again via the install guide and same
error. I was hoping anyone had any pointers before I go ahead and report
this as a bug. Ive tried everything that Ask Openstack answers have
shown and no go. I am suprised that Im the only one getting this error
repeatedly...I see that root % is in there twice and no idea how to get
rid of it but since its using user nova anyways I dont see how that
would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your
nova.conf file (the [database] sql_connection string) is the same as
what you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration
management tool or manually?

Best,
-jay

responded Nov 26, 2014 by Jay_Pipes (59,760 points)   3 10 14
0 votes

Hi Amit,

Please open => /etc/nova/nova.conf

Find a line with starting with "connection = "

Please paste it here. That will help us to fix the issue.

On Wed, Nov 26, 2014 at 11:55 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/25/2014 05:10 PM, Amit Anand wrote:

Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
in in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'
(using password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send
it) - I think this maybe a bug within openstack as this is the second
time I have gotten the exact same error on a totally new install? Ive
checked MaraiDB and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it
back following the insturctions again via the install guide and same
error. I was hoping anyone had any pointers before I go ahead and report
this as a bug. Ive tried everything that Ask Openstack answers have
shown and no go. I am suprised that Im the only one getting this error
repeatedly...I see that root % is in there twice and no idea how to get
rid of it but since its using user nova anyways I dont see how that
would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your
nova.conf file (the [database] sql_connection string) is the same as what
you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration
management tool or manually?

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack

--
--
Regards,
Geo Varghese


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Geo_Varghese (2,260 points)   3 8
0 votes

Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

On Wed, Nov 26, 2014 at 1:25 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/25/2014 05:10 PM, Amit Anand wrote:

Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
in in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'
(using password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send
it) - I think this maybe a bug within openstack as this is the second
time I have gotten the exact same error on a totally new install? Ive
checked MaraiDB and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it
back following the insturctions again via the install guide and same
error. I was hoping anyone had any pointers before I go ahead and report
this as a bug. Ive tried everything that Ask Openstack answers have
shown and no go. I am suprised that Im the only one getting this error
repeatedly...I see that root % is in there twice and no idea how to get
rid of it but since its using user nova anyways I dont see how that
would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your
nova.conf file (the [database] sql_connection string) is the same as what
you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration
management tool or manually?

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Amit_Anand (1,340 points)   1 5 8
0 votes

I mean it is exactly the same in nova.conf and the command line

On Wed, Nov 26, 2014 at 2:21 PM, Amit Anand aanand@viimed.com wrote:

Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

On Wed, Nov 26, 2014 at 1:25 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/25/2014 05:10 PM, Amit Anand wrote:

Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
in in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'
(using password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send
it) - I think this maybe a bug within openstack as this is the second
time I have gotten the exact same error on a totally new install? Ive
checked MaraiDB and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it
back following the insturctions again via the install guide and same
error. I was hoping anyone had any pointers before I go ahead and report
this as a bug. Ive tried everything that Ask Openstack answers have
shown and no go. I am suprised that Im the only one getting this error
repeatedly...I see that root % is in there twice and no idea how to get
rid of it but since its using user nova anyways I dont see how that
would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your
nova.conf file (the [database] sql_connection string) is the same as what
you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration
management tool or manually?

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Amit_Anand (1,340 points)   1 5 8
0 votes

On 11/26/2014 02:21 PM, Amit Anand wrote:
Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

try:

connection=mysql://nova:PASSWORD@localhost/nova

responded Nov 26, 2014 by Jay_Pipes (59,760 points)   3 10 14
0 votes

Same error - also tried with 127.0.0.1. Even crazier I removed all keystone
nova (user, service, etc) and dropped the nova DB and recreated that, then
recreated keystone nova with a new different password, updated nova.conf
with new password and still get the same error (notice below now nova has
the different password):

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+
10 rows in set (0.00 sec)

On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/26/2014 02:21 PM, Amit Anand wrote:

Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

try:

connection=mysql://nova:PASSWORD@localhost/nova

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Amit_Anand (1,340 points)   1 5 8
0 votes

HI Geo - Pasted above in the email chain but here it is again:

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@localhost/nova

On Wed, Nov 26, 2014 at 2:17 PM, Geo Varghese gvarghese@aqorn.com wrote:

Hi Amit,

Please open => /etc/nova/nova.conf

Find a line with starting with "connection = "

Please paste it here. That will help us to fix the issue.

On Wed, Nov 26, 2014 at 11:55 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/25/2014 05:10 PM, Amit Anand wrote:

Hi all,

Setup: 3 node, one controller, one compute and one network all separate
machines. Juno install.

Recreating my Juno install and this is the second time Ive gotten this
error whne running "su -s /bin/sh -c "nova-manage db sync" nova" ( I got
in in another install so I started over):

2014-11-25 16:16:51.707 3238 CRITICAL nova [-] OperationalError:
(OperationalError) (1045, "Access denied for user 'nova'@'localhost'
(using password: YES)") None None

I am confident that all is ok with my nova.conf (Ill be happy to send
it) - I think this maybe a bug within openstack as this is the second
time I have gotten the exact same error on a totally new install? Ive
checked MaraiDB and all looks good there:

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| nova | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+

Im using the exact same password for all my acccounts in this DEV
enviroment to keep it simple.

I can also connect just fine from command line:

[root@controller nova]# mysql -u nova -p nova
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 11
Server version: 5.5.40-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [nova]>

So I have no idea what is wrong. Ive dropped the database and added it
back following the insturctions again via the install guide and same
error. I was hoping anyone had any pointers before I go ahead and report
this as a bug. Ive tried everything that Ask Openstack answers have
shown and no go. I am suprised that Im the only one getting this error
repeatedly...I see that root % is in there twice and no idea how to get
rid of it but since its using user nova anyways I dont see how that
would affect anyting. Please help!! Thanks!

Are you absolutely sure that the user and password that is in your
nova.conf file (the [database] sql_connection string) is the same as what
you are typing in on the command line?

How are you deploying your OpenStack environment? Using a configuration
management tool or manually?

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/
openstack

--
--
Regards,
Geo Varghese


Mailing list:
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe :
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Amit_Anand (1,340 points)   1 5 8
0 votes

Try this

connection=mysql://nova:nova@controller/nova

This will fix the issue.

On Thu, Nov 27, 2014 at 1:06 AM, Amit Anand aanand@viimed.com wrote:

Same error - also tried with 127.0.0.1. Even crazier I removed all
keystone nova (user, service, etc) and dropped the nova DB and recreated
that, then recreated keystone nova with a new different password, updated
nova.conf with new password and still get the same error (notice below now
nova has the different password):

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+
10 rows in set (0.00 sec)

On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/26/2014 02:21 PM, Amit Anand wrote:

Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

try:

connection=mysql://nova:PASSWORD@localhost/nova

Best,
-jay


Mailing list:
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe :
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

--
--
Regards,
Geo Varghese


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Geo_Varghese (2,260 points)   3 8
0 votes

I tried and still same errors. I dont see how that would fix in any case as
the guide says I need to put the password into the connection config?

Tried below and same error:

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:nova@controller/nova

On Wed, Nov 26, 2014 at 3:02 PM, Geo Varghese gvarghese@aqorn.com wrote:

Try this

connection=mysql://nova:nova@controller/nova

This will fix the issue.

On Thu, Nov 27, 2014 at 1:06 AM, Amit Anand aanand@viimed.com wrote:

Same error - also tried with 127.0.0.1. Even crazier I removed all
keystone nova (user, service, etc) and dropped the nova DB and recreated
that, then recreated keystone nova with a new different password, updated
nova.conf with new password and still get the same error (notice below now
nova has the different password):

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+
10 rows in set (0.00 sec)

On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes jaypipes@gmail.com wrote:

On 11/26/2014 02:21 PM, Amit Anand wrote:

Hi Jay - I believe so below is the part that is in the nova.conf

The SQLAlchemy connection string used to connect to the

bare-metal database (string value)

connection=mysql://nova:PASSWORD@controller/nova

The PASSWORD is exactly the same what I have in the conf file and what I
have in the nova.conf

Im doing this manually via the Juno instruction guide for CentOs 7.

try:

connection=mysql://nova:PASSWORD@localhost/nova

Best,
-jay


Mailing list:
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe :
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack

--
--
Regards,
Geo Varghese


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Amit_Anand (1,340 points)   1 5 8
0 votes

On 11/26/2014 02:36 PM, Amit Anand wrote:
Same error - also tried with 127.0.0.1. Even crazier I removed all
keystone nova (user, service, etc) and dropped the nova DB and recreated
that, then recreated keystone nova with a new different password,
updated nova.conf with new password and still get the same error (notice
below now nova has the different password):

Permissions for a user are not affected by the removal of a database.
You can even add permissions for a user to operate on a database that
doesn't exist:

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| informationschema |
| mysql |
| performance
schema |
| test |
+--------------------+
4 rows in set (0.03 sec)

mysql> GRANT ALL ON foo.* TO root@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL ON test.* TO root@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> USE mysql
Database changed
mysql> SELECT * FROM db WHERE User = 'root' AND Db = 'foo'\G
*************************** 1. row ***************************
Host: localhost
Db: foo
User: root
Selectpriv: Y
Insert
priv: Y
Updatepriv: Y
Delete
priv: Y
Createpriv: Y
Drop
priv: Y
Grantpriv: N
References
priv: Y
Indexpriv: Y
Alter
priv: Y
Createtmptablepriv: Y
Lock
tablespriv: Y
Create
viewpriv: Y
Show
viewpriv: Y
Create
routinepriv: Y
Alter
routinepriv: Y
Execute
priv: Y
Eventpriv: Y
Trigger
priv: Y
1 row in set (0.00 sec)

Go figure :)

If you manually specify the host on the command line, do you still get
in to the MySQL server?

i.e., if you do this on the command line, does it work?

mysql -unova -hlocalhost -p -Dnova

Best,
-jay

MariaDB [mysql]> SELECT user,password,host FROM user;
+----------+-------------------------------------------+-----------+
| user | password | host |
+----------+-------------------------------------------+-----------+
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | 127.0.0.1 |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | ::1 |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| keystone | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | localhost |
| glance | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | localhost |
| nova | *3DA97D7423D54524806BFF6A19D94F78EEF97338 | % |
| root | *7088873CEA983CB57491834389F9BB9369B9D756 | % |
+----------+-------------------------------------------+-----------+
10 rows in set (0.00 sec)

On Wed, Nov 26, 2014 at 2:26 PM, Jay Pipes <jaypipes@gmail.com
jaypipes@gmail.com> wrote:

On 11/26/2014 02:21 PM, Amit Anand wrote:

    Hi Jay - I believe so below is the part that is in the nova.conf

    # The SQLAlchemy connection string used to connect to the
    # bare-metal database (string value)
    connection=mysql://nova:__PASSWORD@controller/nova

    The PASSWORD is exactly the same what I have in the conf file
    and what I
    have in the nova.conf

    Im doing this manually via the Juno instruction guide for CentOs 7.


try:

connection=mysql://nova:__PASSWORD@localhost/nova

Best,
-jay


Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : openstack@lists.openstack.org
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
responded Nov 26, 2014 by Jay_Pipes (59,760 points)   3 10 14
...