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 <jaypi...@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
