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.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th October 2009, 15: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]
m23s02:/etc/apache2#

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

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
  #3  
Old 16th October 2009, 09:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

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
Reply

Bookmarks

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 18:15
user ftp points me to the wrong dir mdakar General 2 25th July 2008 14:42
debian etch courier pop3 issue docean Installation/Configuration 6 20th March 2008 15:38
Ruby / FastCGI Problem Chad Server Operation 1 8th March 2008 20:38
FTP Error joshabts Installation/Configuration 3 4th November 2006 16:19


All times are GMT +2. The time now is 14:08.


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