Ask Your Question

Could not prefetch mysql_user provider

asked 2014-11-13 03:20:30 -0500

codingfreak gravatar image


I am new to openstack and trying out the steps in RDO quickstart page in a Centos 7 machine.

Initially I started installing with a sudo user and ended up giving root password toooooo many time. So i started installing as root user. Then I came across a permission related issue but I am not an expert with mysql.

Can anyone help me out ?

Applying x.x.x.x_amqp.pp
Applying x.x.x.x_mariadb.pp
x.x.x.x_amqp.pp:                                  [ DONE ]    
x.x.x.x_mariadb.pp:                            [ ERROR ]      
Applying Puppet manifests                         [ ERROR ]

ERROR : Error appeared during Puppet run: x.x.x.x_mariadb.pp
Error: Could not prefetch mysql_user provider 'mysql': Execution of '/usr/bin/mysql -NBe SELECT MAX_USER_CONNECTIONS, MAX_CONNECTIONS, MAX_QUESTIONS, MAX_UPDATES, PASSWORD FROM mysql.user WHERE CONCAT(user, '@', host) = 'root@'' returned 1: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
You will find full trace in log /var/tmp/packstack/20141113-085431-OW4WHj/manifests/x.x.x.x_mariadb.pp.log
Please check log file /var/tmp/packstack/20141113-085431-OW4WHj/openstack-setup.log for more information

Additional information:
 * A new answerfile was created in: /root/packstack-answers-20141113-085431.txt
 * Time synchronization installation was skipped. Please note that unsynchronized time on server instances might be problem for some OpenStack components.
 * Warning: NetworkManager is active on x.x.x.x. OpenStack networking currently does not work on systems that have the Network Manager service enabled.
 * File /root/keystonerc_admin has been created on OpenStack client host x.x.x.x. To use the command line tools you need to source the file.
 * To access the OpenStack Dashboard browse to http://x.x.x.x/dashboard .
Please, find your login credentials stored in the keystonerc_admin in your home directory.
 * To use Nagios, browse to http://x.x.x.x/nagios username: nagiosadmin, password: 625f77db460f4a4a
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2014-11-25 04:14:55 -0500

updated 2014-11-25 04:16:02 -0500

If you have run packstack previously, there will be a file in your home directory named something like packstack-answers-2014-.txt You will probably want to use that file again, using the --answer-file option, so that any passwords you've already set (eg, mysql) will be reused.

$ packstack --answer-file=~/root/packstack-answers-2014*-*.txt
edit flag offensive delete link more


what if i want change all the passwords. What should be done to reinstall openstack using packstack

Queen gravatar imageQueen ( 2015-03-17 06:11:58 -0500 )edit

as I m getting error of unauthorized Http 401..

Queen gravatar imageQueen ( 2015-03-17 06:12:29 -0500 )edit

@Queen if you want to reinstall then "yum remove mysql mysql-server" and then manually delete mysql contents inside /etc/ by using rm -R /etc/my.cnf* and also /root/.my* file

But dependencies may still exist which can be painful task to remove.

vinayus gravatar imagevinayus ( 2015-12-22 23:24:07 -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

1 follower


Asked: 2014-11-13 03:20:30 -0500

Seen: 1,710 times

Last updated: Nov 25 '14