1

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.

2

Re: Problem with iredamin with MySQL 8?

Thanks for sharing.

According to MySQL doc, "ADMIN became nonreserved in 8.0.12":
https://dev.mysql.com/doc/refman/8.0/en/keywords.html