Hello, list!

I am a complete noob regarding proftpd and here is my problem:

I use a mySQL database for authenticating and logging users in.
Authentication passes fine but when time comes for chrooting the user, I
get the following error message:

myuser chroot("~/"): No such file or directory

Sorry if this is a frequent question; I could not find a solution so far.

Here is my proftpd.conf (prepared according to a gentoo wiki howto
at http://gentoo-wiki.com/HOWTO_SysCP#ProFTPD):

ServerName "my FTP Service"
ServerType standalone
DeferWelcome off
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on
TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200
DisplayLogin welcome.msg
DisplayFirstChdir .message
ListOptions "-l"
DenyFilter \*.*/
Port 21
MaxInstances 30
User nobody
Group nogroup

Umask 022 022
AllowOverwrite on

DefaultRoot ~
RequireValidShell off
SQLAuthTypes Crypt Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo syscp@localhost syscp wolota
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
SQLLogFile /var/log/proftpd-mod_sql.log
SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1
WHERE username='%u'" ftp_users
SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1,
down_bytes=down_bytes+%b WHERE username='%u'" ftp_users
SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b
WHERE username='%u'" ftp_users

If I replace "DefaultRoot ~" with an arbitrary existing directory, the
login process passes fine and one sees exactly that directory. However,
I need the homedir provided in the mysql table for users to be used...
what am I doing wrong? -- any help will be greatly appreciated!

Here's part of the debug log:

myhost (83.148.81.165[83.148.81.165]) - USER
myhost (83.148.81.165[83.148.81.165]) - USER myuser: Login successful.
myhost (83.148.81.165[83.148.81.165]) - ROOT PRIVS at mod_auth.c:1193
myhost (83.148.81.165[83.148.81.165]) - opening TransferLog
'/var/log/xferlog'
myhost (83.148.81.165[83.148.81.165]) - RELINQUISH PRIVS at mod_auth.c:1222
myhost (83.148.81.165[83.148.81.165]) - USER PRIVS 10002 at mod_auth.c:710
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getpwnam" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - RELINQUISH PRIVS at mod_auth.c:714
myhost (83.148.81.165[83.148.81.165]) - notice: unable to resolve '~/':
No such file or directory
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setpwent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setpwent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setpwent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setgrent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setgrent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"setgrent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getpwent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getpwent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getpwent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getgrent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getgrent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"getgrent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - Preparing to chroot() the
environment, path = '~/'
myhost (83.148.81.165[83.148.81.165]) - ROOT PRIVS at mod_auth.c:62
myhost (83.148.81.165[83.148.81.165]) - FS: using system chroot()
myhost (83.148.81.165[83.148.81.165]) - RELINQUISH PRIVS at mod_auth.c:64
myhost (83.148.81.165[83.148.81.165]) - myuser chroot("~/"): No such
file or directory
myhost (83.148.81.165[83.148.81.165]) - error: unable to set default
root directory
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endpwent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endpwent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endpwent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endgrent" to module mod_sql
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endgrent" to module mod_auth_file
myhost (83.148.81.165[83.148.81.165]) - dispatching auth request
"endgrent" to module mod_auth_unix
myhost (83.148.81.165[83.148.81.165]) - FTP session closed.



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click
_______________________________________________
ProFTPD Users List
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html