1

Topic: ERROR 1064 (42000) at line 5 during clean install

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.3
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: Ubuntu 22.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Clean install of iRedMail, clean install of external MySQL server (Ubuntu 22.04 LTS, MySQL from default repos)

USE_EXISTING_MYSQL='YES' \
    MYSQL_SERVER_ADDRESS='192.168.1.19' \
    MYSQL_SERVER_PORT='3306' \
    MYSQL_ROOT_USER='admin_iredmail' \
    MYSQL_ROOT_PASSWD='xxx' \
    MYSQL_GRANT_HOST='192.168.1.13' \
    bash iRedMail.sh

Error:

[ INFO ] Configure MariaDB database server.
ERROR 1064 (42000) at line 5 in file: '/home/andrzej/iRedMail-1.6.3/runtime/init_vmail_db.sql': 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 'SpFNKxxxx'' at line 4
ERROR 1064 (42000) at line 11 in file: '/home/andrzej/iRedMail-1.6.3/runtime/init_vmail_db.sql': 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 'iZYcb8xxxx'' at line 4
[ INFO ] Setup daily cron job to backup SQL databases with /storage/vmail/backup/backup_mysql.sh

What is going on?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: ERROR 1064 (42000) at line 5 during clean install

andrzej wrote:

ERROR 1064 (42000) at line 5 in file: '/home/andrzej/iRedMail-1.6.3/runtime/init_vmail_db.sql': 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 'SpFNKxxxx'' at line 4
ERROR 1064 (42000) at line 11 in file: '/home/andrzej/iRedMail-1.6.3/runtime/init_vmail_db.sql': 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 'iZYcb8xxxx'' at line 4

What are the full SQL commands caused the error in /home/andrzej/iRedMail-1.6.3/runtime/init_vmail_db.sql?
Looks like permission issue on remote server.

3

Re: ERROR 1064 (42000) at line 5 during clean install

This was a clean install - other than provisioning user as per iRedmail external mysql instruction - nothing else was done.