Projects tigase _server server-core Issues #1004
Improve compatibility with MySQL8 (#1004)
Closed
wojciech.kapcia@tigase.net opened 6 years ago

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.

wojciech.kapcia@tigase.net commented 6 years ago

Tests all green.

issue 1 of 1
Type
Task
Priority
Normal
Assignee
RedmineID
8681
Version
tigase-server-8.0.0
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#1004
Please wait...
Page is in error, reload to recover