openstack team mailing list archive

[Paul Michali <pcm@xxxxxxxxx>]

Probably want to follow MySQL procedures to reset the root password to 'pass'.


PCM (Paul Michali)

Contact info for Cisco users http://twiki.cisco.com/Main/pcm


On Jun 18, 2013, at 5:52 PM, zan tosh <ztosh71@xxxxxxxxx> wrote:

> Yes, this seems to be mysql issue. These are the error I am seeing:
> 
> 2013-06-18 11:46:22 + sudo mysqladmin -u root password pass
> 2013-06-18 11:46:22 mysqladmin: connect to server at 'localhost' failed
> 2013-06-18 11:46:22 error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> 2013-06-18 11:46:22 + true
> 2013-06-18 11:46:22 + sudo mysql -uroot -ppass -h127.0.0.1 -e 'GRANT ALL PRIVILEGES ON *.* TO '\''root'\''@'\''%'\'' identified by '\''pass'\'';'
> 2013-06-18 11:46:22 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
> 2013-06-18 11:46:22 + sudo sed -i '/^bind-address/s/127.0.0.1/0.0.0.0/g' /etc/my.cnf
> 2013-06-18 11:46:22 + sudo grep -q default-storage-engine /etc/my.cnf
> 2013-06-18 11:46:22 + sudo bash -c 'source /opt/stack/devstack/functions; iniset /etc/my.cnf mysqld default-storage-engine InnoDB'
> 2013-06-18 11:46:22 + sudo sed -i /log.slow.queries/d /etc/my.cnf
> 2013-06-18 11:46:22 + sudo sed -i -e '/^\[mysqld\]/ a log-slow-queries = /var/log/mysql/mysql-slow.log' /etc/my.cnf
> 2013-06-18 11:46:22 + sudo sed -i /long.query.time/d /etc/my.cnf
> 2013-06-18 11:46:22 + sudo sed -i -e '/^\[mysqld\]/ a long-query-time = 0' /etc/my.cnf
> 2013-06-18 11:46:22 + sudo sed -i /log.queries.not.using.indexes/d /etc/my.cnf
> 2013-06-18 11:46:22 + sudo sed -i -e '/^\[mysqld\]/ a log-queries-not-using-indexes' /etc/my.cnf
> 
> I tried restarting mysqld, re-installing mysql-server etc. Still get the same error when I try to access mysql using root. Btw, I am runnin RHEL 6.4
> 
> 
> On Tue, Jun 18, 2013 at 10:07 AM, Sean Dague <sean@xxxxxxxxx> wrote:
> On 06/18/2013 12:49 PM, zan tosh wrote:
> I am getting stuck with the following errors while installing using
> devstack (stable/grizzly).
> 2013-06-18 09:43:01 + export OS_SERVICE_TOKEN=password
> 2013-06-18 09:43:01 + OS_SERVICE_TOKEN=password
> 2013-06-18 09:43:01 + export OS_SERVICE_ENDPOINT=http://localhost:35357/v2.0
> 2013-06-18 09:43:01 + OS_SERVICE_ENDPOINT=http://localhost:35357/v2.0
> 2013-06-18 09:43:01 + create_keystone_accounts
> 2013-06-18 09:43:01 ++ keystone tenant-create --name admin
> 2013-06-18 09:43:01 ++ grep ' id '
> 2013-06-18 09:43:01 ++ get_field 2
> 2013-06-18 09:43:01 ++ read data
> 2013-06-18 09:43:01 An unexpected error prevented the server from
> fulfilling your request. (OperationalError) (1045, "Access denied for
> user 'root'@'localhost' (using password: YES)") None None (HTTP 500)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> That is your issue. It's mysql connectivity.
> 
>         -Sean
> 
> -- 
> Sean Dague
> http://dague.net
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openstack
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp