Installing Tigase 8.0.0 on default MySQL8 setup yields following warnings and errors:
WARNING
Checking if database exists
Validating whether DB Exists, URI: jdbc:mysql://localhost/tigasedbinst800my8?user=tigasedbinst800my8&password=tigasedbinst800my8&useSSL=false&useLegacyDatetimeCode=false
Query failed: Can't create database 'tigasedbinst800my8'; database exists
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'tigasedbinst800my8'' at line 1
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'tigasedbinst800my8'' at line 1
Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'tigasedbinst800my8'' at line 1
Query failed: Table 'mysql.proc' doesn't exist
Query failed: Table 'mysql.proc' doesn't exist
Query failed: Table 'mysql.proc' doesn't exist
OK
ERROR
Post installation action
Post Installation, URI: jdbc:mysql://localhost/tigasedbinst800my8?user=root&password=root&useSSL=false&useLegacyDatetimeCode=false
Finalizing...
Failed to execute query: UPDATE mysql.proc p SET DEFINER = 'tigasedbinst800my8@%' WHERE db = DATABASE()
=====
Failure: Table 'mysql.proc' doesn't exist
=====
wojciech.kapcia@tigase.net commented 6 years ago
Fixed listed issues - locally tested and works with MySQL 5.7 and 8.0.15. Waiting for TTS-NG tests.
Installing Tigase 8.0.0 on default MySQL8 setup yields following warnings and errors: