ftp (ftpuser) to website failed; please help ?

Discussion in 'ISPConfig 3 Priority Support' started by pcurran, Jul 15, 2013.

  1. pcurran

    pcurran Member

    ftp (ftpuser) to website failed;please help? SOLVED

    Hi, need your help please:
    1. isp.domain.net (cpanel server) has ispconfig3 installed with respect to documentations.
    2. webserver2.domain.net is the server that runs webservers. I configured "website1.domain.net on "isp.domain.net" to run on webserver2.domain.net.
    3. I created ftpuser1 on isp.domain.net for website1.domain.net

    4. I used filezilla to ftp into website1.domain.net using the ftp's username: "website1.domain_netftpuser1" .The ftp session failed with error messages:

    Status: Resolving address of website1.net
    Status: Connecting to 10.226.660:xx:21...
    Status: Connection established, waiting for welcome message...
    Response: 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
    Response: 220-You are user number 1 of 50 allowed.
    Response: 220-Local time is now 07:56. Server port: 21.
    Response: 220-This is a private system - No anonymous login
    Response: 220-IPv6 connections are also welcome on this server.
    Response: 220 You will be disconnected after 15 minutes of inactivity.
    Command: USER mybestonline_netftpuser
    Response: 331 User mybestonline_netftpuser OK. Password required
    Command: PASS ************
    Response: 530 Login authentication failed
    Error: Critical error
    Error: Could not connect to server


    ---------------------------------------
    Please help resolve this issue?

    Note:
    I can ftp and ssh to the physical system using a local accounts.
     
    Last edited: Jul 16, 2013
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Are there any jobs listed in the jobqueue of the ispconfig monitor?
     
  3. craig baker

    craig baker Member HowtoForge Supporter

    ftp and ispconfig3

    From my recent entertainment - the ftp login required -
    1) setup a site under ISPCONFIG3
    2) setup an ftp user under ftp accounts.

    say you setup the site www.mysite.com under ISPCONFIG3
    then add the ftp user 'myuser' under that site
    (so that under ftp users you see under website 'mysite.com' the user 'myuser'


    then your login to pure-ftp is
    user [email protected]
    password whateveryouused.

    I belive the problem is that your username was not complete and not recognized as a valid ISPCONFIG3 account
     
  4. pcurran

    pcurran Member

    After checking the monitor, i can see many "Replicaction failed. Error:". Atleat this error:

    Replication failed. Error: (ftp_user) in MySQL server: (localhost) Unknown column 'username_prefix' in 'field list' # SQL: REPLACE INTO ftp_user (`ftp_user_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`parent_domain_id`,`username`,`username_prefix`,`password`,`quota_size`,`active`,`uid`,`gid`,`dir`,`quota_files`,`ul_ratio`,`dl_ratio`,`ul_bandwidth`,`dl_bandwidth`) VALUES ('4','1','3','riud','riud','','5','2','myusermyuser','myuser','$1$+fy6n73B$uk.R66gmr6fNfic0iFRcJ.','5000','y','web2','client2','/var/www/clients/client2/web2','-1','-1','-1','-1','-1')
     
  5. craig baker

    craig baker Member HowtoForge Supporter

    ftp problems

    forget my post the domain name is not required.

    have you checked permissions on the database? that might explain the inability to write/add/update
     
  6. pcurran

    pcurran Member


    Solved:
    Summary: Basically all the ispconfig3 installations should be at the same version on all the servers. Maybe this made replication/sync much easier?

    Hint from Till about checking if there were jobs pending in Monitor. Yes. There were lots of jobs pending, errors, etc. I delete some of those errors and jobs. But I eventually did the following:
    1. I went to each server and excuted the below command so that each ispconfig3 installation is updated to the same verison (3.0.5.2):
    # ./ispconfig_update.sh

    2. check this url for detail instructions: http://www.howtoforge.com/forums/showthread.php?t=61190&highlight=upgrade+ispconfig

    3. I made sure there were no errors in monitor (by restart services, reboot, etc) .

    4. I was able to ftp with the username=mydomain_netftpuser, and password="the password you gave for username earlier"

    thank you.
     

Share This Page