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

autohomedir doesn't work for any user



Hi,

I have been struggle to put to work the qmail+pgsql patch. The patch installed was the qmail-sql-0.23pre2.patch

I do have the users in the database, however at the moment to delivery the message is not able to create the user directories, like the sqlcreatehomedir  application is not being call.

If I create the user directory with mkdir,  or even if I create the directory with sqlcreatehomedir username domain.com, the system is able to deliver the email.

Do you know what can be the problem? Can be a bug I this release?

I already trace the database connection, and It looks like being connection to the DB once the email arrive!

If I try to send an email to alias@xxxxxxxxxx, I am getting the same error:
deferral: Unable_to_chdir_to_maildir._(#4.2.1)/

Some of the configuration files are:

=============================
root@drb$ more /var/qmail/control/sqlserver
db_use yes
check_host yes
connectionstring user=userconsult password=readonly dbname=userdb
popconnectionstring user=usermgr password=secretdb dbname=userdb
dbtable passwd
autohomedir yes
virt_host_field virtual_host
login_field login
uid_field uid
gid_field gid
home_field home
quota_field hardquota
enabled_field enabled
startdate_field startdate
stopdate_field stopdate
passwd_field password
lastlogin_field lastlogin
localpop domain.com

=============================
root@drb$ psql -d userdb -U usermgr -c "select * from passwd"
 login | uid  | gid  |                 home                  | virtual_host | password | hardquota |         startdate          | stopdate | enabled | lastlogin
-------+------+------+---------------------------------------+---------------+----------+-----------+----------------------------+----------+---------+-----------
 alias | 1000 | 1000 | /export/home/mail/domain.com       | domain.com | | 0 | 2002-12-07 12:12:32.456058 | infinity | t       |
 test  | 1000 | 1000 | /export/home/mail/domain.com/test  | domain.com | | 0 | 2002-12-07 12:44:21.052264 | infinity | t       |
 mike | 1000 | 1000 | /export/home/mail/domain.com/mike | domain.com | | 0 | 2002-12-07 23:24:00.83293  | infinity | t       |
(3 rows)

=============================
root@drb$ psql -d userdb -U usermgr -c "select * from locals"
 virtual_host
--------------
(0 rows)


Thank you for the help,


Nayib