Posts made by JeeLet

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

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 !?

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)

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 ???

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.

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

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

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

.... 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  ");
  }

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 ?

"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

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?

... 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

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

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

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

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

?????

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"}

.... 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"}