pureftpd avec mysql sous ubuntu - Installation - Linux et OS Alternatifs
Marsh Posté le 25-03-2009 à 16:45:29
ReplyMarsh Posté le 25-03-2009 à 16:58:20
J'ai modifié mon fichier mysql.conf mais je ne sais pas il y a rien qui fonctionne, j'ai cherché l'erreur mais rien a faire ,je patoge dans la semoule
J'ai tapez etc/init.d/pure-ftpd-mysql start pour lancer mon serveur et j'obtenu l'erreur suivante
/usr/sbin/pure-ftpd-mysql -l mysq : /etc/pure-ftpd/db/mysql.conf -l pam -u 1000 -O clf : /var/log/pure-ftpd/transfer.log -j -A -E -B
Marsh Posté le 25-03-2009 à 17:30:35
C'est juste la ligne de commande utilisé pour lancé le serveur.
Ca fait longtemps que je n'ai pas utiliser ce ftp. cela dit; peux tu essayer dans la console:
/usr/sbin/pure-ftpd -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -u 1000 -O clf:/var/log/pure-ftpd/transfer.log -j -A -E -B |
Marsh Posté le 26-03-2009 à 06:28:47
il n'y a pas d'erreur dans le cas présent, l'affichage de cette ligne est *normale*.
Marsh Posté le 01-04-2009 à 13:13:40
Bonjour a tous
Excusez moi pour la reponse tardive ,mais je n'arrive pas à donner les permissions sur les dossiers concernés, donc je voudrais savoir comment faire car j'utilise mais comptes utilisateurs avec mysql
Je pensais utiliser chmod mais bon je sais pas si c'est ça, je voudrais une confirmation
Marsh Posté le 01-04-2009 à 13:20:57
tu spécifies normalement au niveau de mysql les uid/gid des utilisateurs virtuels qui seront utilisés sur ton système. C'est donc a ce niveau que tu dois faire ton choix.
Tu as pensé a lire la documentation de pureftpd ?
Marsh Posté le 01-04-2009 à 13:39:24
Oué je met par défaut 1000 dans le fichier de mysql.conf et dans ma base je met 1000 pour un utilisateur quelconque, donc aprés je ne vois pas kes kil faut faire
je vous met mon fichier de conf
##############################################
# #
# 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 127.0.0.1
# 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 root
# Mandatory : user password. You must have a password.
MYSQLPassword runaway
# Mandatory : database to open.
MYSQLDatabase pureftpd
# 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 md5
# 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 users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Query to execute in order to fetch the system user name or uid
MYSQLGetUID SELECT Uid FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Optional : default UID - if set this overrides MYSQLGetUID
#MYSQLDefaultUID 2000
# Query to execute in order to fetch the system user group or gid
MYSQLGetGID SELECT Gid FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Optional : default GID - if set this overrides MYSQLGetGID
#MYSQLDefaultGID 2000
# Query to execute in order to fetch the home directory
MYSQLGetDir SELECT Dir FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Optional : query to get the maximal number of files
# Pure-FTPd must have been compiled with virtual quotas support.
MySQLGetQTAFS SELECT QuotaFiles FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# 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 QuotaSize FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Optional : ratios. The server has to be compiled with ratio support.
MySQLGetRatioUL SELECT ULRatio FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
MySQLGetRatioDL SELECT DLRatio FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Optional : bandwidth throttling.
# The server has to be compiled with throttling support.
# Values are in KB/s .
MySQLGetBandwidthUL SELECT ULBandwidth FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
MySQLGetBandwidthDL SELECT DLBandwidth FROM users WHERE User="\L" AND status="1" AND (ipaccess = "*" OR ipaccess LIKE "\R" )
# Enable ~ expansion. NEVER ENABLE THIS BLINDLY UNLESS :
# 1) You know what you are doing.
# 2) Real and virtual users match.
MySQLForceTildeExpansion 2
# 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
Marsh Posté le 02-04-2009 à 10:11:57
meme si c'est pas la meme distribution :
http://www.howtoforge.com/virtual- [...] 008-spring
tu as le lien qu'on ta donné sur ton post sur clubic ?
http://www.howtoforge.com/virtual- [...] buntu-7.10
Marsh Posté le 25-03-2009 à 16:32:49
Bonjour a tous le monde,je lance ce sujet
j'ai toujours ce problème de démarrage de service avec pureftpd mysql
voila l'erreur
Running: /usr/sbin/pure-ftpd-mysql -l mysqletc/pure-ftpd/db/mysql.conf -l pam -u 1000 -O clfvar/log/pure-ftpd/transfer.log -j -A -E -B
en tapant
/etc/init.d/pure-ftpd-mysql force-reload ou /etc/init.d/pure-ftpd-mysql start ou restart
Alors voila je ne sais vraiment plus koi faire
Pourtant j'ai suivi ce tuto
http://www.howtoforge.com/virtual- [...] buntu-7.10