From owner-freebsd-questions@FreeBSD.ORG Thu Sep 15 13:30:12 2005 Return-Path: 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 CD44816A41F for ; Thu, 15 Sep 2005 13:30:12 +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 74F0D43D46 for ; Thu, 15 Sep 2005 13:30:12 +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 836F947E012 for ; Thu, 15 Sep 2005 15:30:07 +0200 (CEST) Message-ID: <43297789.3010308@vdsoft.org> Date: Thu, 15 Sep 2005 15:30:49 +0200 From: Vladimir Dvorak User-Agent: Debian Thunderbird 1.0.6 (X11/20050802) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: proftpd + disable reverze UID/GID mapping X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Sep 2005 13:30:12 -0000 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