Hi,
Pydio 8.0.2, PHP 5.6.25, Httpd 2.4.27 on centos 7.4
Fresh install with BDD imported and updated from 6.4.2
shared imported from 6.4.2
Everything seems to be ok but the purge still doesn’t works.
When i launch purge for every users via task scheduler, php process stops and task is still “in progress”.
I had the same issue on 6.4.2 with no resolution.
I have a script in batch which purge DB and files but it’s not clean.
Have you got an clue?
here’s my script.
#!/bin/bash
# ce script recherche les fichiers vieux de 30 jours et purge la base
# On cherche les fichiers vieux de 30j mais pas les fichiers cachés
find /var/lib/pydio/personal -mtime +30 -type f -not -path ‘/.’ > /tmp/liste_ files_purge.txt
while read LIGNE
do
# On met en A uniquement le nom de fichier sans chemin
A=echo $LIGNE | awk -F "/" '{ print $NF }'
# On supprime le fichier dans le FS
rm -f “$LIGNE”
# On cherche dans la table d’index le fichier et on met l’enregistrement DB en B
# En BB, on extrait la clé primaire (id) de $B
B=mysql -N -u root --password=xxx pydiodb -e "select * from ajxp_i ndex where node_path like '%$A%'"
BB=echo $B | awk '{print $1}'
# Pareil que B mais pour ajxp_repo
C=mysql -N -u root --password=xxx pydiodb -e "select * from ajxp_r epo where display like '%$A%'"
CC=echo $C | awk '{print $1}'
# Meme chose en core pour ajxp_user_bookmarks
D=mysql -N -u root --password=xxx pydiodb -e "select * from ajxp_u ser_bookmarks where path like '%$A%'"
DD=echo $D | awk '{print $1}'
# Encore une fois pour ajxp_feed
# On test si les variables sont non vides et on supprime les enregistrem ents en base.
if [ ! -z $B ]
then
mysql -N -u root --password=xxx pydiodb -e "delete from ajxp_index where node_id like '$BB'
fi
if [ ! -z $C ]
then
mysql -N -u root --password=xxx pydiodb -e "delete from ajxp_repo where uuid like '$CC'"
fi
if [ ! -z $D ]
then
mysql -N -u root --password=xxx pydiodb -e "delete from ajxp_user_bookmarks where rid like '$DD'" >
fi
done < /tmp/liste_files_purge.txt
Hi,
i forgot to ask but did you enable the purging process on the workspaces that you want to purge as seen in this screenshot, the default value is 0 (which disable the feature)
i have set up hard limit bit soft limit is still 0
I know you command but this purge only one workspace (admin in your example).
And i don’t know password of my users.
And an error occurs, i didn’t had this error on 8.0.2
[root@srv-pydio-02 personal]# php /usr/share/pydio/cmd.php -r=my-files -u=adm_interne -p=xxx -a=purge
PHP Fatal error: Uncaught Pydio\Core\Exception\DBConnectionException: There was an error trying to connect to your database! Did you change any configuration for the core connection? Or maybe your database is down? in /usr/share/pydio/plugins/conf.sql/SqlConfDriver.php:112
I have updated to 8.2.0, with php 7.1 but still no luck
I jumping on this, sorry if I asked questions already asked…
Do you have any commands working correctly when launched from within pydio? Like repository indexation? Is only the purge failing?
-c
