From owner-freebsd-ports@freebsd.org Sat Feb 13 14:59:40 2016 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id C7A93AA70F9 for ; Sat, 13 Feb 2016 14:59:40 +0000 (UTC) (envelope-from marko.cupac@mimar.rs) Received: from mail.mimar.rs (mail1.mimar.rs [193.53.106.128]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 8276A1169 for ; Sat, 13 Feb 2016 14:59:39 +0000 (UTC) (envelope-from marko.cupac@mimar.rs) Received: from mail1.mimar.rs (localhost [127.0.1.128]) by mail.mimar.rs (Postfix) with ESMTP id 155DD45CDE58 for ; Sat, 13 Feb 2016 15:50:50 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=mimar.rs; h= content-transfer-encoding:content-type:content-type:mime-version :x-mailer:organization:message-id:subject:subject:from:from:date :date:received:received; s=mimar-0901; t=1455375046; x= 1457189447; bh=+s3J2ll1d75JTlwqGFucbDjKVbnrSQtRKr1BAHYvI+U=; b=p 2bz8LexEHWMfJkcDIKfn21JZ6AXuEd7BfXxHfQMuhFY6YCqGfX7BS1Vb3/L3VrgC Yd1hUblnbA+QEiaDUbPw/dRFa6jbpAizt6/ZXGhzqKoNxaLgIFLZBCg+CW6h7i8J r2pgEC4vM0JILHqz5BT7SFF6jhhe86CLc6ZcY76bkg= X-Virus-Scanned: amavisd-new at mimar.rs Received: from mail.mimar.rs ([127.0.1.128]) by mail1.mimar.rs (amavis.mimar.rs [127.0.1.128]) (amavisd-new, port 10026) with LMTP id DeUf4dVczL-t for ; Sat, 13 Feb 2016 15:50:46 +0100 (CET) Received: from efreet (109-93-30-181.dynamic.isp.telekom.rs [109.93.30.181]) (using TLSv1.2 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: marko.cupac@mimar.rs) by mail.mimar.rs (Postfix) with ESMTPSA id C59C745CDE57 for ; Sat, 13 Feb 2016 15:50:46 +0100 (CET) Date: Sat, 13 Feb 2016 15:50:46 +0100 From: Marko =?UTF-8?B?Q3VwYcSH?= To: freebsd-ports@freebsd.org Subject: ftp/pure-ftpd mysql auth from jail not working? Message-ID: <20160213155046.020932af@efreet> Organization: Mimar X-Mailer: Claws Mail 3.9.3 (GTK+ 2.24.23; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 13 Feb 2016 14:59:41 -0000 Hi, I have working pure-ftpd server on vmware-based 9.3-RELEASE-p33. It authenticates virtual users from mysql server over tcp, and chroots them to their directories. I'd like to move pure-ftpd to jail-based 10.2-RELEASE-p10. I copied pure-ftpd.conf and pureftpd-mysql.conf to new server, but I get: 331 User someuser OK. Password required Password: 530 Login authentication failed Login failed. pure-ftpd.conf: ChrootEveryone yes BrokenClientsCompatibility no MaxClientsNumber 50 Daemonize yes MaxClientsPerIP 32 VerboseLog no DisplayDotFiles no AnonymousOnly no NoAnonymous yes SyslogFacility ftp DontResolve yes MaxIdleTime 15 MySQLConfigFile /usr/local/etc/pureftpd-mysql.conf LimitRecursion 10000 8 MaxLoad 4 PassivePortRange 30000 31000 Umask 133:022 MinUID 2001 AllowUserFXP no ProhibitDotFilesWrite yes ProhibitDotFilesRead yes AltLog stats:/var/log/pureftpd.log NoChmod yes CreateHomeDir yes MaxDiskUsage 99 CustomerProof yes IPV4Only yes Bind IP.ADD.RE.SS,21 pureftpd-mysql.conf: MYSQLServer mysql.example.org MYSQLPort 3306 MYSQLUser user MYSQLPassword pass MYSQLDatabase pureftpd MYSQLCrypt any MYSQLGetPW SELECT Password FROM users WHERE User=3D'\L' MYSQLGetUID SELECT Uid FROM users WHERE User=3D'\L' MYSQLGetGID SELECT Gid FROM users WHERE User=3D'\L' MYSQLGetDir SELECT Dir FROM users WHERE User=3D'\L' MySQLGetBandwidthUL SELECT ulBwidth FROM users WHERE User=3D'\L' MySQLGetBandwidthDL SELECT dlBwidth FROM users WHERE User=3D'\L' MySQLGetQTASZ SELECT sizeQuota FROM users WHERE User=3D'\L' MySQLGetQTAFS SELECT fileQuota FROM users WHERE User=3D'\L' Any idea why the same configuration does not work in jail-based host? --=20 Before enlightenment - chop wood, draw water. After enlightenment - chop wood, draw water. Marko Cupa=C4=87 https://www.mimar.rs/