Michael Colvin wrote:
A week or so ago I had some questions about QMT and brought up some
questions about VPOPMail, related to connecting to a non-local database for
the purposes of chkuser/vpopmail.
I later thought, can I connect to two different databases? If I put two
lines in vpopmail.mysql, will it check one, then the next?
I did a little research, and it looks like you can put two lines in, but one
is used for read only, and the other is used for read/write. Is this
correct? Can anyone shed any light on this?
I don't know. I would ask this on the vpopmail list (if nobody here knows).
My goal is to have two databases. One that's used simply to verify that a
specific account at a specific domain is legit. The other would be for mail
that's delivered locally. There may not be a reason to do this, in the long
run, but I'd like to know if it's possible.
I'm sorta curious now too.
And, lastly, what are peoples thoughts on using vpopmail configured where
each domain has it's own table w/in MySQL (I believe this is default for the
ISO), versus having one table for all domains? (This is how I have
qmailrocks running now.) Are there any performance benefits to doing it one
way or the other?
I don't know this either. I doubt that performance would vary much one
way or another. There are performance tuning factors that would have a
much bigger impact. Personally, I prefer each domain with its own table,
as it's more normalized (natural).
That being said, if you're concerned about performance, you might want
to consider an LDAP backend when it becomes available in vpopmail-5.5. I
expect this to happen near the end of the year. (LDAP is available in
5.4.28, but you may need a patch for it, and it will change in 5.5 soon
anyhow).
--
-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: qmailtoaster-list-unsubscr...@qmailtoaster.com
For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
