EMONCMS: Timestore and MySQL

Submitted by lobolobo on Wed, 27/11/2013 - 07:25

Hello everybody.

Here is my case:

One RasPI as emonbase taking data from emontx. My RasPI use Timestore, so realtime feeds are timestore. One feed is kwhd (daily type) so it is MySQL.

Forward data to remote emoncms server (Raspberry PI tab in emoncms instance in the PI) The remote server have one Emoncms instance in a Windows XP machine with a Wamp web server, so in this case, all feeds are MySQL.

My question: can i forward the data in the RasPi to my remote Windows machine (despite having in Windows machine only MySQL engine and not Timestore as database engine)?

Thanks in advance for your responses ...

Re: EMONCMS: Timestore and MySQL

Submitted by Paul Reed on Wed, 27/11/2013 - 10:00.

Yes you can, and if you want to use MySQL only on your remote Windows installation, then edit the settings.php file to show;

$default_engine = Engine::MYSQL;

Of course, there is no reason why you can't use Timestore too if you wish. As it would increase performance and reduce storage.

Paul

Re: EMONCMS: Timestore and MySQL

Submitted by lobolobo on Wed, 27/11/2013 - 10:11.

Thank you very much for your response Paul.

Timestore run in windows?

Regards.

Re: EMONCMS: Timestore and MySQL

Submitted by lobolobo on Wed, 27/11/2013 - 12:09.

I can´t see the same database estructure of the PI in the Windows instance. I mean, in the RasPi there are two database engines combinated, MySQL and Timestore but in the remote server, there is only one databes engine, MySQL.

So, how can de RasPi instance forward the data to the remote server (Windows) instance database (MySQL)?

The idea is to replicate the RasPi data in the remote server.

Regards.

Re: EMONCMS: Timestore and MySQL

Submitted by dariomar79 (not verified) on Fri, 22/08/2014 - 15:40.

Hi Paul,

I'm new in EmonCMS, so I could have done some mistakes, but I can't tell to EMONCMS to store feeds data in MySql DB.

I would like to store feeds data on database, in order to do some further queries.

I have just put the string

$default_engine = Engine::MYSQL;

in settings.php file and restarted Apache, but I still see that the actual engine is PHPFINA (I see it from Feeds web page).

Do you think that I should do some other steps?

I'm using version 8, installed following this instruction:

http://emoncms.org/site/docs/installlinux

Thank you,

Dario

[Edit: Duplicate post deleted - Moderator]

Archived Forum