Skip to Content

Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03
From version 58.1
edited by Theodore Xu
on 2023/08/24 17:13
Change comment: There is no comment for this version
To version 68.1
edited by Theodore Xu
on 2023/08/25 09:29
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,9 +1,9 @@
1 1  = **1 General Script Demo** =
2 2  
3 -== **1.1 Address Operation:Write/Read data from address A to B** ==
3 +== **1.1 Address Operation** ==
4 4  
5 5  (((
6 -For example:transfer D2 to D0
6 +Write/Read data from address A to B**. **For example:transfer D2 to D0
7 7  )))
8 8  
9 9  (% style="text-align:center" %)
... ... @@ -343,7 +343,7 @@
343 343  end
344 344  {{/code}}
345 345  
346 -== **1.8 How to parse value from HTTP response body** ==
346 +== **1.8 HTTP response body** ==
347 347  
348 348  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":
349 349  
... ... @@ -1071,10 +1071,8 @@
1071 1071  (% style="text-align:center" %)
1072 1072  [[image:1624441186851-536.png||height="434" width="700" class="img-thumbnail"]]
1073 1073  
1074 -== **2.5 Huawei platform** ==
1074 +=== Huawei by SSL certification. ===
1075 1075  
1076 -In this demo,V-Box connects with Huawei by SSL certification.
1077 -
1078 1078  1.Create a project access for Huawei IOT
1079 1079  
1080 1080  2.configure MQTT configuration
... ... @@ -1483,3 +1483,65 @@
1483 1483  Get message in AWS
1484 1484  
1485 1485  [[image:image-20220709165402-21.png]]
1484 +
1485 +== **2.7 Mysql** ==
1486 +
1487 +=== 1.Install Mysql software ===
1488 +
1489 +Download the latest version of Mysql.
1490 +
1491 +(% style="text-align:center" %)
1492 +[[image:Mysql的软件版本.png]]
1493 +
1494 +=== 2.Navicat connect Mysql ===
1495 +
1496 +Connecting to Mysql with navicat.
1497 +
1498 +(% style="text-align:center" %)
1499 +[[image:连接到mysql.png]]
1500 +
1501 +=== 3.Create a database ===
1502 +
1503 +Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
1504 +
1505 +(% style="text-align:center" %)
1506 +[[image:创建数据库.png]]
1507 +
1508 +=== 4.Create a data table ===
1509 +
1510 +Create a table, enter the fields you need.
1511 +
1512 +(% style="text-align:center" %)
1513 +[[image:创建表1.png]]
1514 +
1515 +Save, enter table name.
1516 +
1517 +(% style="text-align:center" %)
1518 +[[image:创建表2.png]]
1519 +
1520 +=== 5.Input Table Data ===
1521 +
1522 +(% style="text-align:center" %)
1523 +[[image:输入或者导入数据.png]]
1524 +
1525 +=== 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]]** ===
1526 +
1527 +(% style="text-align:center" %)
1528 +[[image:调试结果.png]]
1529 +
1530 +=== 7.Problem ===
1531 +
1532 +During our debugging process it may there are some problems about Mysql， such as
1533 +
1534 +* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
1535 +* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
1536 +* MySQL: SSL connection error: unknown error number.
1537 +* (((
1538 +1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
1539 +)))
1540 +
1541 +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.
1542 +
1543 +{{info}}
1544 +✎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.
1545 +{{/info}}
Mysql的软件版本.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +78.4 KB
Content
创建数据库.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +53.2 KB
Content
创建表1.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +49.0 KB
Content
创建表2.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +18.4 KB
Content
调试结果.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +68.4 KB
Content
输入或者导入数据.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +26.6 KB
Content
连接到mysql.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +59.0 KB
Content
连接数据库1.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +56.5 KB
Content
连接数据库2.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.AiXia
Size
... ... @@ -1,0 +1,1 @@
1 +25.5 KB
Content