On Tue, Jul 19, 2016 at 4:57 AM, Constantinescu David Alexandru <aldavx at gmail.com> wrote: > 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 Yes, this is an option in oslo.db: http://docs.openstack.org/developer/oslo.db/opts.html#database.mysql_sql_mode So you'll need to submit a patch here: https://github.com/openstack/puppet-oslo/blob/master/manifests/db.pp (with unit tests) And here: https://github.com/openstack/puppet-keystone/blob/master/manifests/db.pp Cheers, > 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 > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > -- Emilien Macchi