Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 15 Sep 2005 16:20:46 +0200
From:      Vladimir Dvorak <dvorakv@vdsoft.org>
To:        Vladimir Dvorak <dvorakv@vdsoft.org>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: proftpd + disable reverze UID/GID mapping
Message-ID:  <4329833E.2020909@vdsoft.org>
In-Reply-To: <43297789.3010308@vdsoft.org>
References:  <43297789.3010308@vdsoft.org>

next in thread | previous in thread | raw e-mail | index | archive | help
Vladimir Dvorak wrote:

>Hello *,
>
>I am using ProFTPd with MySQL authentication. Is possible to disable
>UID/GID mapping ?
>
>I can log into existing ftp account but when I use for example ftp
>command 'ls', connection is immediatedly terminated. The reason of
>termination is, that proftpd is trying to map UID/GID number to
>user/group names. In proftpd.conf I have:
>
>SQLUserInfo            ftp login password "id + 10000 as uid" "10000 as
>gid" path NULL
>
>The error is obvious in SQL query ( /var/log/mysql.log ):
>
>Query       SELECT login, password, id + 10000 as uid, 1
>0000 as gid, path FROM ftp WHERE (id + 10000 as uid = 0) LIMIT
>
>Is possible to disable this mapping ? 'PersistentPasswd off' seems
>doesn`t work.
>
>Vladimir
>  
>
If there is directory, which has the same uid as user logged in, its ok.
Problem occures when this directory has another uid - then proftpd
uid/gid subsystem tries to query mysql to find out proper name to
uid/gid number.

Vladimir



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4329833E.2020909>