3

I managed to fix the problem by the following steps:

A. I undid all changes made by previous calls of the backup.php by means of following steps:

  1. stopped apache server : sudo systemctl stop apache2

  2. emptied the folders /var/lib/phpfina and /var/lib/phptimeseries

  3. dropped all mysql tables in emoncms database (I guess that actually not all tables must be dropped)

  4. reset $local_emoncms_userid to 1 in backup.php script

  5. sudo redis-cli FLUSHALL

  6. restarted apache: sudo systemctl start apache2

  7. logged on to emoncms ( http:192.168.1.131/emoncms ) and registered account => this also recreated all required mysql tables !!

B. Re-executed the backup.php script but this time with sudo !

  1. stopped apache : sudo systemctl stop apache2

  2. sudo php backup.php

  3. change owner and group of all files in folders /var/lib/phpfina and /var/lib/phptimeseries to www-data:root by the command sudo chown -R www-data:root /var/lib/phpfina /var/lib/phptimeseries

  4. sudo redis-cli FLUSHALL

  5. restarted apache : sudo systemctl start apache2

So this correctly migrated all feeds from emoncms.org to my local emoncms installation.
FYI the permissions of the php folders:

drwxrwxrwx 2 www-data root 12288 Jun 14 20:54 phpfina
drwxrwxrwx 2 www-data root 4096 Jun 4 22:53 phpfiwa
drwxrwxrwx 2 www-data root 4096 Jun 14 20:53 phptimeseries

1 Like