On 23 July 2015 at 17:41, Steve Ebersole <st...@hibernate.org> wrote: > 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.
That limitation was actually intentional. I think most users will have Hibernate connect via a limited-privileged user, so you don't think there would be value in us actually testing using the more limited privileges? I'm ok to change it, but - unless it's too inconvenient to get current tests reliable - I'd prefer to create a second user for when test infrastructure code need to create/drop databases. Why are you needing this? -- Sanne > > > > 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
