Migrate: Difference between revisions

From QmailToaster
Jump to navigation Jump to search
No edit summary
No edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
'''On destination host'''
[[Main_Page#Migrate|Back]]
Install Rocky [[Rocky,_Alma,_Springdale_8_QT_Install|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install|9]]
== [[ EL7 to EL 8 or 9 ]] ==
qmailctl stop && systemctl stop dovecot
== [[ Many-Domain conversion ]] ==
 
== [[ Vconvert Backend ]] ==
'''On source host''' <span style="color:red">Source host most likely EL7</span>
== [[ Many-Domain script ]] ==
# dhost=192.168.1.3 <span style="color:red">Change IP address for your needs</span>
== [[ ClamAV & SA to EPEL ]] ==
# ssh-keygen
# ssh-copy-id $dhost
# ssh $dhost<br>
'''''First rsync email db'''''
# rsync --progress -zv -are ssh /home/vpopmail/domains/ root@$dhost:/home/vpopmail/domains<br>
'''''Stop services for 2nd rsync'''''
# qmailctl stop && systemctl stop dovecot<br>
'''''Second rsync subsequent changes to email db'''''
# rsync --progress -zv -are ssh /home/vpopmail/domains/ root@$dhost:/home/vpopmail/domains<br>
'''''Bring over the rest of the data'''''
# rsync --progress -zv -are ssh /var/qmail/control/ root@$dhost:/var/qmail/control
# rsync --progress -zv -are ssh /var/qmail/users/ root@$dhost:/var/qmail/users
# rsync --progress -zv -are ssh /etc/tcprules.d/ root@$dhost:/etc/tcprules.d
# rsync --progress -zv -are ssh /usr/share/toaster/include/admin.pass  root@$dhost:/usr/share/toaster/include
# rsync --progress -zv -are ssh /usr/share/toaster/include/admin.htpasswd  root@$dhost:/usr/share/toaster/include
# [ ! -d /etc/mail/spamassassin ] && sqadj= || sqadj=mail/
# rsync --progress -zv -are ssh /etc/${sqadj}spamassassin/.spamassassin/ root@$dhost:/etc/mail/spamassassin/.spamassassin
# rsync --progress -zv -are ssh /etc/${sqadj}spamassassin/*.cf root@$dhost:/etc/mail/spamassassin
# rsync --progress -zv -are ssh /usr/share/squirrelmail/plugins/ root@$dhost:/usr/share/squirrelmail/plugins
# rsync --progress -zv -are ssh /var/lib/squirrelmail/prefs/  root@$dhost:/var/lib/squirrelmail/prefs<br>
'''''Dovecot files are not necessary for EL 8/9 they are only for reference'''''
# rsync --progress -zv -are ssh /etc/dovecot/toaster.conf root@$dhost:/etc/dovecot
# rsync --progress -zv -are ssh /etc/dovecot/local.conf root@$dhost:/etc/dovecot<br>
'''''Bring over MySQL DBs'''''
# mysqldump -u root -p dspam > dspam.sql
# mysqldump -u root -p spamassassin > spamassassin.sql
# mysqldump -u root -p roundcube > roundcube.sql
# mysqldump -u root -p vpopmail > vpopmail.sql
# scp *.sql root@$dhost:/root<br>
'''On destination host'''
'''''Create credentials'''''
# credfile=~/sql.cnf
# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile <span style="color: red">Enter file update password setting for your configuration</span>
'''''Load vpopmail'''''
# mysql --defaults-extra-file=$credfile vpopmail < vpopmail.sql
'''''Load DSpam'''''
# mysqladmin --defaults-extra-file=$credfile create dspam
# mysql --defaults-extra-file=$credfile -e "CREATE USER dspam@localhost IDENTIFIED BY 'p4ssw3rd'"
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON dspam.* TO dspam@localhost"
# mysql --defaults-extra-file=$credfile dspam < dspamdb.sql
'''''Load Roundcube'''''
# mysql --defaults-extra-file=$credfile -e "create database roundcube character set utf8 collate utf8_bin"
# mysql --defaults-extra-file=$credfile -e "CREATE USER roundcube@localhost IDENTIFIED BY 'p4ssw3rd'"
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost"
# mysql --defaults-extra-file=$credfile roundcube < roundcube.sql
'''''Load Spamassassin'''''
# mysqladmin --defaults-extra-file=$credfile create spamassassin
# mysql --defaults-extra-file=$credfile -e "CREATE USER spamassassin@localhost IDENTIFIED BY 'p4ssw3rd'"
# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON spamassassin.* TO spamassassin@localhost"
# mysql --defaults-extra-file=$credfile spamassassin < spamassassin.sql
# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat
 
Questions, comments, suggestions, corrections...contact Eric on the QMT list

Latest revision as of 08:54, 2 April 2024