1

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.

2

Re: What's the fix for "ERROR 1064 (42000) at line xxx" ?

I guess it was caused due to your remote server runs an old MySQL or MariaDB version?

3

Re: What's the fix for "ERROR 1064 (42000) at line xxx" ?

Is there any solution emerged since then?