1 Topic by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Topic: Updating iRedMail/iRedAdmin with separate DB server

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Deployed with iRedMail Easy or the downloadable installer? Installer
- Linux/BSD distribution name and version: CentOS
- 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.
====

Just to be sure i am not doing the wrong thing, any specific precaution or instruction when upgrading iRedMail and all the accessory service in case the DB server is on a separate machine?

Thanks

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,091

Re: Updating iRedMail/iRedAdmin with separate DB server

Nothing particular that i'm aware of.
Just apply the SQL changes on your db server instead of on iRedMail server.

3 Reply by Rashef

  • Rashef
  • Rashef
  • Member
  • Offline
  • From: London
  • Registered: 2009-05-22
  • Posts: 93

Re: Updating iRedMail/iRedAdmin with separate DB server

ZhangHuangbin wrote:

Nothing particular that i'm aware of.
Just apply the SQL changes on your db server instead of on iRedMail server.

I tried to run the iRedAdmin updater on the iRedMail server and it said it couldn't find the correct my.cnf... shall I run it on the DB server?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,091

Re: Updating iRedMail/iRedAdmin with separate DB server

There're few comment lines in the upgrade script:

# Notes:
#
#   * it uses sql username 'root' by default to connect to sql database. If you
#     are using a remote SQL database which you don't have root privilege,
#     please specify the sql username on command line with 'SQL_IREDADMIN_USER'
#     parameter like this:
#
#       SQL_IREDADMIN_USER='iredadmin' bash upgrade_iredadmin.sh
#
#   * it reads sql password for given sql user from /root/.my.cnf by default.
#     if you use a different file, please specify the file on command line with
#     'MY_CNF' parameter like this:
#
#       MY_CNF='/root/.my.cnf-iredadmin' SQL_IREDADMIN_USER='iredadmin' bash upgrade_iredadmin.sh

I suggest you write a my.cnf (with remote db server as server address) on iRedMail server, then run the iRedAdmin upgrade script with the MY_CNF= to specify my.cnf path, and optionally specify the sql user name.