Well created a new controller on a whole new machine and get all the way up until compute and get same error again. I have to think it something with my nova.conf but I cant figure it out. Ive pasted here so if anyone can take a look and see maybe what Im doing incorrect I would appreciate it...
http://paste.openstack.org/show/139079/ On Wed, Nov 26, 2014 at 4:09 PM, Amit Anand <aan...@viimed.com> wrote: > Im going to try building a new controller on a whole new nuc see if I get > the same I will keep yall abreast if it works or not. In any case thank you > very much for all your help!!! > > On Wed, Nov 26, 2014 at 3:56 PM, Amit Anand <aan...@viimed.com> wrote: > >> >> Password is viimed1 >> >> >> >> On Wed, Nov 26, 2014 at 3:55 PM, Amit Anand <aan...@viimed.com> wrote: >> >>> George >>> >>> Thanks. Yeah there no other nova.conf I went as far as to do a find in >>> case I put somewhere nothing turned up except the proper one. I did have a >>> nova.conf.orig (I always make a backup so i can always start over) and was >>> hoping maybe you hit the nail on the head so I moved that out to my >>> /home/amit dir but alas that failed as well :-( >>> >>> Permissions I made rwrwrw still same. >>> >>> >>> >>> >>> >>> On Wed, Nov 26, 2014 at 3:42 PM, Amit Anand <aan...@viimed.com> wrote: >>> >>>> Geo >>>> >>>> Error logs are here: >>>> >>>> http://paste.openstack.org/show/139035/ >>>> >>>> When I run your command with password nova it fails - when I run it >>>> with the real password it works fine >>>> >>>> [root@controller ~]# mysql -u nova -p -h controller nova >>>> Enter password: >>>> I entered nova here >>>> ERROR 1045 (28000): Access denied for user 'nova'@'controller' (using >>>> password: YES) >>>> >>>> >>>> [root@controller ~]# mysql -u nova -p -h controller nova >>>> Enter password: >>>> I entered real password here >>>> Welcome to the MariaDB monitor. Commands end with ; or \g. >>>> Your MariaDB connection id is 13 >>>> 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]> quit >>>> Bye >>>> >>>> >>>> >>>> >>>> >>>> On Wed, Nov 26, 2014 at 3:36 PM, Amit Anand <aan...@viimed.com> wrote: >>>> >>>>> Jay, >>>>> >>>>> So this is the command that u sent, works just fine connect to Nova DB: >>>>> >>>>> [root@controller nova]# mysql -unova -hlocalhost -p -Dnova >>>>> Enter password: >>>>> Welcome to the MariaDB monitor. Commands end with ; or \g. >>>>> Your MariaDB connection id is 8 >>>>> 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]> >>>>> >>>>> >>>>> I also changed in nvoa.conf connection=mysql://nova:__PASS >>>>> WORD@localhost/nova (I tried with both a space and a _ as I was not >>>>> sure exactly what you meant - still same error) :-( >>>>> >>>>> I also took a look at a command you ran and I tried it, would this be >>>>> correct output (notice I didnt specify a DB in command)? >>>>> >>>>> MariaDB [mysql]> SELECT * FROM db WHERE User = 'root'\G >>>>> *************************** 1. row *************************** >>>>> Host: % >>>>> Db: nova >>>>> User: root >>>>> Select_priv: Y >>>>> Insert_priv: Y >>>>> Update_priv: Y >>>>> Delete_priv: Y >>>>> Create_priv: Y >>>>> Drop_priv: Y >>>>> Grant_priv: Y >>>>> References_priv: Y >>>>> Index_priv: Y >>>>> Alter_priv: Y >>>>> Create_tmp_table_priv: Y >>>>> Lock_tables_priv: Y >>>>> Create_view_priv: Y >>>>> Show_view_priv: Y >>>>> Create_routine_priv: Y >>>>> Alter_routine_priv: Y >>>>> Execute_priv: Y >>>>> Event_priv: Y >>>>> Trigger_priv: Y >>>>> 1 row in set (0.01 sec) >>>>> >>>>> Also this is the output for user Nova: >>>>> >>>>> MariaDB [mysql]> SELECT * FROM db WHERE User = 'nova'\G; >>>>> *************************** 1. row *************************** >>>>> Host: localhost >>>>> Db: nova >>>>> User: nova >>>>> Select_priv: Y >>>>> Insert_priv: Y >>>>> Update_priv: Y >>>>> Delete_priv: Y >>>>> Create_priv: Y >>>>> Drop_priv: Y >>>>> Grant_priv: N >>>>> References_priv: Y >>>>> Index_priv: Y >>>>> Alter_priv: Y >>>>> Create_tmp_table_priv: Y >>>>> Lock_tables_priv: Y >>>>> Create_view_priv: Y >>>>> Show_view_priv: Y >>>>> Create_routine_priv: Y >>>>> Alter_routine_priv: Y >>>>> Execute_priv: Y >>>>> Event_priv: Y >>>>> Trigger_priv: Y >>>>> *************************** 2. row *************************** >>>>> Host: % >>>>> Db: nova >>>>> User: nova >>>>> Select_priv: Y >>>>> Insert_priv: Y >>>>> Update_priv: Y >>>>> Delete_priv: Y >>>>> Create_priv: Y >>>>> Drop_priv: Y >>>>> Grant_priv: N >>>>> References_priv: Y >>>>> Index_priv: Y >>>>> Alter_priv: Y >>>>> Create_tmp_table_priv: Y >>>>> Lock_tables_priv: Y >>>>> Create_view_priv: Y >>>>> Show_view_priv: Y >>>>> Create_routine_priv: Y >>>>> Alter_routine_priv: Y >>>>> Execute_priv: Y >>>>> Event_priv: Y >>>>> Trigger_priv: Y >>>>> 2 rows in set (0.00 sec) >>>>> >>>>> >>>>> On Wed, Nov 26, 2014 at 3:12 PM, Jay Pipes <jaypi...@gmail.com> wrote: >>>>> >>>>>> 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 | >>>>>> +--------------------+ >>>>>> | information_schema | >>>>>> | 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 >>>>>> Select_priv: Y >>>>>> Insert_priv: Y >>>>>> Update_priv: Y >>>>>> Delete_priv: Y >>>>>> Create_priv: Y >>>>>> Drop_priv: Y >>>>>> Grant_priv: N >>>>>> References_priv: Y >>>>>> Index_priv: Y >>>>>> Alter_priv: Y >>>>>> Create_tmp_table_priv: Y >>>>>> Lock_tables_priv: Y >>>>>> Create_view_priv: Y >>>>>> Show_view_priv: Y >>>>>> Create_routine_priv: Y >>>>>> Alter_routine_priv: Y >>>>>> Execute_priv: Y >>>>>> Event_priv: 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 <jaypi...@gmail.com >>>>>>> <mailto:jaypi...@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