ENCRYPT has been removed from MySQL 8

[andreasrosdal]

ENCRYPT has been removed from MySQL 8.

So Freeciv-web must be modified, by stop using ENCRYPT in MySQL and Crypt.crypt() in Java.

https://github.com/freeciv/freeciv-web/blob/develop/freeciv-proxy/freeciv-proxy.py#L170
https://github.com/freeciv/freeciv-web/blob/develop/freeciv-web/src/main/java/org/freeciv/servlet/NewPBEMUser.java#L136
https://github.com/freeciv/freeciv-web/blob/develop/freeciv-web/src/main/java/org/freeciv/servlet/LoginUser.java#L84

[andreasrosdal]

@cazfi We need help with fixing this. 😊

[cazfi]

Does MariaDB still have it? Would it be an option to always use MariaDB instead of MySQL, even in distributions where also latter is present?

[andreasrosdal]

Yes, MariaDB still has ENCRYPT():
https://mariadb.com/kb/en/encrypt/
So we could use MariaDB.

ENCRYPT() has been removed from MySQL:
https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html#function_encrypt

[andreasrosdal]

MySQL recommends using SHA2() instead.

[andreasrosdal]

Fixed in 3584523