Project

General

Profile

Support #474

Upload measuring data via Pachube - Xively Not working Anymore

Added by hschenkelaars almost 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
DomotiGaServer3
Target version:
Start date:
08/27/2014
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

Hi,

I'm using Pachube / Xively to publish some data but it isn't working anymore ?
I checked my API key and everything seems to be O.K. I send an E-mail to the support desk of Xively but did not receive a reply jet. I want to investigate this problem at the Domotiga side so have you any idea what I can do or check to get this problem solved ?

My Debug Output of the Pachube Module :

2014/08/27 17:09:49 [Pachube] <?xml version='1.0' encoding='UTF-8'?>
<eeml xmlns='http://www.eeml.org/xsd/005' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.eeml.org/xsd/005 http://www.eeml.org/xsd/005/005.xsd'>
<environment>
<data id='110'>
<tag>Server</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='111'>
<tag>Monitor - Server</tag>
<value>73.1</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='142'>
<tag>Martijn</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='143'>
<tag>Desiree</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='160'>
<tag>CP Ketel</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='161'>
<tag>CP Serre</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='132'>
<tag>Droger</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='133'>
<tag>Wasmachine</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='106'>
<tag>Domotiga Server</tag>
<value>20.2</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='130'>
<tag>IJskast</tag>
<value>0.3</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='131'>
<tag>Diepvries</tag>
<value>81.3</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='134'>
<tag>Magnetron</tag>
<value>1.8</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='162'>
<tag>CV Ketel</tag>
<value>5.4</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='104'>
<tag>Gas verbruik</tag>
<value>3874.348</value>
<unit symbol='m3' type='basicSI'></unit>
</data>
<data id='105'>
<tag>Monitor - Domotiga</tag>
<value>0.6</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='135'>
<tag>Vaatwasser</tag>
<value>0.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='152'>
<tag>Buiten</tag>
<value>31.50</value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='153'>
<tag>Vijverwater</tag>
<value>16.44</value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='151'>
<tag>Woonkamer</tag>
<value>20.19</value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='150'>
<tag>Aanvoer</tag>
<value>19.62</value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='108'>
<tag>Firewall</tag>
<value>15.8</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='107'>
<tag>Synology 1812+</tag>
<value>59.1</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='115'>
<tag>Game PC</tag>
<value>137.0</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='101'>
<tag>Huidig verbruik</tag>
<value>1310</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='102'>
<tag>Verbruik - Normaal</tag>
<value>6307</value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='103'>
<tag>Verbruik - Laag</tag>
<value>6998</value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='170'>
<tag>Server Room - Totaal</tag>
<value>253.6</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='171'>
<tag>Meterkast - Totaal</tag>
<value>124.6</value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='163'>
<tag>Open Therm Burner</tag>
<value>On</value>
<unit symbol='Level' type='derivedunits'></unit>
</data>
</environment>
</eeml>

2014/08/27 17:09:50 [Pachube] Sensor data post error.

My Current Screen Output from the Xively Site :

Url : https://api.xively.com/v2/feeds/78521

History

#1 Updated by Alexie almost 5 years ago

  • Status changed from New to Feedback

The error message is too cryptic ... I added some more debugging in your error situation, can you try the BETA branch?

#2 Updated by hschenkelaars almost 5 years ago

Hi I installed the beta and run it from gambas3 in debug mode. Everything starts but I get the following error message

[Pachube] ERROR: Peer Failed Verification (-1051).

Thats a bit strange because I use the same Feed ID and API key I use for more then a year. I filled in the ID and Key again but that makes no difference.

My Pachube/Xively Settings in DomotiGa

My Feed ID

My API Key

I also made a wireshark trace but did not see any problem regarding the TCP-IP communication.
I only get a "FIN, ACK" from my DomotiGa system killing the session from it to Xively.

10.8.4.19    64.94.18.122    TCP    66    39138 > https [FIN, ACK] Seq=723 Ack=4041 Win=37888 Len=0 TSval=2546177 TSecr=692977211

Do you have a suggestion ?

#3 Updated by hschenkelaars almost 5 years ago

Hi,

Any update on this ?

Thx :)

#4 Updated by rdnzl almost 5 years ago

It seems they dropped support for legacy feed format (pachube), they support a v2 now, I will change the code soon...

#5 Updated by hschenkelaars almost 5 years ago

Thx for the response and it's great you will change the code.
I'm using this for over a year now and am very happy with it.
If you need any testing or additional info please let me know.

Greetz Hans

#6 Updated by rdnzl almost 5 years ago

Hans, I have good news and bad news ;-)
The good news is that the Pachube module is now fixed and can push data again to Xively.
The bad news it that you need to patch your Gambas 3.5.4 install or switch running trunk/beta version of Gambas.
Older versions may work, 3.5.4 has a bug in httpclient.put which new module/api needs, you can find the line to change here
http://sourceforge.net/p/gambas/code/6423
If you are handy you can just replace that first line starting with http_send, and run 'make && sudo make install' in directory gb.net.curl.

My fixes are in beta branch, (CPachube.class) but you can also copy it over to your DomotiGa3/.src DomotiGaServer3/.src dirs and run tools/compile.sh

You can use your Xively master key, or feed key, StreamId are now called Channels, unfortunately the db field used is only 8 chars long.
Let me know if you get it working...btw I would generate new ones, since you posted them above...

#7 Updated by hschenkelaars almost 5 years ago

Hi,

That's quick :)

I will try this and will send you an update soon..

#8 Updated by hschenkelaars almost 5 years ago

Hi I've done the first part, updating my Gambas 3.5.4 by changing the
"CHttpClient.c" file and I issued the command "sudo make install" in the directory gb.net.curl.

This was the outcome of the sudo make install action :

domotiga@HCC-DomotiGa:~/install/gambas3-3.5.4/gb.net.curl$ sudo make install
sudo: /etc/sudoers.d is world writable
Making install in src
make[1]: Entering directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
  CC       gb_net_curl_la-gbcurl.lo
  CC       gb_net_curl_la-main.lo
  CC       gb_net_curl_la-CCurl.lo
  CC       gb_net_curl_la-CHttpClient.lo
  CC       gb_net_curl_la-CFtpClient.lo
  CC       gb_net_curl_la-CNet.lo
  CC       gb_net_curl_la-CProxy.lo
  CCLD     gb.net.curl.la
make[2]: Entering directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
make[2]: Nothing to be done for `install-exec-am'.
 /bin/mkdir -p '/usr/lib/gambas3'
 /usr/bin/install -c -m 644 gb.net.curl.component '/usr/lib/gambas3'
 /bin/mkdir -p '/usr/lib/gambas3'
 /usr/bin/install -c -m 644 gb.net.curl.component '/usr/lib/gambas3'
 /bin/mkdir -p '/usr/lib/gambas3'
 /bin/bash ../libtool   --mode=install /usr/bin/install -c   gb.net.curl.la '/usr/lib/gambas3'
libtool: install: /usr/bin/install -c .libs/gb.net.curl.so.0.0.0 /usr/lib/gambas3/gb.net.curl.so.0.0.0
libtool: install: (cd /usr/lib/gambas3 && { ln -s -f gb.net.curl.so.0.0.0 gb.net.curl.so.0 || { rm -f gb.net.curl.so.0 && ln -s gb.net.curl.so.0.0.0 gb.net.curl.so.0; }; })
libtool: install: (cd /usr/lib/gambas3 && { ln -s -f gb.net.curl.so.0.0.0 gb.net.curl.so || { rm -f gb.net.curl.so && ln -s gb.net.curl.so.0.0.0 gb.net.curl.so; }; })
libtool: install: /usr/bin/install -c .libs/gb.net.curl.lai /usr/lib/gambas3/gb.net.curl.la
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin" ldconfig -n /usr/lib/gambas3
----------------------------------------------------------------------
Libraries have been installed in:
   /usr/lib/gambas3

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the `LD_RUN_PATH' environment variable
     during linking
   - use the `-Wl,-rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
make  install-data-hook
make[3]: Entering directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
Installing the gb.net.curl control icons if needed...
Creating the information files for gb.net.curl component...

make[3]: Leaving directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
make[2]: Leaving directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
make[1]: Leaving directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl/src'
make[1]: Entering directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl'
make[2]: Entering directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl'
make[1]: Leaving directory `/home/domotiga/install/gambas3-3.5.4/gb.net.curl'
domotiga@HCC-DomotiGa:~/install/gambas3-3.5.4/gb.net.curl$.

Second step was downloading the new CPachube.class from the beta branch and copying this to the DomotiGa3/.src DomotiGaServer3/.src dirs.

I only do not understand your last remark "run tools/compile.sh" ??

I tried to run Gambas 3 and tried to run DomotiGa from the debug mode but that didn't work...

Can you explain you last remark ??

Thx in advance.

#9 Updated by rdnzl almost 5 years ago

From directory ~/domotiga do tools/compile.sh

This will compile domotiga3.gambas and domotigaserver3.gambas

Please post debug log output after this.

#10 Updated by hschenkelaars almost 5 years ago

I've done the last step;

domotiga@HCC-DomotiGa:~/domotiga$ tools/compile.sh
OK
-rwxrwxr-x 1 domotiga domotiga 1626030 sep  7 18:31 DomotiGaServer3.gambas
OK
-rwxrwxr-x 1 domotiga domotiga 4212201 sep  7 18:31 DomotiGa3.gambas
domotiga@HCC-DomotiGa:~/domotiga$

And when I run My DomotiGa in debug mode I get this error.

DomotiGa will not start so I cannot provide you some debug logging from DomotiGa or do you mean some other debug logging ?

Any idea ?

#11 Updated by rdnzl almost 5 years ago

You have copied/downloaded the CPachube.class file with the github html code included, that's no gambas.
Do this...

cd ~/domotiga/DomotiGa3/.src/
wget https://raw.githubusercontent.com/DomotiGa/DomotiGa/beta/DomotiGa3/.src/CPachube.class

cp CPachube.class ../../DomotiGaServer3/.src
cd ~/domotiga
tools/compile.sh

#12 Updated by hschenkelaars almost 5 years ago

Hmm. it seems i've several gambas3 directorys. I'm cleaning up now and will try again..

Got the error

domotiga@HCC-DomotiGa:~/domotiga$ tools/compile.sh
CPachube.class:104:6: error: Unknown operator
-rwxrwxr-x 1 domotiga domotiga 552532 sep  7 19:11 DomotiGaServer3.gambas
CPachube.class:104:6: error: Unknown operator
-rwxrwxr-x 1 domotiga domotiga 1198749 sep  7 19:11 DomotiGa3.gambas
domotiga@HCC-DomotiGa:~/domotiga$

Might have to do with the wrong directory....

#13 Updated by hschenkelaars almost 5 years ago

Hi Cleaned everything up to one directory and tried the last steps but get the same error..

domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$ wget https://raw.githubusercontent.com/DomotiGa/DomotiGa/beta/DomotiGa3/.src/CPachube.class
--2014-09-07 19:37:12--  https://raw.githubusercontent.com/DomotiGa/DomotiGa/beta/DomotiGa3/.src/CPachube.class
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.31.18.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.31.18.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 7179 (7,0K) [text/plain]
Saving to: âCPachube.class.1â

100%[=========================================================================>] 7.179       --.-K/s   in 0s

2014-09-07 19:37:13 (35,3 MB/s) - âCPachube.class.1â saved [7179/7179]

domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$ cp CPachube.class ../../DomotiGaServer3/.src
cp: cannot create regular file â../../DomotiGaServer3/.src/CPachube.classâ: Permission denied
domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$ sudo cp CPachube.class ../../DomotiGaServer3/.src
sudo: /etc/sudoers.d is world writable
[sudo] password for domotiga:
domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$
domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$
domotiga@HCC-DomotiGa:~/domotiga/DomotiGa3/.src$ cd ~/domotiga
domotiga@HCC-DomotiGa:~/domotiga$
domotiga@HCC-DomotiGa:~/domotiga$
domotiga@HCC-DomotiGa:~/domotiga$
domotiga@HCC-DomotiGa:~/domotiga$ tools/compile.sh
CPachube.class:104:6: error: Unknown operator
-rwxrwxr-x 1 domotiga domotiga 552532 sep  7 19:37 DomotiGaServer3.gambas
CPachube.class:104:6: error: Unknown operator
-rwxrwxr-x 1 domotiga domotiga 1198749 sep  7 19:37 DomotiGa3.gambas
domotiga@HCC-DomotiGa:~/domotiga$

I think Gambas3 is patched but why does the last step fail.. ??

#14 Updated by hschenkelaars almost 5 years ago

It seems I need to restore my system from an Image. I will try later this week. I need to study for an important F5 Exam, so not extra time ....:)

Do you think this fix will be available in the new 10.0.017 rel ?
And when do you expect that 10.0.017 will be available as the next general release ?

Maybe I'll wait a bit... Probably not.. ;)

#15 Updated by rdnzl over 4 years ago

I just release version 1.0.017 in master branch, please test it and report back so we can close this ticket.

#16 Updated by hschenkelaars over 4 years ago

Hi,

I've Upgraded to rel 10.0.017 but the data push to pachube/Xively, sadly, still doesn't work, See the output below.
Any Idea what to do next ?

2014/10/25 17:07:57 [Pachube] Posting data to feed url 'https://api.xively.com/v2/feeds/78521.xml'.
2014/10/25 17:07:57 [Pachube] Using header "X-ApiKey: bNxn46zLk4bffhSSdPXsrD5pK1GSzlpJa7SsOXFMYXo4ek4rVGc9".
2014/10/25 17:07:57 [Pachube] <?xml version='1.0' encoding='UTF-8'?>
<eeml>
<environment>
<data id='110'>
<tag>Server</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='111'>
<tag>Monitor - Server</tag>
<current_value>73.7</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='142'>
<tag>Martijn</tag>
<current_value>6.9</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='143'>
<tag>Desiree</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='160'>
<tag>CP Ketel</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='161'>
<tag>CP Serre</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='132'>
<tag>Droger</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='133'>
<tag>Wasmachine</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='106'>
<tag>Domotiga Server</tag>
<current_value>18.9</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='130'>
<tag>IJskast</tag>
<current_value>38.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='131'>
<tag>Diepvries</tag>
<current_value>0.7</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='134'>
<tag>Magnetron</tag>
<current_value>1.8</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='162'>
<tag>CV Ketel</tag>
<current_value>54.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='104'>
<tag>Gas verbruik</tag>
<current_value>3954.337</current_value>
<unit symbol='m3' type='basicSI'></unit>
</data>
<data id='105'>
<tag>Monitor - Domotiga</tag>
<current_value>0.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='135'>
<tag>Vaatwasser</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='152'>
<tag>Buiten</tag>
<current_value>14.00</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='153'>
<tag>Vijverwater</tag>
<current_value>13.12</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='151'>
<tag>Woonkamer</tag>
<current_value>19.75</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='150'>
<tag>Aanvoer</tag>
<current_value>33.75</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='108'>
<tag>Firewall</tag>
<current_value>13.8</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='107'>
<tag>Synology 1812+</tag>
<current_value>59.3</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='115'>
<tag>Game PC</tag>
<current_value>131.8</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='101'>
<tag>Huidig verbruik</tag>
<current_value>1070</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='102'>
<tag>Verbruik - Normaal</tag>
<current_value>6924</current_value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='103'>
<tag>Verbruik - Laag</tag>
<current_value>7607</current_value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='170'>
<tag>Server Room - Totaal</tag>
<current_value>256.4</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='171'>
<tag>Meterkast - Totaal</tag>
<current_value>121.1</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='163'>
<tag>Open Therm Burner</tag>
<current_value>On</current_value>
<unit symbol='Level' type='derivedunits'></unit>
</data>
<data id='144'>
<tag>Badkamer</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
</environment>
</eeml>

2014/10/25 17:07:59 [Pachube] HTTP/1.1 400 Bad Request
2014/10/25 17:07:59 [Pachube] Date: Sat, 25 Oct 2014 15:07:59 GMT
2014/10/25 17:07:59 [Pachube] Content-Type: application/xml; charset=utf-8
2014/10/25 17:07:59 [Pachube] Content-Length: 118
2014/10/25 17:07:59 [Pachube] Connection: keep-alive
2014/10/25 17:07:59 [Pachube] X-Request-Id: b66bd28f10866c35e253c67da89ac30a0b44c15a

#17 Updated by rdnzl over 4 years ago

I forgot, you have to upgrade your Gambas also to the new version 3.6.0.
It has the http.put method fixed which is needed for Xively and Philip Hue.
You then run from domotiga directory tools/compile.sh to recompile your DomotiGa*.gambas executable.

#18 Updated by rdnzl over 4 years ago

Could also be something else... will test myself too.. but upgrading gambas doesn't hurt :)

#19 Updated by hschenkelaars over 4 years ago

I'm upgrading Gambas to the latest trunk release now....

#20 Updated by hschenkelaars over 4 years ago

I finisched upgrading Gambas to 3.6.90 and compiled a new executable. This works fine. I also see that the pachube module is puching data to xively. When I check xively I receive a "PUT" but get an error on my first device 110 "error : Unknown symbol".

received info Picture and captured content.

<?xml version='1.0' encoding='UTF-8'?>
<eeml>
<environment>
<data id='110'>
<tag>Server</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='111'>
<tag>Monitor - Server</tag>
<current_value>74.4</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='142'>
<tag>Martijn</tag>
<current_value>9.5</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='143'>
<tag>Desiree</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='160'>
<tag>CP Ketel</tag>
<current_value>35.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='161'>
<tag>CP Serre</tag>
<current_value>40.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='132'>
<tag>Droger</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='133'>
<tag>Wasmachine</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='106'>
<tag>Domotiga Server</tag>
<current_value>19.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='130'>
<tag>IJskast</tag>
<current_value>38.4</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='131'>
<tag>Diepvries</tag>
<current_value>0.7</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='134'>
<tag>Magnetron</tag>
<current_value>1.8</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='162'>
<tag>CV Ketel</tag>
<current_value>44.5</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='104'>
<tag>Gas verbruik</tag>
<current_value>3955.745</current_value>
<unit symbol='m3' type='basicSI'></unit>
</data>
<data id='105'>
<tag>Monitor - Domotiga</tag>
<current_value>0.6</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='135'>
<tag>Vaatwasser</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='152'>
<tag>Buiten</tag>
<current_value>11.19</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='153'>
<tag>Vijverwater</tag>
<current_value>13.06</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='151'>
<tag>Woonkamer</tag>
<current_value>19.81</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='150'>
<tag>Aanvoer</tag>
<current_value>32.31</current_value>
<unit symbol='°C' type='basicSI'></unit>
</data>
<data id='108'>
<tag>Firewall</tag>
<current_value>15.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='107'>
<tag>Synology 1812+</tag>
<current_value>59.3</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='115'>
<tag>Game PC</tag>
<current_value>143.3</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='101'>
<tag>Huidig verbruik</tag>
<current_value>1060</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='102'>
<tag>Verbruik - Normaal</tag>
<current_value>6924</current_value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='103'>
<tag>Verbruik - Laag</tag>
<current_value>7610</current_value>
<unit symbol='kWh' type='basicSI'></unit>
</data>
<data id='170'>
<tag>Server Room - Totaal</tag>
<current_value>276.5</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='171'>
<tag>Meterkast - Totaal</tag>
<current_value>122.2</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
<data id='163'>
<tag>Open Therm Burner</tag>
<current_value>On</current_value>
<unit symbol='Level' type='derivedunits'></unit>
</data>
<data id='144'>
<tag>Badkamer</tag>
<current_value>0.0</current_value>
<unit symbol='Watt' type='basicSI'></unit>
</data>
</environment>
</eeml>

You can check yourselve via the url https://xively.com/feeds/78521

We are almoste there. I hope you have a solution.. :)

#21 Updated by hschenkelaars over 4 years ago

I also get an error message in my Domotiga debug log

2014/10/25 19:18:33 [Pachube] Error sensor data is not valid after uploading to Pachube/Xively!

#22 Updated by hschenkelaars over 4 years ago

Additional info:

When I klick on the API endpoint link I get this as an output.

{"id":78521,"title":"HCC-Online","private":"false","tags":["dev","SmartMeter"],"feed":"https://api.xively.com/v2/feeds/78521.json","status":"frozen","updated":"2014-09-29T17:16:17.200074Z","created":"2012-10-02T20:12:50.965645Z","creator":"https://xively.com/users/hschenkelaars","version":"1.0.0","datastreams":[{"id":"101","current_value":"ERROR: Unknown symbol","at":"2014-09-29T17:16:16.857152Z","max_value":"8380.0","min_value":"0.0","tags":["Huidig verbruik"],"unit":{"type":"basicSI","symbol":"kWh"}},{"id":"102","current_value":"4103","at":"2014-09-29T17:16:16.857152Z","max_value":"31250.0","min_value":"0.0","tags":["verbruik - Normaal"],"unit":{"type":"basicSI","symbol":"kWh"}},{"id":"103","current_value":"4482","at":"2014-09-29T17:16:16.857152Z","max_value":"6813.0","min_value":"0.0","tags":["verbruik - Laag"],"unit":{"type":"basicSI","symbol":"kWh"}},{"id":"104","current_value":"2792.102","at":"2014-09-29T17:16:16.857152Z","max_value":"2208184.0","min_value":"20.8","tags":["Gas verbruik"],"unit":{"type":"basicSI","symbol":"m3"}},{"id":"105","current_value":"0.7","at":"2014-09-29T17:16:16.857152Z","max_value":"30.9","min_value":"0.4","tags":["Monitor - Domotiga"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"106","current_value":"4.8","at":"2014-09-29T17:16:16.857152Z","max_value":"24.5","min_value":"0.0","tags":["Domotiga Server"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"107","current_value":"62.6","at":"2014-09-29T17:16:16.857152Z","max_value":"72.9","min_value":"57.2","tags":["Synology 1812+"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"108","current_value":"25.3","at":"2014-09-29T17:16:16.857152Z","max_value":"31.7","min_value":"11.9","tags":["Firewall"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"110","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"169.5","min_value":"0.0","tags":["Server"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"111","current_value":"75.0","at":"2014-09-29T17:16:16.857152Z","max_value":"88.6","min_value":"0.0","tags":["Monitor - Server"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"115","current_value":"132.3","at":"2014-09-29T17:16:16.857152Z","max_value":"252.3","min_value":"0.0","tags":["Game PC"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"130","current_value":"0.1","at":"2014-09-29T17:16:16.857152Z","max_value":"829.6","min_value":"0.0","tags":["IJskast"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"131","current_value":"80.0","at":"2014-09-29T17:16:16.857152Z","max_value":"1062.3","min_value":"0.6","tags":["Diepvries"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"132","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"1989.3","min_value":"-0.0029968","tags":["Droger"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"133","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"2314.8","min_value":"0.0","tags":["Wasmachine"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"134","current_value":"1.9","at":"2014-09-29T17:16:16.857152Z","max_value":"2093.5","min_value":"0.0","tags":["Magnetron"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"135","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"2231.1","min_value":"0.0","tags":["Vaatwasser"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"142","current_value":"12.3","at":"2014-09-29T17:16:16.857152Z","max_value":"430.4","min_value":"0.0","tags":["Martijn"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"143","current_value":"5.9","at":"2014-09-29T17:16:16.857152Z","max_value":"164.9","min_value":"0.0","tags":["Desiree"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"150","current_value":"18.56","at":"2014-09-29T17:16:16.857152Z","max_value":"77.19","min_value":"14.81","tags":["Aanvoer"],"unit":{"type":"basicSI","symbol":"°C"}},{"id":"151","current_value":"19.81","at":"2014-09-29T17:16:16.857152Z","max_value":"44.12","min_value":"5.06","tags":["Woonkamer"],"unit":{"type":"basicSI","symbol":"°C"}},{"id":"152","current_value":"5.19","at":"2014-09-29T17:16:16.857152Z","max_value":"36.94","min_value":"-0.75","tags":["Buiten"],"unit":{"type":"basicSI","symbol":"°C"}},{"id":"153","current_value":"5.62","at":"2014-09-29T17:16:16.857152Z","max_value":"27.38","min_value":"3.31","tags":["Vijverwater"],"unit":{"type":"basicSI","symbol":"°C"}},{"id":"160","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"38.7","min_value":"0.0","tags":["CP Ketel"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"161","current_value":"0.0","at":"2014-09-29T17:16:16.857152Z","max_value":"16441.6","min_value":"0.0","tags":["CP Serre"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"162","current_value":"4.2","at":"2014-09-29T17:16:16.857152Z","max_value":"273.0","min_value":"0.0","tags":["CV Ketel"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"170","current_value":"207.1","at":"2014-08-04T17:13:01.761551Z","max_value":"79692.8","min_value":"0.0","tags":["Server Room - Totaal"],"unit":{"type":"basicSI","symbol":"Watt"}},{"id":"171","current_value":"122.2","at":"2014-08-04T17:13:01.761551Z","max_value":"841.5","min_value":"115.4","tags":["Meterkast - Totaal"],"unit":{"type":"basicSI","symbol":"Watt"}}],"location":{"name":"Home","domain":"physical","lat":51.4947708276455,"lon":5.38372993469238}}

#23 Updated by rdnzl over 4 years ago

Does of your devices contains a value with contents: ERROR:unknown symbol?

#24 Updated by hschenkelaars over 4 years ago

I deleted the value "ERROR:unknown symbol"with a static value and that looks O.K. but this value is not changed with the newly pushed value from DomotiGa. I also created a new channel "10" in Xively and Domotiga. The value for channel 10 is pushed by DomotiGa but is also not updates into the Xively channel / Graph. There are still "No datapoints found for this channel"...

It seems the data structure of the pushed data might be the problem because I receive an error in the main log of DomotiGa when I push content to Xively.


2014/10/26 12:48:55 [Pachube] Error sensor data is not valid after uploading to Pachube/Xively!

#25 Updated by rdnzl over 4 years ago

I will check it, see whats wrong.

#26 Updated by hschenkelaars over 4 years ago

Hi,

I did some further investigation that might help.

I used my Rpi to setup a host that pushes CPU load to Xively via this link - https://xively.com/dev/tutorials/pi/
When I run the script data is pushed to Xively and the graph us updated. When comparing the pushed content I get the following results.

Domotiga content Push:

Rpi content Push:

The syntax of the pushed content, by DomotiGa, looks a bit different then the pushed Rpi content.

Created channel by the Rpi push and updated graph:

Hope this helps a bit.

#27 Updated by rdnzl over 4 years ago

It's because domotiga uses the older legacy pachibr XML format. And the RPO the native json format.. Will try to rewrite it.. XML still worked last time I tried but the result were visible under a different section on the site...

#28 Updated by hschenkelaars over 4 years ago

No Problem. I'll wait for your response. We will get there :) and I hope that other DomotiGa users will profit from this work as well ;)

#29 Updated by rdnzl over 4 years ago

1915
1916

Henk, I was ready to fix it, but here it just works.. (with one device/stream though) I don't use it that frequently.

See screenshots..Its the battery voltage of my smoke detector..

The error you get is a http status 422 (i will extend the debug output of the plugin)

422 Unprocessable Entity Xively was unable to create a Feed because the EEML/JSON was not complete/valid (e.g. it didn’t include a “title” element). Check your body against examples.

Which is strange because I also don't send one.
You are using the api key from the legacy section of the site correct?

#30 Updated by hschenkelaars over 4 years ago

Hi,

Here are some screenshots from my legacy feed and key's I used. I tried all 3 keys but get nu update in my xively graphs but only a "PUT". Any Idea what the problem might be? The syntax of what we send seems the same. I'm puzzeled.......

My Legacy Feed :

My API key :

My API key's from the settings menu :

#31 Updated by hschenkelaars over 4 years ago

I solved the issue by deleting all the id's/channels created in the Pachube/Xively settings, in DomotiGa, and recreate them. Now everything works just fine ??..... Strange but finally it works again.. :)

Maybe it's a good thing change the "legacy pachibr XML format" to the "Native json format" ? But only when there is time. When nothing changes everything should keep working.

Thx again for your support and patience.

Grtz, Hans Schenkelaars

#32 Updated by rdnzl over 4 years ago

In your xml is something wrong i guess, maybe a ' or " in device name os something like that?
Anyway I have renamed all Pachube occurences to Xively, and I am coding in json now. Will appear in new version when done.
I close this ticket now.

#33 Updated by rdnzl over 4 years ago

  • Status changed from Feedback to Closed

In you xml is something wrong i guess, maybe a ' or " in device name os something like that?
Anyway I have renamed all Pachube occurences to Xively, and I am coding in json now. Will appear in new version when done.
I close this ticket now.

Also available in: Atom PDF