hmm, looks like the db structure changed since my old install??
Is that correct?
I created a new test domain in vpopmail with vadddomain which
worked, then added a new user to that dummy domain.
When I look at the db, it now has a vpopmail table that has the following structure.
mysql> select * from vpopmail;
+------------+-----------+------------------------------------+--------+--------+------------+--------------------------------------------+-----------------+-----------------+
| pw_name | pw_domain | pw_passwd |
pw_uid | pw_gid | pw_gecos |
pw_dir | pw_shell |
pw_clear_passwd |
My old server has a separate table for every domain, then the structure for each domain has this structure.
select * from gbco_us;
+----------------+------------------------------------+--------+--------+---------------------+-----------------------------------------------+------------+------------------+
| pw_name | pw_passwd | pw_uid |
pw_gid | pw_gecos |
pw_dir | pw_shell |
pw_clear_passwd |
+----------------+------------------------------------+--------+--------+---------------------+-----------------------------------------------+------------+------------------+
The difference being the field "pw_domain"
So I guess the new structure has all the domains in the same table? If it does, then I need to figure out how to migrate my old db to the new format.
Thanks, gb
--------------------------------------------------------------------- To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
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 g...@gbco.us 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: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.comIt'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: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
