openstack team mailing list archive

[Arindam Choudhury <arindam@xxxxxxxx>]

thanks,
GRANT ALL ON keystone.* TO 'keystone'@'192.168.122.10' IDENTIFIED BY 'keystone';
fixed the issue.
but then:
GRANT ALL ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'keystone';
what it does?


> From: Robert.vanLeeuwen@xxxxxxxxxxxxx
> To: openstack@xxxxxxxxxxxxxxxxxxx
> Date: Wed, 17 Apr 2013 10:48:01 +0000
> Subject: Re: [Openstack] keystone-manage db_sync error
> 
> > connection = mysql://keystone:keystone@192.168.122.10/keystone
> >
> > mysql> select User,Host from mysql.user;
> > | keystone         | localhost         |
> >
> > sqlalchemy.exc.OperationalError: (OperationalError) 
> > (1045, "Access denied for user 'keystone'@'ubu-a.arindam.com' (using password: YES)") None None
> 
> Looks like a pretty clear error message to me.
> 
> Note that if you specify 192.168.122.10 as a database host you need to give grants to that user from the IP it will connect from. If it is on the same machine it will probably connect from 192.168.122.10
> If you set mysql user permissions from localhost you will also need to connect to localhost in the keystone.conf.
> 
> Cheers,
> Robert van Leeuwen
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp