Bug 1266032

Summary: Packstack should use pymysql database driver since Liberty
Product: Red Hat OpenStack Reporter: Ihar Hrachyshka <ihrachys>
Component: openstack-packstackAssignee: Ivan Chavero <ichavero>
Status: CLOSED ERRATA QA Contact: Yogev Rabl <yrabl>
Severity: high Docs Contact:
Priority: high    
Version: 8.0 (Liberty)CC: aortega, apevec, derekh, ichavero, jschluet, majopela, mmagr, moshele, nlevinki, tsedovic, yeylon
Target Milestone: gaKeywords: TestOnly, Triaged, ZStream
Target Release: 8.0 (Liberty)   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: openstack-packstack-7.0.0-0.11.dev1692.g1b5e83b.el7ost Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 1266028 Environment:
Last Closed: 2016-04-15 13:46:02 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1266027, 1266028, 1266029    
Bug Blocks: 1266381    
Attachments:
Description Flags
answer-file none

Description Ihar Hrachyshka 2015-09-24 10:57:23 UTC 
+++ This bug was initially created as a clone of Bug #1266028 +++

+++ This bug was initially created as a clone of Bug #1266027 +++

As of Liberty, openstack gate switched to pymysql driver, so it's better to use it in all openstack installers too.

To switch to the new driver, database_connection string should get driver specifier as in:

database_connection = mysql+pymysql://...127.0.0.1/...
Comment 2 Ihar Hrachyshka 2015-09-25 08:20:29 UTC 
*** Bug 1266387 has been marked as a duplicate of this bug. ***
Comment 3 Miguel Angel Ajo 2015-11-12 11:12:29 UTC 
rising the priority of this, because it does block QoS
Comment 4 Miguel Angel Ajo 2015-11-12 11:13:38 UTC 
Also upstream uses for all tests the pymsql driver, there are for sure hidden issues with the old one that we don't want to get materialised in support requests.
Comment 6 Martin Magr 2015-12-07 15:42:43 UTC 
Created attachment 1103278 [details]
answer-file

Hi,
Regarding https://bugzilla.redhat.com/show_bug.cgi?id=1288968
Please look at the following answer file

Thanks,
Itzik
Comment 7 Martin Magr 2015-12-07 15:44:03 UTC 
Comment on attachment 1103278 [details]
answer-file

Pardon me, this is a wrong BZ :).
Comment 10 Alvaro Lopez Ortega 2016-01-26 14:56:43 UTC 
Right. Actually, we identified the old python module as the source of various problems.
Comment 14 Yogev Rabl 2016-04-10 14:27:28 UTC 
verified on openstack-packstack-7.0.0-0.14.dev1702.g490e674.el7ost.noarch
Comment 16 errata-xmlrpc 2016-04-15 13:46:02 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2016-0636.html