# PureFTP and MariaDB 10.3

**URL:** <https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081>\
**Category:** Support Debian\
**Created:** [Juin 29, 2018, 12:02 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081 "2018-06-29T00:02:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![oitsuki](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/o/b487fb/32.png) [@oitsuki](https://www.debian-fr.org/u/oitsuki)\
**Post date:** [Juin 29, 2018, 12:02 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081/1 "2018-06-29T00:02:35Z")

</div>

Bonjour,

Bonjour, j’ai du faire une mise à jour de maria db en 10.3. Mais il semblerait que cela fonctionne mais pas avec pure FTP  
J’ai suivi le tuto sur cette page : [https://serverfault.com/questions/861176/pure-ftpd-mysql-wont-start-after-updating-mariadb-to-10-2](https://serverfault.com/questions/861176/pure-ftpd-mysql-wont-start-after-updating-mariadb-to-10-2)  
je suis sous ispconfig.

```nohighlight
apt-get remove pure-ftpd-mysql
cd /tmp
wget https://download.pureftpd.org/pub/pure-ftpd/releases/pure-ftpd-1.0.47.tar.gz
tar xzvf pure-ftpd-1.0.47.tar.gz
cd pure-ftpd-1.0.47
./configure --with-tls --with-virtualchroot --with-puredb --with-quotas --with-throttling --with-mysql
make install-strip

/etc/init.d//pure-ftpd-mysql restart

```

J’ai un ok.

Mon pb est que avec filezilla, j’ai toujours pas de connexion.

Votre aide est la bienvenue.

Merci

---

<div class="post-metadata">

**Author:** ![Almtesh](https://www.debian-fr.org/user_avatar/www.debian-fr.org/almtesh/32/10312_2.png) [@Almtesh](https://www.debian-fr.org/u/Almtesh)\
**Post date:** [Juin 29, 2018, 2:40 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081/2 "2018-06-29T14:40:28Z")

</div>

> [@oitsuki](#):
>
> Mon pb est que avec filezilla, j’ai toujours pas de connexion.

Peux-tu donner le retour de `netstat -ltpn` ou, à défaut, `ps -ef | grep -E 'ftp|mysql'` ?

---

<div class="post-metadata">

**Author:** ![oitsuki](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/o/b487fb/32.png) [@oitsuki](https://www.debian-fr.org/u/oitsuki)\
**Post date:** [Juin 29, 2018, 3:11 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081/3 "2018-06-29T15:11:32Z")

</div>

Merci pour ton aide.  
Voici les éléments

`netstat -ltpn`

```nohighlight
Connexions Internet actives (seulement serveurs)
Proto Recv-Q Send-Q Adresse locale Adresse distante Etat PID/Program name    
tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 778/dovecot         
tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 778/dovecot         
tcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN 1166/master         
tcp 0 0 94.23.214.34:53 0.0.0.0:* LISTEN 767/named           
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 767/named           
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 882/sshd            
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 571/postgres        
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 745/smtpd           
tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN 767/named           
tcp 0 0 127.0.0.1:5433 0.0.0.0:* LISTEN 570/postgres        
tcp 0 0 0.0.0.0:993 0.0.0.0:* LISTEN 778/dovecot         
tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN 778/dovecot         
tcp 0 0 127.0.0.1:10025 0.0.0.0:* LISTEN 1166/master         
tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 1098/mysqld         
tcp 0 0 127.0.0.1:10027 0.0.0.0:* LISTEN 1166/master         
tcp 0 0 0.0.0.0:587 0.0.0.0:* LISTEN 1166/master         
tcp 0 0 127.0.0.1:11211 0.0.0.0:* LISTEN 823/memcached       
tcp6 0 0 :::110 :::* LISTEN 778/dovecot         
tcp6 0 0 :::143 :::* LISTEN 778/dovecot         
tcp6 0 0 :::80 :::* LISTEN 869/apache2         
tcp6 0 0 :::465 :::* LISTEN 1166/master         
tcp6 0 0 :::8081 :::* LISTEN 869/apache2         
tcp6 0 0 :::53 :::* LISTEN 767/named           
tcp6 0 0 :::8085 :::* LISTEN 869/apache2         
tcp6 0 0 :::22 :::* LISTEN 882/sshd            
tcp6 0 0 :::25 :::* LISTEN 745/smtpd           
tcp6 0 0 ::1:953 :::* LISTEN 767/named           
tcp6 0 0 :::443 :::* LISTEN 869/apache2         
tcp6 0 0 :::993 :::* LISTEN 778/dovecot         
tcp6 0 0 :::995 :::* LISTEN 778/dovecot         
tcp6 0 0 :::587 :::* LISTEN 1166/master   

```

`ps -ef | grep -E 'ftp|mysql'`

```nohighlight
mysql 1098 1 0 juin27 ? 00:21:13 /usr/sbin/mysqld
root 1832 1574 0 17:10 pts/0 00:00:00 grep -E ftp|mysql

```

---

<div class="post-metadata">

**Author:** ![Almtesh](https://www.debian-fr.org/user_avatar/www.debian-fr.org/almtesh/32/10312_2.png) [@Almtesh](https://www.debian-fr.org/u/Almtesh)\
**Post date:** [Juin 29, 2018, 3:27 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081/4 "2018-06-29T15:27:47Z")

</div>

En effet, tu n’as aucun serveur FTP lancé, c’est normal que ça ne fonctionne pas avec FileZilla.  
Que contient ton fichier `/etc/init.d//pure-ftpd-mysql` ?

---

<div class="post-metadata">

**Author:** ![oitsuki](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/o/b487fb/32.png) [@oitsuki](https://www.debian-fr.org/u/oitsuki)\
**Post date:** [Juin 29, 2018, 3:53 UTC](https://www.debian-fr.org/t/pureftp-and-mariadb-10-3/77081/5 "2018-06-29T15:53:10Z")

</div>

```auto
#! /bin/sh
### BEGIN INIT INFO
# Provides: pure-ftpd-mysql
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Should-Start: slapd mysql postgresql-8.3 postgresql-8.4
# Should-Stop: slapd mysql postgresql-8.3 postgresql-8.4
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
### END INIT INFO
#
# pure-ftpd starts and stops the pure-ftpd ftp daemon
#
# Copyright 2002-2011 by Stefan Hornburg (Racke) <racke@linuxia.de>

PATH=/sbin:/bin:/usr/sbin:/usr/bin
NAME=pure-ftpd
DESC="ftp server"
: ${SSDAEMONLOGOPTS:="--quiet"}
UPLOADDAEMON=/usr/sbin/pure-uploadscript
UDNAME=pure-uploadscript
UDDESC="ftp upload handler"
WRAPPER=/usr/sbin/pure-ftpd-wrapper

# load LSB init-functions to get status_of_proc helper
. /lib/lsb/init-functions

PIDFILE=/var/run/pure-ftpd/pure-ftpd.pid

# try to figure with suffix this script is called,
# $0 might be a symlink pointing to this script
if [-h $0]; then
        ME=`/bin/readlink $0`
else 
        ME=$0
fi

SUFFIX=`basename $ME | sed -ne 's/^pure-ftpd-\(.*\)/\1/p'`
if ["$SUFFIX"] ; then
        DAEMON=/usr/sbin/pure-ftpd-$SUFFIX
       else
                SUFFIX="virtualchroot"
        fi
fi

test -x $DAEMON || exit 0
test -x $WRAPPER || exit 0

set -e

if [! -e `dirname $PIDFILE`];then
       mkdir `dirname $PIDFILE`
fi

start_uploadscript() {
        if ["$UPLOADSCRIPT" -a "$STANDALONE_OR_INETD" != inetd] && \
                egrep -i '^[]*(yes|1|on)[]*' /etc/pure-ftpd/conf/CallUpl$
        then
                UOPTS=""
                test "$UPLOADUID" && UOPTS="$UOPTS -u $UPLOADUID"
                test "$UPLOADGID" && UOPTS="$UOPTS -g $UPLOADGID"
                echo -n "$1 $UDDESC: "
                start-stop-daemon --start $SSDAEMONLOGOPTS --oknodo \
                        --exec $UPLOADDAEMON -- -r "$UPLOADSCRIPT" -B $UOPTS
                echo "$UDNAME."
        fi
}

case "$1" in
  start)
        test "$STANDALONE_OR_INETD" = standalone || exit 0
        echo -n "Starting $DESC: "
        start-stop-daemon --start $SSDAEMONLOGOPTS --pidfile "$PIDFILE" \
                --exec $WRAPPER -- $SUFFIX
        start_uploadscript Starting
        ;;
  stop)
        echo -n "Stopping $DESC: "
        start-stop-daemon --stop $SSDAEMONLOGOPTS --oknodo \
                --pidfile "$PIDFILE"
        start-stop-daemon --stop $SSDAEMONLOGOPTS --oknodo --exec $UPLOADDAEMON
        echo "$NAME."
        ;;
  restart|force-reload)
        test "$STANDALONE_OR_INETD" = standalone || exit 0
        echo -n "Restarting $DESC: "
        start-stop-daemon --stop $SSDAEMONLOGOPTS --oknodo \
                --pidfile "$PIDFILE"
        start-stop-daemon --stop $SSDAEMONLOGOPTS --oknodo --exec $UPLOADDAEMON
        sleep 1
start-stop-daemon --start $SSDAEMONLOGOPTS --pidfile "$PIDFILE" \
                --exec $WRAPPER -- $SUFFIX
        start_uploadscript Restarting
        ;;
  status)
        status_of_proc -p /var/run/pure-ftpd/pure-ftpd.pid $DAEMON $NAME && exi$
        ;;
  *)
        N=/etc/init.d/$NAME
        echo "Usage: $N {start|stop|restart|force-reload|status}" >&2
        exit 1
        ;;
esac

exit 0

```
