Emoncms cannot connect to mqtt server

mariusl · 10 December 2021 09:39

Hi
I installed Emoncms on a VPS using the Debian install script. The following error is shown in the log
2021-12-10 09:30:48.038|ERROR|emoncms_mqtt.php|unexpected connection problem mqtt server:Connection Refused: not authorised.
I used all the default usernames and passwords as the system installed. Any suggestions please?

From the terminal I do this
sudo mosquitto_sub -v -u ‘emonpi’ -P ‘emonpimqtt2016’ -t ‘emon/#’
It sits and waits so I assume that it connected

Then with this
sudo mosquitto_sub -v -u ‘emoncms’ -P ‘emoncmsmqtt2016’ -t ‘emon/#’
Connection Refused: not authorised.

TrystanLea · 11 December 2021 21:35

Hello @mariusl I assume mosquitto is running ok?

This is the script that installs mosquitto and sets mosquitto.conf, might be worth checking that these steps applied ok…

github.com

openenergymonitor/EmonScripts/blob/master/install/mosquitto.sh

#!/bin/bash
source load_config.sh

if [ "$install_mosquitto_server" = true ]; then
    echo "-------------------------------------------------------------"
    echo "Mosquitto Server installation and configuration"
    echo "-------------------------------------------------------------"
    sudo apt-get install -y mosquitto
    sudo apt-get install -y libmosquitto-dev

    # Disable mosquitto persistance
    sudo sed -i "s/^persistence true/persistence false/" /etc/mosquitto/mosquitto.conf
    # append line: allow_anonymous false
    sudo sed -i -n '/allow_anonymous false/!p;$a allow_anonymous false' /etc/mosquitto/mosquitto.conf
    # append line: password_file /etc/mosquitto/passwd
    sudo sed -i -n '/password_file \/etc\/mosquitto\/passwd/!p;$a password_file \/etc\/mosquitto\/passwd' /etc/mosquitto/mosquitto.conf
    # append line: log_type error
    sudo sed -i -n '/log_type error/!p;$a log_type error' /etc/mosquitto/mosquitto.conf

    # Create mosquitto password file

This file has been truncated. show original

mariusl · 13 December 2021 15:09

I used the script that is supplied for Debian installation. I think Mosquitto is running fine but I will go through the steps that you suggested.

Vster · 14 December 2021 11:31

This is the terminal on the VPS?
Is the log error is generated by that first mosquitto_sub command? Or the second _sub?

If it’s the second, then it’s probably correct.

The first line sitting and waiting it correct, it’s waiting for some incoming messages.
If you log in to a second terminal (or use screen), then publish some data to mosquitto, it should show up in the first command.

mariusl · 14 December 2021 20:33

I ended up re-installing the system. Maybe it was not required but I needed to know that I did everything correct.
I do not know why the emoncms connection with the mqtt server failed as I used the automated install script. After the reinstall that problem went away.
Then I think there might be some confusion on my part with regards to topic definitions.
On the emonesp I defined the topic to be emon/# and the same on emoncms. This failed. Then looking at the debug output from the emonesp I saw another piece that was required.
I changed the topic to emon/emonesp/# and that seemed to work.
I also managed to connect emoncms with emonesp by using the device API-KEY.
I am now connecting to the VPS using emonesp