Migrate - Revision history

Ebroch at 14:54, 2 April 2024

2024-04-02T14:54:10Z

← Older revision		Revision as of 08:54, 2 April 2024
Line 1:		Line 1:
			[[Main_Page#Migrate\|Back]]
	== [[ EL7 to EL 8 or 9 ]] ==		== [[ EL7 to EL 8 or 9 ]] ==
	== [[ Many-Domain conversion ]] ==		== [[ Many-Domain conversion ]] ==

Ebroch at 04:12, 30 March 2024

2024-03-30T04:12:21Z

← Older revision		Revision as of 22:12, 29 March 2024
Line 3:		Line 3:
	== [[ Vconvert Backend ]] ==		== [[ Vconvert Backend ]] ==
	== [[ Many-Domain script ]] ==		== [[ Many-Domain script ]] ==
			== [[ ClamAV & SA to EPEL ]] ==

Ebroch at 04:04, 30 March 2024

2024-03-30T04:04:44Z

← Older revision		Revision as of 22:04, 29 March 2024
Line 1:		Line 1:
	== [[ EL7 to EL 8 or 9 ]] ==		== [[ EL7 to EL 8 or 9 ]] ==
			== [[ Many-Domain conversion ]] ==
	== [[ Vconvert Backend ]] ==		== [[ Vconvert Backend ]] ==
	== [[ Many-Domain script ]] ==		== [[ Many-Domain script ]] ==

Ebroch at 03:54, 30 March 2024

2024-03-30T03:54:52Z

← Older revision		Revision as of 21:54, 29 March 2024
Line 1:		Line 1:
	== [[ EL7 to EL 8 or 9 ]] ==		== [[ EL7 to EL 8 or 9 ]] ==
	== [[ Vconvert Backend ]] ==		== [[ Vconvert Backend ]] ==
			== [[ Many-Domain script ]] ==

Ebroch: /* Backend */

2024-03-30T03:29:58Z

Backend

← Older revision		Revision as of 21:29, 29 March 2024
Line 1:		Line 1:
	== [[ EL7 to EL 8 or 9 ]] ==		== [[ EL7 to EL 8 or 9 ]] ==
	== [[ Backend ]] ==		== [[ Vconvert Backend ]] ==

Ebroch: /* CDB to MySQL */

2024-03-30T03:20:11Z

CDB to MySQL

← Older revision		Revision as of 21:20, 29 March 2024
Line 1:		Line 1:
	== [[ EL7 to EL 8 or 9 ]] ==		== [[ EL7 to EL 8 or 9 ]] ==
	== [[ ~~CDB to MySQL~~ ]] ==		== [[ Backend ]] ==

Ebroch: Replaced content with "== EL7 to EL 8 or 9 == == CDB to MySQL =="

2024-03-30T03:05:01Z

Replaced content with "== EL7 to EL 8 or 9 == == CDB to MySQL =="

← Older revision		Revision as of 21:05, 29 March 2024
Line 1:		Line 1:
	~~'''On destination host'''~~		== [[ EL7 to EL 8 or 9 ]] ==
	~~Install Rocky~~ [[~~Rocky,_Alma,_Springdale_8_QT_Install\|~~8]] or ~~[[Rocky,_Alma,_Springdale_9_QT_Install\|~~9]]		== [[ CDB to MySQL ]] ==
	~~qmailctl stop && systemctl stop dovecot~~

	~~'''On source host''' <span style~~=~~"color:red">Source host most likely EL7</span>~~
	~~# dhost~~=~~192.168.1.3 <span style~~=~~"color:red">Change IP address for your needs</span>~~
	~~# 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">Edit credentials file and update password setting</span>~~
	~~'''''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~~

Ebroch at 02:51, 30 March 2024

2024-03-30T02:51:46Z

← Older revision		Revision as of 20:51, 29 March 2024
Line 39:		Line 39:
	# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile <span style="color: red">Edit credentials file and update password setting</span>		# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile <span style="color: red">Edit credentials file and update password setting</span>
	'''''Load vpopmail'''''		'''''Load vpopmail'''''
	# ~~mysql~~ --defaults-extra-file=$credfile vpopmail < vpopmail.sql		# mysqladmin --defaults-extra-file=$credfile vpopmail < vpopmail.sql
	'''''Load DSpam'''''		'''''Load DSpam'''''
	# mysqladmin --defaults-extra-file=$credfile create dspam		# mysqladmin --defaults-extra-file=$credfile create dspam

Ebroch at 02:49, 30 March 2024

2024-03-30T02:49:33Z

← Older revision		Revision as of 20:49, 29 March 2024
Line 37:		Line 37:
	'''''Create credentials'''''		'''''Create credentials'''''
	# credfile=~/sql.cnf		# 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>		# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile <span style="color: red">Edit credentials file and update password setting</span>
	'''''Load vpopmail'''''		'''''Load vpopmail'''''
	# mysql --defaults-extra-file=$credfile vpopmail < vpopmail.sql		# mysql --defaults-extra-file=$credfile vpopmail < vpopmail.sql

Ebroch at 02:48, 30 March 2024

2024-03-30T02:48:03Z

← Older revision		Revision as of 20:48, 29 March 2024
Line 34:		Line 34:
	# mysqldump -u root -p vpopmail > vpopmail.sql		# mysqldump -u root -p vpopmail > vpopmail.sql
	# scp *.sql root@$dhost:/root<br>		# scp *.sql root@$dhost:/root<br>
	'''''On destination host'''''		'''On destination host'''
	~~[[Simscan\|DSpam & Spamassassin DB creation]]~~		'''''Create credentials'''''
	# credfile=~/sql.cnf		# 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>		# echo -e "[client]\nuser=root\npassword=mysqlpass\nhost=localhost" > $credfile <span style="color: red">Enter file update password setting for your configuration</span>
	# mysql -~~u root~~ -p vpopmail < vpopmail.sql		'''''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		# 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