Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03

From 48.1 to 49.1 From 66.1 to 67.1

From version 49.1

edited by Hunter
on 2023/05/06 10:09

Change comment: There is no comment for this version

To version 66.1

edited by Theodore Xu
on 2023/08/25 09:17

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

@@ -1,1 +1,1 @@
--XWiki.Hunter
++XWiki.AiXia

Content

@@ -1,9 +1,9 @@
  = **1 General Script Demo** =
--== **1.1 Address Operation:Write/Read data from address A to B** ==
++== **1.1 Address Operation** ==
  (((
--For example:transfer D2 to D0
++Write/Read data from address A to B**. **For example:transfer D2 to D0
  )))
  (% style="text-align:center" %)
@@ -27,25 +27,19 @@
  == **1.4 Short message** ==
--When the alarm condition is reached: temp1 > 5 & temp2 >10 & temp3 < 20(lasts more than 5 seconds) , then send an "alarm trigger" sms.
++The following demo shows that when the alarm condition is reached: temp1 > 5 & temp2 >10 & temp3 < 20(lasts more than 5 seconds) , then send an "alarm trigger" sms.
--When the alarm condition is released，then send an "alarm release" sms.
++When the alarm condition is released，then send an  "alarm release" sms. Script is as below:
--(% style="text-align:center" %)
--[[image:1645535936750-316.png||height="385" width="400" class="img-thumbnail"]]
--
--Script is as below:
--
--(% class="box infomessage" %)
--(((
++{{code language="lua"}}
  function sms.main()
--~-~-~-~-~-~-send condition~-~-~-~-~-~-
++------send condition------
  local temp1 = addr_getword("@Temperature1")
  local temp2 = addr_getword("@Temperature2")
  local temp3 = addr_getword("@Temperature3")
  local timer = addr_getword("@Timer")
  local tag = addr_getbit("@Tag")
--~-~-~-~-~-~-lasting time~-~-~-~-~-~-
++------lasting time------
  if temp1 > 5 and temp2 > 10 and temp3 < 20 then
      timer = timer + 1
      addr_setword("@Timer",timer)
@@ -53,7 +53,7 @@
      timer = 0
      addr_setword("@Timer",timer)
  end
--~-~-~-~-~-~-send sms & output Y0~-~-~-~-~-~-
++------send sms & output Y0------
  if timer > 5 then
      if tag == 0 then
          send_sms_ira("19859254700","alarm trigger")
@@ -64,7 +64,7 @@
  addr_setbit("@Tag",0)
  end
  end
--)))
++{{/code}}
  == **1.5 Telegram notification** ==
@@ -145,7 +145,7 @@
  This example shows how to use the LINE Notify to send message into LINE group. When monitoring bit "@test" changes, it will trigger and send the message. Please replace with your own Token.
--{{code}}
++{{code language="lua"}}
  local tempBit = 0
  local tempWord = 0
@@ -349,7 +349,7 @@
  end
  {{/code}}
--== **1.8 How to parse value from HTTP response body** ==
++== **1.8 HTTP response body** ==
  This example use [[https:~~/~~/www.weatherapi.com/>>https://www.weatherapi.com/]] as example, to show how to parse value from HTTP response body. When we input the city name into address "@HDW5050":
@@ -478,7 +478,7 @@
  end
  {{/code}}
--= **2 V-Box connect with third part server** =
++= **2 Third part server** =
  V-Box have two mode.One is for V-Net,User need to use WECON server to store data.We call this V-NET platform.
@@ -503,7 +503,7 @@
  (% class="wikigeneratedid" %)
  Tool link: **[[MQTT.fx>>http://mqttfx.jensd.de/index.php/download]]**
--== **2.1 V-Box connect with test server(General Example)** ==
++== **2.1 Test server(General Example)** ==
  The following example is trying to publish to the topic "testtopic/test/no1/7890", and subscribe the topic "testtopic/test/no1/123456".
@@ -527,6 +527,7 @@
  {{code language="lua"}}
  --MQTT configuration table
  local MQTT_CFG={}
++--if there is no need the username and password, please put them as ""
  MQTT_CFG.username = "weconsupport"
  MQTT_CFG.password = "123456"
  MQTT_CFG.netway = 0
@@ -566,7 +566,7 @@
  function mqtt_init()
      print(string.format("mqtt init mqtt_url:%s mqtt_clientid:%s", MQTT_URL, MQTT_CLIENT_ID))
      if g_mq then
--        mqtt.close() --Close mqtt object
++        mqtt.close(g_mq) --Close mqtt object
      end
      g_mq, err = mqtt.create(MQTT_URL, MQTT_CLIENT_ID) -- create mqtt object,and declare it as a global variable
      if g_mq then
@@ -651,7 +651,7 @@
  end
  {{/code}}
--== **2.2 V-Box connect with customer server:grouprobotinfo.com** ==
++== **2.2 Customer server:grouprobotinfo.com** ==
  This demo does not use SSL certification. Script is as below
@@ -792,7 +792,7 @@
  end
  {{/code}}
--== **2.3 V-Box connect with Azure platform** ==
++== **2.3 Azure platform** ==
  In this demo,V-Box connects with Azure by SSL certification.
@@ -923,8 +923,12 @@
  end
  )))
--== **2.4 How to configure the Huawei platform?（✎Note: Huawei IOT DA function is only in China area.If you want this function,you need to use chinese mobile to register）** ==
++== **2.4 Huawei platform** ==
++{{info}}
++**✎Note**:**Huawei IOT DA function is only in China area.If you want this function,you need to use chinese mobile to register**
++{{/info}}
++
 .Register a account: [[https:~~/~~/www.huaweicloud.com/intl/en-us/s/JUlPVERNJQ>>https://www.huaweicloud.com/intl/en-us/s/JUlPVERNJQ]]
 .log in the Huawei IOTDA
@@ -1072,10 +1072,8 @@
  (% style="text-align:center" %)
  [[image:1624441186851-536.png||height="434" width="700" class="img-thumbnail"]]
--== **2.5 V-Box connect with Huawei platform** ==
++=== Huawei by SSL certification. ===
--In this demo,V-Box connects with Huawei by SSL certification.
--
 .Create a project access for Huawei IOT
 .configure MQTT configuration
@@ -1193,7 +1193,7 @@
  (% style="text-align:center" %)
  [[image:1624506666650-161.png||height="547" width="1000" class="img-thumbnail"]]
--== **2.6 V-Box connect with AWS platform** ==
++== **2.6 AWS platform** ==
  === **Log in AWS** ===
@@ -1258,7 +1258,7 @@
  [[image:image-20220709165402-11.png]]
--=== **Test with MQTT.fx tool** ===
++=== **MQTT.fx tool** ===
  Click “View Setting” to get the “Broker Adress”
@@ -1286,7 +1286,7 @@
  [[image:image-20220709165402-18.png]]
--=== **Configurate in CloudTool** ===
++=== **CloudTool** ===
  Copy the same setting in MQTT.fx to MQTT configuration
@@ -1484,3 +1484,67 @@
  Get message in AWS
  [[image:image-20220709165402-21.png]]
++
++== **2.7 Mysql** ==
++
++
++
++=== 1.Install Mysql software ===
++
++Download the latest version of Mysql.
++
++(% style="text-align:center" %)
++[[image:Mysql的软件版本.png||height="673" width="894"]]
++
++=== 2.Navicat connect Mysql ===
++
++Connecting to Mysql with navicat.
++
++(% style="text-align:center" %)
++[[image:How to connect MYSQL with V-Box@连接到mysql.png]]
++
++=== 3.Create a database ===
++
++Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
++
++(% style="text-align:center" %)
++[[image:How to connect MYSQL with V-Box@创建数据库.png||height="585" width="818"]]
++
++=== 4.Create a data table ===
++
++Create a table, enter the fields you need.
++
++(% style="text-align:center" %)
++[[image:创建表1.png||height="484" width="737"]]
++
++Save, enter table name.
++
++(% style="text-align:center" %)
++[[image:创建表2.png]]
++
++=== 5.Input Table Data ===
++
++(% style="text-align:center" %)
++[[image:输入或者导入数据.png]]
++
++=== 6.Modifying scripts and debug：**[[Mysql script>>https://docs.we-con.com.cn/bin/view/V-BOX/V-Net/Manual/04%20Lua%20Script/01%20Lua%20Functions/\#H11MySQLdatabaseoperation]]** ===
++
++(% style="text-align:center" %)
++[[image:调试结果.png]]
++
++=== 7.Problem ===
++
++During our debugging process it may there are some problems about Mysql， such as
++
++* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
++* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
++* MySQL: SSL connection error: unknown error number.
++* (((
++1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
++)))
++
++This type of problem has nothing to do with scripts or devices, it is a Mysql configuration issue. If you have any of these problems, please look for a solution online.
++
++{{info}}
++✎Note: If you want to use CMD to access Mysql, you need to add the bin file to the environment variable, please check online for details of the operation.
++{{/info}}

Changes for page 2 Script

Summary

Details

Navigation

Table of Contents