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 <[email protected]> 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 <[email protected]> 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 : [email protected] >> 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 : [email protected] > Unsubscribe : > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > >
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
