Topic: Problem with iredamin with MySQL 8?
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.98
- Linux/BSD distribution name and version: Ubuntu 16.04LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Not yet
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I've tried to move from using a mariaDB backend to a 8.0.11 MySQL Cluster and it seems to be working fine but I can't logon to iredadmin because I get an error:
(1064, "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 'admin WHERE username='webtech@armymail.mod.uk' AND active=1 LIMIT 1' at line 1")
It looks like MySQL 8 sees admin as a reserved word so changing the SQL statement to:
"SELECT * FROM `admin` WHERE username='webtech@armymail.mod.uk' AND active=1 LIMIT 1' at line 1"
..would work.
Regards
jones6r
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.