raspberry localhost

mikelle · 2021-01-24T08:59:47.929Z

Hello everybody
I am currently sending data to emoncms.org with an arduino.
I want to expand my system this year and double the number of feeds.
Therefore I would like to switch to a localhost to reduce costs.
I own a raspberry 3 (no experience) and have been trying to install emoncms for days with various instructions. so far without success.
I would like to start over with the installation and hope for your support.

Question is this guide the right one for my project?

github.com

emoncms/emoncms/blob/master/docs/RaspberryPi/readme.md

**To install emoncms on a Raspberry Pi see new installation script approach:<br>https://github.com/openenergymonitor/EmonScripts**

---

## Archived: Install Emoncms on Raspberry Pi (Raspbian Stretch)

This guide will install emoncms onto a Raspberry Pi running the Raspbian Stretch operating system.

**Highly Recommended: A pre-built Raspberry Pi SD card image is available with Emoncms pre-installed & optimised for low-write. [SD card image download & change log repository](https://github.com/openenergymonitor/emonpi/wiki/emonSD-pre-built-SD-card-Download-&-Change-Log).**

An alternative (older) installation guide is avaliable for [Raspbian Jessie](jessie.md) - they are different, so ensure that you use the correct guide!

Due to the number of writes that the full version of emoncms makes, the lifespan of an SD card will almost certainly be shortened, and it is therefore recommended that you eventually [move the operating system partition (root) to an USB HDD](USB_HDD.md) or to lower the write frequency to the SD card by enabling the [low-write mode.](Low-write-mode.md)
Before installing emoncms, it is essential you have a working version of Raspbian Stretch installed on your Raspberry Pi. If not, head over to [raspberrypi.org](https://www.raspberrypi.org/documentation/installation/installing-images/README.md) and follow their installation guide.

### Preparation

Start by updating the system repositories and packages:
```
sudo apt-get update && sudo apt-get upgrade

This file has been truncated. show original

Or schould i try another?

Michael

https://emoncms.org/dashboard/view?id=44470

borpin · 2021-01-24T09:02:11.705Z

Welcome.

mikelle:

Question is this guide the right one for my project?

Short answer, no.

As it says at the very top of the page

image717×158 11.6 KB

GitHub

GitHub - openenergymonitor/EmonScripts: Emoncms Stack Installation and Update...

Emoncms Stack Installation and Update scripts. Contribute to openenergymonitor/EmonScripts development by creating an account on GitHub.

mikelle · 2021-01-24T09:06:19.698Z

ok i will try

mikelle · 2021-01-24T10:05:47.700Z

I have installed the image from this site:

https://github.com/openenergymonitor/EmonScripts/blob/master/install/readme.md

the raspberry shows emonpi login:

Whats next: " Install the EmonCMS Installation Scripts" ?

grafik1352×831 68.1 KB

<

borpin · 2021-01-24T11:14:39.805Z

mikelle:

I have installed the image from this site:

If you have installed the image there is not much else to do.

Nothing to install - Emoncms is preinstalled.

mikelle · 2021-01-24T11:27:26.385Z

that sounds good. How can I access the localhost? Do I have to adjust settings? Is there a graphic interface?

mikelle · 2021-01-24T14:31:33.221Z

I tried to connect via browser “http://emonpi.local/” or IP adress and get the following message

Can’t connect to database, please verify credentials/configuration in settings.ini
Error message: Connection refused

/var/www/emoncms/settings.ini

emoncms_dir = "/opt/emoncms"
openenergymonitor_dir = "/opt/openenergymonitor"

[sql]
server = "192.168.0.175"
database = "emoncms"
username = "emoncms"
password = "emonpiemoncmsmysql2016"
; Skip database setup test - set to false once database has been setup.
dbtest   = true

[redis]
enabled = true
prefix = ''

[mqtt]
enabled = true
user = 'emonpi'
password = 'emonpimqtt2016'

[feed]
engines_hidden = [0,6,10]
redisbuffer[enabled] = true
redisbuffer[sleep] = 300
phpfina[datadir] = '/var/opt/emoncms/phpfina/'
phptimeseries[datadir] = '/var/opt/emoncms/phptimeseries/'

[interface]
enable_admin_ui = true
feedviewpath = "graph/"
favicon = "favicon_emonpi.png"

[log]
; Log Level: 1=INFO, 2=WARN, 3=ERROR
level = 2

borpin · 2021-01-24T16:45:36.637Z

mikelle:

[sql]
server = "192.168.0.175"

You appear to have changed this - have you setup the database on this host?

mikelle · 2021-01-24T16:51:58.963Z

yes i have changed that from 127.0.0.1 because my raspberrys ip is on 192.168.0.175.
mistake?

mikelle · 2021-01-24T19:07:47.771Z

How can i setup the database on this host ?

borpin · 2021-01-24T19:55:46.818Z

just leave it as the local host IP

mikelle · 2021-01-24T20:17:26.538Z

it works !!

Thank you