emoncms stops receiving data from oemgateway

My emoncms on Win7 does receive once the data from the oemgateway (Raspberry Pi) and then it stops receiving further data . See at the first attachment a screenshot where you can see the 6 nodes with ID 20. The values are correct so the oemgateway is sending the data. In the debug output of my oemgateway it says at the end "DEBUG Send ok". So the issue is not at the oemgateway side. The oemgateway.conf file contains this config:

[[emoncms_local]]
    type = OemGatewayEmoncmsBuffer
    [[[init_settings]]]
    [[[runtime_settings]]]
        domain = localhost
        apikey = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
        protocol = http://
        active = False
        path = /emoncms

[[emoncms_remote]]
    type = OemGatewayEmoncmsBuffer
    [[[init_settings]]]
    [[[runtime_settings]]]
        domain = 192.168.76.100
        apikey = 7f7caf34201f6784d0f1bdaxxxxxxxxxxxxxx
        protocol = http://
        active = True
        path = /emoncms

The apikey is correct.

On the emoncms server the settings.php I changed the following:

   $username = "my user name";
    $password = "my password";
    $server   = "localhost";
    $database = "emoncms";

         'phpfiwa'=>array(
            'datadir'=>"C:\\Benutzer\\brisco\\emoncmsdata\\phpfiwa\\"
        ),
        'phpfina'=>array(
            'datadir'=>"C:\\Benutzer\\brisco\\emoncmsdata\\phpfina\\"
        ),
        'phptimeseries'=>array(
          'datadir'=>"C:\\Benutzer\\brisco\\emoncmsdata\\phptimeseries\\"

So what is wrong here? Can you help?

pb66's picture

Re: emoncms stops receiving data from oemgateway

You could  following the steps at the end of this page in Troubleshooting to see what is being sent by oem gateway and on the windows pc find your apache " access.log " to see what has been received. from that info you should be able to determine where the issue could be.

Paul

brisco's picture

Re: emoncms stops receiving data from oemgateway

Thanks Paul. I checked out the troubleshooting link and the gateway works well. I used oemgateway before with emoncms.org without problems. I just modified the oemgateway.config as described above. 

I found the access.log file on the server and the last entries are like this -see below. Unfortunately I'm not so experienced to see any information who can help me to figure out what's wrong.   

(I have marked out the API Key)

 

192.168.75.133 - - [16/May/2014:19:48:29 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:10,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:9,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:8,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:7,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:6,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:5,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:4,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:3,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:2,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:1,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:33 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:87,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:48:33 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:48:39 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:40 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:89,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:48:43 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:47 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:33,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:48:49 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.108 - - [16/May/2014:19:48:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:55 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:138,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:48:59 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:03 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:30,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:03 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:49:08 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:49:11 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:212,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:13 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:18 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:19 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:24,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:23 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:49:27 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:198,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:29 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.108 - - [16/May/2014:19:49:33 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:35 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:163,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:39 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:43 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:169,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:43 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:45 +0200] "GET /emoncms/feed/list HTTP/1.1" 200 14826
192.168.75.114 - - [16/May/2014:19:49:45 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:48 +0200] "GET /emoncms/feed/updatesize.json HTTP/1.1" 200 1
192.168.75.114 - - [16/May/2014:19:49:48 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:50 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:49:51 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:160,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/node HTTP/1.1" 200 6129
192.168.75.108 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:59 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:105,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:50:03 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:50:05 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:50:06 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:32,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:50:13 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:50:14 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:50:14 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:82,6:231} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:50:22 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:107,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:50:23 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:50:24 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:50:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:183,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:50:33 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:50:34 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:50:38 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:67,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:50:43 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:50:44 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:50:46 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:49,6:231} HTTP/1.1" 200 2

It seems that the data is received by the server. In myphpadmin it shows no data in the database.

Any hint?

brisco's picture

Re: emoncms stops receiving data from oemgateway

Thanks Paul. I checked out the troubleshooting link and the gateway works well. I used oemgateway before with emoncms.org without problems. I just modified the oemgateway.config as described above.

I found the access.log file on the server and the last entries are like this -see below. Unfortunately I'm not so experienced to see any information who can help me to figure out what's wrong.  

(I have marked out the API Key)

 

192.168.75.133 - - [16/May/2014:19:48:29 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:10,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:9,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:8,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:30 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:7,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:6,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:5,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:31 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:4,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:3,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:2,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:1,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:32 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:0,6:0} HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:48:33 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:87,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:48:33 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:48:39 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:40 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:89,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:48:43 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:47 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:33,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:48:49 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.108 - - [16/May/2014:19:48:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:48:55 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:138,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:48:59 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:03 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:30,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:03 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.114 - - [16/May/2014:19:49:08 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:49:11 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:212,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:13 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:18 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:19 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:24,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:23 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 744
192.168.75.133 - - [16/May/2014:19:49:27 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:198,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:29 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.108 - - [16/May/2014:19:49:33 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:35 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:163,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:39 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.133 - - [16/May/2014:19:49:43 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:169,6:231} HTTP/1.1" 200 2
192.168.75.108 - - [16/May/2014:19:49:43 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:45 +0200] "GET /emoncms/feed/list HTTP/1.1" 200 14826
192.168.75.114 - - [16/May/2014:19:49:45 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:48 +0200] "GET /emoncms/feed/updatesize.json HTTP/1.1" 200 1
192.168.75.114 - - [16/May/2014:19:49:48 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:50 +0200] "GET /emoncms/feed/list.json HTTP/1.1" 200 2
192.168.75.133 - - [16/May/2014:19:49:51 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:160,6:231} HTTP/1.1" 200 2
192.168.75.114 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/node HTTP/1.1" 200 6129
192.168.75.108 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745
192.168.75.114 - - [16/May/2014:19:49:53 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 745

brisco's picture

Re: emoncms stops receiving data from oemgateway

Thanks Paul. In the access.log file on the windows PC I see the following entries:

oemgateway has IP 102.168.75.133. So it seems that emoncms is receiving datas from the oemgateway.

192.168.75.114 - - [17/May/2014:10:29:48 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 1176
192.168.75.114 - - [17/May/2014:10:29:48 +0200] "GET /emoncms/Lib/bootstrap/img/glyphicons-halflings.png HTTP/1.1" 304 -
192.168.75.133 - - [17/May/2014:10:29:55 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:208,6:196} HTTP/1.1" 200 2
192.168.75.114 - - [17/May/2014:10:29:58 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 1177
192.168.75.133 - - [17/May/2014:10:30:03 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:130,6:196} HTTP/1.1" 200 2
192.168.75.114 - - [17/May/2014:10:30:08 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 1177
192.168.75.133 - - [17/May/2014:10:30:10 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:152,6:197} HTTP/1.1" 200 2
192.168.75.114 - - [17/May/2014:10:30:18 +0200] "GET /emoncms/input/list.json HTTP/1.1" 200 1177
192.168.75.133 - - [17/May/2014:10:30:18 +0200] "GET /emoncms/input/post.json?apikey=7f7caf3xxxxxxxxxxxxxxxxxxxxxxxxxxx&node=20&json={1:0,2:0,3:0,4:0,5:61,6:197} HTTP/1.1" 200 2

 

Strange is when I send some json test messages over the browser to the emoncms Windwos server the time "last updated" right after sending the string is 96seconds. But right after sending the time should be just a few seconds.

I have looked into the database itself over myphpadmin. see attachment. There are just 11 records. but no more.

 

I have switched off the windows firewall as well.

 

Any hints?

thanks

brisco's picture

Re: emoncms stops receiving data from oemgateway

addition: in emoncms input view the last update counter starts at 93 seconds, goes up to 100 and then begins again from 93. The values sill are the same!

Can anybode help??

brisco's picture

Re: emoncms stops receiving data from oemgateway

I just add a screenshot of emoncms. it seems that emoncms does not have got the right data format???

 

pb66's picture

Re: emoncms stops receiving data from oemgateway

The screen dump of SQL shows 11 inputs from 4 node ids not individual records, so from the top

node 20    input 4     value 0

node 20    input 3     value 0

etc

so you have   ( node 20 inputs 1 to 6 ) ( node 17 inputs 1 & 2 ) (node 19 inputs 1 & 2 ) and ( node 0 input 'power' ),

addition: in emoncms input view the last update counter starts at 93 seconds, goes up to 100 and then begins again from 93. The values sill are the same!

The 93 seconds is probably a time difference between the pi and the pc. the fact it counts to 100 each time tells us its being updated every 7 seconds. looking at the submitted data strings, node 20 inputs 1 to 4 are all zero, only 5 and 6 are receiving data and the fluctuation is quite small.

the initial screen dump shows different values to the sql and access.logs so some change should be seen on 5&6

run  sudo ntpd on the pi to correct time and check your pc's clock, then try again but try to create a change in the data eg warm the temp sensor up (if accessible and safe to do so)

I'm not quite sure what you are saying in your last post, the screen dump shows a blank process list for the " temp " input, you need to create feeds to record your data see  http://emoncms.org/site/docs/inputsandfeeds the screenshots are of previous versions but the concept is the same.

 

 

brisco's picture

Re: emoncms stops receiving data from oemgateway

thanks pb66. But it doesn't help. When I want to set up a process list for the input "random" emoncms says that "Error: Feed could not be created, undefined". see screenshot.

 

pb66's picture

Re: emoncms stops receiving data from oemgateway

Ok. but the suggestions were in fact intended to help resolve the issues of a 93-100 sec time difference and the inputs not updating. did you make any progress with those points? has the time interval changed? are the inputs updating now ?

I ask to determine if it may be related to the next issue...

With regard to the "Error: Feed could not be created, undefined" a quick forum search on the phrase "Error: Feed could not be created, undefined" shows this has been seen and resolved before. It usually (but not always)  relates to the feed engine directories and is more common on windows installations. there are several suggestions within these threads but as I am not familiar with using a windows server I cannot recommend any in particular.

 

brisco's picture

Re: emoncms stops receiving data from oemgateway

Thanks a lot for your help! I figured out the problem.

1. time synch on emoncms server and oemgateway helped to have now the data updated in a correct way

2. I had to change within settings.php the path entries as follows:

         'datadir'=>"C:/emoncmsdata/phpfiwa/"
        ),
        'phpfina'=>array(
            'datadir'=>"C:/emoncmsdata/phpfina/"
        ),
        'phptimeseries'=>array(
            'datadir'=>"C:/emoncmsdata/phptimeseries/"
        )

previously I had a too many sub directories. 

Now its working! many thanks for help!!

Comment viewing options

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