Skip to content
Closed
Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
43 commits
Select commit Hold shift + click to select a range
6314367
CLOUDSTACK-9647: NIC adapter type becomes e1000 , even after changing…
Dec 2, 2016
bbff9f1
CLOUDSTACK-9725 Failed to update VPC Network during N/w offering Upgr…
bvbharat Jan 5, 2016
bd80c8e
VM snapshot is disabled if the VM Instance is off
Jul 12, 2016
280f3be
CLOUDSTACK-9623: Deploying virtual machine fails due to "Couldn't fin…
Dec 6, 2016
d7eae25
CLOUDSTACK-9208: Assertion Error in VM_POWER_STATE handler- Fixed
jayapalu Mar 9, 2017
b676a8a
Bug fix for CLOUDSTACK-9762 Management Server UI (VM statistics pag…
resmo Jan 31, 2017
0c1c27b
CLOUDSTACK-9871: Set SQL Mode in SQL Session for MySQL 5.7 compatibility
wido Apr 12, 2017
c689d4a
CE-113 trace logging and rethrow instead of nesting CloudRuntimeExcep…
DaanHoogland Mar 30, 2017
61189db
CE-113 configure workervm gc based on job expiry
DaanHoogland Apr 5, 2017
8065aed
CE-113 extra trace log of worker VMs
DaanHoogland Apr 5, 2017
4fd7291
CE-113 removed TODOs
DaanHoogland Apr 6, 2017
084febb
CE-113 use of duration (instead of the old clock-tick-based code
DaanHoogland Apr 7, 2017
9e634d9
deb: Only build binary packages
wido Apr 19, 2017
e7326b1
CLOUDSTACK-9630: Cannot use listNics API as advertised
Dec 9, 2016
70e7382
Fix typo on label.gpu
ustcweizhou Apr 24, 2017
feb5fa9
CLOUDSTACK-9779 : Releasing secondary guest IP fails with error VM ni…
niteshsarda Feb 27, 2017
1f93087
Merge pull request #1978 from Accelerite/ReleaseNicSecondaryIP
karuturi Apr 26, 2017
ac1fd45
Merge pull request #2063 from ustcweizhou/label.gpu
karuturi Apr 26, 2017
cf622ec
CLOUDSTACK-8793: fix missing doc when projectid was added
resmo Apr 26, 2017
91e237c
CLOUDSTACK-9893 / CLOUDSTACK-8239 fix smoke/test_deploy_virtio_scsi_v…
nathanejohnson Apr 25, 2017
4ad29b4
Merge pull request #1918 from jayakarteek/cloudstack-9762
karuturi Apr 27, 2017
3f6d27f
Merge pull request #1797 from sudhansu7/CLOUDSTACK-9630
karuturi Apr 27, 2017
64776f3
Merge pull request #1852 from Accelerite/CLOUDSTACK-9695
karuturi Apr 27, 2017
cab0869
Merge pull request #2037 from wido/sql_mode
karuturi Apr 27, 2017
f6edc1b
Merge release branch 4.9 to master
karuturi Apr 27, 2017
4bb7ffe
CLOUDSTACK-9815 move CertService to more generic location
DaanHoogland Apr 27, 2017
8377e2f
Merge pull request #2069 from resmo/fix/doc-version-added-CLOUDSTACK-…
karuturi Apr 27, 2017
11bc262
Merge pull request #2053 from wido/deb-binary
karuturi Apr 27, 2017
20c67ac
CLOUDSTACK-9815 rename ssl to tls
DaanHoogland Apr 27, 2017
ae4e571
CLOUDSTACK-9815 move package further to apache location
DaanHoogland May 1, 2017
dd5b02a
Merge pull request #2066 from myENA/bug/CLOUDSTACK-9893-fix_virtio_sc…
karuturi May 2, 2017
0ca2841
Merge pull request #1997 from Accelerite/vmpoweroff
karuturi May 2, 2017
992ce6e
Merge pull request #1970 from bvbharatk/CLOUDSTACK-9725
karuturi May 2, 2017
8854d4c
Merge pull request #1792 from nitin-maharana/nitin4
karuturi May 2, 2017
57628b2
Merge pull request #2030 from shapeblue/snapshot-housekeeping
karuturi May 2, 2017
2de854c
Merge pull request #2071 from shapeblue/certificate-handling-move
karuturi May 2, 2017
bdc4fd7
Merge pull request #1810 from sudhansu7/CLOUDSTACK-9647
karuturi May 2, 2017
dcc7f4c
Merge release branch 4.9 to master
karuturi May 2, 2017
4e49b7d
CE-110 move config to public fields
DaanHoogland Mar 23, 2017
234c3fb
CE-110 remove duplicate-unused functionality
DaanHoogland Apr 14, 2017
73021fb
CE-110 task for marking cleaning fully cloned templates
DaanHoogland Apr 14, 2017
c970d34
CE-110 default interval of 0 minutes means do not mark for cleaning
DaanHoogland Apr 18, 2017
7ba5017
CE-110 markedForGC is ignored so delete the templates in the task tha…
DaanHoogland Apr 20, 2017
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
CLOUDSTACK-9871: Set SQL Mode in SQL Session for MySQL 5.7 compatibility
MySQL 5.7 has a more strict SQL mode by default with which CloudStack
is not compatible.

By setting the SQL Mode to a more relaxed mode on run-time we can
run without changing any SQL server settings.

Admins could also apply this to the [mysqld] section of their my.cnf:

sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

Signed-off-by: Wido den Hollander <wido@widodh.nl>
  • Loading branch information
wido committed Apr 12, 2017
commit 0c1c27ba85bbe6812e7d07fe05e999abf0574b33
2 changes: 1 addition & 1 deletion client/tomcatconf/db.properties.in
Original file line number Diff line number Diff line change
Expand Up @@ -39,7 +39,7 @@ db.cloud.testWhileIdle=true
db.cloud.timeBetweenEvictionRunsMillis=40000
db.cloud.minEvictableIdleTimeMillis=240000
db.cloud.poolPreparedStatements=false
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

# CloudStack database SSL settings
db.cloud.useSSL=false
Expand Down
2 changes: 1 addition & 1 deletion packaging/centos7/tomcat7/db.properties
Original file line number Diff line number Diff line change
Expand Up @@ -39,7 +39,7 @@ db.cloud.testWhileIdle=true
db.cloud.timeBetweenEvictionRunsMillis=40000
db.cloud.minEvictableIdleTimeMillis=240000
db.cloud.poolPreparedStatements=false
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

# CloudStack database SSL settings
db.cloud.useSSL=false
Expand Down
2 changes: 1 addition & 1 deletion utils/conf/db.properties
Original file line number Diff line number Diff line change
Expand Up @@ -44,7 +44,7 @@ db.cloud.testWhileIdle=true
db.cloud.timeBetweenEvictionRunsMillis=40000
db.cloud.minEvictableIdleTimeMillis=240000
db.cloud.poolPreparedStatements=false
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&prepStmtCacheSqlLimit=4096
db.cloud.url.params=prepStmtCacheSize=517&cachePrepStmts=true&prepStmtCacheSqlLimit=4096&sessionVariables=sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

# usage database settings
db.usage.username=cloud
Expand Down