Hi All,
I want to give emoncms a try and publish the results on my own homepage. I didn't find a documentation on how to make all this work on a web site.
I have a Joomla! CMS, so i created a emoncms folder in which i copied all files.
I have a database that has many Joomla! tables and i don't want to make any mess in it...
Any risk if i setup in the default.settings to make a connection to my existing database ? What tables are been created by emoncms ?
Will all this work ?
Thanks for any help,
Patrick.
Re: Installing emoncms on a webserver
Hi Patrick,
The docs for installing emoncms on a shared Linux host are at:
https://github.com/emoncms/emoncms/blob/master/docs/SharedLinuxHostingInstall.md
The safest thing would be installing emoncms with its own database. (If your web host allows more than one MySQL database)
Emoncms v8.5 creates the following tables:
dashboard
feeds
input
multigraph
myelectric
node
rememberme
schedule
users
Regards,
Bill
Re: Installing emoncms on a webserver
Hello Bill,
I think i managed this ! I indeed have build a new database (200Mb) and could setup the settings.php file.
I also created the data folders and modified the settings accordingly.
I could login after creating a new account.
I'm now trying to create some test sources/feeds....
Thanks !
Patrick.
Re: Installing emoncms on a webserver
BTW,
Before i continue, i need to know if emoncms will suit my needs... ;-)
I want to develop a beehive monitoring system around an Arduino. The goal is to measure :
- local air temperature (°C)
- local atmospheric pressure (hPa)
- local air humidity (%)
- battery voltage (V)
Than, a certain number of beehives will report their:
- weight (kg)
- hive temperature (°C)
All this on a 1 hour cycle. Datas should be saved a few months at least.
Is emoncms, installed on my shared server, an answer to my specs ?
Thanks for any advice.
Patrick
Re: Installing emoncms on a webserver
Hi Patrick,
Someone else is doing something similar with beehives and emonCMS - check out this site:
http://beemonitor.org
Re: Installing emoncms on a webserver
That "Someone else" is none other than our own OEM'er Glyn (Glyn.Hudson)
http://openenergymonitor.org/emon/beemonitor
http://openenergymonitor.org/emon/beehive/v2
http://openenergymonitor.org/emon/search/node/bee%20hive
Paul
Re: Installing emoncms on a webserver
Haha, I didn't notice the name! A "small world" moment for sure.
Re: Installing emoncms on a webserver
HI,
Thanks for the links !
My question was not precise enough... Can i monitor other units than those programmed in emoncms ?
For example hPa, %,kg etc...And how far back can i keep datas ? Years ?
Thanks,
Re: Installing emoncms on a webserver
If you are willing to write or copy and paste some code, yes you can use any sensors. It would be easiest to use sensors supported by the Arduino community, since the OEM hardware is based on the same architecture and example software (called sketches in Arduino-speak) can be found in places like Github.
I made some pressure sensors for a drip irrigation system using modified OEM EmonTX code and Honeywell HSC pressure sensors. I found example code for the HSC sensor on Github, and mashed the two together to make this:
Sketch shared here:
https://github.com/peakmonitor/Moteino_to_emoncms
Dashboard made with emonCMS can be viewed here:
http://data.peakmonitor.com/proto2&id=14
I'm sure you can find a load cell or digital scale that has been interfaced with an Arduino somewhere, and start from that point to post the data to emonCMS.
Re: Installing emoncms on a webserver
Patrick,
good news to hear, someone is installing Emoncms 8.5 to linux based shared webhosting, as I am. Let me know then (after installation) please, whether ot not are you able to create dashboards in your new installation. Im fighting with this issue already a few days with no success till now. I asked in this forum for help and also nobody knows, what can be the wrong.
Radek
Re: Installing emoncms on a webserver
Hi Radek,
I did not work further on my Emoncms install.. Everything seems OK, but i didn't create any source and flux..
Being not sure if can create new units, store for years, etc...
I have made some tests with the DYGRAPHS library, and i had good results so far.
It doesn't look so sexy as Emoncms, no dashbord, etc... but it is fully customizable and i have full control on everything ...
I wish you good success !
Patrick.
Re: Installing emoncms on a webserver
My more than year long experience with older version of EMONCMS is very good. You can add any units (temp, pressure, relative humidity, flow, electricity consumption... simply any unit you can transform into numerical value. EMONCMS is great as a central data storage with a great flexibility. What is slightly limited is ability to present measured data via dashboards (limited amount of presentation elements). But you can create presentation layer at another webserver and using emoncms as a great data source as it is equipped by a great tool for data providing to third parties. I think, great scenario would be to combine emoncms in role of "datawarehouse " with some other presentation tools. I have to check that your DYGRAPHS library as it look nice at first sight. We can share our experience later.
Radek
Re: Installing emoncms on a webserver
OK Radek,
I will try to find out how it works !
Meanwhile, i "played" a bit with Dygraphs and another library "Flexgauge".
Not bad for the time it took me to understand how all this works ! I made a small database and have build an array to feed the Dygraphs and gauges.
Have a look here if any interest. It's a first try..
Cheers,
Patrick
Re: Installing emoncms on a webserver
Looks very nice for a first try, Patrick. You can compare it with standard output of emoncms via its dashboard at my heatpump monitoring here:
http://cenzdra.cz/emoncms/Radek/demo
This is that older version, which works fine and Im currently working on to move it to another hosting with last version of emoncms.
Radek