HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   FTP connection Problem (wrong user-table) (http://www.howtoforge.com/forums/showthread.php?t=40150)

Bloedi 15th October 2009 15:27

FTP connection Problem (wrong user-table)
 
It seems that my Pure-FTPd tries to read the user data not from the table ftp_user.

Here is a little log:

Oct 15 13:19:31 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [INFO] New connection from auriga.webchance-net.de
Oct 15 13:19:31 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [DEBUG] Command [user] [web1_paddy]
Oct 15 13:19:31 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [DEBUG] Command [pass] [<*>]
Oct 15 13:19:32 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [WARNING] Wrong SQL parameters : [SELECT Password FROM users WHERE User="web1_paddy"]
Oct 15 13:19:32 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [INFO] PAM_RHOST enabled. Getting the peer address
Oct 15 13:19:34 m23s02 pure-ftpd: (?@auriga.webchance-net.de) [WARNING] Authentication failed for user [web1_paddy]
m23s02:/etc/apache2#

How can I instruct Pure-FTPd to read users from table ftp_user .. not from users?

Bloedi 15th October 2009 15:46

Now I found the problem. In the original mysql config file are some options missing.

Options like this:

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

WIthout this option Pure-FTPd tries to use the table "users" instead "ftp_user" .. :) ..

till 16th October 2009 09:05

Then ispconfig is not installed completely on your server as ispconfig sets the correct file on setup or you installed or updated something in pure-ftpd after you installed ispconfig and this wiped out the configuration file.


All times are GMT +2. The time now is 21:37.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.