1 Topic by etaboada

  • etaboada
  • Member
  • Offline
  • Registered: 2019-07-31
  • Posts: 6

Topic: IredAdmin update and Upgrade to Pro

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.9 MARIADB edition.
- Deployed with iRedMail Easy or the downloadable installer?downloadable installer
- Linux/BSD distribution name and version: Ubuntu 18.04 LTS 4.15.0-55-generic
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

We have an installation with IRedMail and remote MariaDB Server. We made the installation and before update to iRedAdminPro, we try to upgrade.

When we run bash upgrade_iredadmin.sh
We get the following error
<<< ERROR >>> MySQL user name 'root' or password is incorrect in /root/.my.cnf, please double check.

We need to put modifiers before telling that is a remote MYSQL installation?

The process to install IredAdminPro also need modifiers for Remote MYSQL?

----

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

2 Reply by etaboada

  • etaboada
  • Member
  • Offline
  • Registered: 2019-07-31
  • Posts: 6

Re: IredAdmin update and Upgrade to Pro

I Try with
MYSQL_SERVER_ADDRESS='IP_mysql_Server' \
     MYSQL_SERVER_PORT='3306' \
     MYSQL_ROOT_USER='root_user' \
     MYSQL_ROOT_PASSWD='root_password' \
     MYSQL_GRANT_HOST='%' \
bash upgrade_iredadmin.sh
But i get the same error
<< ERROR >>> MySQL user name 'root' or password is incorrect in /root/.my.cnf, please double check.

It means that i need to modify /root/.my.cnf?

3 Reply by etaboada

  • etaboada
  • Member
  • Offline
  • Registered: 2019-07-31
  • Posts: 6

Re: IredAdmin update and Upgrade to Pro

I check the settings in /root.my.cnf
# NOTE: This file is used by several programs:
#   - daily SQL backup script: /var/vmail/backup/backup_mysql.sh
#   - iRedAPD upgrade script
#   - iRedAdmin upgrade script
[client]
user=install
password=mypassword"
host=mysql_host
port=3306
And i tryed to connect to the server from iRedMail computer with these credentials
mysql -u install -p -h mysql_host
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 736
Server version: 10.1.38-MariaDB-0+deb9u1 Debian 9.8

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Everything seems ok

4 Reply by etaboada

  • etaboada
  • Member
  • Offline
  • Registered: 2019-07-31
  • Posts: 6

Re: IredAdmin update and Upgrade to Pro

Ok, solved, I must change user in .my.cnf