Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Sun, 26/04/2015 - 12:52

Hello ,
I am undergraduate computer science student.

I posted in the Forums before a while the following:
http://openenergymonitor.org/emon/node/10468

I am working step by step to configure the the emontx and the raspberry pi with the following plan:
get the hardware to work with emoncms.org> get the hardware to work with emoncms in localhost> use method 1 you answered to me in the forums to get some data in my website.

I attached to this post a document of my progress.
I am having problem in getting the hardware to work with emoncms in localhost
I am following the link followed to run in localhost

https://github.com/emoncms/emoncms/blob/master/docs/WindowsInstall.md

I am stocked in the point where I run the python script.

I am getting this error

the error says:

SerialException("could not open port %r: %r" % (self.portstr, ctypes.WinError()))

SerialException: could not open port 'COM3': WindowsError(2, 'The system cannot find the file specified.')

I hope you give me some help or tips to get the data in the localhost.

I would also be very very thankful for your if you instruct me how to get some data in files or databases other than emoncms.

I will be praying and waiting to read and get help from you.

Thanks in advance.

Regards,

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Sun, 26/04/2015 - 15:17.

Please note that I do not have a jeelink plugged into the usb port

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by pb66 on Sun, 26/04/2015 - 17:06.

There appears to be some confusion of softwares here, Your other thread says you do not want to use emoncms as you want to store the data in your own mySQL database, And "method 1" appears to be writing your own script rather than using emonhub. But your documentation shows emoncms and emonhub so can you confirm what you have and what you are trying to achieve?

The "SerialException" and your comment above suggests windows cannot find the device that's not there, which sounds logical! Why is it trying to access the serial port if there isn't anything there?

I think if you are not using a JeeLink you should skip the "Using a JeeLink" section of that guide.

Paul

PS Be careful with the screen dumps, you have exposed apikeys and email addresses etc

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Mon, 27/04/2015 - 14:31.

Hello,

Thank you for notifying me about the email and the apikey.

I am just having problem in getting the data to show in my localhost/emoncms.

The raspberry pi is working and sending the data to emoncms.org

I do not know why I am not having the inputs in the localhost.

Can you instruct me or give me some references to use in order to get raspberry pi to work with the local version??

Thanks in advance.

[Can you not read? You submitted 4 copies of the same post inside a minute. The duplicates have been deleted. Moderator - RW]

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Mon, 27/04/2015 - 14:33.

Is there any way to have raspberry pi to send data to emoncms in localhost without JeeLink??

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by pb66 on Mon, 27/04/2015 - 22:15.

Yes, there is. A Jeelink is not used by a Pi to send data to emoncms !

A Jeelink is a USB version of the Jeenode. A Jeenode is the "RFM network"device for Arduino that the RFM2Pi is based upon. The RFM2Pi is specific to RaspberryPi as it connects to the GPIO. Therefore if you are intending to receive data from RFM equipped devices eg emonTx and emonTH etc directly to a Non-RasperryPi machine then you could use a Jeelink instead of an RFM2Pi.

A RaspberryPi can "send data to emoncms" via Ethernet or WiFi if emoncms is on a Windows server or if the emonCMS server is on the RaspberryPi then no external hardware is required.

Generally localhost is a term used for "the same machine" when you sit at a windows machine the localhost is that windows machine meanwhile if the Pi is logging data to the localhost it is referring to the RaspberryPi as that is local from it's prospective.

Paul

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Mon, 27/04/2015 - 22:45.

What if I have emoncms on wamp server in my computer? How can I connect the raspberry pi with the emoncms I am hosting in wamp local server?

Can you provide me with help and refrences?? please??

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by kh_saf on Tue, 28/04/2015 - 00:05.

Hello,

I am a student who bought emontx reassembled , raspberry pi with RFM69Pi.

I managed to configure the raspberry pi to comunicate with emoncms.org

I wanted to see how emoncms save the data in its database or file. This is why I am trying to get the raspberry pi to comumicate wihe emoncms version I hosted in WAMP windows server. But, I am not successful on that.

My ultimate goal is get the raspberry pi to save the incoming data from emontx in my own MySQL database that I am hosting in WAMP in my windows labtop. Assume it is super simple database called power data, with two tables one is called place (ID, Name) and the other table is called power (Place_ID, Power, Voltage, Timestamp)

The power of power table is the values raspberry pi is reciving from emontx.

I am in dark place and I have no idea what to do.

I need your support and help to get this working.

Please please help me! or direct me to someone who can help me.

Thanks,

Re: Problem in letting rapberry pi to send data to emoncms in localhost

Submitted by pb66 on Tue, 28/04/2015 - 15:23.

The Pi connects to emoncms via a network connection (except localhost) if your Pi is able to post to emoncms.org then it should be able to post to your WAMP server too.

In the emonhub.conf you will need settings for each reporter you wish to create. The format of the reporter settings will be the same for each but the details will differ. Each must have a unique name eg [[emoncms_org]], [[emoncms_wamp]] [[emoncms_pi]] etc. All will be the same Type and the only other differences in the settings will be the url and apikeys. Each target emoncms has its own write apikey and the url must start "http" and resolve to the target emoncms. You can use domain names, network names or IP's in your urls, the most reliable is a fixed ip address.

In emonhub.log you can see the frames being processed if you set the loglevel to DEBUG and you can compare the functional emoncms.org frames to the WAMP frames if there is a problem.

Paul

Archived Forum