Open Stack

Hi Guys

Do you think it's possible to add support for setting mysql_sql_mode in the
keystone puppet module?

Without this, and using only the default setting :

mysql_sql_mode = TRADITIONAL

many queries are failing in MariaDB servers

MariaDB [(none)]> set session sql_mode = 'TRADITIONAL';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SHOW FULL TABLES FROM "keystone";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to use
near '"keystone"' at line 1
MariaDB [(none)]>
Cheers,
Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160719/f8893cc3/attachment.html>