Pure-ftpd Login bzw Start Problem

EndoMorph

New Member
Guten Tag

Ich hoffe ich nerve nicht habe aber noch ein Problem.... :(

Da ich einen VServer habe und pure-ftpd beim normale apt-get install weigert sich passend zu installieren musste ich selber compilieren...

Nun habe ich folgendes Problem:

wenn ich den server via: " /usr/local/sbin/pure-ftpd &" starte, startet er zwar greift aber nicht auf die mysql.conf zu und somit kann ich mich nicht einloggen.... (zumindest kommt immer ein "530 Login authentication failed")

wenn ich ihn aber via "/usr/local/sbin/pure-ftpd -l mysql:/etc/pure-ftpd/db/mysql.conf &" starte kommt "421 Configuration error: Invalid SQL configuration file: /etc/pure-ftpd/db/mysql.conf"

Ist jemand dieser Fehler bekann? die mysql.conf schaut aus wie folgt:
Code:
##############################################
#                                            #
# Sample Pure-FTPd Mysql configuration file. #
# See README.MySQL for explanations.         #
#                                            #
##############################################


# Optional : MySQL server name or IP. Don't define this for unix sockets.

MYSQLServer     *ip*


# Optional : MySQL port. Don't define this if a local unix socket is used.

MYSQLPort       3306


# Optional : define the location of mysql.sock if the server runs on this host.

# MYSQLSocket      /var/run/mysqld/mysqld.sock


# Mandatory : user to bind the server as.

MYSQLUser       *user*


# Mandatory : user password. You must have a password.

MYSQLPassword   *pw*


# Mandatory : database to open.

MYSQLDatabase   dbispconfig


# Mandatory : how passwords are stored
# Valid values are : "cleartext", "crypt", "md5" and "password"
# ("password" = MySQL password() function)
# You can also use "any" to try "crypt", "md5" *and* "password"

MYSQLCrypt      any


# In the following directives, parts of the strings are replaced at
# run-time before performing queries :
#
# \L is replaced by the login of the user trying to authenticate.
# \I is replaced by the IP address the user connected to.
# \P is replaced by the port number the user connected to.
# \R is replaced by the IP address the user connected from.
# \D is replaced by the remote IP address, as a long decimal number.
#
# Very complex queries can be performed using these substitution strings,
# especially for virtual hosting.


# Query to execute in order to fetch the password

MYSQLGetPW      SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '2' AND username="\L"


# Query to execute in order to fetch the system user name or uid

MYSQLGetUID     SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '2' AND username="\L"


# Optional : default UID - if set this overrides MYSQLGetUID

# MYSQLDefaultUID 1000


# Query to execute in order to fetch the system user group or gid

MYSQLGetGID     SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '2' AND username="\L"


# Optional : default GID - if set this overrides MYSQLGetGID

# MYSQLDefaultGID 1000


# Query to execute in order to fetch the home directory

MYSQLGetDir     SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '2' AND username="\L"


# Optional : query to get the maximal number of files 
# Pure-FTPd must have been compiled with virtual quotas support.

# MySQLGetQTAFS  SELECT quota_files FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"


# Optional : query to get the maximal disk usage (virtual quotas)
# The number should be in Megabytes.
# Pure-FTPd must have been compiled with virtual quotas support.

MySQLGetQTASZ  SELECT quota_size FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"


# Optional : ratios. The server has to be compiled with ratio support.

MySQLGetRatioUL SELECT ul_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"


# Optional : bandwidth throttling.
# The server has to be compiled with throttling support.
# Values are in KB/s .

MySQLGetBandwidthUL SELECT ul_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"

# Enable ~ expansion. NEVER ENABLE THIS BLINDLY UNLESS :
# 1) You know what you are doing.
# 2) Real and virtual users match.

# MySQLForceTildeExpansion 1


# If you upgraded your tables to transactionnal tables (Gemini,
# BerkeleyDB, Innobase...), you can enable SQL transactions to
# avoid races. Leave this commented if you are using the
# traditionnal MyIsam databases or old (< 3.23.x) MySQL versions.

MySQLTransactions On

Mit freundlichen Grüßen

EndoMorph
 

Till

Administrator
Hi,

also ein Fehler in der mysql Config Datei die mit ISPConfig 3 ausgeliefert wird ist unwahrscheinlich, da sie einwandfrei auf allen unterstützten Distributionen läuft. Ich evrmute mal, dass dein Pureftpd vielleicht nicht mit mysql Untersztützung kompiliert wurde.
 

EndoMorph

New Member
Also der ist 100% mit mysql compiliert (habe es mitlerweile 3mal überprüft...) und wenn ich ihn mit dem backup von der standart mysql.conf starte läuft er auch ohne probleme....

Bloß die von isp erstellte file geht nicht...

EDIT:
Problem gelöst... es lag nicht an der fehlenden mysql unterstützung sondern an fehlenden throttle, ratio und quota unterstützung.....
 
Zuletzt bearbeitet:

Werbung

Top