serial reading

[epierre]

Hello,

Looks like it's good, in one hour I've had 12 metering values, given I modified the timer in the sensor to 10 instead of 30. It is reporting only changed values which is smart (should be documented, extra value !)

1 1 1 0 21.0
1 0 1 1 52.0
1 0 1 1 53.0
1 0 1 1 54.0
1 1 1 0 20.0
1 1 1 0 21.0
1 1 1 0 20.0
1 0 1 1 55.0
1 0 1 1 54.0
1 0 1 1 55.0
1 0 1 1 54.0
1 0 1 1 55.0
1 1 1 0 21.0

[epierre]

well... I tried to replicate this on a cubitruck2 (IBOX), does not work...

I did on the i5 a test to see conf of usb port that works with:

stty -F /dev/ttyUSB1
speed 115200 baud; line = 0;
kill = ^H; min = 0; time = 0;
ignbrk -brkint -icrnl -imaxbel
-opost -onlcr
-isig -icanon -iexten -echo -echoe -echok -echoctl -echoke

I tried to replicate it to the cubie:
stty -F /dev/ttyUSB1 cs8 115200 ignbrk -brkint -imaxbel -opost -onlcr -isig -icanon -iexten -echo -echoe -echok -echoctl -echoke -ixon -crtscts kill ^H min 0

but still nothing... any idea ?

[epierre]

my bad, wrong reading script... works straight with the above parameters, should check if it works without... well no arduino ide run before it works for me now, I'm a bit farther than the arduino.cc forum ;-)

[epierre]

Hello,

Works like a charm, I now receive the DHT11 values and I am able to post it to a (now) static node in domoticz (could be used for every system with a json posting interface).

This is where it can be tricky, you need both Temp and Humidity to report, so I have to wait to have them both in memory to push a report.

I expect to use a sqlite3 database locally to handle the last known value and the status/association of a node and its device. Doing so requires that either I handle all in a conf file, or that creation of device are driven by the script which I can handle too (maybe specific to domoticz).

[jendrush]

I have little success too. I modified some code from other project, and now i can report temperatures(DS18B20), temperatures + humidity(DHT22), motion sensor to Domoticz. Today i will try to handle turning on, and off a switch, and also i am planning to modify relay code to handle my wireless 433MHz wall plugs to work as normal relay. Next time maybe reading status of power meter? But in this case i see a problem - how to read last value of acumulated energy from Domoticz? Now some information about solution. Serial gateway is connected to Raspberry Pi(Domoticz), and there is Node.js script. Script can read, and send messages through serial, and post links to Domoticz by JSON.

[jendrush]

And screenshoot http://screenshooter.net/1288732/gimyqda

[BulldogLowell]

@jendrush

very nice!

[jendrush]

Now i am lack of arduinos, DHT22 is connected directly to atmega on breadboard:) Maybe i recieve this week few of 4 i've ordered lately.

I have one Stellaris launchpad, someone tried to make it work with mysensors? :)

[hek]

:thumbsup:

[epierre]

@jendrush you can see from my Xively script how to do it: http://www.domoticz.com/wiki/Perl_for_Domoticz#Pachube_.2F_Cosm_.2F_Xively, in short you get all the nodes, you aprse the one you need, and you get the data field, first one is instant, second cumulated separated by a semicolon (";").

To push data, please see http://www.domoticz.com/wiki/Domoticz_API/JSON_URL's#Electric.28Instant_and_Counter.29, I updated it recently.

BTW, as you can see in the first script, I post all my values to Xyvely/COSM/Pachube... but this is another story for I made modification yesterday and I've not reported them to the wiki yet.

[epierre]

Ok so today I've added a conf file reading, and started to work on the database model (hardware-device-sensor) in sqlite3 to keep track of last known value and last affected sensor id. This speeds up the whole thing at startup.

Next step is to store all devices data in the table, and update them whenever they are received.

Afterward, I'll try creating a new sensor automatically, and then try to extend it to other sensors type.

If anyone is interrested in trying it (very beta yet...)...

[jendrush]

@epierre I wish to see the code:)

[epierre]

Hello,

This is very alpha, it handles only one node with id=1 till I manage the sqlite3 database fully (data model is not right yet...).
mysensors-gw.pl : main file, reader, tested only with DHT11 Temp+Humidity
.conf-mysensors : conf file to set serial port, domoticz IP/PORT, hardware device (for future virtual sensors creation, I prefer to leave it configurable by now)

github repository

You will need those packages:
sudo apt-get install libdevice-serialport-perl libdatetime-perl libdbd-sqlite3-perl libdbi-perl sqlite3 libjson-perl libfile-slurp-unicode-perl libwww-perl libconfig-simple-perl

Discussion:

• What I need to see is how to handle existing nodes that wouldn't be in the database, I thought of a config file ? In RFX433 devices, when you change the battery, it resets all ... painfull... here I would like to avoid this situation but this will be complicated without a GUI.
• Other point, to send orders, I would need to have some JSON API, or a script that is called from the DZ to interract with the sensors. the Gateway.py from @wannabee does it.
• I will try maybe to implement the same conf file than @wanabee link text for he has identified the same issues as me, meaning all mapping of a sensor will be done in the conf file (see wiki)

[jendrush]

@epierre I will try to use MySQL with my project.

[epierre]

@jendrush mysql is only a small conf change (replace dbi:SQLite:dbname=mysensors.db by DBI:mysql:database=$database;host=$hostname;port=$port ;-)