Community
OpenEnergyMonitor

OpenEnergyMonitor Community

Error in update emoncms

@Geinian_Gomes, have you collected much data? I have just successfully installed emoncms on Ubuntu 18LTS using the scripts GitHub - openenergymonitor/EmonScripts: Emoncms Stack Installation and Update scripts.

The script needs a modified config.ini to work on Ubuntu plus a couple of other minor changes, but it was (almost) painless to install.

When pressing the command presents at the end this error how to solve?

N: Ignoring file ‘mosquitto-jessie.list.1’ in directory ‘/etc/apt/sources.list.d/’ as it has an invalid filename extension
[email protected]:/usr/bin$

Can you click here, then paste into a message please?

I don’t understand

You posted an image of your admin page above and in it you can see this button.

If you click the button, it copies the contents of the page. If you then paste (Ctl-V) into a new message it will look like this

Server Information

Server Information

Services

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

Emoncms

Server

  • OS :- Linux 4.19.57-v7+
  • Host :- emonpi | emonpi | (192.168.7.243)
  • Date :- 2019-09-12 12:34:57 UTC
  • Uptime :- 12:34:57 up 55 days, 3:27, 1 user, load average: 0.28, 0.11, 0.04

Memory

  • RAM :- Used: 20.61%
    • Total :- 975.62 MB
    • Used :- 201.1 MB
    • Free :- 774.52 MB
  • Swap :- Used: 0.00%
    • Total :- 100 MB
    • Used :- 0 B
    • Free :- 100 MB

Disk

  • / :- Used: 47.04%
    • Total :- 3.81 GB
    • Used :- 1.79 GB
    • Free :- 1.84 GB
  • /boot :- Used: 52.42%
    • Total :- 42.52 MB
    • Used :- 22.29 MB
    • Free :- 20.23 MB
  • /home/pi/data :- Used: 3.72%
    • Total :- 3.21 GB
    • Used :- 122.25 MB
    • Free :- 2.92 GB

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-09-12 12:34:56 (UTC 00:00‌​)
  • Stats :- Uptime: 4764441 Threads: 3 Questions: 1121865 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables: 24 Queries per second avg: 0.235

Redis

  • Version :- 3.2.6
  • Host :- localhost:6379
  • Size :- 120 keys (848.92K)
  • Uptime :- 55 days

MQTT Server

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

PHP

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

Pi

  • Model :- Raspberry Pi 3 Model B+ Rev 1.3 - 1GB (Sony UK)

  • Serial num. :- 71604C19

  • Temperature :- 51.54°C - 50.5°C

  • emonpiRelease :- emonSD-30Oct18

  • File-system :- read-write

Client Information

Client Information

HTTP

  • Browser :- Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.110 Safari/537.36 Vivaldi/2.7.1628.30
  • Language :- en-US,en;q=0.9

Window

  • Size :- 1367 x 869

Screen

  • Resolution :- 1920 x 1080
Server Information

Server Information

Services

  • emonhub :- Active Running
  • redis-server :- Active Running
  • mosquitto :- Active Exited

Emoncms

Server

  • OS :- Linux 4.4.0-159-generic
  • Host :- emoncms | emoncms | (192.168.0.157)
  • Date :- 2019-09-12 09:40:16 -03
  • Uptime :- 09:40:16 up 16 min, 1 user, load average: 0.01, 0.09, 0.17

Memory

  • RAM :- Used: 13.19%
    • Total :- 1.97 GB
    • Used :- 265.71 MB
    • Free :- 1.71 GB
  • Swap :- Used: 0.00%
    • Total :- 976 MB
    • Used :- 0 B
    • Free :- 976 MB

Disk

  • / :- Used: 20.83%
    • Total :- 17.91 GB
    • Used :- 3.73 GB
    • Free :- 13.25 GB
  • /boot :- Used: 14.61%
    • Total :- 719.48 MB
    • Used :- 105.08 MB
    • Free :- 577.86 MB

HTTP

  • Server :- Apache/2.4.18 (Ubuntu) HTTP/1.1 CGI/1.1 80

MySQL

  • Version :- 5.7.27-0ubuntu0.16.04.1
  • Host :- localhost:6379 (127.0.0.1)
  • Date :- 2019-09-12 09:40:16 (UTC -03:00‌​)
  • Stats :- Uptime: 937 Threads: 1 Questions: 449 Slow queries: 0 Opens: 136 Flush tables: 1 Open tables: 54 Queries per second avg: 0.479

Redis

  • Version :- 3.0.6
  • Host :- localhost:6379
  • Size :- 111 keys (439.53K)
  • Uptime :- 0 days

MQTT Server

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

PHP

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

Client Information

HTTP

  • Browser :- Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:69.0) Gecko/20100101 Firefox/69.0
  • Language :- pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3

Window

  • Size :- 1905 x 963

Screen

  • Resolution :- 1920 x 1080

So your error now stems from this problem. You must have installed emoncms before the build guide was changed.

@pb66, do you have a solution to remove the old mosquitto install?

can you provide all the git needed to install emoncms on ubuntu?
if possible, it is better to reinstall emoncms again.
following the correct steps.

Do you want to keep your data and setup? Much easier if you do not.

Are you in a position to start with a fresh Ubuntu install? If not, the problem with mosquitto still needs fixing.

it’s okay to erase the data.

can you redirect to the correct emoncms installation links?

I’ve posted it here Install EmonCMS on Ubuntu 18LTS with scripts.

version of ubuntu I’m using is 16.4, do you have any emoncms compatibility issues?

That should be fine as it is Stretch based. If you can, move to 18.04 as that is what I have tested this install on.

Okay, I’m updating the ubuntu.

1 Like

just to be clear (and I will update the other post, you start the install here for Ubuntu EmonScripts/readme.md at master · openenergymonitor/EmonScripts · GitHub

these emoncms installation steps are for running
in raspberry, it works in local emoncms “ubuntu”?

You need to start here

wget https://raw.githubusercontent.com/openenergymonitor/EmonScripts/master/install/init.sh
chmod +x init.sh
./init.sh

I do not understand ‘cargo’ - translation problem I suspect :grin:

where the emoncms data will be stored?
has a database ?