One thing to keep in mind right now you cannot auth with alias domain until you apple the patch that Eric created a moth ago as I discovered this problem.
Remo -- Sent from iPhone > On martedì, feb 20, 2024 at 11:23, Remo Mattei <r...@mattei.org > (mailto:r...@mattei.org)> wrote: > Well after you create the list you can do this: > > > > Qmail Toaster Help / Perl Help > (https://plug-discuss.phxlinux.narkive.com/e3hWI4px/qmail-toaster-help-perl-help) > phxlinux.narkive.com > (https://plug-discuss.phxlinux.narkive.com/e3hWI4px/qmail-toaster-help-perl-help) > > > > > > > > > > > > > > cat lista3 | tr "," " " | while read USER DOMAIN PASSWORD ; do vadduser > $USER@$DOMAIN $PASSWORD; done > > > From the shell > > To get the current pass you can do this: > > for i in $(cat lista); do vuserinfo $i...@italy1.com ; done|grep clear > > Then you can use the paste command like this: > > paste lista1 clear1|column -s $'\t' -t|tee lista3 > > > To give you an idea on how to make this happen. You will need to tweak it a > little to fit the command above :) or tweak the first command > > Remo > > > > > On Feb 20, 2024, at 09:48, Gary Bowling <g...@gbco.us> wrote: > > > > > > > > > > > > I see the new versions were not compiled with --disable-many-domains. That > > looks like it was discussed in the list way back in 2011. > > > > > > Back then, when that decision was made, there much have been a convenient > > way to migrate from one db structure to the other? > > > > > > > > > > > > > > > > Remo, > > > > > > > > Yes, but there are complications to doing that. I have many domains, many > > users, different quotas, aliases, etc. > > > > > > > > The command you sent. > > > > > > Once you get the list of users > > > > for i in $(cat lista); do vadduser -r -q NOQUOTA $i...@domain.com ; done > > > > Thanks,gb > > > > > > > > > > > > On 2/20/2024 12:23 PM, Remo Mattei wrote: > > > Hi Gary, > > > Did you recall my email? I said create the domain on the new server, then > > > run the shell to create every user with password then sync from old to > > > new on all emails and you would have been set. The script may have been > > > changed Eric will know more about that but how I migrate which is a > > > little longer does not depend on the old mysql. I had issue in the past > > > so I just do that my own way and no issues at all. > > > > > > Remo > > > > > > > On Feb 20, 2024, at 09:20, Gary Bowling <g...@gbco.us> > > > > (mailto:g...@gbco.us) wrote: > > > > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 2/20/2024 11: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 g...@gbco.us > > > > > (mailto: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: > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > ____________________ > > > > > > > The Moderns on Spotify > > > > > > > (https://distrokid.com/hyperfollow/themoderns/bbrs) > > > > > > > ____________________ > > > > > > > --------------------------------------------------------------------- > > > > > > > To unsubscribe, e-mail: > > > > > > > qmailtoaster-list-unsubscr...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com) For > > > > > > > additional commands, e-mail: > > > > > > > qmailtoaster-list-h...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-h...@qmailtoaster.com) > > > > > > > --------------------------------------------------------------------- > > > > > > > To unsubscribe, e-mail: > > > > > > > qmailtoaster-list-unsubscr...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com) For > > > > > > > additional commands, e-mail: > > > > > > > qmailtoaster-list-h...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-h...@qmailtoaster.com) > > > > > > > --------------------------------------------------------------------- > > > > > > > To unsubscribe, e-mail: > > > > > > > qmailtoaster-list-unsubscr...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-unsubscr...@qmailtoaster.com) For > > > > > > > additional commands, e-mail: > > > > > > > qmailtoaster-list-h...@qmailtoaster.com > > > > > > > (mailto:qmailtoaster-list-h...@qmailtoaster.com) > > --------------------------------------------------------------------- To > > unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For > > additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com