Another change is to make sure our test user has create/drop privileges on all databases, and to be able to create/drop databases:
grant create, drop on *.* to 'hibernate_orm_test'@'localhost'; We will need similar for the other databases too. On Tue, Jul 21, 2015 at 6:02 PM Sanne Grinovero <sa...@hibernate.org> wrote: > On 20 July 2015 at 17:41, Steve Ebersole <st...@hibernate.org> wrote: > > Sanne for MariaDB (and MySQL if we ever add it) we need to add at least > one > > more setting: > > > > sql-mode="traditional" > > I've applied this change. > > --Sanne > > > > > We could probably get away with less ANSI compliant mode, but after days > > playing with this I just want to cover my bases :) > > > > On Sat, Jul 18, 2015 at 3:37 PM Sanne Grinovero <sa...@hibernate.org> > wrote: > >> > >> Thanks, great suggestions! > >> I've applied these and some more. > >> > >> The MariaDB configuration: > >> - > >> > https://github.com/hibernate/ci.hibernate.org/blob/master/roles/mariadb-server/files/my.cnf > >> > >> The PosgreSQL configuration files: > >> - > >> > https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-server/files/pg_hba.conf > >> - > >> > https://github.com/hibernate/ci.hibernate.org/blob/master/roles/postgres-server/files/postgresql.conf > >> > >> Both are running with these settings now on each CI slave. > >> Sanne > >> > >> On 18 July 2015 at 00:49, Steve Ebersole <st...@hibernate.org> wrote: > >> > [18:45] <sebersole> whoa.. > >> > [18:45] <sebersole> sannegrinovero: we definitely need this for > mariadb > >> > on > >> > ci... > >> > [18:46] <sebersole> sync_binlog=0 innodb_flush_log_at_trx_commit=0 > >> > innodb_doublewrite=0 > >> > [18:46] <sebersole> tests were much faster > >> > > >> > These were suggested to me on the #mariadb list. I added them to my > >> > local > >> > /etc/my.cnf file and the tests were significantly faster. > >> > _______________________________________________ > >> > hibernate-dev mailing list > >> > hibernate-dev@lists.jboss.org > >> > https://lists.jboss.org/mailman/listinfo/hibernate-dev > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
