1

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.

2

Re: Install iRedMail with a remote MySQL server

*) What's the content in file /root/.my.cnf?
*) Any error in file iRedMail-0.9.6/runtime/install.log?

3

Re: Install iRedMail with a remote MySQL server

Sorry, it's my fault.
Typing wrong mysql admin_iredmail password.

I can install iRedmail with a remote MySQL Server now.

Thanks a lot.

Matt