Ulrik S. Kofod wrote:
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.
Certainly. It's been a while since I looked at the vpopmail database,
but when I did I remember thinking "what a mess". It shows signs of
evolution more so than 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.
In DBA parlance, the --enable-many-domains configuration is not normalized.
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.
The difference to me is that, with --enable-many-domains, you can't very
well say "show me all the users for every domain" w/out knowing a valid
domain first. I suspect that this is considered some form of (convoluted
imho) security. That, and you can grant separate permissions to separate
domains with --enable-many-domains. Think ISP. I don't believe that this
is a valid concern though. I hope that some ISP types correct me here if
I'm wrong.
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 :)
I agree that a choice would be nice. Rather than continue the practice
of hard coding this option, why not have the spec file use a flag,
similar to the spambox flag in qmailadmin, that controls which database
option is used in the configure command? I expect that Jake would
include this in the stock distro, providing that the default behavior
remained the same. This way you could have your cake and eat it too. :)
It's easy to specify build flags for qtp-newmodel to use with any given
package.
My only other concern would be with the qtp-backup and qtp-restore
scripts. I think they should continue to be compatible with the
--disable-many-domains option. Can/will you have a look at them and see
if they any modification to work with the --disable-many-domains option?
This could be a problem though when QMT v2 becomes yum based. On a
related note, I hope to make the LDAP configuration of vpopmail an
option in the future (once the LDAP portion of vpopmail v5.5 is
available). I suspect that vpopmail-toaster might need to be split into
separate packages for different configurations if runtime configuration
options are not a possiblility. We can cross that bridge when we come to it.
In the meantime, you should be able to use qtp-newmodel to upgrade all
packages except vpopmail-toaster. I don't expect that your vpopmail
version (5.4.10) is much different than the current toaster version
(5.4.17), but you should check to be sure.
regards
Thanks for your help with this, Ulrik.
--
-Eric 'shubes'
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'
>
---------------------------------------------------------------------------------
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]
