How to Resolve This :- Authorization Failed: An unexpected error prevented the server from fulfilling your request. (OperationalError) (2003, "Can't connect to MySQL server on '127.0.0.1' (111)") None None (HTTP 500) [closed]

asked 2014-02-24 00:58:45 -0500

Milan Detroja gravatar image

Hi all,

i am getting following error while installing devstack on VM. [last error] +++ glance image-list --status=active Authorization Failed: An unexpected error prevented the server from fulfilling your request. (OperationalError) (2003, "Can't connect to MySQL server on '127.0.0.1' (111)") None None (HTTP 500) ++ case "${#images[]}" in milan@openstack2:~/devstack$ 2014-02-24 01:00:09 ++ echo 'Found no valid images to use!' Found no valid images to use! ++ exit 1 + clean + local r=1 ++ jobs -p + kill [first error] ... ++ keystone endpoint-get --service ec2 ++ awk '/\|[[:space:]]ec2.publicURL/ {print $4}' Authorization Failed: An unexpected error prevented the server from fulfilling your request. (OperationalError) (2003, "Can't connect to MySQL server on '127.0.0.1' (111)") None None (HTTP 500) + ec2= ...

I even Checked for Mysql status before running stack.sh it was working.

Thanks Milan

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Milan Detroja
close date 2014-02-25 04:04:34.651048

Comments

Your database has not been given grant for the ip 127.0.0.1 possibly, can you share your localrc and complete log with paste.openstack.org? Also share what "show grants;" display on mysql

prasoontelang gravatar imageprasoontelang ( 2014-02-24 02:44:29 -0500 )edit

before running stack.sh i checked for mysql and it was working fine. but once i run stack.sh after mysql is not in working condition, i even try to start mysql but i was showing job fail to start.

Milan Detroja gravatar imageMilan Detroja ( 2014-02-24 03:54:08 -0500 )edit

mysql> show grants -> ; +----------------------------------------------------------------------------------------------------------------------------------------+ | Grants for root@localhost | +----------------------------------------------------------------------------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*0BE3B501084D35F4C66DD3AC4569EAE5EA738212' WITH GRANT OPTION | | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION | +----------------------------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.01 sec)

Milan Detroja gravatar imageMilan Detroja ( 2014-02-24 03:57:11 -0500 )edit

share your localrc too.

prasoontelang gravatar imageprasoontelang ( 2014-02-24 05:34:36 -0500 )edit

SERVICE_TOKEN=nova ADMIN_PASSWORD=nova GUEST_PASSWORD=nova ROOTSLEEP=3 PUBLIC_INTERFACE=eth0 FLAT_INTERFACE=eth1 FLOATING_RANGE='10.0.14.0/24' NET_MAN=FlatDHCPManager MULTI_HOST=False MYSQL_HOST='127.0.0.1' MYSQL_USER=root MYSQL_PASSWORD=nova RABBIT_HOST='127.0.0.1' RABBIT_PASSWORD=nova LIBVIRT_TYPE=qemu GLANCE_HOSTPORT='127.0.0.1:9292' SERVICE_PASSWORD=nova ENABLED_SERVICES=g-api,g-reg,key,n-api,n-crt,swift,n-cpu,n-net,n-cond,cinder,c-sch,c-api,c-vol,c-bak,n-sch,n-novnc,n-xvnc,n-cauth,horizon,rabbit,tempest,mysql,s-proxy SWIFT_HASH=66a3d6b56c1f479c8b4e70ab5c2000f5 SWIFT_REPLICAS=1 SWIFT_DATA_DIR=$DEST/data API_RATE_LIMIT=False USE_SCREEN=True SCREEN_LOGDIR=$DEST/logs/screen LOGFILE='/opt/stack/devstack.log'

Milan Detroja gravatar imageMilan Detroja ( 2014-02-24 06:51:44 -0500 )edit