When I first installed qmail on a redhat, 10+ years ago, i set --enable-many-domains because because I think duplicate tables used for the exact same thing is poor database design.
I can't see the upside to having duplicate tables used for the exact same thing. If you have many users one domain, all you rows will be in a single table anyway and if you (like me) have many domains with a few users on each, you will end up with nearly more tables than rows. Basically the only difference in the two solutions is where you put the domain name in the SQL, after "from" or in the where clause. As the domain name just is a peace of data, to me, it belongs in the where clause. When I moved to qmailtoaster just I changed the vpopmail-toaster.spec and rebuild it. That was a lot easier than writing a SQL script dividing the data out into a many small tables. When I move to a new server I'll consider swallowing my principles and go for the "popular" solution, so I can enjoy the benefits of qtp :) though it would be nice if there was a way to choose :) regards Eric Shubert sagde: > How'd you end up with --enable-many-domains? > What do you need it for? > > What do you hate about --disable-many-domains? It still allows multiple > domains, it just implements them in separate tables instead of lumping them all together. Having them in the same table is considered a bad practice by many, for reasons I won't go into here. > > If you don't really need --enable-many-domains and can live with mutiple > domains in separate tables, it shouldn't be too hard to convert. Someone here could probably help you out, or you might try asking on the vpopmail users list. > > When in Rome, ... ;) > > -- > -Eric 'shubes' > > Ulrik S. Kofod wrote: >> I'm waiting for an answer from the sender. >> I have looked into qtp before, but decided not to go for it. Problem is that >> I build >> vpopmail with --enable-many-domains and I don't want an autoupdate to mess >> with that. >> I soo wish --enable-many-domains could be changed to a yes/no option in a >> .conf file. >> It is a COS4 and I have a new COS5 box where I'll be installling qmt, just >> need time >> to get it done, but >> 1) changing mysql so i don't need --enable-many-domains does not make the >> move from >> old to new server less complicated :( >> 2) I really hate the "--disable-many-domains" solution ;) >> regards >> Eric Shubert sagde: >>> I guess the answer to your question is, "back to the sender". Now why it was rejected is another question that I'm afraid might never be answered. As I said, that old of a version would reject messages with no log message explaining that the message was rejected or why. >>> That's a pretty old version you're running, and logging has improved a bit >>> since that version. QTP has many improvements as well. I would strongly recommend upgrading. Which OS version are you running? If you're on COS4, I would install the qmailtoaster-plus.repo package (see http://qtp.qmailtoaster.com/), then >>> # yum update >>> then >>> # qtp-newmodel >>> That should bring you up to date on everything. >>> I'd also recommend installing spamdyke, which is as easy as running the qtp-install-spamdyke script (in more recent versions of QTP). >>> -- >>> -Eric 'shubes' > > > --------------------------------------------------------------------------------- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) > Vickers Consulting Group offers Qmailtoaster support and installations. > If you need professional help with your setup, contact them today! > --------------------------------------------------------------------------------- > Please visit qmailtoaster.com for the latest news, updates, and packages. > > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > venlig hilsen Ulrik --------------------------------------------------------------------------------- Qmailtoaster is sponsored by Vickers Consulting Group (www.vickersconsulting.com) Vickers Consulting Group offers Qmailtoaster support and installations. If you need professional help with your setup, contact them today! --------------------------------------------------------------------------------- Please visit qmailtoaster.com for the latest news, updates, and packages. To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
