sslug-teknik team mailing list archive

["Jesper Have" <f-have@xxxxxxxxxxxxxx>]

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