Re: MySQL 5.7 and SQL Mode

2017-04-12 Thread Wido den Hollander
>> > >> Yes, but a client can do this as well. It doesn't have to be server > >> wide. > >> > >> Do you know where the MySQL client is initiated by CloudStack? A few > >> lines of code there should/might be enough. > >> > >> Wi

Re: MySQL 5.7 and SQL Mode

2017-04-12 Thread Erik Weber
t;> > >> >> Yes, but a client can do this as well. It doesn't have to be server wide. >> >> Do you know where the MySQL client is initiated by CloudStack? A few >> lines of code there should/might be enough. >> >> Wido >> >> > >> > Regards. >> > >

Re: MySQL 5.7 and SQL Mode

2017-04-12 Thread Wido den Hollander
t doesn't have to be server wide. > > Do you know where the MySQL client is initiated by CloudStack? A few > lines of code there should/might be enough. > > Wido > > > > > Regards. > > > > _

Re: MySQL 5.7 and SQL Mode

2017-04-11 Thread Koushik Das
Hollander > Sent: 10 April 2017 20:30:55 > To: dev@cloudstack.apache.org > Subject: MySQL 5.7 and SQL Mode > > Hi, > > While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran into this error on the management server: > >

Re: MySQL 5.7 and SQL Mode

2017-04-11 Thread Wido den Hollander
__ > From: Wido den Hollander > Sent: 10 April 2017 20:30:55 > To: dev@cloudstack.apache.org > Subject: MySQL 5.7 and SQL Mode > > Hi, > > While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran > into this error on the management server: >

Re: MySQL 5.7 and SQL Mode

2017-04-11 Thread Rohit Yadav
ander Sent: 10 April 2017 20:30:55 To: dev@cloudstack.apache.org Subject: MySQL 5.7 and SQL Mode Hi, While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran into this error on the management server: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1

Re: MySQL 5.7 and SQL Mode

2017-04-10 Thread Wido den Hollander
> Op 10 april 2017 om 18:20 schreef Rafael Weingärtner > : > > > I noticed this problem on CentOS 7. > It seems that by default the mysql 5.6, comes with sql_mode = "" (at least > in my Ubuntu installation); while on 5.7, it comes with quite some > restrictions. > I set it to the default of 5.6

Re: MySQL 5.7 and SQL Mode

2017-04-10 Thread Wei ZHOU
We had this issue, and made same change as you said. We also add it to chef cookbook. 2017年4月10日星期一，Wido den Hollander 写道： > Hi, > > While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran > into this error on the management server: > > com.mysql.jdbc.exceptions.jdbc4.MySQLS

Re: MySQL 5.7 and SQL Mode

2017-04-10 Thread Rafael Weingärtner
I noticed this problem on CentOS 7. It seems that by default the mysql 5.6, comes with sql_mode = "" (at least in my Ubuntu installation); while on 5.7, it comes with quite some restrictions. I set it to the default of 5.6, it would be nice though to see if we can improve our SQLs to comply with th

Re: MySQL 5.7 and SQL Mode

2017-04-10 Thread Rene Moser
Hi Wido On 04/10/2017 05:00 PM, Wido den Hollander wrote: > Hi, > > While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran > into this error on the management server: > > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of > SELECT list is not in GRO

MySQL 5.7 and SQL Mode

2017-04-10 Thread Wido den Hollander
Hi, While testing with Ubuntu 16.04 and CloudStack 4.10 (from master) I've ran into this error on the management server: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cloud.i.id' which is not