{"id":658,"date":"2013-10-18T12:44:25","date_gmt":"2013-10-18T10:44:25","guid":{"rendered":"http:\/\/sam-soul.fr\/Info\/?p=658"},"modified":"2013-10-18T12:44:25","modified_gmt":"2013-10-18T10:44:25","slug":"historisation-des-sondes-oregon","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2013\/10\/18\/historisation-des-sondes-oregon\/","title":{"rendered":"Historisation des sondes Oregon"},"content":{"rendered":"<p>&nbsp;<\/p>\n<pre><cite>nightfever a \u00e9crit:<\/cite>\nMa d\u00e9marche :\n<strong>0 - pr\u00e9requis :\u00a0<\/strong>\nAvoir install\u00e9 le paquet phpmyadmin sur le NAS\nlogin (de base) = root\nmdp = y'en a pas\u00a0<img decoding=\"async\" title=\"Mort de rire\" alt=\":lol:\" src=\"http:\/\/www.touteladomotique.com\/forum\/images\/smilies\/icon_lol.gif\" \/>\u00a0\n\n<strong>1 - pr\u00e9paration du NAS :<\/strong>\u00a0J'ai cr\u00e9\u00e9 un repertoire \"graphiques\" dans le repertoire web du NAS.\nEnsuite, j'ai tout mis (derni\u00e8re version de psykokwac en page\u00a0<img decoding=\"async\" title=\"Cool\" alt=\"8)\" src=\"http:\/\/www.touteladomotique.com\/forum\/images\/smilies\/icon_cool.gif\" \/>\u00a0sur le nas dans le repertoire web\/graphiques o\u00f9 j'ai plac\u00e9 : graph.php, logger.php et le dossier pChart2.1.3\n\n<strong>2 - cr\u00e9ation de la base :\u00a0<\/strong>Nom de la base : graph, Login user : graph_user en localhost, Password user : graph, Cr\u00e9ation de la table : graph_tbl\npuis Cr\u00e9ation des 3 champs : ffeed de type TEXT + ftimestamp de type TIMESTAMP et default CURRENT_TIMESTAMP + fvalue de type DOUBLE\n\n<strong>3 - modification du fichier graph.php ET logger.php\u00a0en fin de fichier avec :\u00a0<\/strong>\n$this-&gt;_db_name = \"graph\";\n$this-&gt;_db_login = \"graph_user\";\n$this-&gt;_db_passw = \"graph\";\n$this-&gt;_db_table = \"graph_tbl\";\n\n<strong>4 - cr\u00e9ation d'une sc\u00e8ne dans la vera :<\/strong>\nnom = T\u00b0C jardin (on y met ce qu'on veut)\nonlget \"code luup\"<\/pre>\n<pre>CODE:\u00a0<a href=\"http:\/\/www.touteladomotique.com\/forum\/viewtopic.php?f=18&amp;t=7962&amp;start=108#\">TOUT S\u00c9LECTIONNER<\/a><code>local tempext = luup.variable_get(\"urn:upnp-org:serviceId:TemperatureSensor1\", \"CurrentTemperature\", 21)\ntempext = tonumber(tempext)\nmy_graph_sensor(\"Temp_ext\", tempext)\nreturn true<\/code><\/pre>\n<pre>21 est l'id de ma sonde oregon de T\u00b0\nonglet \"programmation\" :\u00a0lancement toutes les 10min (pour tester).\u00a0\nJe laisse 10 min pour le jardin et je vais refaire une sc\u00e8ne avec les sondes int\u00e9rieures que je lancerai toutes les heures.\u00a0<img decoding=\"async\" title=\"Clin d'oeil\" alt=\":wink:\" src=\"http:\/\/www.touteladomotique.com\/forum\/images\/smilies\/icon_wink.gif\" \/>\u00a0\n\n<strong>5 - code de d\u00e9marrage de la vera :<\/strong>\napplications \/ d\u00e9velopper des applications \/ editer le d\u00e9marrage Lua :<\/pre>\n<pre>CODE:\u00a0<a href=\"http:\/\/www.touteladomotique.com\/forum\/viewtopic.php?f=18&amp;t=7962&amp;start=108#\">TOUT S\u00c9LECTIONNER<\/a><code>function my_graph_sensor (feed, value)\n\u00a0 local url = \"http:\/\/192.168.1.16\/graphiques\/logger.php?\" -- remplacez ici par votre serveur\n\u00a0 luup.inet.wget(url .. \"f=\"..feed..\"&amp;v=\"..value)\u00a0\nend<\/code><\/pre>\n<pre><strong>\n6 - R\u00e9sultat :<\/strong>\nje tape dans mon navigateur (Chrome) :\u00a0<a href=\"http:\/\/192.168.1.16\/graphiques\/graph.php?title=Titre%20Temperatures&amp;window=hour&amp;feeds\">http:\/\/192.168.1.16\/graphiques\/graph.ph ... hour&amp;feeds<\/a>[Temp_ext]=Temp%20jardin\nJ'ai un beau graphique avec l'\u00e9chelle automatique o\u00f9 appara\u00eet l'historique des temp\u00e9ratures de ma sonde\u00a0<img decoding=\"async\" title=\"M. Green\" alt=\":mrgreen:\" src=\"http:\/\/www.touteladomotique.com\/forum\/images\/smilies\/icon_mrgreen.gif\" \/><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; nightfever a \u00e9crit: Ma d\u00e9marche : 0 &#8211; pr\u00e9requis :\u00a0 Avoir install\u00e9 le paquet phpmyadmin sur le NAS login (de base) = root mdp = y&rsquo;en a pas\u00a0\u00a0 1 &#8211; pr\u00e9paration du NAS :\u00a0J&rsquo;ai cr\u00e9\u00e9 un repertoire &laquo;&nbsp;graphiques&nbsp;&raquo; dans le repertoire web du NAS. Ensuite, j&rsquo;ai tout mis (derni\u00e8re version de psykokwac en page\u00a0\u00a0sur &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2013\/10\/18\/historisation-des-sondes-oregon\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;Historisation des sondes Oregon&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/658"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=658"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/658\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=658"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}