Skip to Content

Changes for page 2 Script

Last modified by Devin Chen on 2025/06/06 14:03
From version 60.1
edited by Theodore Xu
on 2023/08/24 17:17
Change comment: There is no comment for this version
To version 62.1
edited by Theodore Xu
on 2023/08/24 17:27
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -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  
... ... @@ -1481,3 +1481,67 @@
1481 1481  Get message in AWS
1482 1482  
1483 1483  [[image:image-20220709165402-21.png]]
1484 +
1485 += **2.7 Mysql** =
1486 +
1487 +
1488 +
1489 +=== 1.Install Mysql software ===
1490 +
1491 +Download the latest version of Mysql.
1492 +
1493 +(% style="text-align:center" %)
1494 +[[image:Mysql的软件版本.png||height="673" width="894"]]
1495 +
1496 +=== 2.Navicat connect Mysql ===
1497 +
1498 +Connecting to Mysql with navicat.
1499 +
1500 +(% style="text-align:center" %)
1501 +[[image:连接到mysql.png]]
1502 +
1503 +=== 3.Create a database ===
1504 +
1505 +Character set should be choose utf8mb3/utf8mb4 and Collation choose utf8mb3_danish_ci/utf8mb4_danish_ci.
1506 +
1507 +(% style="text-align:center" %)
1508 +[[image:创建数据库.png||height="585" width="818"]]
1509 +
1510 +=== 4.Create a data table ===
1511 +
1512 +Create a table, enter the fields you need.
1513 +
1514 +(% style="text-align:center" %)
1515 +[[image:创建表1.png||height="484" width="737"]]
1516 +
1517 +Save, enter table name.
1518 +
1519 +(% style="text-align:center" %)
1520 +[[image:创建表2.png]]
1521 +
1522 +=== 5.Input Table Data ===
1523 +
1524 +(% style="text-align:center" %)
1525 +[[image:输入或者导入数据.png]]
1526 +
1527 +=== 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]]** ===
1528 +
1529 +(% style="text-align:center" %)
1530 +[[image:调试结果.png]]
1531 +
1532 +=== 7.Problem ===
1533 +
1534 +During our debugging process it may there are some problems about Mysql， such as
1535 +
1536 +* MySQL: Host  192.168.XXX.XXX  is not allowed to connect.
1537 +* MySQL: Host  192.168.XXX.XXX  is blocked because of many connection errors.
1538 +* MySQL: SSL connection error: unknown error number.
1539 +* (((
1540 +1449-The user specified as a definer(‘mysql.infoschema‘@localhost‘) does not exist.
1541 +)))
1542 +
1543 +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.
1544 +
1545 +{{info}}
1546 +✎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.
1547 +{{/info}}