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 sshuser@IPserveradress's password: Connected to IPserveradress. sftp> dir c1kaminphoto_wp.sql packages.txt sftp> quit but lftp: someuser$ lftp -u userfromispconfig IPSserveraddress Password: lftp userfromftpispconfig@IPserveraddress:~> 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
That's ok, pure-ftpd-mysql is pure-ftpd with MySQL support compiled in, it reports itself still as pure-ftpd. Run the test script and post the result: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
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
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.
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
To explain: We need to run old Drupal web sites under ispconfig, so both versions of the PHP 5.x and 7. are needed...
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.
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.
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
What show Code: apt policy pure-ftpd-mysql pure-ftpd-common and Code: systemctl status pure-ftpd-mysql.service
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
How was this system installed? Refer to chapter "11. Install PureFTPd and Quota" of the ISPConfig Perfect Server Guide. Install the packages pure-ftpd needs. https://www.howtoforge.com/tutorial...-bind-postfix-doveot-and-ispconfig/2/#g0.0.16 You should go through that Guide from beginning to end in case something else is also missing.
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
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
