• Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    1. Home
    2. JeeLet
    3. Posts
    J
    • Profile
    • Following 0
    • Followers 0
    • Topics 16
    • Posts 127
    • Best 17
    • Controversial 0
    • Groups 0

    Posts made by JeeLet

    • RE: Grafana install

      MyController can be installed anywhere, it is pure carbon, the hardest material 🙂

      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      I realize that the questions I ask, many are explained in the Documentation 🙂

      Hello jkandasa
      yes influx 2.x soon on a new install.
      a new hardware base, maybe an Odroid-N2 !?

      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      https://songrgg.github.io/operation/influxdb-command-cheatsheet/
      the management of metrics in terminal mode with CLI commands for ver1.8 is not simple
      a good thing with a graphical interface.

      version 2.0 already has an integrated tool https://docs.influxdata.com/influxdb/v2.6/visualize-data/visualization-types/table/

      Let's talk about MyC again.

      on image of the architecture https://v2.mycontroller.org/doc-images/architecture.png

      how the dialogue between the mys gateway and influxDB works

      I don't understand the difference between StorageDB and MetricDB

      you say "You can also use influx 2.x. MyC supports influx 2.x"?

      on a next new installation I switch to the influxDB-2 version I don't have anything to modify in mycontroller ?? .... I may try ??

      For the last test with grafana, the "mc_gauge_float_data" values work but not the "mc_binary_data" numbers
      (maybe I'm wrong in the config)

      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      I try to read the future, yes the future is tomorrow (yes I have a crystal ball) 🙂

      the elements that come out : TIG
      Telegraf + InfluxDB + Grafana

      and telegraf is an obligatory passage, evolution of influxDB v2

      the infos put aside
      https://www.sqlpac.com/fr/documents/influxdb-migration-v1-v2-procedure.html

      major changes in influxDB
      The TSI index is the default storage engine, the In-Memory index is removed.
      Chronograf (visualization tool) is integrated in InfluxDB.
      Flux becomes the default language and InfluxQL is unfortunately removed.
      Continuous queries are replaced by Tasks.
      The native support of OpenTSDB, Graphite, CollectD... protocols is also unfortunately removed in InfluxDB v2, Telegraf agents must be implemented.

      then the next step is : ??? apt install telegraf ??? 🙂

      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      a question:

      Can MyC manage the database of influxDB ?

      a bit like on HAss : https://forum.hacf.fr/t/installer-influxdb-dans-home-assistant-et-booster-votre-base-de-donnee/360

      cella will allow me to make cleaning of the old Node that I removed.

      posted in General Discussion
      J
      JeeLet
    • RE: MQTT Gateway USB

      it was to make a test, how to use the 2mqtt that you created.

      arduino -- usb ---> Mosquitto --> myC
      in arduino a temperature (IA*) or a command (DI*)

      • IA=analog input / DI= digital input
      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      a good year 2023 for you @jkandasa and your family.

      myController --> influxDB --> Grafana
      yes functional, and it's quite simple (the principle)
      the discovery of influxDB and Grafana is rich.

      I will surely have questions about the marriage between myC and influxDB (v1.8) ..... how the databases are created and deleted in time.

      an image of the configuration

           editor  lien field influxDB

      posted in General Discussion
      J
      JeeLet
    • RE: Grafana install

      text alternatif

      posted in General Discussion
      J
      JeeLet
    • MQTT Gateway USB

      bonjour @jkandasa

      .... a test of the Mqtt protocol with myController
      (Odroid and Arduino Uno)

      I'm looking for an architecture with :

      • myController and Mosquito (functional part)
      • Gateway-Usb with sensors and Oled display
        (for a bidirectional dialogue)

      is it possible ???
      ...I've been looking for sketches as examples for GWusb but nothing seen.

      https://github.com/mycontroller-org/2mqtt
      https://forum.mysensors.org/topic/11721/serial-ethernet-to-mqtt/5
      https://forum.mycontroller.org/topic/368/serial-mqtt-adapter

      Re-Edit : subject abandoned

      posted in General Discussion
      J
      JeeLet
    • RE: Ghost Value

      .... happy holidays to you Jkandasa

      I'm rethinking my vision / use of the Mys protocol

      as I have chosen a Usb gateway and mostly a communication bus in rs485 (RF is for specific cases)

      MyC <---usb---> Gateway Mega2560/Gui-Oled <----RS485---> Nodes1 2 3 <---- RF ---> NodeX

      • the controller in a closet
      • the gateway on the desk (usb 3 meters)
      • the nodes everywhere in the house (in the technical parts)

      and as the "real" Node to Node doesn't work (yes a gateway is mandatory for routing)

      I'll see how I'm going to do a state management.
      I'm testing a feedback on the OLED display of the gateway.

      an example of the sketch on the gateway of a remote node

      //------ node 36 Link distant ------ 
          const byte LINKY_NODE_ID  = 36 ;  // node linky
          const byte CHILD_ID_PAPP  = 1 ;   // ID papp
          uint16_t valPAPP ;  //  variable valeur PAPP 
          
          //-------- linky papp ------------------
       if (message.sender == LINKY_NODE_ID && message.sensor==CHILD_ID_PAPP  && message.type == V_VA  ) {    // val PAPP
          valPAPP = message.getInt();
          Serial.print("val PAPP. : ");
          Serial.println(valPAPP);                     
          }
            
          //------------ OLED valeur PAPP --------------------------
       void valPaPP()
        {
        oled.set2X();           
        oled.setCursor(37,2);
        oled.print(valPAPP);
        oled.print("va  ");
        }
      
      posted in General Discussion
      J
      JeeLet
    • RE: Ghost Value

      I get it, it's a push mode enter, or "pull flow".

      "Node down status maintained by MyC" ... yes that's a very good thing.

      ideas out loud about the structure of the system:
      MyC <--- Gw <--- node1 <---- node2 <--- ...etc
      . the nodes give us the values of the sensors
      . MyC displays or sends commands and other things

      • Gw and stick to the controller, it does not do much, it relays, it is an intermediary.
        Couldn't we use the Gateway-Usb to monitor the nodes ?
        of their values ? of their states ?
      posted in General Discussion
      J
      JeeLet
    • RE: Ghost Value

      "So this is data from 20 hours ago" yes I agree.

      another example : I have a node stopped with temperature probes.

      Theoretically when I restart MyC the values displayed in the list of Fields, the sensors should be at zero.
      But no, they keep their last value.

      why MyC will not read the values on the bus
      (MyC ---> Gw ---> Nodes)

      it's complicated for the values to go to zero (or other sign/value) when the system is restarted or after a last of time passed ???

      thanks

      posted in General Discussion
      J
      JeeLet
    • Ghost Value

      hello @jkandasa
      a question before christmas 🙂

      I don't understand the problem, the node is absent (turned off) and the old value is still there ?
      it must be zero !

      ---> pdf image <---

      Maybe ghost value is not the right terminology for this?

      posted in General Discussion
      J
      JeeLet
    • RE: MyController V2, breaking change

      ... umm

      this means that if we update with the new version, the existing base on the System or if we use an existing backup, it will give problems.

      So you have to do the manipulation that you propose.

      (yes I rephrase the text because the translators give us nonsense sometimes)

      Hello @Jkandasa
      Thank you for the maintenance of MyController

      https://github.com/mycontroller-org/server/releases/tag/master

      posted in Announcements
      J
      JeeLet
    • RE: Grafana install

      good evening @jkandasa

      no I haven't done anything yet, I'm on electrical measurements and a library to review.
      But yes, it's great that you're looking at it.

      it will make MyC even more interesting 👑

      posted in General Discussion
      J
      JeeLet
    • Grafana install

      MyController for the management of the MySensors galaxy and the most Aboutie, it's a bit normal you might say 🙂
      I tested a good range of home automation programs, and I always come back to MyC. Why?

      So I decided to make MyC the Core and add around what I found on the Other Controllers

      the last one is Motion which work with a Usb Cam, but I have to do it again to switch to Motionplus (evolution)

      Today I launch the idea married MyC and Grafana
      (which version? that goes with the influxdb version of Mycontroller)
      Grafana

      So when you have a moment Jkandasa can you tell us how to start on the right foot, an idea on how to bring up the values in Grafana?

      ...looking forward to reading your answers

      posted in General Discussion
      J
      JeeLet
    • RE: systemctl et MyController

      it's maximum super good 👍

      after cleaning the old one

      "sudo systemctl revert mycontroller.service"
      

      and a copy of the example you gave me (thanks)

         "sudo systemctl enable mycontroller.service"
      

      a reboot, functional server connection 😎

      ... well I continue with MyController, other things to see.

      Thanks a lot, lots of sunshine for you
      🤸

      posted in General Discussion
      J
      JeeLet
    • RE: systemctl et MyController

      yes it works fine
      it asks me the password.

      so I just have to add a timeout in the file, or even better check the start of influxdb ?

      @odroidc2:~$ systemctl stop mycontroller
      ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
      Authentification requise pour arrêter « mycontroller.service ».
      Authenticating as: ... "..name"
      Password: 
      ==== AUTHENTICATION COMPLETE ===
      
      @odroidc2:~$ systemctl start mycontroller
      ==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
      Authentification requise pour démarrer « mycontroller.service ».
      Authenticating as: ...."name"
      Password: 
      ==== AUTHENTICATION COMPLETE ===
      
      

      test

      
      [Unit]
      Requires=influxdb@client.service
      After=influxdb@client.service
      
      

      ?????

      posted in General Discussion
      J
      JeeLet
    • RE: systemctl et MyController

      manual launch

      .....@odroidc2:~$ sudo /opt/apps/mycontroller/mcctl.sh start
      [sudo] Mot de passe de "name" : 
      start command issued to the MyController server
      

      SERVICE STATUS

      ... @odroidc2:~$ systemctl status mycontroller 
      ● mycontroller.service - MyController V2
         Loaded: loaded (/lib/systemd/system/mycontroller.service; enabled; vendor preset: enabled)
         Active: active (exited) since Wed 2022-11-09 09:17:05 CET; 20min ago
        Process: 1694 ExecStart=/bin/bash /opt/apps/mycontroller/mcctl.sh start (code=exited, status=0/SUCCESS)
       Main PID: 1694 (code=exited, status=0/SUCCESS)
          Tasks: 0 (limit: 1992)
         Memory: 20.1M
         CGroup: /system.slice/mycontroller.service
      
      nov. 09 09:17:05 odroidc2 systemd[1]: Starting MyController V2...
      nov. 09 09:17:05 odroidc2 bash[1694]: start command issued to the MyController server
      nov. 09 09:17:05 odroidc2 systemd[1]: Started MyController V2.
      

      ACCESS MYCONTROLLER SERVER

      ...  @odroidc2:~$  curl http://localhost:8080/api/status -v 
      
      * Expire in 0 ms for 6 (transfer 0xaaaae49aad60)
      * Expire in 1 ms for 1 (transfer 0xaaaae49aad60)
      .....
      ...
      * Expire in 1 ms for 1 (transfer 0xaaaae49aad60)
      * Expire in 1 ms for 1 (transfer 0xaaaae49aad60)
      *   Trying ::1...
      * TCP_NODELAY set
      * Expire in 149998 ms for 3 (transfer 0xaaaae49aad60)
      * Expire in 200 ms for 4 (transfer 0xaaaae49aad60)
      * Connected to localhost (::1) port 8080 (#0)
      > GET /api/status HTTP/1.1
      > Host: localhost:8080
      > User-Agent: curl/7.64.0
      > Accept: */*
      > 
      < HTTP/1.1 200 OK
      < Content-Type: application/json
      < Vary: Accept-Encoding
      < Vary: Origin
      < Date: Wed, 09 Nov 2022 08:39:05 GMT
      < Content-Length: 313
      < 
      * Connection #0 to host localhost left intact
      {"hostname":"","documentationUrl":"","login":{"message":"Default username and password to login: \u003cb\u003eadmin\u003c/b\u003e / \u003cb\u003eadmin\u003c/b\u003e","serverMessage":""},"startTime":"0001-01-01T00:00:00Z","serverTime":"0001-01-01T00:00:00Z","uptime":0,"metricsDBDisabled":false,"language":"en_GB"}mci@odroidc2:~$ 
      
      

      VERIFY MYCONTROLLER SERVER IS RUNNING

      ..... @odroidc2:~$ ps -ef | grep mycontroller 
      root      2624     1  1 09:37 pts/0    00:00:03 ./mycontroller-server -config ./mycontroller.yaml
      mci       2646  2593  0 09:41 pts/0    00:00:00 grep mycontroller
      
      ....@odroidc2:~$ tail -f /opt/apps/mycontroller/logs/mycontroller.log 
      2022-11-09T09:37:14.195+0100	info	gateway/service.go:35	starting a gateway	{"id": "GwRs485"}
      2022-11-09T09:37:14.196+0100	info	protocol_serial/client.go:63	opening a serial port	{"gateway": "GwRs485", "port": "/dev/ttyACM0"}
      2022-11-09T09:37:14.203+0100	info	handler/handler.go:106	secure share directory included	{"directory": "mc_home/secure_share", "handlerPath": "/secure_share"}
      2022-11-09T09:37:14.203+0100	info	handler/handler.go:111	insecure share directory included	{"directory": "mc_home/insecure_share", "handlerPath": "/insecure_share"}
      2022-11-09T09:37:14.203+0100	info	listener/listener.go:32	web console direcory location	{"web_directory": "web_console"}
      2022-11-09T09:37:14.203+0100	info	gateway/service.go:48	started a gateway	{"id": "GwRs485", "timeTaken": "8.465971ms"}
      2022-11-09T09:37:14.204+0100	info	listener/listener.go:64	listening HTTPS/SSL service on	{"address": "0.0.0.0:8443"}
      2022-11-09T09:37:14.204+0100	info	listener/listener.go:44	listening HTTP service on	{"address": "0.0.0.0:8080"}
      2022-11-09T09:37:14.204+0100	info	gateway/service.go:35	starting a gateway	{"id": "OdroidC2"}
      2022-11-09T09:37:14.439+0100	info	gateway/service.go:48	started a gateway	{"id": "OdroidC2", "timeTaken": "234.218179ms"}
      
      
      posted in General Discussion
      J
      JeeLet
    • RE: systemctl et MyController

      .... jkandasa thanks for the help
      here are the messages in two parts

      • reboot of the system for an automatic launch of MyC
      • and manual launch with the command line
      browser logout:  This site can’t be reached192.16xxxx refused to connect.
      

      SERVICE STATUS

      ...@odroidc2:~$ systemctl status mycontroller 
      ● mycontroller.service - MyController V2
         Loaded: loaded (/lib/systemd/system/mycontroller.service; enabled; vendor pre
         Active: active (exited) since Wed 2022-11-09 09:17:05 CET; 14min ago
        Process: 1694 ExecStart=/bin/bash /opt/apps/mycontroller/mcctl.sh start (code=
       Main PID: 1694 (code=exited, status=0/SUCCESS)
          Tasks: 0 (limit: 1992)
         Memory: 20.1M
         CGroup: /system.slice/mycontroller.service
      
      nov. 09 09:17:05 odroidc2 systemd[1]: Starting MyController V2...
      nov. 09 09:17:05 odroidc2 bash[1694]: start command issued to the MyController s
      nov. 09 09:17:05 odroidc2 systemd[1]: Started MyController V2.
      

      ACCESS MYCONTROLLER SERVER

      ...@odroidc2:~$ curl http://localhost:8080/api/status -v 
      * Expire in 0 ms for 6 (transfer 0xaaaadeeb5d60)
      * Expire in 1 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 0 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 2 ms for 1 (transfer 0xaaaadeeb5d60)
      * Ex......
      ...........
       .........ransfer 0xaaaadeeb5d60)
      * Expire in 2 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 0 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 0 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 2 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 1 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 1 ms for 1 (transfer 0xaaaadeeb5d60)
      * Expire in 1 ms for 1 (transfer 0xaaaadeeb5d60)
      *   Trying ::1...
      * TCP_NODELAY set
      * Expire in 149998 ms for 3 (transfer 0xaaaadeeb5d60)
      * Expire in 200 ms for 4 (transfer 0xaaaadeeb5d60)
      * connect to ::1 port 8080 failed: Connexion refusée
      *   Trying 127.0.0.1...
      * TCP_NODELAY set
      * Expire in 149997 ms for 3 (transfer 0xaaaadeeb5d60)
      * connect to 127.0.0.1 port 8080 failed: Connexion refusée
      * Failed to connect to localhost port 8080: Connexion refusée
      * Closing connection 0
      curl: (7) Failed to connect to localhost port 8080: Connexion refusée
      

      VERIFY MYCONTROLLER SERVER IS RUNNING

      ... @odroidc2:~$ ps -ef | grep mycontroller 
      
      "name"       2609  2593  0 09:35 pts/0    00:00:00 grep mycontroller
      
      ... @odroidc2:~$ tail -f /opt/apps/mycontroller/logs/mycontroller.log 
      
      2022-11-09T09:24:15.244+0100	info	gateway/service.go:35	starting a gateway	{"id": "GwRs485"}
      2022-11-09T09:24:15.245+0100	info	protocol_serial/client.go:63	opening a serial port	{"gateway": "GwRs485", "port": "/dev/ttyACM0"}
      2022-11-09T09:24:15.245+0100	error	provider/service.go:86	error	{"error": "open /dev/ttyACM0: no such file or directory"}
      2022-11-09T09:24:15.245+0100	error	gateway/service.go:44	failed to start a gateway	{"id": "GwRs485", "timeTaken": "1.771339ms", "error": "open /dev/ttyACM0: no such file or directory"}
      2022-11-09T09:17:05.711+0100	info	logger/load.go:15	welcome to the MyController world :)
      2022-11-09T09:17:05.733+0100	info	mcbus/client.go:48	bus service paused
      2022-11-09T09:17:05.736+0100	info	backup/restore.go:149	Executing import job	{"sourceDir": "mc_home/data/storage/memory_db/yaml", "fileType": "yaml"}
      2022-11-09T09:17:06.083+0100	info	mcbus/client.go:54	bus service resumed
      2022-11-09T09:17:06.099+0100	error	influxdb_v2/client.go:206	error on getting ping status	{"error": "Get \"http://127.0.0.1:8086/ping\": dial tcp 127.0.0.1:8086: connect: connection refused"}
      2022-11-09T09:17:06.099+0100	fatal	server/start.go:39	error on init metric database	{"error": "Get \"http://127.0.0.1:8086/ping\": dial tcp 127.0.0.1:8086: connect: connection refused"}
      
      posted in General Discussion
      J
      JeeLet