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

am I missing a step for sqlcreatehomedir ?

Ok, I've gone through the archives and the help files I Can find.
I have the qmail-sql system working in every way except for the autohomedir

If I create the home maildir manually, everything works nicely.
I am using qmail-1.03 and the 0.23pre3.patch

I have also patched checkpassword with the latest patch and am running qmail-pop3d. All users are checking their mail through that.

I must've missed something in the config.  Any suggestions would
be more than welcome.

Here's the list of permissions from the bottom to the top for
drwxr-sr-x   11 root     root         4096 Jul 30 08:00 usr
drwxr-xr-x   12 root     root         4096 Aug 16 20:13 local
drwxr-xr-x    2 root     root         4096 Aug 18 20:49 sbin
-rwsr-x---    1 root     nofiles    158176 Aug 16 22:26 sqlcreatehomedir

permissions on sqlserver file are
-r--r-----    1 qmails   nofiles       631 Aug 18 20:33 /var/qmail/control/sqlserver

Here is my /var/qmail/control/sqlserver file
query_timeout 5
connection_timeout 5
check_host yes
connectionstring user=userconsult password=4rfvgy7 dbname=qmail
popconnectionstring user=usermgr password=4rfvgy7 dbname=qmail
dbtable passwd
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
use_dotqmail_field use_dotqmail
dotqmailtable dotqmails
dotqmail_field dotqmail
extension_field extension
rcpthosts_from_db yes
allowed_recipients_from_db yes
autohomedir /usr/local/sbin/sqlcreatehomedir

The user in the database looks like this
| info  | 3000 | 3000 | /mail/lst454.com | lst454.com | rt7UMK1ZZVZFY | 0 | 0000-00-00 00:00:00 | NULL | 1 | 0 | 2013-08-18 19:12:08 |

and the directory /mail has this permission set
drwxr-xr-x    5 root     root         4096 Aug 18 20:50 mail