Topic: What's the fix for "ERROR 1064 (42000) at line xxx" ?
==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.2
- Linux/BSD distribution name and version: Ubuntu 22.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Trying to use remote MySQL
- Web server (Apache or Nginx): Nginx
Hello!
I'm trying to install iRedMail 1.6.2 on my Ubuntu 22.04 LTS VPS. I'm launching the installer with the following commands:
USE_EXISTING_MYSQL='YES' \
MYSQL_SERVER_ADDRESS='mysql.xxxxl.org' \
MYSQL_SERVER_PORT='3306' \
MYSQL_ROOT_USER='xxxxxx' \
MYSQL_ROOT_PASSWD='xxxxxxxx' \
MYSQL_GRANT_HOST='mysql.xxxxxxl.org' \
bash iRedMail.sh
I choose to install MariaDB server because I cannot skip that!!!
Everything starts installing and then few and there starts logging MySQL related errors. Something like this:
[ INFO ] Configure Fail2ban (authentication failure monitor).
ERROR 1064 (42000) at line 5: 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 'j6dF90876QLxxxxxxxxgVnzaq6'' at line 1
Can anyone give me some help with this? Is this happening because my remote sql server runs MySQL and iRedMail installs on MariaDB?
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.