Bug 1344783 - rhel-osp-director: Deployment of osp9 fails with 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock''
Summary: rhel-osp-director: Deployment of osp9 fails with 'Can't connect to local MySQ...
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: rhosp-director
Version: 9.0 (Mitaka)
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ga
: 9.0 (Mitaka)
Assignee: Angus Thomas
QA Contact: Omri Hochman
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-06-10 19:35 UTC by Alexander Chuzhoy
Modified: 2016-06-14 15:08 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2016-06-14 15:08:26 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Alexander Chuzhoy 2016-06-10 19:35:54 UTC
rhel-osp-director: Deployment of osp9 fails with 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock''

Environment:
openstack-puppet-modules-8.0.4-1.el7ost.noarch
instack-undercloud-4.0.0-2.el7ost.noarch
openstack-tripleo-heat-templates-liberty-2.0.0-9.el7ost.noarch
openstack-tripleo-heat-templates-kilo-2.0.0-9.el7ost.noarch
openstack-tripleo-heat-templates-2.0.0-9.el7ost.noarch




Steps to reproduce:
Attempt to deploy overcloud HA with ssl:
 Deployment command: openstack overcloud deploy --templates --control-scale 3 --compute-scale 1 --swift-storage-scale 0 --block-storage-scale 0 --neutron-network-type vxlan --neutron-tunnel-types vxlan  --ntp-server clock.redhat.com --timeout 90 -e /usr/share/openstack-tripleo-heat-templates/environments/storage-environment.yaml -e /usr/share/openstack-tripleo-heat-templates/environments/network-isolation.yaml -e network-environment.yaml -e ~/ssl-heat-templates/environments/enable-tls.yaml -e ~/ssl-heat-templates/environments/inject-trust-anchor.yaml --ceph-storage-scale 1


Result:
Deployment fails.
Debugging with heat shows:
Error: Could not prefetch mysql_user provider 'mysql': Execution of '/usr/bin/mysql -NBe SELECT CONCAT(User, '@',Host) AS User FROM mysql.user' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error: Could not prefetch mysql_database provider 'mysql': Execution of '/usr/bin/mysql -NBe show databases' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error: Execution of '/usr/bin/mysql -e GRANT ALL PRIVILEGES ON `sahara`.* TO 'sahara'@'192.168.100.12'' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error: /Stage[main]/Sahara::Db::Mysql/Openstacklib::Db::Mysql[sahara]/Openstacklib::Db::Mysql::Host_access[sahara_192.168.100.12]/Mysql_grant[sahara@192.168.100.12/sahara.*]/ensure: change from absent to present failed: Execution of '/usr/bin/mysql -e GRANT ALL PRIVILEGES ON `sahara`.* TO 'sahara'@'192.168.100.12'' returned 1: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


Expected result:
Successful deployment.

Comment 3 Alexander Chuzhoy 2016-06-14 15:08:26 UTC
Don't reproduce this bz.


Note You need to log in before you can comment on or make changes to this bug.