Ok well figured it out!!! I guess its either me or the documentation. I basically got rid of the original nova.conf (that comes with the distro) and then I just made a new nova.conf with only the changes that are listed in the documentation (ie I created [database] [DEFAULT] etc sections listed there only) and then ran DB sync an viola! It seems to work. Crazy
Now Im worried (even tho everything seems to have worked) that the conf files for glance and keystone maybe incorrect because just edited the original conf files that came with the distro. Would anyone have any idea? Also do you think this would be valuable to post on Ask Openstack and/or report it as a bug?? My new nova.conf: http://paste.openstack.org/show/139105/ Thanks everyone!!! On Wed, Nov 26, 2014 at 4:56 PM, Amit Anand <aan...@viimed.com> wrote: > 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
