Regarding migrating domains and emails from old toaster to the new one
I ran into an issue:

- In the old toaster in the vpopmail db I have a separate table for each domain.
- In the new toaster all domain info go to the same table named vpopmail.

Has anyone created a migration script to copy data from old separate
tables to the new multi-domain table?

Best,
Peter

On Thu, Dec 31, 2020 at 10:59 PM Peter Peltonen
<[email protected]> wrote:
>
> These commands were posted to the CentOS mailing list earlier and they
> worked for me:
>
> curl -O
> "https://springdale.math.ias.edu/data/puias/7/x86_64/os/RPM-GPG-KEY-puias";
>
> rpm --import RPM-GPG-KEY-puias
>
> curl -O
> "https://springdale.math.ias.edu/data/puias/8/x86_64/os/BaseOS/Packages/springdale-release-8.3-0.42.el8.x86_64.rpm";
>
> curl -O
> "https://springdale.math.ias.edu/data/puias/8/x86_64/os/BaseOS/Packages/springdale-appstream-8-0.sdl8.2.noarch.rpm";
>
> curl -O
> "https://springdale.math.ias.edu/data/puias/8/x86_64/os/BaseOS/Packages/springdale-core-8-0.sdl8.2.noarch.rpm";
>
> rpm -K springdale-* |grep "digests signatures OK"
>
> rpm --nodeps -ev centos-linux-release-8.3-1.2011.el8.noarch
> centos-linux-repos-8-2.el8.noarch
>
> yum --releasever 8 localinstall spring*
>
> yum clean all
>
> yum distrosync
>
> reboot
>
> On Thu, Dec 31, 2020 at 4:32 PM Eric Broch <[email protected]> wrote:
> >
> > Thanks, Peter.
> >
> > Can you post the migration notes the list?
> >
> > I'll make it a script.
> >
> > Eric
> >
> > On 12/31/2020 3:52 AM, Peter Peltonen wrote:
> > > HI,
> > >
> > > SDL 8 has the same EOL as RHEL 8: May, 2029.
> > >
> > > SDL existed before CentOS, it's provided by a university, so it should
> > > be a good option for the next eight years.
> > >
> > > Migrating from CentOS 8 to SDL 8 was pretty straightforward, not that
> > > many commands. I can provide the migration notes if someone is
> > > interested.
> > >
> > > Best,
> > > Peter
> > >
> > >
> > > On Thu, Dec 31, 2020 at 7:29 AM Eric Broch <[email protected]> 
> > > wrote:
> > >> Yes, I would recommend staying with CentOS 7 for the time being...
> > >>
> > >> But, Springdale promises longevity and stability. I was hoping to have 
> > >> the bases covered.
> > >>
> > >> The makers of Rocky are predicting having an OS out before next year. 
> > >> This is the direction I'd really like to head.
> > >>
> > >> I'm still going to try to get a Debian/Devaun version going as well.
> > >>
> > >> There is an OpenSUSE version of QMT out now, just trying to keep options 
> > >> open.
> > >>
> > >> --Eric
> > >>
> > >> On 12/30/2020 3:17 PM, [email protected] wrote:
> > >>
> > >> So the question here is CentOS 8 eol is 2021 not sure it’s even worth 
> > >> that route. Anyhow that could be a totally diff topic but CentOS 7 looks 
> > >> to have a longer support life now.
> > >>
> > >> Il giorno 30 dic 2020, alle ore 12:08, Peter Peltonen 
> > >> <[email protected]> ha scritto:
> > >>
> > >> Ok it appears my second problem was due to having php74 (and not php)
> > >> from remi's repo installed before running the script.
> > >>
> > >> Removing mariadb-server and php74 and then rerunning the install
> > >> script seems to have done the trick.
> > >>
> > >> Next step to migrate domains from old cos5 server...
> > >>
> > >> Peter
> > >>
> > >> On Wed, Dec 30, 2020 at 5:07 PM Peter Peltonen 
> > >> <[email protected]> wrote:
> > >>
> > >> Hi,
> > >>
> > >> I tried installing latest QMT using Eric's qt_install_cos8.sh script.
> > >>
> > >> I have a CentOS 8 VM that I had converted to Springdale Linux 8.
> > >>
> > >>
> > >> I ran into a few issues:
> > >>
> > >> 1) MariaDB password setup failed somehow. Maybe because I had MariaDB
> > >> already installed on this server? I could not access the mariadb
> > >> server after this failure, and needed to start the server without
> > >> grant tables and then disable "plugin authentication" (I also defined
> > >> the pw again just in case):
> > >>
> > >> service mariadb stop
> > >> mysqld_safe --skip-grant-tables &
> > >> sudo mysql -u root
> > >> [mysql] use mysql;
> > >> [mysql] update user set plugin='' where User='root';
> > >> [mysql] UPDATE user SET password=PASSWORD("my_password") WHERE 
> > >> user="root";
> > >> [mysql] flush privileges;
> > >> CTRL+D
> > >> mysqladmin -u root -p shutdown
> > >> service mariadb start
> > >>
> > >> I then rerun the part:
> > >>
> > >> credfile=~/sql.cnf
> > >> echo "Creating vpopmail database..."
> > >> mysqladmin --defaults-extra-file=$credfile reload
> > >> mysqladmin --defaults-extra-file=$credfile refresh
> > >> mysqladmin --defaults-extra-file=$credfile create vpopmail
> > >> mysqladmin --defaults-extra-file=$credfile reload
> > >> mysqladmin --defaults-extra-file=$credfile refresh
> > >> echo "Adding vpopmail users and privileges..."
> > >> mysql --defaults-extra-file=$credfile -e "CREATE USER
> > >> vpopmail@localhost IDENTIFIED BY 'SsEeCcRrEeTt'"
> > >> mysql --defaults-extra-file=$credfile -e "GRANT ALL PRIVILEGES ON
> > >> vpopmail.* TO vpopmail@localhost"
> > >> mysqladmin --defaults-extra-file=$credfile reload
> > >> mysqladmin --defaults-extra-file=$credfile refresh
> > >> echo "Done with vpopmail database..."
> > >>
> > >> BTW should the vpopmail mysql pw be changed to something else or is
> > >> the default pw used somewhere else?
> > >>
> > >>
> > >> 2) Some issues at the end of the script with clamav:
> > >>
> > >> Starting QMT...
> > >> ./qt_install_cos8.sh: line 124: qmailctl: command not found
> > >> Starting clamd freshclam dovecot spamassassin httpd chronyd acpid atd
> > >> autofs smartd named, this may take a while...
> > >> Failed to enable unit: Unit file [email protected] does not exist.
> > >> --2020-12-30 16:47:51--
> > >> https://raw.githubusercontent.com/qmtoaster/scripts/master/toaststat.cos8
> > >> Resolving raw.githubusercontent.com (raw.githubusercontent.com)...
> > >> 151.101.0.133, 151.101.64.133, 151.101.128.133, ...
> > >> Connecting to raw.githubusercontent.com
> > >> (raw.githubusercontent.com)|151.101.0.133|:443... connected.
> > >> HTTP request sent, awaiting response... 200 OK
> > >> Length: 1436 (1.4K) [text/plain]
> > >> Saving to: '/usr/bin/toaststat'
> > >> /usr/bin/toaststat                                          100%
> > >> Status of toaster services
> > >> cat: /etc/vsftpd/vsftpd.conf: No such file or directory
> > >> mariadb mariadb
> > >> systemd service:       [email protected]:       [  FAILED  ]
> > >> systemd service:         clamav-freshclam:       [  FAILED  ]
> > >> systemd service:             spamassassin:       [  FAILED  ]
> > >> systemd service:                  dovecot:       [  FAILED  ]
> > >> systemd service:                  mariadb:       [  OK  ]
> > >> systemd service:                    httpd:       [  OK  ]
> > >> systemd service:                  chronyd:       [  OK  ]
> > >> systemd service:                     sshd:       [  OK  ]
> > >> systemd service:                    crond:       [  OK  ]
> > >> systemd service:                   vsftpd:       [  FAILED  ]
> > >> systemd service:                    acpid:       [  FAILED  ]
> > >> systemd service:                      atd:       [  OK  ]
> > >> systemd service:                   autofs:       [  FAILED  ]
> > >> systemd service:                   smartd:       [  OK  ]
> > >> systemd service:               irqbalance:       [  OK  ]
> > >>
> > >>
> > >> Not sure what went wrong and if I should start debugging or try to do
> > >> a fresh install?
> > >>
> > >>
> > >> Best,
> > >> Peter
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: [email protected]
> > >> For additional commands, e-mail: [email protected]
> > >>
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: [email protected]
> > >> For additional commands, e-mail: [email protected]
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: [email protected]
> > > For additional commands, e-mail: [email protected]
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to