[Solved]Input Time & Value, Feed data not being stored in Mysql on Local Raspberry Pi

G'day,

I have a Raspberry Pi B+ running a local emoncms with Only a GLCD connect to it at the moment with the Solar PV sample sketch loaded so i could test the RFM12Pi with the Temperature sensor on the GLCD.

The RFM12Pi is working fine, the Input appeared in the local emoncms once both units were turned on and updates every 20's or so with the same temp as shown on the screen (- decimal point).

I setup a process from the input tab with the following option:

Log to Feed  |  Create New:  |  GLCD Temp  |  Fixed Interval No Average (PHPFINA)  |  10 Mins

I check the feed tab and the feed was there as expected.

How every i notice that the size stays at 0.0kb

 

So i took a look in mysql and found the the updates don't appear to be logged.

1. Null entries in the time and value fields in the Input table

2. No feed_1 table created

3. Null entries in the time, value and size fields in the feeds table

Below are the sql tables from the raspberry pi.

 

mysql> show tables;
+-----------------------------+
| Tables_in_emoncms
+-----------------------------+
| applist                           
| dashboard                   
| feeds                            
| input            
| multigraph       
| myelectric       
| raspberrypi      
| rememberme       
| report           
| users            
+-----------------------------+

mysql> SELECT * FROM input;
+----+---------+---------+-----------------+----------+-----------------+--------+---------+
| id   | userid | name | description   | nodeid | processList | time   | value   |
+----+---------+---------+-----------------+----------+-----------------+--------+---------+
|  1   |      1     | 1         | GLCD Temp |     20     | 1:1                 | NULL |  NULL |
+----+---------+---------+-----------------+----------+-----------------+--------+---------+

mysql> select * from feeds;
+----+--------------+----------+------------+---------+---------+------------+---------+--------+----------+
| id   | name         | userid | tag           | time    | value   | datatype | public | size    | engine |
+----+--------------+----------+------------+---------+---------+------------+---------+--------+----------+
|  1   | node:20:1 |      1      | Node:20 | NULL |  NULL |        1       |      0     | NULL |      5      |
+----+--------------+----------+------------+---------+---------+------------+---------+--------+----------+

 

If someone could point me in the write direction to fix this that would be great...

Thanks

Andy

Paul Reed's picture

Re: [Solved]Input Time & Value, Feed data not being stored in Mysql on Local Raspberry Pi

Hi Andy

Only the data framework is stored in MYSQL, ie the things that do not readily change, whilst the actual feed data is contained in folders. Try looking at;

/var/lib/phpfiwa
/var/lib/phpfina
/var/lib/phptimeseries
/var/lib/timestore

In relation to the database size not increasing, it will take some time before the database reaches a size worth displaying, and as you are only updating it every 10 minutes, it may take a while! (I take it that you have refreshed the feed size via the refresh button).

Paul

ewiandr's picture

Re: [Solved]Input Time & Value, Feed data not being stored in Mysql on Local Raspberry Pi

That explains why there's nothing in the sql :)

I can now see where it's hiding...

pi@raspberrypi ~ $ ls -l data/phpfina/
total 2
-rw-r--r-- 1 www-data www-data 288 Sep  2 21:20 1.dat
-rw-r--r-- 1 www-data www-data   16 Sep  2 09:35 1.meta

The size is still saying 0.0kb, but i guess the size is really small.

Looks like my feeds are working correctly.

Thanks for the help

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.