[Bug 1845321] Re: cinder-daemons autopkgtest must override driver to use pymysql

[Christian Ehrhardt ]

@Corey: the Eoan upload has a different but still cross arch SQL error:

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'IDENTIFIED BY 'changeme'' at line 1

This test does:
  9 mysql -u root << EOF                                                             
 10 CREATE DATABASE cinder;                                                          
 11 GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'localhost' \                       
 12   IDENTIFIED BY 'changeme';                                                      
 13 GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'%' \                               
 14   IDENTIFIED BY 'changeme';                                                      
 15 EOF 

That is a common mysql8 issue, read e.g. [1].
Users are no more "implicitly" created by Grant+identified.
Instead you'd need it to be like:

CREATE USER 'cinder'@'%' IDENTIFIED BY 'changeme';
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'%';
CREATE USER 'cinder'@'localhost' IDENTIFIED BY 'changeme';
GRANT ALL PRIVILEGES ON cinder.* TO 'cinder'@'localhost';

Here is a debdiff with a suggestion, and given that it is a
mysql8-special you won't need it in Disco.

[1]: https://lefred.be/content/how-to-grant-privileges-to-users-in-
mysql-8-0/

** Patch added: "fix for mysql8 issues in eoan (debdiff)"
   https://bugs.launchpad.net/ubuntu/+source/qemu/+bug/1845321/+attachment/5291379/+files/cinder-mysql8.debdiff

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to cinder in Ubuntu.
https://bugs.launchpad.net/bugs/1845321

Title:
  cinder-daemons autopkgtest must override driver to use pymysql

Status in cinder package in Ubuntu:
  Fix Committed
Status in qemu package in Ubuntu:
  New
Status in cinder source package in Disco:
  Triaged
Status in qemu source package in Disco:
  New
Status in cinder source package in Eoan:
  Fix Committed
Status in qemu source package in Eoan:
  New

Bug description:
  [Impact]
  debian/tests/cinder-daemons is failing due to the disco switch of sqlalchemy defaulting to mysqldb. We must override the driver to use pymysql. I'm not sure how this was not caught until now.

  [Test Case]
  Run autopkgtests.

  [Regression Potential]
  None, this is just updating an autopkgtest.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cinder/+bug/1845321/+subscriptions