RE: virtualdomains file

[Michael Devogelaere <michael@xxxxxxxxxx>]

A possible problem is with your locals-table: you tell the server that it
only serves 'localdomain.com'. Try to use a locals-file and remove that
line from your sqlserver-file. If that solves the problem: put that
line back in your sqlserver-file, and add 'mydomain.net' to the table.
Another problem: your connectionstring doesn't make sense: qmail doesn't
know the name of your database: try to add 'dbname=...' to it.
The little qmail-getpw test would certainly fail here. The main reason
i put that test in the installguide, is that it checks a _lot_ of your
sqlserver-file (it doesn't check pop-related things and localtable).
Could you please run that test ? If it doesn't print anything, please
tell us the exit-status (qmail-getpw xyz modomain.net ; echo $?)

Kindly regards,
Michael Devogelaere.

On Mon, 22 Jan 2001, amin wrote:

> 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.
>