EL7 to EL 8 or 9 - Revision history

Ebroch at 14:20, 2 April 2024

2024-04-02T14:20:35Z

← Older revision		Revision as of 08:20, 2 April 2024
Line 1:		Line 1:
	[~~http://wiki.qmailtoaster.org/index.php?title=~~Migrate\|Back]		[[Migrate\|Back]]
	'''On destination host'''		'''On destination host'''
	Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]		Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]

Ebroch at 14:20, 2 April 2024

2024-04-02T14:20:03Z

← Older revision		Revision as of 08:20, 2 April 2024
Line 1:		Line 1:
	[[http://wiki.qmailtoaster.org/index.php?title=Migrate\|Back]]		[http://wiki.qmailtoaster.org/index.php?title=Migrate\|Back]
	'''On destination host'''		'''On destination host'''
	Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]		Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]

Ebroch at 14:19, 2 April 2024

2024-04-02T14:19:37Z

← Older revision		Revision as of 08:19, 2 April 2024
Line 1:		Line 1:
			[[http://wiki.qmailtoaster.org/index.php?title=Migrate\|Back]]
	'''On destination host'''		'''On destination host'''
	Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]		Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]

Ebroch at 14:17, 2 April 2024

2024-04-02T14:17:45Z

← Older revision		Revision as of 08:17, 2 April 2024
Line 1:		Line 1:
	'''On destination host'''		'''On destination host'''
	Install Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]		Install QMT, Rocky [[Rocky,_Alma,_Springdale_8_QT_Install\|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install\|9]]
	qmailctl stop && systemctl stop dovecot		qmailctl stop && systemctl stop dovecot

Ebroch at 04:05, 30 March 2024

2024-03-30T04:05:53Z

← Older revision		Revision as of 22:05, 29 March 2024
Line 58:		Line 58:
	''If you're migrating from a Many-Domain to Many-Domain backend nothing more is required''		''If you're migrating from a Many-Domain to Many-Domain backend nothing more is required''
	''If you're migrating from a Domain-Table backend to a Many-Domain backend you'll need to run [[Many-Domain_script\|this]] script''		''If you're migrating from a Domain-Table backend to a Many-Domain backend you'll need to run [[Many-Domain_script\|this]] script''
			''If you're migrating from a Domain-Table to Domain-Table backend and want to convert to [[Many-Domain_conversion\|Many-Domain]]''

	# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat		# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat

	Questions, comments, suggestions, corrections...contact Eric on the QMT list		Questions, comments, suggestions, corrections...contact Eric on the QMT list

Ebroch at 03:57, 30 March 2024

2024-03-30T03:57:29Z

← Older revision		Revision as of 21:57, 29 March 2024
Line 58:		Line 58:
	''If you're migrating from a Many-Domain to Many-Domain backend nothing more is required''		''If you're migrating from a Many-Domain to Many-Domain backend nothing more is required''
	''If you're migrating from a Domain-Table backend to a Many-Domain backend you'll need to run [[Many-Domain_script\|this]] script''		''If you're migrating from a Domain-Table backend to a Many-Domain backend you'll need to run [[Many-Domain_script\|this]] script''
	''

	# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat		# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat

	Questions, comments, suggestions, corrections...contact Eric on the QMT list		Questions, comments, suggestions, corrections...contact Eric on the QMT list

Ebroch at 03:56, 30 March 2024

2024-03-30T03:56:22Z

← Older revision		Revision as of 21:56, 29 March 2024
Line 55:		Line 55:
	# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON spamassassin.* TO spamassassin@localhost"		# mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON spamassassin.* TO spamassassin@localhost"
	# mysql --defaults-extra-file=$credfile spamassassin < spamassassin.sql		# mysql --defaults-extra-file=$credfile spamassassin < spamassassin.sql

			''If you're migrating from a Many-Domain to Many-Domain backend nothing more is required''
			''If you're migrating from a Domain-Table backend to a Many-Domain backend you'll need to run [[Many-Domain_script\|this]] script''
			''

	# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat		# qmailctl cdb && qmailctl start && sleep 2s && systemctl start dovecot && toaststat

	Questions, comments, suggestions, corrections...contact Eric on the QMT list		Questions, comments, suggestions, corrections...contact Eric on the QMT list

Ebroch: Created page with " '''On destination host''' Install Rocky 8 or 9 qmailctl stop && systemctl stop dovecot '''On source host''' Source host most likely EL7 # dhost=192.168.1.3 Change IP address for your needs # ssh-keygen # ssh-copy-id $dhost # ssh $dhost
'''''First rsync email db''''' # rsync --progress -zv -are ssh /home/vpopmail/do..."

2024-03-30T03:05:16Z

Created page with " '''On destination host''' Install Rocky 8 or 9 qmailctl stop && systemctl stop dovecot '''On source host''' Source host most likely EL7 # dhost=192.168.1.3 Change IP address for your needs # ssh-keygen # ssh-copy-id $dhost # ssh $dhost '''''First rsync email db''''' # rsync --progress -zv -are ssh /home/vpopmail/do..."

New page

'''On destination host'''
Install Rocky [[Rocky,_Alma,_Springdale_8_QT_Install|8]] or [[Rocky,_Alma,_Springdale_9_QT_Install|9]]
qmailctl stop && systemctl stop dovecot

'''On source host''' Source host most likely EL7
# dhost=192.168.1.3 Change IP address for your needs
# ssh-keygen
# ssh-copy-id $dhost
# ssh $dhost 
'''''First rsync email db'''''
# rsync --progress -zv -are ssh /home/vpopmail/domains/ root@$dhost:/home/vpopmail/domains 
'''''Stop services for 2nd rsync'''''
# qmailctl stop && systemctl stop dovecot 
'''''Second rsync subsequent changes to email db'''''
# rsync --progress -zv -are ssh /home/vpopmail/domains/ root@$dhost:/home/vpopmail/domains 
'''''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 
'''''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 
'''''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 
'''On destination host'''
'''''Create credentials'''''
# credfile=~/sql.cnf
# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile Edit credentials file and update password setting
'''''Load vpopmail'''''
# mysqladmin --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