Ask Your Question
0

Keystone unable to connect to MySQL durring Grizzy Setup

asked 2013-04-17 12:21:40 -0500

ten_ten_steve gravatar image

updated 2013-08-22 19:43:54 -0500

fifieldt gravatar image

My first time installing Open Stack and I'm following the instruction guide form https://github.com/mseknibilel/OpenStack-Grizzly-Install-Guide/blob/master/OpenStack_Grizzly_Install_Guide.rst (OpenStack Grizzly Install Guide)

I've gotten to Step 3 with no issues. When I try to run keystone-manage db_sync

I get the response sqlalchemy.exc.OperationalError: (OperationalError) (2003, "Can't connect to MySQL server on '10.10.100.51' (110)") None None

I went back into MySQL as root and made sure the keystone database and keystoneUser privileges were indeed there.

I then tried to login to MySQL as keystoneUser using mysql -u keystoneUser -p using keystonePass as the password (as specified in the install guide) and MySQL returns Access denied for user 'keystoneUser'@'localhost' (using password: YES)

Is there something I'm missing? Has anyone else encountered a problem like this?

Thanks

edit retag flag offensive close merge delete

3 answers

Sort by ยป oldest newest most voted
2

answered 2013-04-18 01:11:15 -0500

RomilGupta gravatar image

updated 2013-06-07 17:31:41 -0500

smaffulli gravatar image

Hey,

I think MySQL is not configured to listen for remote connections follow the below steps :

1 Configure MySQL to listen for remote connections:

  sed -i "s/^bind-address/#bind-address/" /etc/mysql/my.cnf

2 Configure MySQL to accept remote root connections (from any host ('%')):

MYSQL_BATCH="mysql --user=root --password=$MYSQL_PASS --batch"
$MYSQL_BATCH --execute "INSERT INTO mysql.user ( Host , User , Password , Select_priv ,
    Insert_priv , Update_priv , Delete_priv , Create_priv , Drop_priv , Reload_priv , 
    Shutdown_priv , Process_priv , File_priv , Grant_priv , References_priv , 
    Index_priv , Alter_priv , Show_db_priv , Super_priv , Create_tmp_table_priv , 
    Lock_tables_priv , Execute_priv , Repl_slave_priv , Repl_client_priv , 
    Create_view_priv , Show_view_priv , Create_routine_priv , Alter_routine_priv , 
    Create_user_priv , ssl_type , max_questions , max_updates , max_connections , 
    max_user_connections) VALUES ( '%', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
    'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y','Y', 'Y', 'Y', 'Y', 'Y',
    'Y', 'Y', 'Y', 'Y', '', '0', '0', '0', '0');"

3 Restart MySQL for the changes to take effect:

/etc/init.d/mysql restart

hopefully this will solve your problem .

edit flag offensive delete link more

Comments

it did! thank you very much

ten_ten_steve gravatar imageten_ten_steve ( 2013-05-06 14:41:45 -0500 )edit

I am having the same problem, but this solution unfortunately does not work for me. Any thoughts?

bobo gravatar imagebobo ( 2013-08-09 19:00:29 -0500 )edit
0

answered 2013-11-18 15:54:02 -0500

shri gravatar image

check ip address of your eth0, it should be 10.10.100.51...

edit flag offensive delete link more
0

answered 2013-06-06 02:15:21 -0500

modernkarthi gravatar image

Hi

i am installing openstack Grizzly on redhat 6.4 using the instruction below

https://github.com/mseknibilel/OpenStack-Grizzly-Install-Guide/blob/OVS_MultiNode/OpenStack_Grizzly_Install_Guide.rst (https://github.com/mseknibilel/OpenStack-Grizzly-Install-Guide/blob/OVSMultiNode/OpenStackGrizzlyInstallGuide.rst)

While running ./keystone_basic.sh script on node 1. what is causing the below error. First time i am running the script.

[user@rh64x-41-101 ~]$ sudo vi keystonebasic.sh [user@rh64x-41-101 ~]$ ./keystonebasic.sh Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) usage: keystone user-role-add --user <user> --role <role> [--tenant <tenant>] keystone user-role-add: error: argument --user/--user-id/--userid: expected one argument usage: keystone user-role-add --user <user> --role <role> [--tenant <tenant>] keystone user-role-add: error: argument --user/--user-id/--userid: expected one argument usage: keystone user-role-add --user <user> --role <role> [--tenant <tenant>] keystone user-role-add: error: argument --user/--user-id/--user_id: expected one argument Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) (1045, \"Access denied for user 'keystone'@'localhost' (using password: YES)\") None None", "code": 500, "title": "Internal Server Error"}}. (HTTP 500) usage: keystone user-create --name <user-name> [--tenant-id <tenant-id>] [--pass <pass>] [--email <email>] [--enabled <true|false>] keystone user-create: error: argument --tenant-id: expected one argument usage: keystone user-role-add --user <user> --role <role> [--tenant <tenant>] keystone user-role-add: error: argument --tenant/--tenant-id: expected one argument usage: keystone user-create --name <user-name> [--tenant-id <tenant-id>] [--pass <pass>] [--email <email>] [--enabled <true|false>] keystone user-create: error: argument --tenant-id: expected one argument usage: keystone user-role-add --user <user> --role <role> [--tenant <tenant>] keystone user-role-add: error: argument --tenant/--tenant-id: expected one argument usage: keystone user-create --name <user-name> [--tenant-id <tenant-id>] [--pass <pass>] [--email <email>] [--enabled <true|false>] keystone user-create: error: argument --tenant-id: expected one argument usage: keystone user-role-add --user <user ... (more)

edit flag offensive delete link more

Comments

Plz check whether you have provided correct host ip amd ext ip. HOST IP should not connect to internet. EXT IP connects to internet for openstack, ALso check the write permissions for keystone_basic.sh and keystone_endpoints_basic.sh

shri gravatar imageshri ( 2013-11-18 15:58:56 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2013-04-17 12:21:40 -0500

Seen: 7,142 times

Last updated: Nov 18 '13