Pure-ftpd-mysql - no connection

Discussion in 'Server Operation' started by MaKa, Jul 27, 2020.

  1. MaKa

    MaKa New Member

    Dear all, my first question here ;)
    I am experiencing problem with my ispconfig setup.
    Works fine, but I am unable to connect to pure-ftpd-mysql service
    In short:
    • sftp for ssh users works fine (both Filezilla and Win Scp)
    • www services (sql, wordpress) with ispconfig works smoothly
    Long:
    • ssh and sftp works
    • ufw works
    • apache2 works
    • pure-ftpd-mysql status
    NEWSRV-28420-root-~> service pure-ftpd-mysql status
    ● pure-ftpd-mysql.service
    Loaded: loaded (/etc/init.d/pure-ftpd-mysql; generated)
    Active: active (exited) since Mon 2020-07-27 18:07:31 CEST; 54min ago
    Docs: man:systemd-sysv-generator(8)
    Process: 812 ExecStart=/etc/init.d/pure-ftpd-mysql start (code=exited, status=0/SUCCESS)

    Jul 27 18:07:31 domainname systemd[1]: Starting pure-ftpd-mysql.service...
    Jul 27 18:07:31 domainname systemd[1]: Started pure-ftpd-mysql.service.


    sftp:
    sshuser$ sftp IPserveraddress
    [email protected]'s password:
    Connected to IPserveradress.
    sftp> dir
    c1kaminphoto_wp.sql packages.txt
    sftp> quit


    but lftp:
    someuser$ lftp -u userfromispconfig IPSserveraddress
    Password:
    lftp [email protected]:~> dir
    `ls' at 0 [Connection refused]
    Nothing wrong in /var/log/Auth.log, just only:
    Jul 27 17:05:43 28420 pure-ftpd: ([email protected]) [INFO] Logout.
    But pure-ftpd is NOT installed, just pure-ftpd-mysql

    Any idea? I have tried many guides, but nothing leads to final WORKING stage... :(
    Tried to look into the ispconfig database table (yes ftp users exist)...
    help please
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. MaKa

    MaKa New Member

    OK, seems problems here ;) Nice script
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 18.04.4 LTS
    [INFO] ISPConfig is installed.
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.15p3
    [WARN] Could not use mysql command line to connect to the database. Check your mysql config!
    ##### VERSION CHECK #####
    [INFO] php (cli) version is 7.4.8
    ##### PORT CHECK #####
    [WARN] Port 21 (FTP server) seems NOT to be listening
    [WARN] I could not determine which ftp server is running.


    But
    ifconfig shows me IP address ipv4 and IPv6 too...

    mysql config is /etc/mysql/my.cnf
    [client-server]
    # Import all .cnf files from configuration directory
    !includedir /etc/mysql/conf.d/
    !includedir /etc/mysql/mariadb.conf.d/
    general_log_file = /var/log/mysql/mysql.log
    general_log = 1


    I have no plan to use mail services at this stage.
    Report in attach
    thank you
     

    Attached Files:

  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Have you installed a new version of PHP on that host? Ubuntu 18.04 comes with PHP 7.2. ISPConfig must use the original default PHP version of the OS, changing that breaks ISPConfig.
    Report shows other problems also, but they may be caused by the PHP version mismatch.
    The way to get additional PHP versions on an ISPConfig host is explained in tutorial. I think there was a version of that tutorial for Ubuntu, search in the Tutorial section. Debian version definitely exists, that may work about the same for Ubuntu.
     
  5. MaKa

    MaKa New Member

    You simply CAN NOT use original PHP from Ubuntu 18.04, because we need old one PHP 5.6 version... So I followed this guide (sorry I Cannot publish link here right now for some security reasons...gggrrrr)

    Code:
    vitux.com/how-to-install-php5-and-php7-on-ubuntu-18-04-lts/
    My CLI version is...
    Code:
    PHP 7.4.8 (cli) (built: Jul 13 2020 16:45:47) ( NTS )
    Copyright (c) The PHP Group
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
        with Zend OPcache v7.4.8, Copyright (c), by Zend Technologies
     
  6. MaKa

    MaKa New Member

    To explain:
    We need to run old Drupal web sites under ispconfig, so both versions of the PHP 5.x and 7. are needed...
     
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Adding PHP version that way breaks ISPConfig.
    I have followed this guide, which allows me to have PHP versions from 5.6 to 7.4 assigned per website and keep a working ISPConfig. https://www.howtoforge.com/tutorial...fig-3-from-debian-packages-on-debian-8-and-9/
    I installed those additional PHP version for precicely the same reason you did, that is so I could assign for each website the PHP version that website works with.
     
    MaKa likes this.
  8. MaKa

    MaKa New Member

    I use sury.org as PHP packages too! Everything is working except pute-ftp-mysql...
     
  9. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    The script stated ftp server is not running.
    Try command
    Code:
    systemctl --state=failed
    and then systemctl status <name-of-failed-service>.
    But I am surprised your ISPConfig works with altered PHP version.
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Probably he installed the 3.1dev which supports PHP 7.4 already.
     
  11. MaKa

    MaKa New Member

    Code:
    NEWSRV-28420-root-/var/www/kamin.photo/log> systemctl --state=failed
    0 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    Seems OK
     
  12. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What show
    Code:
     apt policy pure-ftpd-mysql pure-ftpd-common
    and
    Code:
    systemctl status pure-ftpd-mysql.service
     
  13. MaKa

    MaKa New Member

    Code:
    pure-ftpd-mysql:
      Installed: (none)
      Candidate: 1.0.46-1build1
      Version table:
         1.0.46-1build1 500
            500 http://cz.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
            100 /var/lib/dpkg/status
    pure-ftpd-common:
      Installed: 1.0.46-1build1
      Candidate: 1.0.46-1build1
      Version table:
     *** 1.0.46-1build1 500
            500 http://cz.archive.ubuntu.com/ubuntu bionic/universe amd64 Packages
            500 http://cz.archive.ubuntu.com/ubuntu bionic/universe i386 Packages
            100 /var/lib/dpkg/status
    NEWSRV-28420-root-/var/www/kamin.photo/log> pure-ftpd-mysql:
            100 /var/lib/dpkg/status
    Code:
    systemctl status pure-ftpd-mysql.service
    Code:
    pure-ftpd-mysql.service
       Loaded: loaded (/etc/init.d/pure-ftpd-mysql; generated)
       Active: active (exited) since Mon 2020-07-27 18:07:31 CEST; 20h ago
         Docs: man:systemd-sysv-generator(8)
      Process: 812 ExecStart=/etc/init.d/pure-ftpd-mysql start (code=exited, status=
    
    Jul 27 18:07:31 28420.vm20.wedos.net systemd[1]: Starting pure-ftpd-mysql.servic
    Jul 27 18:07:31 28420.vm20.wedos.net systemd[1]: Started pure-ftpd-mysql.service
     
  14. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  15. MaKa

    MaKa New Member

    Of course I did, step by step. I ll try tomorrow remove and pure pure-ftp-mysql and try again. THNX
     
  16. MaKa

    MaKa New Member

    SOLVED :):):)
    Problem: pure-ftpd-mysql service stated IT IS installed but in the real it IS NOT installed

    Code:
    service pure-ftpd-mysql status
    ● pure-ftpd-mysql.service
       Loaded: loaded (/etc/init.d/pure-ftpd-mysql; generated)
       Active: active (exited) since Mon 2020-07-27 18:07:31 CEST; 1 day 14h ago
         Docs: man:systemd-sysv-generator(8)
      Process: 812 ExecStart=/etc/init.d/pure-ftpd-mysql start (code=exited, status=
    
    Jul 27 18:07:31 28420.vm20.wedos.net systemd[1]: Starting pure-ftpd-mysql.servic
    Jul 27 18:07:31 28420.vm20.wedos.net systemd[1]: Started pure-ftpd-mysql.service
    
    but pure-ftpd-mysql is not running in memory
    Code:
    ps -ax|grep pure-ftp
    30841 pts/0    S+     0:00 grep --color=auto pure-ftp
    after checking installed packages with apt search pure-ftpd
    Code:
    pure-ftpd-common/bionic,bionic,now 1.0.46-1build1 all [installed]
      Pure-FTPd FTP server (Common Files)
    ...some staff...
    pure-ftpd-mysql/bionic,now 1.0.46-1build1 amd64 [residual-config]
      Secure and efficient FTP server with MySQL user authentication
    
    after apt install pure-ftpd-mysql
    Code:
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following additional packages will be installed:
      libfile-copy-recursive-perl openbsd-inetd tcpd update-inetd
    The following NEW packages will be installed:
      libfile-copy-recursive-perl openbsd-inetd pure-ftpd-mysql tcpd update-inetd
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following additional packages will be installed:
      libfile-copy-recursive-perl openbsd-inetd tcpd update-inetd
    The following NEW packages will be installed:
      libfile-copy-recursive-perl openbsd-inetd pure-ftpd-mysql tcpd update-inetd
    
    it is running in memory
    Code:
    ps -ax|grep pure
    31189 ?        Ss     0:00 pure-ftpd (SERVER)
    31264 pts/0    S+     0:00 grep --color=auto pure
    and everything is running smothly.
    So, problem was the service pure-ftpd-mysql was stating it is running, but WAS NOT installed, even...
    Thank you Taleman and till
     
    Last edited: Jul 29, 2020
  17. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    The apt policy command did show it is not installed. I thought you had read that?
    Code:
    pure-ftpd-mysql:
      Installed: (none)
      Candidate: 1.0.46-1build1
     
  18. MaKa

    MaKa New Member

    Yes my fault... o_O
     

Share This Page