From: Juan Miscaro (scry_mryahoo.ca)
Date: Fri Jun 01 2007 - 11:49:34 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

--- mouss <mlist.onlyfree.fr> wrote:

> Juan Miscaro wrote:
> >
> > I'm using an SQL backend where I have a table for system users such
> as
> > postmaster and root that point to remote addresses and a table for
> my
> > Maildir users. I'm sorry I don't have the proper table terminology
> > (I'm temporarily locked out of my system) but the way I read your
> > comment my additions should be made to the same table and that
> doesn't
> > seem possible with my setup.
> >
> >
>
> multiple tables can be joined to form a single table in multiple
> ways.
> for example:
>
> query = select target from db1.table1, db2.table2, .... where ....
>
> you can also use CASE WHEN... and other statements if you only want
> to
> do some queries in some cases.

You went a bit over my head mouss. This is what I have:

virtual_mailbox_domains =
mysql:/etc/postfix/sql/virtual_mailbox_domains.cf
virtual_uid_maps = mysql:/etc/postfix/sql/virtual_uid_maps.cf
virtual_gid_maps = mysql:/etc/postfix/sql/virtual_gid_maps.cf
virtual_mailbox_maps =
mysql:/etc/postfix/sql/virtual_mailbox_recipients.cf
virtual_alias_maps = mysql:/etc/postfix/sql/virtual_alias_maps.cf
virtual_transport = maildrop

$ cat virtual_mailbox_recipients.cf

user = postfix
password = password
dbname = mail
table = virtual_users
select_field = virtual_mailbox
where_field = email
additional_conditions = and active = '1'
hosts = robby.example.com

$ cat virtual_alias_maps.cf

user = postfix
password = password
dbname = mail
table = virtual_aliases
select_field = virtual_user_email
where_field = alias
hosts = robby.example.com

Where do I construct the query you speak of?

Juan

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]