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