From owner-freebsd-questions@FreeBSD.ORG  Mon Mar 29 04:29:10 2010
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id C7993106566B
	for <freebsd-questions@freebsd.org>;
	Mon, 29 Mar 2010 04:29:10 +0000 (UTC)
	(envelope-from m.anis@arc.itb.ac.id)
Received: from mx2.ITB.ac.id (mx2.itb.ac.id [IPv6:2001:d30:3:5::67])
	by mx1.freebsd.org (Postfix) with ESMTP id C81D78FC12
	for <freebsd-questions@freebsd.org>;
	Mon, 29 Mar 2010 04:28:59 +0000 (UTC)
Received: from mx3.itb.ac.id (mx3.itb.ac.id [167.205.1.68])
	by mx2.ITB.ac.id (Postfix) with ESMTP id E76A9353BF
	for <freebsd-questions@freebsd.org>;
	Mon, 29 Mar 2010 11:29:09 +0700 (WIT)
Received: from mx4.itb.ac.id ([167.205.1.69] helo=mx4.ITB.ac.id)
	by mx3.itb.ac.id with ESMTP id oBTgpKPl34915;
	Mon, 29 Mar 2010 11:29:42 +0700
Received: from [167.205.35.246] (unknown [167.205.35.246])
	by mx4.ITB.ac.id (Postfix) with ESMTP id B50D0B6B5
	for <freebsd-questions@freebsd.org>;
	Mon, 29 Mar 2010 11:29:11 +0700 (WIT)
Message-ID: <4BB02C81.9090802@arc.itb.ac.id>
Date: Mon, 29 Mar 2010 11:28:49 +0700
From: "m.anis" <m.anis@arc.itb.ac.id>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
	rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
X-SpamTest-Envelope-From: m.anis@arc.itb.ac.id
X-SpamTest-Info: Profiles 12931 [Mar 28 2010]
X-SpamTest-Info: {FROM: real name seems fake}
X-SpamTest-Method: none
X-SpamTest-Rate: 0
X-SpamTest-Status: Not detected
X-SpamTest-Status-Extended: not_detected
X-SpamTest-Version: SMTP-Filter Version 3.0.0 [0285], KAS30/SDK/Release
X-Anti-Virus: Kaspersky Mail Gateway, version: 5.6.28/RELEASE,
	bases: 20100325T100353 #3865736, check: 20100326 clean
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: pure-ftpd with mysql authentication
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: Mon, 29 Mar 2010 04:29:10 -0000

Hi all,
I have problem with my pure-ftpd with mysql auth
I don't know where the error
I look on the database with phpmyadmin, and everything goes well

here my config:
pureftpd-mysql.conf

/MYSQLSocket      /tmp/mysql.sock
MYSQLServer     localhost
MYSQLPort       3306
MYSQLUser <mysqluser>
MYSQLPassword <mysqlpass>
MYSQLDatabase <mysqldb>

/////

pure-ftpd.conf

[...]
ChrootEveryone              yes
[...]
MySQLConfigFile               /usr/local/etc/pure-ftpd/pureftpd-mysql.conf
[...]
CreateHomeDir               yes
[...]

Thank for your help.

-- 
--
Best regards
Muhammad Anis