16/09/2012, 22:59:45
Voici mon fichier linknx.xml de test qui log correctement dans mysql
Et un extrait de la météo chez moi ces derniers temps :-)
Quand il y a plusieurs "off" de suite c'est que je reboot la frambroise, donc linknx va lire la valeur sur le bus
Code :
<?xml version="1.0" ?>
<config>
<services>
<smsgateway />
<emailserver />
<xmlserver type="inet" port="1028" />
<knxconnection url="ip:127.0.0.1" />
<exceptiondays>
<date day="1" month="1" />
<date day="1" month="5" />
<date day="15" month="8" />
<date day="25" month="12" />
<date day="25" month="4" year="2011" />
<date day="2" month="6" year="2011" />
<date day="13" month="6" year="2011" />
<date day="9" month="4" year="2012" />
<date day="17" month="5" year="2012" />
<date day="28" month="5" year="2012" />
<date day="1" month="4" year="2013" />
<date day="9" month="5" year="2013" />
<date day="20" month="5" year="2013" />
<date day="21" month="4" year="2014" />
<date day="29" month="5" year="2014" />
<date day="9" month="6" year="2014" />
</exceptiondays>
<persistence type="mysql" host="localhost" user="linknx" pass="linknx" db="linknx" table="persist" logtable="log" />
<ioports />
</services>
<objects>
<object type="1.001" id="P2L6" gad="1/1/3" init="request">Palier Biblio</object>
<object type="1.001" id="Pluie" gad="0/1/2" init="request" log="true">Pluie</object>
<object type="9.xxx" id="TempYo" gad="3/0/1" init="request" log="true">Temperature Yoann</object>
<object type="1.001" id="VoletTest" gad="2/4/1" init="request">TV stop</object>
<object type="1.001" id="VoletTestBougre" gad="2/4/2" init="request">TV Bouge</object>
<object type="5.xxx" id="VoletTestPosition" gad="2/4/4" init="request">TV position</object>
<object type="11.001" id="cur_date" gad="0/0/1" init="now" flags="cwtus">Current Date</object>
<object type="10.001" id="cur_time" gad="0/0/2" init="now">Current Time</object>
<object type="1.001" id="test_on_off" gad="1/1/2" init="request" log="true">NoL1</object>
</objects>
<rules>
<rule id="cur_time_date">
<condition type="timer" trigger="true">
<every>1h</every>
</condition>
<actionlist>
<action type="set-value" id="cur_time" value="now" />
<action type="set-value" id="cur_date" value="now" />
</actionlist>
</rule>
</rules>
<logging />
</config>Et un extrait de la météo chez moi ces derniers temps :-)
Code :
mysql> select * from log where object = "pluie";
+---------------------+--------+-------+
| ts | object | value |
+---------------------+--------+-------+
| 2012-08-30 16:51:06 | Pluie | on |
| 2012-08-30 16:53:37 | Pluie | off |
| 2012-09-01 10:17:30 | Pluie | off |
| 2012-09-10 06:47:57 | Pluie | on |
| 2012-09-10 07:17:21 | Pluie | off |
| 2012-09-10 07:22:32 | Pluie | on |
| 2012-09-10 07:29:27 | Pluie | off |
| 2012-09-10 21:19:31 | Pluie | on |
| 2012-09-10 21:28:04 | Pluie | off |
| 2012-09-10 21:43:16 | Pluie | on |
| 2012-09-10 21:48:14 | Pluie | off |
| 2012-09-10 22:04:30 | Pluie | on |
| 2012-09-10 22:15:07 | Pluie | off |
| 2012-09-10 22:37:28 | Pluie | on |
| 2012-09-10 22:47:16 | Pluie | off |
| 2012-09-11 02:40:27 | Pluie | on |
| 2012-09-11 02:55:31 | Pluie | off |
| 2012-09-11 04:03:45 | Pluie | on |
| 2012-09-11 04:18:52 | Pluie | off |
| 2012-09-11 10:33:55 | Pluie | on |
| 2012-09-11 10:42:55 | Pluie | off |
| 2012-09-13 01:48:23 | Pluie | on |
| 2012-09-13 02:02:12 | Pluie | off |
| 2012-09-13 02:12:42 | Pluie | on |
| 2012-09-13 02:25:35 | Pluie | off |
| 2012-09-15 15:33:43 | Pluie | off |
+---------------------+--------+-------+
26 rows in set (0.00 sec)Quand il y a plusieurs "off" de suite c'est que je reboot la frambroise, donc linknx va lire la valeur sur le bus
Viens voir !!! La lampe s'allume, la lampe s'allume !!!!