Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 15th October 2009, 16:27
Bloedi Bloedi is offline
Junior Member
Join Date: Oct 2009
Posts: 5
Thanks: 0
Thanked 2 Times in 2 Posts
Question 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]

How can I instruct Pure-FTPd to read users from table ftp_user .. not from users?
Reply With Quote
Sponsored Links
Old 15th October 2009, 16:46
Bloedi Bloedi is offline
Junior Member
Join Date: Oct 2009
Posts: 5
Thanks: 0
Thanked 2 Times in 2 Posts

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" .. ..
Reply With Quote
Old 16th October 2009, 10:05
till till is online now
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,006
Thanks: 840
Thanked 5,650 Times in 4,460 Posts

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.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The system is currently updating the configuration files. warlock General 8 21st February 2009 19:15
user ftp points me to the wrong dir mdakar General 2 25th July 2008 15:42
debian etch courier pop3 issue docean Installation/Configuration 6 20th March 2008 16:38
Ruby / FastCGI Problem Chad Server Operation 1 8th March 2008 21:38
FTP Error joshabts Installation/Configuration 3 4th November 2006 17:19

All times are GMT +2. The time now is 10:47.

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