+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: integration mysql - Wiser (/showthread.php?tid=5195)
integration mysql - Wiser - DannyVolkaerts - 08.01.2024
Hi,
I hope it's ok to post a question about the Schneider Wiser for KNX server since it seems more or less the same as LogicMachine.
I would like to enable a Lua script which writes some object logs to a mysql database which I activated and is accessible on localhost.
The script starts with following package import:
Code:
luasql = require "luasql.mysql"My question:
How can I install the package on Wiser? It seems there is no terminal available after login.
Thank you for your help!
Regards,
Danny
RE: integration mysql - Wiser - Daniel - 08.01.2024
It was SE decision to remove package installer on SE devices. It is possible only on LM.
RE: integration mysql - Wiser - DannyVolkaerts - 08.01.2024
(08.01.2024, 16:56)Daniel Wrote: It was SE decision to remove package installer on SE devices. It is possible only on LM.
Thank you Daniel for your fast response.
Is there any other efficient way on how to extract the logs automatically (cronjob?) from Wiser?
Best regards
RE: integration mysql - Wiser - Daniel - 09.01.2024
Object logs can be exported to csv.
https://kb.logicmachine.net/scripting/export-last-hour-csv/
RE: integration mysql - Wiser - DannyVolkaerts - 09.01.2024
(09.01.2024, 08:36)Daniel Wrote: Object logs can be exported to csv.
https://kb.logicmachine.net/scripting/export-last-hour-csv/
Hi Daniel,
Thank you for the link. I will look into it.
Indeed I have seen configuration options for FTP in the System settings of Wiser.
I will let you know if I have issues on that.
Thank you again!
D