From owner-freebsd-questions@FreeBSD.ORG  Thu Sep 15 14:20:10 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 2DF0A16A41F
	for <freebsd-questions@freebsd.org>;
	Thu, 15 Sep 2005 14:20:09 +0000 (GMT)
	(envelope-from dvorakv@vdsoft.org)
Received: from mail.vdsoft.org (poseidon.vdsoft.org [193.85.147.250])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7247143D49
	for <freebsd-questions@freebsd.org>;
	Thu, 15 Sep 2005 14:20:09 +0000 (GMT)
	(envelope-from dvorakv@vdsoft.org)
Received: from [10.10.0.110] (195.70.144.6.adsl.nextra.cz [195.70.144.6])
	by mail.vdsoft.org (Postfix) with ESMTP id 3183E47E013;
	Thu, 15 Sep 2005 16:20:04 +0200 (CEST)
Message-ID: <4329833E.2020909@vdsoft.org>
Date: Thu, 15 Sep 2005 16:20:46 +0200
From: Vladimir Dvorak <dvorakv@vdsoft.org>
User-Agent: Debian Thunderbird 1.0.6 (X11/20050802)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Vladimir Dvorak <dvorakv@vdsoft.org>
References: <43297789.3010308@vdsoft.org>
In-Reply-To: <43297789.3010308@vdsoft.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: proftpd + disable reverze UID/GID mapping
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 15 Sep 2005 14:20:10 -0000

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