I'm confused ;)
because remote_sync.pl don't find ffmpeg I added again:

$conf['vjs_mediainfo_dir'] = '/usr/bin/';
$conf['vjs_exiftool_dir'] = '/usr/bin/';
$conf['vjs_ffprobe_dir'] = '/usr/bin/';
$conf['ffmpeg_dir'] = '/usr/bin/';

and both, manual syncronisation within piwigo as well as cron triggered syncronisation with remote_sync.pl is working.

Sorry for this uncertainty.

But
neither manual syncronisation nor remote_sync.pl are calculating the md5sums.
Can I configure somewhat so it will be calculated during syncronisation?

Last edited by AthLux (2025-05-04 15:33:52)

Hmmm - that's not for me. I'm too lazy :)

#!/bin/bash

declare ioConnect="mysql --skip-column-names -D piwigo -e"
declare TopDir=/srv/piwigoStorage/matthias/www/gallery

while read id path
do
  path="${path#*.}"
  md5=$(md5sum "$TopDir$path" | awk '{print $1}')
  ext="${path##*.}"
  name="${path##*/}"; name=${name%.$ext*}
  path="${path%/*}"

  mv "$TopDir$path/$name.$ext" "$TopDir$path/$name-${md5:0:8}.$ext"
  if [ -e $TopDir/$path/pwg_representative/$name.jpg ]
  then
    mv $TopDir/$path/pwg_representative/$name.jpg $TopDir/$path/pwg_representative/$name-${md5:0:8}.jpg
  fi

  $ioConnect "UPDATE piwigo_images SET path=''.$path/$name-${md5:0:8}.$ext", md5sum='$md5' WHERE id='$id'"

done <<<$($ioConnect "SELECT id, path FROM piwigo_images WHERE md5sum IS NULL")

Last edited by AthLux (2025-05-06 10:49:40)

Currently in developing.
Because PiwigoNG isn't able to syncronise my mobile into piwigo I syncronise my mobile into cloud-service (e.g. onedrive). Already implemented:
- get new pictures from cloud service
- sort it into albums, based on geo location and count of pictues in same geo location
- import it into piwigo and caclulate md5sum
Still some tests to do and to solve the import of exif-data and thumbnails for videos.
I plan a daily execution.

Syncronise as well as remote_sync.pl import the filenames as it is on source.
If you click on "calculation of the checksums" after syncronise, the checksums will be added in this database table and the filenames will be supplemented by first 8 characters of the checksum - by the piwigo implementation.

That's simply what this script do.

I believe it wouldn't be necessary to rename the filenames. I assume all MD5 checks, done by piwigo, would use the md5sum and not the filename. Maybe piwigo add it to the filenames to enable import of several files with same filename but different md5sum.

BTW: I still have troubles with importing exif-data and thumbnails for videos. Do you too? Or that is working for you?

Last edited by AthLux (2025-05-05 06:33:30)

I only use local sync, so Piwigo isn't renaming my files to include any MD5 hash stuff. But your approach to automatically creating the MD5 checksum and updating the DB via script is interesting, I might try that.

I am not having any issues (that I'm aware of) with EXIF data or video thumbnails.

Here's some snippets from my local config (I have a of other stuff in there not related to this thread). I have the ffmpeg stuff commented out and use VideoJS to generate the thumbnails. As for EXIF, I did some overrides to just show the fields I care about and then also added IPTC fields.

//$conf['ffmpeg_dir'] = '/usr/bin/ffmpeg';
//$conf['vjs_mediainfo_dir'] = '/usr/bin/mediainfo';
//$conf['vjs_exiftool_dir'] = '/usr/bin/exiftool';
//$conf['vjs_ffprobe_dir'] = '/usr/bin/ffprobe';

$conf['graphics_library'] = 'ext_imagick';
$conf['upload_form_all_types'] = true;

$conf['show_exif_fields'] = array(
  'Make',
  'Model',
  'DateTimeOriginal',
  );

$conf['show_iptc'] = true;
$conf['show_iptc_mapping'] = array(
  'iptc_caption'         => '2#120',
  'iptc_keywords'        => '2#025',
  'iptc_date_creation'   => '2#055',
);

$lang['iptc_caption']        = 'Description';
$lang['iptc_keywords']       = 'Keywords';
$lang['iptc_date_creation']  = 'Created Date';

$conf['use_iptc'] = true;
$conf['use_iptc_mapping'] = array(
  'author'          => '2#080',
  'name'            => '2#005',
  'comment'         => '2#120',
  'keywords'        => '2#025',
  'date_creation'   => '2#055',
);

I'm not using remote_sync.pl, so not sure what the differences could be.

Yeah, my process is run local sync, then go into batch manager to generate any video thumbnails, tag etc. then every now and then go into the link to update all the MD5 hashes.