Topic: Install iRedMail with a remote MySQL server
==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.6
- Linux/BSD distribution name and version: CentOS 7.3 64-Bit
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL (Remote 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.
====
Dear Support,
I try to follow the step to install iRedmail with remote MySQL as below URL
http://www.iredmail.org/docs/install.ir … erver.html
But seems that it cannot connect to remote MySQL when installing. Please advise.
node1.example.com 192.168.15.137 (Remte MySQL)
mail1.example.com 192.168.15.139 (iRedmail)
===================================================================================
Installation Script:
USE_EXISTING_MYSQL='YES' \
MYSQL_SERVER_ADDRESS='192.168.15.137' \
MYSQL_SERVER_PORT='3306' \
MYSQL_ROOT_USER='admin_iredmail' \
MYSQL_ROOT_PASSWD='admin_password' \
MYSQL_GRANT_HOST='192.168.15.139' \
bash iRedMail.sh
===================================================================================
Error message when installing:
[ INFO ] Configure MariaDB database server.
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
ERROR 1045 (28000): Access denied for user 'admin_iredmail'@'mail1.example.com' (using password: YES)
[ INFO ] Setup daily cron job to backup SQL databases with /var/vmail/backup/backup_mysql.sh
===================================================================================
Testing the MySQL remote connection from 192.168.15.139 to 192.168.15.137:
[root@mail1 iRedMail-0.9.6]# mysql -u admin_iredmail -p -h 192.168.15.137
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 298
Server version: 5.5.56-MariaDB-wsrep MariaDB Server, wsrep_25.20.r9949137
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
MariaDB [(none)]>
===================================================================================
Regards,
Matt
----
Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.