On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
DK <[EMAIL PROTECTED]> wrote:
> On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > DK <[EMAIL PROTECTED]> wrote:
> > > There is data like email aliases which need to be accessed by the MTA.
> > > It wouldn't be a good idea to open each users db to check the aliases
> > > for each email that arrives. So what we would need is a common db
> > > which mirrors one table from all the user databases.
> >
> > Have one database containing email aliases and/or other shared
> > information and then one email per user. Then use the ATTACH
> > command to join them together at runtime. See
> >
> > http://www.sqlite.org/lang_attach.html
> >
> > --
> > D. Richard Hipp <[EMAIL PROTECTED]>
> >
>
> Thanks Richard,
> But it says: "There is a compile-time limit of 10 attached database
> files" If this means max db 10 then this is no good we will have more
> then 10 users.
>
You are probably not serving all your users all at once. Just
ATTACH and DETACH user databases on an as-needed basis.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Well postfix when mail arrives checks if the to field of the email
matches up with any users aliases. One user can have many aliases as
in [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
but also [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED] these are all aliases which belong to one user
one mail box. Postfix must check this table field for every user.
Right now we have a table with two fields userid and alias. Postfix
checks the alias field to know if that users exist then if the alias
exists postfix accepts that email sends it over to dbmail, dbmail
matches the alias field to the userid and delivers the mail.
Demi
