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.