LCD Screen says "Updating - Do Not Unplug" (updating system from V8.5)

Does the error go when you select ‘graphs’ or does it persist? Try changing something on the graphs, add a feed and then delete it and so you can save the graph.

Your data sources should just appear in the Inputs page. Does it?

Can you PM me your settings.php please?

The error persists, each time you re-select the “Graphs” menu at the left.

In my inputs page, I had 3 things listed, all called “emo”, as if it was truncated. It looks like one of them is the emonpi, the other two are emonth sensors. I can select them to initialise them, but can’t see any data. As it stands, I should have 2x wired dallas sensors, 2x TH RF sensors, AC mains sensor, current clamp, etc.

The graphs are all in an “undefined” submenu, and where it has created new graphs for the emonpi (by initialising it), the drop-down to select a graph (under MyGraphs) is completely empty.

Can you do a screen shot of what you currently see? Win 10 you can just Win+shift+S, Alt+PrtScrn, or use the snipping tool, then just paste it in a message.

On its way now…

Thanks. I meant post the images here (for all) and the file to me as it has passwords etc in it, but no bother.

Let me check, what hardware do you have? EmonPi, EmonBase, EmonTX, EmonTH?

Could you also do a ls -la /var/www/emoncms/ please.

Ah, I can post them here too…

I have an emonPi, and two emonTH sensors.

Output of the above command is:

pi@emonpi:/var/www/emoncms $ ls -la /var/www/emoncms/
total 216
drwxr-xr-x 9 pi pi 4096 Oct 19 15:15 .
drwxr-xr-x 4 pi root 4096 Aug 15 2018 …
-rw-r–r-- 1 pi pi 513 Oct 19 12:26 composer.json
-rw-r–r-- 1 pi pi 1025 Oct 19 12:26 COPYRIGHT.txt
-rw-r–r-- 1 pi pi 8052 Oct 19 12:26 core.php
-rw-r–r-- 1 pi pi 7037 Oct 19 12:26 default.emonpi.settings.php
-rw-r–r-- 1 pi pi 5843 Oct 19 12:26 default-settings.ini
-rw-r–r-- 1 pi pi 7130 Oct 19 12:26 default-settings.php
drwxr-xr-x 4 pi pi 4096 Oct 19 12:26 docs
-rw-r–r-- 1 pi pi 2063 Oct 19 12:26 example.settings.ini
drwxrwxrwx 8 pi pi 4096 Oct 19 13:38 .git
-rw-r–r-- 1 pi pi 413 Oct 19 12:26 .gitignore
-rw-r–r-- 1 pi pi 8917 Oct 19 12:26 .htaccess
-rw-r–r-- 1 pi pi 16213 Oct 19 12:26 index.php
-rw-r–r-- 1 pi pi 223 Aug 2 2018 .jshintrc
drwxr-xr-x 11 pi pi 4096 Oct 19 12:26 Lib
-rw-r–r-- 1 pi pi 32386 Aug 2 2018 LICENSE.txt
-rw-r–r-- 1 pi pi 3703 Oct 19 12:26 locale.php
drwxr-xr-x 17 pi pi 4096 Oct 19 12:27 Modules
-rw-r–r-- 1 pi pi 4119 Aug 2 2018 param.php
-rwxr-xr-x 1 pi pi 95 Aug 2 2018 php-info.php
-rw-r–r-- 1 pi pi 4585 Oct 19 12:26 process_settings.php
-rw-r–r-- 1 pi pi 12504 Oct 19 12:26 readme.md
-rw-r–r-- 1 pi pi 4821 Oct 19 12:26 route.php
drwxr-xr-x 6 pi pi 4096 Oct 19 12:26 scripts
-rw-r–r-- 1 pi pi 628 Oct 19 12:26 settings.env.ini
-rw-r–r-- 1 pi pi 7037 Oct 19 12:26 settings.php
drwxr-xr-x 4 pi pi 4096 Oct 25 2018 tests
drwxr-xr-x 3 pi pi 4096 Aug 2 2018 Theme
-rw-r–r-- 1 pi pi 111 Oct 19 12:26 .travis.yml
-rw-r–r-- 1 pi pi 7 Oct 19 12:26 version.txt

Images here for reference:

This may or may not be relevant (from emoncms.log):

2019-10-19 16:17:22.981|WARN|emoncms_mqtt.php|Not connected, retrying connection
2019-10-19 16:17:23.162|WARN|emoncms_mqtt.php|Connecting to MQTT server: Connection Accepted.: code: 0
2019-10-19 16:17:24.688|WARN|index.php|406 Not Acceptable|feed/list
2019-10-19 16:17:29.183|WARN|index.php|406 Not Acceptable|feed/list
.
.
.
2019-10-19 16:28:20.382|WARN|index.php|406 Not Acceptable|feed/list
2019-10-19 16:28:22.649|ERROR|index.php|Not Authenticated|feed/view
2019-10-19 16:56:01.633|WARN|emoncms_mqtt.php|Not connected, retrying connection
2019-10-19 16:56:01.665|WARN|emoncms_mqtt.php|Connecting to MQTT server: Connection Accepted.: code: 0

Ok so I’m not sure why the inputs and feeds have not been created properly.

Just so I’m clear, you started with the

Not the 2019 image?

On the admin page, next to the server infomation header there is a button ‘copy as markdown’. Could you do that and post it here please?

The lack of MQTT will explain no data.

Try

systemctl status mosquitto.service
sudo  systemctl restart mosquitto.service
systemctl status mosquitto.service

and post the output please.

When posting code or console output, please put 3 backticks (top left of keyboard) ```on a line before and 3 more on a line after - no other formatting.

Ah thanks - will do…
Yes, I’m definitely on the 2018 stable image, not the 2019 beta.

Server Information

Server Information

Server Information

Services

  • emonhub :- Active Running
  • emoncms_mqtt :- Active Running
  • feedwriter :- Active Running - sleep 60s 0 feed points pending write
  • service-runner :- Active Running
  • emonPiLCD :- Active Running
  • redis-server :- Active Running
  • mosquitto :- Active Running

Emoncms

Server

  • OS :- Linux 4.14.71-v7+
  • Host :- emonpi | emonpi | (172.16.12.4)
  • Date :- 2019-10-19 16:56:46 UTC
  • Uptime :- 16:56:46 up 32 min, 0 users, load average: 0.40, 0.19, 0.12

Memory

  • RAM :- Used: 16.19%
    • Total :- 976.74 MB
    • Used :- 158.15 MB
    • Free :- 818.59 MB
  • Swap :- Used: 0.00%
    • Total :- 100 MB
    • Used :- 0 B
    • Free :- 100 MB
      Write Load Period

Disk

  • / :- Used: 39.99%
    • Total :- 3.81 GB
    • Used :- 1.53 GB
    • Free :- 2.11 GB
    • Write Load :- 14.55 KB/s (1 mins)
  • /boot :- Used: 51.69%
    • Total :- 42.52 MB
    • Used :- 21.98 MB
    • Free :- 20.54 MB
    • Write Load :- 0 B/s (1 mins)
  • /home/pi/data :- Used: 4.29%
    • Total :- 10.66 GB
    • Used :- 467.89 MB
    • Free :- 9.66 GB
    • Write Load :- 281.32 B/s (1 mins)

HTTP

  • Server :- Apache/2.4.25 (Raspbian) HTTP/1.1 CGI/1.1 80

MySQL

  • Version :- 5.5.5-10.1.23-MariaDB-9+deb9u1
  • Host :- localhost:6379 (127.0.0.1)
  • Date :- 2019-10-19 16:56:45 (UTC 00:00‌​)
  • Stats :- Uptime: 2369 Threads: 3 Questions: 3560 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 24 Queries per second avg: 1.502

Redis

  • Version :-
    • Redis Server :- 3.2.6
    • PHP Redis :- 4.1.1
  • Host :- localhost:6379
  • Size :- 58 keys (754.81K)
  • Uptime :- 0 days

MQTT Server

  • Version :- Mosquitto 1.4.10
  • Host :- localhost:1883 (127.0.0.1)

PHP

  • Version :- 7.0.30-0+deb9u1 (Zend Version 3.0.0)
  • Modules :- apache2handler | calendar v7.0.30-0+deb9u1 | Core v7.0.30-0+deb9u1 | ctype v7.0.30-0+deb9u1 | curl v7.0.30-0+deb9u1 | date v7.0.30-0+deb9u1 | dom v20031129 | exif v7.0.30-0+deb9u1 | fileinfo v1.0.5 | filter v7.0.30-0+deb9u1 | ftp v7.0.30-0+deb9u1 | gd v7.0.30-0+deb9u1 | gettext v7.0.30-0+deb9u1 | hash v1.0 | iconv v7.0.30-0+deb9u1 | igbinary v2.0.1 | json v1.4.0 | libxml v7.0.30-0+deb9u1 | mbstring v7.0.30-0+deb9u1 | mcrypt v7.0.30-0+deb9u1 | mosquitto v0.4.0 | mysqli v7.0.30-0+deb9u1 | mysqlnd vmysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ | openssl v7.0.30-0+deb9u1 | pcre v7.0.30-0+deb9u1 | PDO v7.0.30-0+deb9u1 | pdo_mysql v7.0.30-0+deb9u1 | Phar v2.0.2 | posix v7.0.30-0+deb9u1 | readline v7.0.30-0+deb9u1 | redis v4.1.1 | Reflection v7.0.30-0+deb9u1 | session v7.0.30-0+deb9u1 | shmop v7.0.30-0+deb9u1 | SimpleXML v7.0.30-0+deb9u1 | sockets v7.0.30-0+deb9u1 | SPL v7.0.30-0+deb9u1 | standard v7.0.30-0+deb9u1 | sysvmsg v7.0.30-0+deb9u1 | sysvsem v7.0.30-0+deb9u1 | sysvshm v7.0.30-0+deb9u1 | tokenizer v7.0.30-0+deb9u1 | wddx v7.0.30-0+deb9u1 | xml v7.0.30-0+deb9u1 | xmlreader v7.0.30-0+deb9u1 | xmlwriter v7.0.30-0+deb9u1 | xsl v7.0.30-0+deb9u1 | Zend OPcache v7.0.30-0+deb9u1 | zlib v7.0.30-0+deb9u1

Pi

  • Model :- Raspberry Pi 2 Model B Rev 1.1 - 1GB (Sony UK)

  • Serial num. :- 9FEA2AF3

  • Temperature :- 45.46°C - 45.5°C

  • emonpiRelease :- emonSD-30Oct18

  • File-system :- read-write

Client Information

Client Information

HTTP

  • Browser :- Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.120 Safari/537.36
  • Language :- en-GB,en-US;q=0.9,en;q=0.8

Window

  • Size :- 2379 x 1171

Screen

  • Resolution :- 1920 x 1080

First command:

pi@emonpi:~ $ systemctl status mosquitto.service
● mosquitto.service - LSB: mosquitto MQTT v3.1 message broker
   Loaded: loaded (/etc/init.d/mosquitto; generated; vendor preset: enabled)
   Active: active (running) since Sat 2019-10-19 16:17:21 UTC; 7h ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mosquitto.service
           └─905 /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf

Oct 19 16:17:21 emonpi systemd[1]: Starting LSB: mosquitto MQTT v3.1 message bro
Oct 19 16:17:21 emonpi mosquitto[898]: Starting network daemon:: mosquitto.
Oct 19 16:17:21 emonpi systemd[1]: Started LSB: mosquitto MQTT v3.1 message brok
lines 1-10/10 (END)
● mosquitto.service - LSB: mosquitto MQTT v3.1 message broker
   Loaded: loaded (/etc/init.d/mosquitto; generated; vendor preset: enabled)
   Active: active (running) since Sat 2019-10-19 16:17:21 UTC; 7h ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mosquitto.service
           └─905 /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf

Oct 19 16:17:21 emonpi systemd[1]: Starting LSB: mosquitto MQTT v3.1 message broker...
Oct 19 16:17:21 emonpi mosquitto[898]: Starting network daemon:: mosquitto.
Oct 19 16:17:21 emonpi systemd[1]: Started LSB: mosquitto MQTT v3.1 message broker.

Second command:

pi@emonpi:~ $ sudo systemctl restart mosquitto.service
pi@emonpi:~ $

Third command:

pi@emonpi:~ $ systemctl status mosquitto.service
● mosquitto.service - LSB: mosquitto MQTT v3.1 message broker
   Loaded: loaded (/etc/init.d/mosquitto; generated; vendor preset: enabled)
   Active: active (running) since Sat 2019-10-19 23:46:13 UTC; 30s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 7198 ExecStop=/etc/init.d/mosquitto stop (code=exited, status=0/SUCCESS)
  Process: 7207 ExecStart=/etc/init.d/mosquitto start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mosquitto.service
           └─7213 /usr/sbin/mosquitto -c /etc/mosquitto/mosquitto.conf

Oct 19 23:46:13 emonpi systemd[1]: Starting LSB: mosquitto MQTT v3.1 message broker...
Oct 19 23:46:13 emonpi mosquitto[7207]: Starting network daemon:: mosquitto.
Oct 19 23:46:13 emonpi systemd[1]: Started LSB: mosquitto MQTT v3.1 message broker.

Mmmm.

Next thing to check is the emonhub.

Can you download and attach the log file please.

Can you also attach the emoncms log as well.

Logs attached - as you’d mentioned previously, there could be an MQTT issue, there are multiple log entries saying “Could not connect…”.

emonhub.log.txt (167.7 KB) emoncms.log.txt (3.3 KB)

Try this

mosquitto_sub -v -u 'emonpi' -P 'emonpimqtt2016' -t 'emon/#'

It doesn’t return anything…

pi@emonpi:~ $ mosquitto_sub -v -u 'emonpi' -P 'emonpimqtt2016' -t 'emon/#'

But I assume it’s authenticating fine cos if I change the password I get this:

pi@emonpi:~ $ mosquitto_sub -v -u 'emonpi' -P 'wrongpassword' -t 'emon/#'
Connection Refused: not authorised.
Connection Refused: not authorised.
Connection Refused: not authorised.

Yes which is really odd.

But the log does then say connected - you always get a couple of ‘not connected’ at boot/restart.

So emonhub.cfg
The emonhub.log shows that

2019-10-20 10:17:07,243 INFO     MQTT       Connecting to MQTT Server
2019-10-20 10:17:07,244 INFO     MQTT       Could not connect...

Check the MQTT settings, username and password in the emonhub.cfg (via the web interface).

[[MQTT]]

    Type = EmonHubMqttInterfacer
    [[[init_settings]]]
        mqtt_host = 127.0.0.1
        mqtt_port = 1883
        mqtt_user = emonpi
        mqtt_passwd = emonpimqtt2016

If correct try

mosquitto_sub -v -d -h 127.0.0.1 -u 'emonpi' -P 'emonpimqtt2016' -t 'emon/#'

Ah, interesting - it’s slightly different in emonhub.cfg:

### This interfacer manages the RFM2Pi module
[[MQTT]]

    Type = EmonHubMqttInterfacer
    [[[init_settings]]]
        mqtt_host = 127.0.0.1
        mqtt_port = 1883
    [[[runtimesettings]]]
        pubchannels = ToRFM12,
        subchannels = ToEmonCMS,
        basetopic = emonhub/

Looks like the user/pass are missing. I’ve searched the config and neither appear anywhere in emonhub.cfg.

Ah can you post the whole thing. Watch for an API key listed.

See attached. I think the last 6 nodes were added since migration by trying to set up inputs (the last feed I had in the old config was [[7]] nodename = emonTx_4

emonhub.conf.txt (10.9 KB)

Just checking which config I should be looking at… the extracts above are from emonhub.conf from the web interface, but if I go to /home/pi/emonhub/conf/emonhub.conf then the contents are different:

[[MQTT]]

    Type = EmonHubMqttInterfacer
    [[[init_settings]]]
        mqtt_host = 127.0.0.1
        mqtt_port = 1883
        mqtt_user = ''
        mqtt_passwd = ''

emonhub.conf.txt (7.5 KB)

There are also other conf files in that folder, emonpi.default.emonhub.conf has the right credentials in it. This is what’s in the folder:

pi@emonpi:~/emonhub/conf $ ls
default       emonpi.default.emonhub.conf  nodes
emonhub.conf  interfacer_examples          old.default.emonhub.conf