Pure-Ftp doesn't recognize the ISPConfig users

vaio1 · Oct 13, 2015

Hi guys,
this is the configuration of the pure-ftp:

##############################################
# #
# Sample Pure-FTPd Mysql configuration file. #
# See README.MySQL for explanations. #
# #
##############################################

MYSQLSocket /var/run/mysqld/mysqld.sock
MYSQLUser ispconfig
MYSQLPassword 5f0014f4d3afs1227d74314021a0e85b3
MYSQLDatabase dbispconfig
MYSQLCrypt cleartext

MYSQLGetPW SELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetUID SELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetGID SELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MYSQLGetDir SELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="\L"
MySQLGetRatioUL SELECT ul_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND ul_ratio != '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_ratio != '-1' AND username="\L"
MySQLGetBandwidthUL SELECT ul_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND ul_bandwidth != '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_bandwidth != '-1' AND username="\L"
Click to expand...

I get these errors when I try to connect my Pure-FTP server:

Oct 12 15:02:26 webserver pure-ftpd: ([email protected]) [INFO] New connection from 79.20.236.178
Oct 12 15:02:26 webserver pure-ftpd: ([email protected]) [INFO] PAM_RHOST enabled. Getting the peer address
Oct 12 15:02:32 webserver pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [shine_magento]
Oct 12 15:02:32 webserver pure-ftpd: ([email protected]) [INFO] Logout.
Click to expand...

I have configured the mysql.conf as explained in your tutorial of the Perfect Server:

##############################################
# #
# 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 ispconfig

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

MYSQLPassword 826e6b256a3dfdcb3b60931836fe7db0

# 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 crypt

# 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 = '1' 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 = '1' 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 = '1' 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 = '1' 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 = '1' 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 = '1' AND quota_size != '-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 = '1' AND ul_ratio != '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_ratio != '-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 = '1' AND ul_bandwidth != '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND dl_bandwidth != '-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
Click to expand...

ISPConfig works as well but the users cannot connect to their websites space.
Any help?

thanks

florian030 · Oct 12, 2015

It seems, that you use the wrong user or the wrong password.

durchd8.de · Oct 12, 2015

Check back in FTP-Users and you will see the user has a prefix automatically assigned by ISPconfig.

Witht he correct username it will be ok

vaio1 · Oct 12, 2015

Hi guys,
I can see the mysql queries by debugging the log:
These are the queries:

241 Connect ispconfig@localhost on dbispconfig
241 QuerySELECT password FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="shine_ftp"
241 QuerySELECT uid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="shine_ftp"
241 QuerySELECT gid FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="shine_ftp"
241 QuerySELECT dir FROM ftp_user WHERE active = 'y' AND server_id = '1' AND username="shine_ftp"
241 Quit
Click to expand...

This the result:

password: $1$RunXWkwzXg3IEj2THIfEpTSrI6R1
dir: /var/www/clients/client1/web3889
gid: client1
uid: web3889
Click to expand...

but I get this result:

Oct 12 16:58:40 webserver pure-ftpd: ([email protected]) [INFO] New connection from host178-236-dynamic.20-79-r.retail.telecomitalia.it
Oct 12 16:58:40 webserver pure-ftpd: ([email protected]) [DEBUG] Command [user] [shine_ftp]
Oct 12 16:58:40 webserver pure-ftpd: ([email protected]) [DEBUG] Command [pass] [<*>]
Oct 12 16:58:44 webserver pure-ftpd: ([email protected]) [WARNING] Authentication failed for user [shine_ftp]
Oct 12 16:58:44 webserver pure-ftpd: ([email protected]) [DEBUG] Command [quit] []
Oct 12 16:58:44 webserver pure-ftpd: ([email protected]) [INFO] Logout.
Click to expand...

and nothing change.

durchd8.de · Oct 12, 2015

@vaio: apparently you didnt get it - check the ftp-username in ispconfig.

Why? ispconfig adds a preceding handle from client identifier to the ftp-username. Thats why your ftp-username probably isnt right.

vaio1 · Oct 13, 2015

As you can see into the previous post MySQL returns the correct user.
So now I don't know why but it seems ok

till · Oct 13, 2015

Try to set the password again. And check that the directory /var/www/clients/client1/web3889 exists, pure-ftpd can throw a login error when the directory of the FTP user does not exist.

vaio1 · Oct 13, 2015

Hi Till, thanks for the reply
The directory exists.

# ll /var/www/clients/client1/web3889
total 32K
drwxr-x--x 2 web3889 client1 4.0K Sep 18 2012 cgi-bin
drwxr-xr-x 2 root root 4.0K Oct 12 09:36 log
drwxr-xr-x 2 web3889 client1 4.0K Nov 8 2012 media
drwx--x--- 2 web3889 client1 4.0K Mar 20 2013 private
drwxr-xr-x 2 root root 4.0K Apr 11 2012 ssl
drwxrwx--- 2 web3889 client1 4.0K Sep 26 13:45 tmp
drwx--x--x 18 web3889 client1 4.0K Jul 28 13:52 web
drwx--x--- 2 web3889 client1 4.0K Mar 20 2013 webdav
Click to expand...

vaio1 · Oct 13, 2015

I have solved a part of the problem!
The parameter MYSQLCrypt was set as "cleartext" instead of "crypt" and the login fails.
Now I can see ALL the webserver directories!!! How to solve this new issue?
Thanks

till · Oct 13, 2015

Did you set virtual chroot to yes?

vaio1 · Oct 13, 2015

Maybe I didn't! How have I to set it?
thanks

till · Oct 13, 2015

Which Linux distribution do you use?

vaio1 · Oct 13, 2015

Debian 8 Jessie thanks

till · Oct 13, 2015

See chapter 14 of the ISPConfig installation instructions:

https://www.howtoforge.com/tutorial...n-8-jessie-apache-bind-dovecot-ispconfig-3/2/

vaio1 · Oct 13, 2015

Thanks till I have already set but it doesn't work. I have solved by this article: http://serverfault.com/a/242136/84365

Log in or Sign up

Pure-Ftp doesn't recognize the ISPConfig users

vaio1 Member

florian030 Well-Known Member HowtoForge Supporter

durchd8.de Member

vaio1 Member

durchd8.de Member

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

Share This Page

Log in or Sign up

Pure-Ftp doesn't recognize the ISPConfig users

vaio1 Member

florian030 Well-Known Member HowtoForge Supporter

durchd8.de Member

vaio1 Member

durchd8.de Member

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

till Super Moderator Staff Member ISPConfig Developer

vaio1 Member

Share This Page

Useful Searches