View Revisions: Issue #4161
| Summary | 0004161: MySQL ignore zeroDateTimeBehavior=convertToNull if server is set to NO_ZERO_DATE | ||
|---|---|---|---|
| Revision | 2019-11-23 18:56 by zeljko.katic@procosafe.no | ||
| Description | In a fresh installation of Ubuntu 18.04.3 Desktop and Fedora31 Workstation in VirtualBox and with addition of MySQL on both VM's provisioning of Master Node is stuck at at Installing Node banner and it just keeps on hanging, Even after refresh. I can see in MySQL DB that SymmetricDS tables get installed but the installation does not finish, even after couple of hours. | ||
| Revision | 2019-11-24 17:13 by elong | ||
| Description | The settings of db.url with zeroDateTimeBehavior=convertToNull and server set to sql_mode of NO_ZERO_DATE are not compatible. SymmetricDS will try to compare dates with 0000-00-00 to convert them, but MySQL will return a syntax error, which causes queries and triggers to break. In a fresh installation of Ubuntu 18.04.3 Desktop and Fedora31 Workstation in VirtualBox and with addition of MySQL on both VM's provisioning of Master Node is stuck at at Installing Node banner and it just keeps on hanging, Even after refresh. I can see in MySQL DB that SymmetricDS tables get installed but the installation does not finish, even after couple of hours. |
||
| Revision | 2019-11-23 18:56 by zeljko.katic@procosafe.no | ||
| Steps To Reproduce | Install Ubuntu 18.04.3 Desktop or Fedora31 Workstation Install Java 11 headless Install MySQL DB Grant correct users Create a DB. Install SymmetricDS 3.11.0 as new installation in /opt/symmetricds with defaults Go to Mozzila Firefox to localhost:31415 Install Master Node with MySQL Connection String Choose Standard2Tier All permissions granted Press Install button |
||
| Revision | 2019-11-24 17:13 by elong | ||
| Steps To Reproduce | Install Ubuntu 18.04.3 Desktop or Fedora31 Workstation Install Java 11 headless Install MySQL DB Grant correct users Create a DB. Install SymmetricDS 3.11.0 as new installation in /opt/symmetricds with defaults Go to Mozzila Firefox to localhost:31415 Install Master Node with MySQL Connection String Choose Standard2Tier All permissions granted Press Install button |
||