[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: virtualdomains file



I've try the instruction below but nothing happen to
my virtual user and the maillog recorded as below, 
  +------------------------------+
Jan 23 12:38:28 relay qmail: 980224708.835339 starting
delivery 15: msg 2033 to local xyz@xxxxxxxxxxxx
Jan 23 12:38:28 relay qmail: 980224708.835549 status:
local 1/10 remote 0/20
Jan 23 12:38:28 relay qmail: 980224708.913193 delivery
15: deferral: Temporary_failure_in_qmail-lspawn./
Jan 23 12:38:28 relay qmail: 980224708.913470 status:
local 0/10 remote 0/20
   +-----------------------------------+

and my database record is
+--------------------------------------+
userdb=> select * from passwd;
login|uid|gid|home                 
|virtual_host|password|hardquota|startdate            
      |stopdate|enabled|lastlogin
-----+---+---+----------------------+------------+--------+---------+----------------------------+--------+-------+---------
alias|  1|  1|/home/mydomain     |mydomain.net |      
 |        0|Tue Jan 23 11:45:32 2001 MYT|infinity|t   
  |         
xyz | 10|  2|/home/mydomain.net/xyz|mydomain.net |    
   |        0|Tue Jan 23 11:47:26 2001 MYT|infinity|t 
    |         
(2 rows)
------------------------------------------------------


userdb=> select * from locals;
virtual_host  
--------------
localdomain.com
(1 row)

+---and here is my local/sqlserver file ---+
 
db_use yes
check_host yes
connectionstring host=localhost user=userconsult
password=readonly dbname=userdbpopconnectionstring
user=usermgr password=secretdb dbname=userdb
dbtable passwd
autohomedir yes
localtable locals
virt_host_field virtual_host
login_field login
uid_field uid
gid_field gid
home_field home
quota_field hardquota
enable_field enable
startdate_field startdate
stopdate_field stopdate
passwd_field password
lastlogin_field lastlogin
+------------------------------+

What else missing in my system ?

-amin-
Kuala Lumpur,
Malaysia.

--- Michael Devogelaere <michael@xxxxxxxxxx> wrote:
> insert into passwd (login, virtual_host, home)
> values ('alias', 'master.com',
>                     '/home/master.com');
> 
> mkdir /home/master.com
can sqlcreatehomedir do this job? How to turn it oN?


> If a mail is sent to 'XYZ@xxxxxxxxxx':
> - select home from passwd where login='XYZ' and
> virtual_host='master.com'.
>   Suppose that user exists: fine, switch to the
> supplied homedir and deliver
>   the mail (=check for a .qmail; if not: use the
> default)
> - If that user doesn't exist: select home from
> passwd where login='alias'
>   and virtual_host='master.com'.
>   If that user doesn't exist: flood the maillogs of
> this badly-configured
>   server and do nothing else.
>   If that user exists: change to the homedir and try
> to deliver it
>   -> is there a .qmail-XYZ ?
>       yes: read it and deliver the mail
>       no: is there a .qmail-default ?
>           yes: read it and deliver the mail
>           no: bounce the mail
>                             
> Hope this helps.
> 
> Regards,
> Michael.

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/