1 (edited by abranca 2021-04-14 23:53:10)

Topic: [SOLVED] migration to new server and mysql access denied

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.3.2
- Deployed with iRedMail Easy or the downloadable installer? downloadable installer
- Linux/BSD distribution name and version: debian buster 10.9
- 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.
====
hello everyone,
i'm running some pre-migration tests and i followed the guide (https://docs.iredmail.org/migrate.to.ne … l-accounts) regarding the mysql part.

i have an iredmail installation on a proxmox ve container and, given the amount of mails (about 200gb), incremental backups take about 6 hours because the software has to re-read the whole disk every time looking for differences. i decided to migrate to a proxmox vm because backups are faster.

now i have a debian buster 10.9 container, iredmail 1.3.2 mysql with roundcube, sogo, fail2ban, etc. (complete installation) and an identical vm with the same mysql passwords.

I copied from the new server the mail archive (vmail1) with rsync (rsync -apt root@xxx.xxx.xxx.xxx:/var/vmail/vmail1 /var/vmail) and I copied from the old server the backups of the mysql database and imported them.

when I restart the server I get from roundcube a connection error to the database

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

in the log are reported access denied:

Access denied for user 'vmail'@'localhost' (using password: YES)
Access denied for user 'netdata'@'localhost' (using password: YES)
Access denied for user 'iredadmin'@'localhost' (using password: YES)
Access denied for user 'fail2ban'@'localhost' (using password: YES)
Access denied for user 'sogo'@'localhost' (using password: YES)
Access denied for user 'roundcube'@'localhost' (using password: YES)

what and where am i wrong?
thanks for your help, if I can post or attach other data let me know.

----

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