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

Re: autohomedir doesn't work for any user



I believe there is configuration option in sqlserver file. You don't have
that in you sqlserver.

Syntax is like
autohomedir /usr/local/sbin/sqlcreatehomedir
depending where your script is.

Nayib Kiuhan said:
> 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


-- 
lp, Klemen