Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th September 2009, 21:19
gawehner gawehner is offline
Junior Member
 
Join Date: Sep 2009
Location: Manassas, VA
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via AIM to gawehner
Default PureFTPd on ISPConfig 3 won't connect

I followed the "The Perfect Server - Ubuntu 9.04 [ISPConfig 3]" how-to to set up my home web server. Everything seems to work fine with the exception of FTP. I created a client and a website and can browse to the default website. I then created an FTP user and navigated to user@domain with no success. I don't even get the login page - just an "The connection has timed out" error. I have port 21 forwarded on my router and open on fail2ban. Any ideas?

Here is my netstat -tap | grep ftp output:
Code:
tcp        0      0 *:ftp                   *:*                     LISTEN      8032/pure-ftpd (SER
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      8032/pure-ftpd (SER
Here is my iptables -L | grep ftp output:
Code:
Chain PUB_IN (4 references)
PAROLE     tcp  --  anywhere             anywhere            tcp dpt:ftp-data
PAROLE     tcp  --  anywhere             anywhere            tcp dpt:ftp
/etc/pure-ftpd/db/mysql.conf reads:
Code:
##############################################
#                                            #
# 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   mypassword


# 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_files != '-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 quota_files != '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '1' AND quota_files != '-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 quota_files != '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '1' AND quota_files != '-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
Finally, my mysql entry for dbispconfig.ftp_user is:
Code:
ftp_user_id = 1
sys_userid = 1
sys_groupid = 2
sys_perm_user = 'riud'
sys_perm_group = 'riud'
sys_perm_other = ''
server_id = 1
parent_domain_id = 1
username = my username
password = my encryped password
quota_size = -1
active = 'y'
uid = 'web1'
gid = 'client1'
dir = '/var/www/clients/client1/web1'
quota_files = -1
ul_ratio = -1
dl_ratio = -1
ul_bandwidth = -1
dl_bandwidth = -1
What am I missing?

Thank you for helping this new guy out!

Last edited by gawehner; 18th September 2009 at 21:38.
Reply With Quote
Sponsored Links
  #2  
Old 19th September 2009, 21:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Is this a physical server or a virtual machine?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
gawehner (20th September 2009)
  #3  
Old 20th September 2009, 04:22
gawehner gawehner is offline
Junior Member
 
Join Date: Sep 2009
Location: Manassas, VA
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via AIM to gawehner
Default

My system is a physical server. Just a additional bit of info, when I enter myuser@myipaddress (as opposed to myuser@mydomain) from my home network I get a blank white screen, but no login prompt or any other indication that I am on a ftp page.

Greg
Reply With Quote
  #4  
Old 21st September 2009, 22:06
gawehner gawehner is offline
Junior Member
 
Join Date: Sep 2009
Location: Manassas, VA
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via AIM to gawehner
Default

Also, my syslog is spewing this (I have it on a 5min refresh in ispconfig right now)

Code:
Sep 21 14:02:26 LittleBox kernel: [262664.090227] php[2383]: segfault at b6d2e760 ip b6d2e760 sp b6ca039c error 4 in librt-2.9.so[b7047000+7000]
Sep 21 14:05:02 LittleBox pure-ftpd: (?@localhost) [INFO] New connection from localhost
Sep 21 14:05:02 LittleBox pure-ftpd: (?@localhost) [INFO] Logout.
Sep 21 14:10:01 LittleBox pure-ftpd: (?@localhost) [INFO] New connection from localhost
Sep 21 14:10:01 LittleBox pure-ftpd: (?@localhost) [INFO] Logout.
Sep 21 14:15:01 LittleBox pure-ftpd: (?@localhost) [INFO] New connection from localhost
Sep 21 14:15:01 LittleBox pure-ftpd: (?@localhost) [INFO] Logout.
Sep 21 14:20:02 LittleBox pure-ftpd: (?@localhost) [INFO] New connection from localhost
Sep 21 14:20:02 LittleBox pure-ftpd: (?@localhost) [INFO] Logout.
It's repeating this series over and over again.
Reply With Quote
  #5  
Old 22nd September 2009, 17:11
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts
Default

Did you try both active and passive transfers in your FTP client?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 22nd September 2009, 18:22
gawehner gawehner is offline
Junior Member
 
Join Date: Sep 2009
Location: Manassas, VA
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via AIM to gawehner
Default

Nothing in either mode.
Reply With Quote
  #7  
Old 8th October 2009, 17:09
Jolman Jolman is offline
Member
 
Join Date: May 2009
Location: Kazakhstan
Posts: 34
Thanks: 4
Thanked 1 Time in 1 Post
Send a message via Skype™ to Jolman
Default I have same problem

Quote:
Originally Posted by falko View Post
Did you try both active and passive transfers in your FTP client?
I have same problem please help!!! I can't login on FTP it can't accept remote connnection.
I have not installed the iptables and remove apparmor when installing ISPConfig 3.


In the syslog:
Code:
Oct  9 06:50:01 server pure-ftpd: (?@localhost) [INFO] New connection from localhost
Oct  9 06:50:01 server pure-ftpd: (?@localhost) [INFO] Logout.

Last edited by Jolman; 9th October 2009 at 05:41.
Reply With Quote
  #8  
Old 8th October 2009, 17:47
Jolman Jolman is offline
Member
 
Join Date: May 2009
Location: Kazakhstan
Posts: 34
Thanks: 4
Thanked 1 Time in 1 Post
Send a message via Skype™ to Jolman
Default Can login from localhost

Quote:
Originally Posted by Jolman View Post
I have same problem please help!!! I can't login on FTP it "reject" connnection
I can login from localhost but can't remote. I have not installed the iptables and remove apparmor when installing ISPConfig 3. I check my hosts.deny nothing. Pleas help with that i can't resolve this problem alone

Last edited by Jolman; 9th October 2009 at 05:32.
Reply With Quote
  #9  
Old 8th October 2009, 19:39
gawehner gawehner is offline
Junior Member
 
Join Date: Sep 2009
Location: Manassas, VA
Posts: 11
Thanks: 3
Thanked 0 Times in 0 Posts
Send a message via AIM to gawehner
Default

Just a couple of updates. I thought the problem might be that port 20 was blocked somewhere, but after going through my router, my server's iptables and my firewall settings again I confirmed that ports 20 and 21 are open. I tried rebuilding the machine with both proftpd and vsfptd and without any ftp server. ISPConfig doesn't look for anything but pureftpd, even thought the main page says it supports the other two. I doesn't even recognize if an ftp server isn't installed. While the only thing it does is produce an error message on the Monitor tab, this annoys me to no end. Now I have to either keep a service running that I can't connect to or keep ISPConfig with an constant error message in the Monitor tab. Pureftpd works on localhost if I set up a "real" user, but the virtual authentication and remote connection is a no-go. At this point I'm giving up and switching to OpenSuSE and trying something else.
Reply With Quote
  #10  
Old 22nd October 2009, 09:39
dpnux dpnux is offline
Junior Member
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

I found that the problem has been resolved by Till on this thread

http://www.howtoforge.org/forums/sho...d.php?p=205926

I have same problem, after adding DontResolve in pureftpd conf. Everything works fine now.
Reply With Quote
The Following User Says Thank You to dpnux For This Useful Post:
gawehner (22nd October 2009)
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
ISPConfig 3.0.0.8 RC1 released till General 92 22nd February 2010 10:52
ISPconfig after installation cannot reach www.xyz.de:81 Figth4Linux Installation/Configuration 23 6th March 2008 23:38
Postfix problem: lost connection after CONNECT from unknown fernando_torrez Server Operation 5 30th November 2007 15:17
Can't connect to ispconfig bswinnerton Installation/Configuration 4 11th September 2007 18:57
ISPConfig 2.3.2-dev released till General 9 4th June 2007 11:46


All times are GMT +2. The time now is 19:33.


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