Ah, thanks Eric! Unfortunately I didn't find that page earlier. But but I cobbled together a few sql queries, so I...
- exported each domain to an xml file
- then did a bit of scripting on each domains xml file to add the pw_domain field, which is the same for every record in each file.
- then used the "load xml local infile..." sql command to load
each of the files into the vpopmail table.
It seems to have all worked. I can now use ./vuserinfo and get
correct entries. The other tables, valias, lastauth, dir_control,
all seem to be the same.
So I think I'm on to the next challenge. The script you showed on
that page would have been a little easier, but no worries, it
wasn't to difficult.
Which reminds me, I need to go back and set Global
Local_infiles=0 as I had to change that to export/import local
files. Although I'm not sure that hurts anything.
Thanks, gb
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]did you migrate the database?
Many domain's conversion - QMT (qmailtoaster.org)
On 2/20/2024 9:37 AM, Gary Bowling wrote:
Thanks Eric.
Continuing through the "migration" page. After going through everything moving configs and my database, then restarting. Toaststat says everything is ok.
So I tried a simple run of ~vpopmail/bin/vuserinfo [email protected] just to query an account. I get this error
mysql: sql error[3]: Table 'vpopmail.vpopmail' doesn't exist
Logging into the db and checking, indeed I do not have a vpopmail.vpopmail table. I have all the domain tables, etc. So I went back to my old server (the one this email is coming from) and it also does not have a vpopmail.vpopmail table.
I'm sure it has something to do with how old my existing server is. But how do I resolve this?
Thanks, gb
On 2/20/2024 10:00 AM, Eric Broch wrote:
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]It's all good and there's nothing to do.
On 2/20/2024 7:11 AM, Gary Bowling wrote:
Another question on my migration. On the qmailtoaster.com site, under the RHEL9 derivative install heading. There is the qmail1.03-3.3.8 header and underneath it is a link for "patches applied"
I'm confused if that means. It implies that those patches are already applied and there is no need to do them. But the link takes you to the page for the patch like it's something we should apply.
I'm pretty sure it's all good and there is nothing to do, just wanted to make sure.
Thanks, gb
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
