Trying the find command
pi@emonpi:~ $ find /dev/disk/by-id/
/dev/disk/by-id/
/dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0-part2
/dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0-part3
/dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0-part1
/dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0
/dev/disk/by-id/mmc-SC16G_0xb4aaceb9-part3
/dev/disk/by-id/mmc-SC16G_0xb4aaceb9-part2
/dev/disk/by-id/mmc-SC16G_0xb4aaceb9-part1
/dev/disk/by-id/mmc-SC16G_0xb4aaceb9
pi@emonpi:~ $
Did an emonPi update and got your new import script. Update log is
Starting update via service-runner-update.sh (v3.0) >
- emonSD version: emonSD-17Oct19
emonSD base image check passed...continue update
git pull /opt/openenergymonitor/EmonScripts
master
* stable
On branch stable
Your branch is up to date with 'origin/stable'.
nothing to commit, working tree clean
Already up to date.
-------------------------------------------------------------
Main Update Script
-------------------------------------------------------------
Date: Wed 29 Apr 15:19:16 BST 2020
EUID: 1000
openenergymonitor_dir: /opt/openenergymonitor
type: all
firmware: none
Hardware detected: EmonPi
Stopping emonPiLCD service
Display update message on LCD
I2C LCD DETECTED Ox27
git pull /opt/openenergymonitor/emonpi
* master
On branch master
Your branch is up to date with 'origin/master'.
nothing to commit, working tree clean
Fetching origin
Already up to date.
git pull /opt/openenergymonitor/RFM2Pi
* master
On branch master
Your branch is up to date with 'origin/master'.
nothing to commit, working tree clean
Fetching origin
Already up to date.
Start emonhub update script:
-------------------------------------------------------------
emonHub update
-------------------------------------------------------------
git pull /opt/openenergymonitor/emonhub
* emon-pi
On branch emon-pi
Your branch is up to date with 'origin/emon-pi'.
nothing to commit, working tree clean
Already up to date.
Failed to restart .service.service: Unit .service.service not found.
- Service
Running emonhub automatic node addition script
[[5]]
Node 5 already present
[[6]]
Node 6 already present
[[7]]
Node 7 already present
[[8]]
Node 8 already present
[[9]]
Node 9 already present
[[10]]
Node 10 already present
[[11]]
Node 11 already present
[[12]]
Node 12 already present
[[13]]
Node 13 already present
[[14]]
Node 14 already present
[[15]]
Node 15 already present
[[16]]
Node 16 already present
[[19]]
Node 19 already present
[[20]]
Node 20 already present
[[21]]
Node 21 already present
[[22]]
Node 22 already present
[[23]]
Node 23 already present
[[24]]
Node 24 already present
[[25]]
Node 25 already present
[[26]]
Node 26 already present
Start emoncms update:
-------------------------------------------------------------
Update Emoncms Core
-------------------------------------------------------------
Checking status of /var/www/emoncms git repository
- git branch: stable
- no local changes
- running: git pull origin stable
Fetching origin
From https://github.com/emoncms/emoncms
* branch stable -> FETCH_HEAD
Already up to date.
Update Emoncms database
[]
-------------------------------------------------------------
Update Emoncms Services
-------------------------------------------------------------
emoncms_mqtt.service already installed
feedwriter.service already installed
service-runner.service already installed
Reloading systemctl deamon
Restarting Services...
- sudo systemctl restart feedwriter.service
--- ActiveState=active ---
- sudo systemctl restart emoncms_mqtt.service
--- ActiveState=active ---
- sudo systemctl restart emonhub.service
--- ActiveState=active ---
/opt/openenergymonitor/EmonScripts/sudoers.d/emoncms-rebootbutton: parsed OK
emonPi emoncms admin reboot button sudoers updated
-------------------------------------------------------------
Update Emoncms Modules
-------------------------------------------------------------
------------------------------------------
Updating /var/www/emoncms/Modules/app module
------------------------------------------
- git branch: stable
- git tags: 2.1.1
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/config module
------------------------------------------
- git branch: stable
- git tags: 2.0.5
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/dashboard module
------------------------------------------
- git branch: stable
- git tags: 2.0.7
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/device module
------------------------------------------
- git branch: stable
- git tags: 2.0.5
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/graph module
------------------------------------------
- git branch: stable
- git tags: 2.0.8-2-g7df046d
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/setup module
------------------------------------------
- git branch: stable
fatal: No names found, cannot describe anything.
- git tags:
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
------------------------------------------
Updating /var/www/emoncms/Modules/wifi module
------------------------------------------
- git branch: stable
- git tags: 2.0.0-29-g274bcd5
- no local changes
- running: git pull origin stable
Fetching origin
Already on 'stable'
Your branch is up to date with 'origin/stable'.
Already up to date.
/opt/openenergymonitor/EmonScripts/sudoers.d/wifi-sudoers: parsed OK
wifi sudoers entry updated
------------------------------------------
Updating /opt/emoncms/modules/backup module
------------------------------------------
- git branch: stable
- git tags: 2.2.2
- no local changes
- running: git pull origin stable
From https://github.com/emoncms/backup
8b670a0..70894e1 stable -> origin/stable
dfaca67..3f2beaa master -> origin/master
Updating 8b670a0..70894e1
Fast-forward
.travis.yml | 14 ++
LICENSE.txt | 619 ++++++++++++++++++++++++++++++++++++++++++++++
backup-module/module.json | 2 +-
composer.json | 17 ++
usb-import.sh | 15 +-
5 files changed, 658 insertions(+), 9 deletions(-)
create mode 100644 .travis.yml
create mode 100644 LICENSE.txt
create mode 100644 composer.json
Already on 'stable'
Your branch is up to date with 'origin/stable'.
------------------------------------------
Updating /opt/emoncms/modules/demandshaper module
------------------------------------------
- git branch: stable
- git tags: 1.2.4-5-gd689aae
- no local changes
- running: git pull origin stable
Already up to date.
Already on 'stable'
Your branch is up to date with 'origin/stable'.
------------------------------------------
Updating /opt/emoncms/modules/postprocess module
------------------------------------------
- git branch: stable
- git tags: 2.1.0-21-g0e2d78f
- no local changes
- running: git pull origin stable
Already up to date.
Already on 'stable'
Your branch is up to date with 'origin/stable'.
------------------------------------------
Updating /opt/emoncms/modules/sync module
------------------------------------------
- git branch: stable
- git tags: 2.0.5
- no local changes
- running: git pull origin stable
Already up to date.
Already on 'stable'
Your branch is up to date with 'origin/stable'.
------------------------------------------
Updating /opt/emoncms/modules/usefulscripts module
------------------------------------------
- git branch: stable
fatal: No names found, cannot describe anything.
- git tags:
- no local changes
- running: git pull origin stable
Already up to date.
Already on 'stable'
Your branch is up to date with 'origin/stable'.
--------------------------------------------
Backup module installation and update script
--------------------------------------------
- Loading EmonScripts config.ini
- Copying default.config.cfg to config.cfg
- Setting config.cfg settings
- Backup module symlink already exists
- PHP Version: 7.3
- Creating /etc/php/7.3/mods-available/emoncmsbackup.ini
post_max_size = 3G
upload_max_filesize = 3G
upload_tmp_dir = /var/opt/emoncms/backup/uploads
- phpenmod emoncmsbackup
- /var/opt/emoncms/backup already exists
- /var/opt/emoncms/backup/uploads already exists
- restarting apache
Update Emoncms database
[]
Starting emonPi LCD service..
-------------------------------------------------------------
emonPi update done: Wed 29 Apr 15:20:03 BST 2020
-------------------------------------------------------------
restarting service-runner
Ran it and it did lots of work
=== USB Emoncms import start ===
2020-04-29-15:20:13
Backup module version:
"version" : "2.2.3"
EUID: 1000
Reading /opt/emoncms/modules/backup/config.cfg....
Location of data databases: /var/opt/emoncms
Location of emonhub.conf: /etc/emonhub
Location of Emoncms: /var/www/emoncms
Scanning for USB card reader:
- Found: /dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0 at /dev/sda
**Using: /dev/disk/by-id/usb-Generic_MassStorageClass_000000001536-0:0 at /dev/sda**
- No card reader found on sdb
- No card reader found on sdc
creating mount point /media/old_sd_boot
creating mount point /media/old_sd_root
creating mount point /media/old_sd_data
Mounting old SD card boot partition
Mounting old SD card root partition
Mounting old SD card data partition
Stopping services..
Read MYSQL authentication details from settings.php
stopping mysql
Manually deleting old mysql emoncms database
Manual install of emoncms database
'/media/old_sd_root/var/lib/mysql/emoncms' -> '/var/lib/mysql/emoncms'
'/media/old_sd_root/var/lib/mysql/emoncms/db.opt' -> '/var/lib/mysql/emoncms/db.opt'
'/media/old_sd_root/var/lib/mysql/emoncms/app_config.frm' -> '/var/lib/mysql/emoncms/app_config.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/app_config.MYI' -> '/var/lib/mysql/emoncms/app_config.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/app_config.MYD' -> '/var/lib/mysql/emoncms/app_config.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/demandshaper.frm' -> '/var/lib/mysql/emoncms/demandshaper.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/demandshaper.MYI' -> '/var/lib/mysql/emoncms/demandshaper.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/demandshaper.MYD' -> '/var/lib/mysql/emoncms/demandshaper.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/device.frm' -> '/var/lib/mysql/emoncms/device.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/device.MYI' -> '/var/lib/mysql/emoncms/device.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/device.MYD' -> '/var/lib/mysql/emoncms/device.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/feeds.frm' -> '/var/lib/mysql/emoncms/feeds.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/feeds.MYI' -> '/var/lib/mysql/emoncms/feeds.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/feeds.MYD' -> '/var/lib/mysql/emoncms/feeds.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/graph.frm' -> '/var/lib/mysql/emoncms/graph.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/graph.MYI' -> '/var/lib/mysql/emoncms/graph.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/graph.MYD' -> '/var/lib/mysql/emoncms/graph.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/input.frm' -> '/var/lib/mysql/emoncms/input.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/input.MYI' -> '/var/lib/mysql/emoncms/input.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/input.MYD' -> '/var/lib/mysql/emoncms/input.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/postprocess.frm' -> '/var/lib/mysql/emoncms/postprocess.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/postprocess.MYI' -> '/var/lib/mysql/emoncms/postprocess.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/postprocess.MYD' -> '/var/lib/mysql/emoncms/postprocess.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/schedule.frm' -> '/var/lib/mysql/emoncms/schedule.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/schedule.MYI' -> '/var/lib/mysql/emoncms/schedule.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/schedule.MYD' -> '/var/lib/mysql/emoncms/schedule.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/setup.frm' -> '/var/lib/mysql/emoncms/setup.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/setup.MYI' -> '/var/lib/mysql/emoncms/setup.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/setup.MYD' -> '/var/lib/mysql/emoncms/setup.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/sync.frm' -> '/var/lib/mysql/emoncms/sync.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/sync.MYI' -> '/var/lib/mysql/emoncms/sync.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/sync.MYD' -> '/var/lib/mysql/emoncms/sync.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/users.frm' -> '/var/lib/mysql/emoncms/users.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/users.MYI' -> '/var/lib/mysql/emoncms/users.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/users.MYD' -> '/var/lib/mysql/emoncms/users.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/rememberme.frm' -> '/var/lib/mysql/emoncms/rememberme.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/rememberme.MYI' -> '/var/lib/mysql/emoncms/rememberme.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/rememberme.MYD' -> '/var/lib/mysql/emoncms/rememberme.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/multigraph.frm' -> '/var/lib/mysql/emoncms/multigraph.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/multigraph.MYI' -> '/var/lib/mysql/emoncms/multigraph.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/multigraph.MYD' -> '/var/lib/mysql/emoncms/multigraph.MYD'
'/media/old_sd_root/var/lib/mysql/emoncms/dashboard.frm' -> '/var/lib/mysql/emoncms/dashboard.frm'
'/media/old_sd_root/var/lib/mysql/emoncms/dashboard.MYI' -> '/var/lib/mysql/emoncms/dashboard.MYI'
'/media/old_sd_root/var/lib/mysql/emoncms/dashboard.MYD' -> '/var/lib/mysql/emoncms/dashboard.MYD'
Setting database ownership
starting mysql
checking database
emoncms.app_config OK
emoncms.dashboard OK
emoncms.demandshaper OK
emoncms.device OK
emoncms.feeds OK
emoncms.graph OK
emoncms.input OK
emoncms.multigraph OK
emoncms.postprocess OK
emoncms.rememberme OK
emoncms.schedule OK
emoncms.setup OK
emoncms.sync OK
emoncms.users OK
Updating Emoncms Database..
[]
Archive old data folders
Copying PHPFina feed data
'/media/old_sd_data/phpfina' -> '/var/opt/emoncms/phpfina'
'/media/old_sd_data/phpfina/1.meta' -> '/var/opt/emoncms/phpfina/1.meta'
'/media/old_sd_data/phpfina/1.dat' -> '/var/opt/emoncms/phpfina/1.dat'
'/media/old_sd_data/phpfina/4.meta' -> '/var/opt/emoncms/phpfina/4.meta'
'/media/old_sd_data/phpfina/4.dat' -> '/var/opt/emoncms/phpfina/4.dat'
'/media/old_sd_data/phpfina/3.meta' -> '/var/opt/emoncms/phpfina/3.meta'
'/media/old_sd_data/phpfina/3.dat' -> '/var/opt/emoncms/phpfina/3.dat'
'/media/old_sd_data/phpfina/5.meta' -> '/var/opt/emoncms/phpfina/5.meta'
'/media/old_sd_data/phpfina/5.dat' -> '/var/opt/emoncms/phpfina/5.dat'
'/media/old_sd_data/phpfina/6.meta' -> '/var/opt/emoncms/phpfina/6.meta'
'/media/old_sd_data/phpfina/6.dat' -> '/var/opt/emoncms/phpfina/6.dat'
'/media/old_sd_data/phpfina/7.meta' -> '/var/opt/emoncms/phpfina/7.meta'
'/media/old_sd_data/phpfina/7.dat' -> '/var/opt/emoncms/phpfina/7.dat'
'/media/old_sd_data/phpfina/8.meta' -> '/var/opt/emoncms/phpfina/8.meta'
'/media/old_sd_data/phpfina/8.dat' -> '/var/opt/emoncms/phpfina/8.dat'
'/media/old_sd_data/phpfina/9.meta' -> '/var/opt/emoncms/phpfina/9.meta'
'/media/old_sd_data/phpfina/9.dat' -> '/var/opt/emoncms/phpfina/9.dat'
'/media/old_sd_data/phpfina/14.meta' -> '/var/opt/emoncms/phpfina/14.meta'
'/media/old_sd_data/phpfina/15.meta' -> '/var/opt/emoncms/phpfina/15.meta'
'/media/old_sd_data/phpfina/14.dat' -> '/var/opt/emoncms/phpfina/14.dat'
'/media/old_sd_data/phpfina/15.dat' -> '/var/opt/emoncms/phpfina/15.dat'
'/media/old_sd_data/phpfina/16.meta' -> '/var/opt/emoncms/phpfina/16.meta'
'/media/old_sd_data/phpfina/16.dat' -> '/var/opt/emoncms/phpfina/16.dat'
Copying PHPTimeSeries feed data
'/media/old_sd_data/phptimeseries' -> '/var/opt/emoncms/phptimeseries'
'/media/old_sd_root/etc/emonhub/emonhub.conf' -> '/etc/emonhub/emonhub.conf'
Flushing redis
OK
Restarting emonhub...
Restarting feedwriter...
Restarting emoncms MQTT...
2020-04-29-15:21:03
=== Emoncms import complete! ===
So I’ve rebooted. Deep breath, refresh the browser on the emonPi and …
I’m back! All previously recorded data restored.
Thank you Trystan, much appreciate the instant responses today, and glad to have been able to provide material to improve the product.
Apologies for the off topic comments below, I’ll happily repost appropriately if you recommend so.
-
There is a ca. 2 day data gap which the My Solar App shows as constant use rather than My Electric showing zero, which IMHO would be better.
-
I suspect that the old SDcard will be absolutely fine for reuse - or for the few pounds cost should I just ditch it as suspect and tainted?
-
I will repost on the wired ethernet in another forum section - clearly nothing to do with emonSD.
@borpin I also have eth0 and wlan0 IPs. And had a play with dhcpcd.conf to try and assign a valid local wired network IP, to no avail. Efforts to sort were pushed to the back of the queue when all started falling apart.
@Bill.Thomson I will try without the powerline adapters - I too have found them flaky. Had a big win when I realised the out of the box setup with default credentials was locking on to somebody else’s adapter on the same power phase (a neighbour somewhere). Changed the authorisation and its been much more stable for many months.