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]
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
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
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.
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)
share your localrc too.
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'