pure-ftpd - mysql auth

• Next message: Laust S. Jespersen: "RE: Prob. med at inst. FreeBSD 4.7 på en Olivetti P133 bærbar"
• Previous message: Mich Bartels Nielsen: "Re: Vedr.: Prob. med at inst. FreeBSD 4.7 på en Olivetti P133 bærbar"
• Next in thread: Ole Moller: "Re: pure-ftpd - mysql auth"
• Reply: Ole Moller: "Re: pure-ftpd - mysql auth"
• Reply: Martin Allan Jensen: "Re: pure-ftpd - mysql auth"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

From: "Jesper Have" <none@bsd--jdh.dk.lh.bsd-dk.dk>
To: <none@bsd-dk--bsd-dk.dk.lh.bsd-dk.dk>
Subject: pure-ftpd - mysql auth
Date: Mon, 2 Dec 2002 18:46:08 +0100

Jeg har fået installeret pure-ftpd så den køre på en mysql database, men kan
ikke få startet serveren :(
når jeg forsøger får jeg fejlen

<klip>
server# /usr/local/sbin/pure-ftpd -l
mysql:/usr/local/etc/pureftpd-mysql.conf &
[1] 81913
server# 421 Configuration error: Invalid SQL configuration file:
/usr/local/etc/pureftpd-mysql.conf

[1] Exit 252 /usr/local/sbin/pure-ftpd -l
mysql:/usr/local/etc/pureftpd-mysql.conf
<klip>

og min pure-ftpd.conf ser sådan her ud

<klip>
# If you want to use the Socket connect methode comment out the
# Lines with MMYSQLServer and MYSQLPort.
# If you want to use the Port methode comment out the MYSQLSocket line
#MYSQLSocket /tmp/mysql.sock
MYSQLServer localhost
MYSQLPort 3306
MYSQLUser *******
MYSQLPassword *********
MYSQLDatabase pureftpd
MYSQLCrypt cleartext
MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L"AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L"AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L"AND
status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L"AND
status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MySQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L"AND status="1" AND
(ipaccess = "*" OR ipaccess LIKE "\R")
<klip>

--
Med venlig hilsen
Jesper Have

• Next message: Laust S. Jespersen: "RE: Prob. med at inst. FreeBSD 4.7 på en Olivetti P133 bærbar"
• Previous message: Mich Bartels Nielsen: "Re: Vedr.: Prob. med at inst. FreeBSD 4.7 på en Olivetti P133 bærbar"
• Next in thread: Ole Moller: "Re: pure-ftpd - mysql auth"
• Reply: Ole Moller: "Re: pure-ftpd - mysql auth"
• Reply: Martin Allan Jensen: "Re: pure-ftpd - mysql auth"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
• Mail actions: [ respond to this message ] [ mail a new topic ]

This archive was generated by hypermail 2b30 : Wed 15 Nov 2006 - 18:24:25 CET