Stephen Liu wrote:
--- mouss <[EMAIL PROTECTED]> wrote:

Stephen Liu wrote:
Hi folks,


Debian Etch Postfix 2.3.8
Dovcot


I'm learning to setup "virtual mailbox domain class".  Please shed
me
some light on its setup;
[snip]

On /etc/postfix/mysql-virtual-mailbox-maps.cf
user = mailuser
password = mailuserpasswd
hosts = 127.0.0.1
dbname = mailserver
query = SELECT 1 FROM view_users WHERE email='%s'

unless you are using an external delivery agent, virtual_mailbox_maps

should return the mailbox location, not "1".


Could you please explain in more detail.  I'm going to create mailboxes
for users.  On non "virtual mailbox domain class" I just run;

useradd -m -s /bin/bash username


On the arrival of the 1st mail to users' account the mailbox will be
automatically created on /home/username/.  How about on "virtual
mailbox domain class".  What steps shall I perform?  TIA


if you were using a hash table, you would simply put things like

[EMAIL PROTECTED]    satimis.com/info
...

or if you want maildir (recommended)
[EMAIL PROTECTED]    satimis.com/info/
...

but you are using mysql, so this information must be put in a mysql table and your SELECT query must return the field in the second column "satimis.com/info/", somthing like

query = select mailbox from ...

instead of "select 1...". see the workaround.org howto for examples.

you need to be familiar with mysql.


take a look at the howto on http://workaround.org/

Noted with thanks

read it. it has examples of tables etc.

Reply via email to