Wireless Kev co thiab Kub Sensor Cov Ntaub Ntawv rau MySQL Siv Node-RED: 40 Cov Kauj Ruam

2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:26

Qhia NCD's Long Range IoT Industrial wireless kev co thiab ntsuas kub, khav txog li 2-mais ntau qhov kev siv cov wireless sib txuas sib txuas qauv. Kev koom nrog qhov tseeb 16-ntsis kev co thiab ntsuas kub, cov cuab yeej no xa tawm qhov tsis txaus ntseeg zoo heev thiab cov ntaub ntawv ntsuas kub ntawm cov neeg siv piav qhia ntev.

Kauj ruam 1: Kho vajtse thiab Software xav tau

Kho vajtse:

NCD Ntev Ntau Yam Kev co thiab Kub Sensor

NCD Ntev Ntau Yam Wireless Mesh Modem nrog USB Interface

Software:

Node-Liab

XAMPP

Kauj Ruam 2: Teeb XAMPP

XAMPP yog qhov tseem ceeb tshaj plaws, pub dawb qhib-qhov chaw hla-platform uas yog ib qho kev daws teeb meem los khiav koj cov kev pabcuam web. XAMPP yog tsim los ntawm ApacheFriends uas tau tso tawm rau lub Tsib Hlis 2002. XAMPP Sawv Cev rau Hla-Platform (X), Apache (A), MySQL (M) kuj Qee zaum (M) hais txog MariaDB, PHP (P) thiab Pearl (P).

XAMPP tso cai rau koj ua haujlwm ntawm ib tus neeg rau zaub mov hauv nroog thiab sim cov ntawv luam hauv zos ntawm cov vev xaib siv PHP code thiab MySQL databases. Thaum XAMPP tau ua haujlwm, koj tuaj yeem nkag mus rau koj daim ntawv hauv zos nrog lub browser siv URL zoo li https:// localhost/lossis https:// localhost/

Rub tawm thiab Txhim Kho

XAMPP Mus rau XAMPP lub vev xaib thiab rub tawm lub installer raws li koj lub operating system. Kev teeb tsa yuav tsum zoo ib yam li kev teeb tsa software ib txwm koj ua hauv koj lub operating system. Thaum txhim kho, yuav muaj kev xaiv los xaiv seb koj puas xav khiav Apache thiab MySQL li kev pabcuam. Yog tias koj xaiv nws, Apache thiab MySQL yuav pib ntawm qhov system boot-up uas yuav tsis xav tau yog tias koj lub khoos phis tawj nruj nrog cov peev txheej nco lossis yog tias koj tsis ua PHP kev txhim kho nquag. Koj tuaj yeem hloov cov chaw no tom qab teeb tsa.

Kauj Ruam 3: Pib Apache thiab MySQL

Mus rau qhov chaw uas koj tau teeb tsa XAMPP (feem ntau yog C: / Program Files / xampp) thiab ob npaug nias rau XAMPP Tswj Vaj Huam Sib Luag (xampp-control.exe). Qhov no yuav coj koj lub vijtsam hauv qab no. Nyem rau Pib khawm tom ntej ntawm Apache thiab MySQL rau pib lawv.

Kauj Ruam 4: Tam sim no Qhib Koj Tus browser thiab Ntaus Http: // localhost/lossis

Kauj Ruam 5: Qhov no Yuav Qhib Ib Nplooj Ntawv Hauv Qab No. Nyem rau ntawm PhpMyAdmin

Kauj Ruam 6: Qhov no Yuav Coj Koj Mus Hauv Qab Qhov screen. Tam sim no Nyem rau ntawm lub pob "Tshiab" Raws li qhia hauv daim duab hauv qab no los Tsim Tus Qauv Tshiab

Kauj Ruam 7: Tam sim no Tsim Cov Ntaub Ntawv Tshiab Raws Li Qhia hauv Daim Duab hauv qab no

Kauj Ruam 8: Tam sim no Tsim Lub Rooj kom pom cov ntaub ntawv raws li qhia hauv daim duab hauv qab no

Kauj Ruam 9: Tam sim no Npe Thawj Kab Raws li "id"

Kauj Ruam 10: Tam sim no scroll mus rau sab xis ntawm lub Vijtsam Koj Yuav Pom "A_I Comments" I.e. Nws pib nce ntxiv thiab Nws tau siv teeb tsa Tus Thawj Ntsiab Tseem Ceeb uas Cim Cim Rau Txhua Cov Ntaub Ntawv Hauv Cov Lus. Nyem rau ntawm lub npov hauv qab Nws

Kauj Ruam 11: Qhov no Yuav Nqa Koj Tom Ntej Screen. Tam sim no Nyem rau ntawm "Mus" Khawm

Kauj Ruam 12: Tam sim no Nkag mus rau qhov muaj txiaj ntsig ntawm Lwm Kab

Lub npe = rms_x, Hom = DECIMAL, Ntev/Qhov muaj nuj nqis = 10, 2 (piv txwv li txog 2 lub zauv zauv zauv) thiab zoo ib yam rau txhua lwm qhov txiaj ntsig thiab hauv kab lus kawg, koj tuaj yeem pom lub sijhawm tsim thiab nyem rau ntawm lub pob txuag raws li qhia hauv daim duab hauv qab no.

Kauj Ruam 13: Tam sim no Nyem rau ntawm koj lub npe Database kom nthuav dav nws thiab nws yuav qhia koj lub npe lub npe, Tom qab ntawv nyem rau nws kom pom li cas Cov Ntaub Ntawv Qhia, Raws li tau qhia hauv daim duab hauv qab no

Qhov ntawd yog txhua yam nrog kev teeb tsa XAMPP.

Kauj Ruam 14: Teeb Node-liab

Tam sim no koj muaj cov ntsuas ntsuas ua haujlwm, peb xav tau txoj hauv kev los ua qee yam muaj txiaj ntsig nrog cov ntaub ntawv ntawd.

• Ua ntej tshaj plaws, koj yuav tsum teeb tsa Node-Red.
• Thaum ua tiav qhov no, koj yuav tsum nkag mus rau koj kab lus hais kom ua, lossis Lub Hwj Chim Lub Hwj Chim rau Windows cov neeg siv, taug kev mus rau cov npe Node-RED tau teeb tsa.
• Tam sim no ntaus "npm i ncd-red-wireless node-red-dashboard". Qhov no yuav teeb tsa cov node xav tau kom tau txais cov ntaub ntawv los ntawm koj lub wireless sensors thiab koj tuaj yeem pib Node-RED thaum qhov no ua tiav.
• Txhawm rau pib node server sau node-liab hauv qhov hais kom ua lossis davhlau ya nyob twg thiab nias nkag mus.

Kauj Ruam 15: Cov Kauj Ruam los Tsim Cov Dej

Txog ntawm qhov no koj yuav pom qhov khoob loj nrog cov npe ntev ntawm cov nodes nyob rau sab laug, sab tes no hu ua palette.

Kauj Ruam 16: Mus Ua Ntej thiab Luag Lub Wireless Gateway Node Tshaj rau Koj Cov Canvas Flow kom Pib

ncd-liab-wireless Muab cov nodes uas tswj kev sib txuas, txheeb xyuas cov ntaub ntawv nkag khoom, lim nws los ntawm qhov tshwj xeeb, thiab tso cai rau koj teeb tsa lub wireless sensors

Kauj Ruam 17: Nrhiav Koj Li Wireless Sensors:

Thaum koj tau xa cov node koj yuav tuaj yeem pom cov ntaub ntawv tab, uas muaj cov ntaub ntawv hais txog ntawm lub peev xwm muaj peev xwm, lub tab no tau muaj neeg nyob zoo rau qhov siab tshaj plaws ntawm cov pob liab thiab muaj cov txheeb cais muaj txiaj ntsig, feem ntau koj yuav tam sim no tsis xav tau txhawm rau saib lwm cov ntaub ntawv sab nraum ntawm cov ntaub ntawv tab, yog li tuav nws hauv kev xav txawm tias koj tab tom tsim koj cov dej ntws thaum koj muaj lus nug kwv yees li cas ntawm cov node ua haujlwm. Lub ntsiab lus tom ntej peb xav ua yog teeb tsa lub node, thaum koj thawj zaug ntxiv nws koj yuav nco ntsoov tias muaj daim duab peb sab me me nyob rau ntawm kaum sab xis saum toj ntawm lub cim xiav, daim duab peb sab qhia tias lub hauv paus xav tau kev teeb tsa ntxiv, xiav dot qhia tias lub node tsis muaj lawm tab sis tau muab tso ua ib feem ntawm qhov ntws.

• Nyem ob npaug rau ntawm qhov kom qhib qhov kev xaiv teeb tsa.
• Nyem rau ntawm tus xaum cim nyob ib sab ntawm Serial Device teb txhawm rau teeb tsa koj lub USB router, qhov no yuav qhib lub rooj teeb tsa thib ob uas tsuas muaj qee qhov kev xaiv.

Kauj Ruam 18: Nyem rau ntawm lub iav tsom iav tom ntej ntawm Serial Port Field thiab Xaiv Chaw Nres Nkoj uas Sib Raug Zoo Nrog Koj Lub Router, Tom qab ntawd nyem rau "Ntxiv" Khawm rau saum

Kauj Ruam 19: Cov Khoom Siv Hauv Ntej Yuav Tam Sim No Muaj Neeg Nyob Raws Li Qhov Xaiv, thiab Koj tuaj yeem Nyem "Ua tiav", Tam sim no koj muaj kev nkag ncaj qha rau koj lub Wireless Sensors! los Saib Cov Ntaub Ntawv Los Hauv

Kauj Ruam 20: Tam sim no rov qab mus rau koj lub Palette thiab ntaus "debug" rau hauv Chaw Tshawb Nrhiav nyob rau sab saum toj, Lob Ib qho ntawm Cov Nodes no thiab Drag Nws mus rau sab xis ntawm Koj Lub Rooj vag Wireless

Kauj ruam 21: Nyem ob npaug rau nws thiab hloov "msg." kom "ua tiav Msg Object" Nyem Ua tiav

Kauj Ruam 22: Tam sim no Kos Kab Kab Ntawm Ob Lub Nodes, thiab Nyem rau "Deploy" nyob rau sab xis saum toj ntawm lub qhov rais

Kauj Ruam 23: Ua Haujlwm Nrog Cov Ntaub Ntawv:

Tam sim no tawm ntawm koj cov wireless cov ntaub ntawv tau sib sau thiab nws tau tso tawm rau "debug" tab, qhov no "debug tab" tau muab tso rau hauv sab xis sab tom qab cov ntaub ntawv tab. Txhawm rau pom cov ntaub ntawv muaj nyob rau ntaus lub khawm pib dua. Hauv cov ntaub ntawv-liab cov ntaub ntawv tau dhau ntawm cov nodes hauv pob JSON. Thaum cov khoom msg tuaj rau hauv qhov debug tab koj tuaj yeem ua rau nws loj dua los saib cov npe tag nrho cov ntaub ntawv uas los nrog nws. Qhov no muaj txiaj ntsig tshwj xeeb hauv qhov xwm txheej koj yuav tsum tau pom sai sai uas cov sensors tau tshuaj xyuas hauv. ntawm lub node thiab cov cuab yeej yuav hloov mus rau lub network teeb tsa, ntaus nws ib zaug ntxiv kom rov qab mus rau hom mloog. Thaum peb tau txais cov cuab yeej wi-fi ntawm cov teeb tsa, lawv yuav raug teeb tsa ib txwm teeb tsa lub teeb tsa thaum nws nkag mus rau hauv kev teeb tsa hom, yog li nws ib txwm muaj los tswj xyuas cov rooj vag ntawm no tam sim no ntawm qhov nrawm rau teeb tsa lub cuab yeej.

Kauj Ruam 24: Ntxiv Cov Wireless Sensors:

Peb yuav tsum tau cais cov ntaub ntawv tsis siv lub tshuab hluav taws xob hauv tsev kom peb muaj peev xwm tso tawm nws, peb tuaj yeem siv qhov hloov pauv los cais tawm cov lus los ntawm lub qhov rooj raws li tag nrho ntawm mac chaw nyob nrog lossis hom sensor, tab sis raws li kuv hais txog, wireless nodes tiag tiag suav nrog kev ua haujlwm ntxiv rau teeb tsa cov cim, yog li peb yuav pib nrog lawv los muab koj cov duab ntxiv ntawm qhov uas cov qauv no tuaj yeem ua haujlwm li cas. Yog tias koj tseem tsis tau pom cov pob ntawv los ntawm ob qho ntawm koj lub ntsuas, hla ua ntej thiab ntaus lub pob pib dua ntawm qhov tsuas yog tsis tau pib. Thaum lub ntsuas ntsuas ntsuas los ntawm ib qho txheej txheem teeb tsa ntawm lub cuab yeej, qhov chaw nyob mac thiab hom kev ntsuas tau kaw rau hauv pas dej ua ke yog li peb tuaj yeem pom sai sai rau lub sijhawm ntawm cov kauj ruam tom ntej no.

Lob Wireless Node los ntawm lub palette thiab rub nws mus rau qhov ntws, ob npaug nias rau nws kom nws teeb tsa

Kauj Ruam 25: Xaiv Cov Khoom Siv Los Ntawm Qhov Tso Tawm Uas Koj Siv Rau Wireless Gateway, Tam sim no Nyem rau lub iav tsom iav tom ntej rau “Mac Chaw Nyob” thiab Xaiv Ib qho ntawm Cov Kev Xaiv Muaj

Kauj ruam 26: Nyem Ua tiav

Koj yuav pom qhov no cia li teeb tsa lub hom sensor rau koj, koj tseem tuaj yeem muab nws lub npe los ua kom yooj yim txheeb xyuas. Raws li tau sau tseg hauv cov ntaub ntawv tab, Serial Device for Config field yog nyob ntawm yeem, thiab peb yuav tsis txhawj txog nws tam sim no. Lub node koj nyuam qhuav ntxiv ua haujlwm tau zoo raws li lub lim ntawm cov ntaub ntawv sensor nkag, tsuas yog hla cov ntaub ntawv rau mac chaw nyob, lossis hom sensor yog tias tsis muaj mac chaw nyob.

Kauj Ruam 27: Tam sim no rov qab mus rau koj lub Palette thiab ntaus "debug" rau hauv Chaw Tshawb Nrhiav nyob rau Sab Saum Toj, Rub Ib qho ntawm Cov Nodes no thiab rub nws mus rau sab xis ntawm koj lub Wireless Gateway

Kauj ruam 28: Nyem ob npaug rau nws thiab Nyem Ua li cas

Kauj Ruam 29: Ntxiv Txoj Haujlwm Nodes

Txoj haujlwm ua haujlwm tau siv los khiav JavaScript code tiv thaiv cov khoom msg. Lub luag haujlwm ua haujlwm lees txais cov khoom msg raws li kev nkag thiab tuaj yeem xa rov qab 0 lossis ntau dua cov khoom lus raws li tso tawm. Cov lus xa xov no yuav tsum muaj cov peev txheej them (msg.payload) thiab feem ntau muaj lwm yam khoom nyob ntawm qhov ua raws.

Tam sim no lob tus "ua haujlwm" ntawm lub palette, thiab tso nws mus rau sab xis ntawm Temp/Hum node

Kauj Ruam 30: Ob Nyem Nyem rau ntawm Node kom Qhib Qhov Kev Xaiv Kho

Ntawm no koj yuav tsum sau me ntsis javascript code los tsim qhov xwm txheej, yog li ntawm tus nqi tshwj xeeb, email ceeb toom yuav xa mus rau tus lej email tshwj xeeb.

Koj tuaj yeem hloov kho qhov tseem ceeb raws li peb tus kheej.

rms_x = msg.payload.rms_xrms_y = msg.payload.rms_yrms_z = msg.payload.rms_zmax_x = msg.payload.max_xmax_y = msg.payload.max_ymax_z = msg.payload.max_zmin_x = msg.min_min = min msg.payload.min_ztemperature = msg.payload.temperaturemsg.topic = "INSERT INTO vibration_temperature (` rms_x`, `rms_y`,` rms_z`, `max_x`,` max_y`, `max_z`,` min_x`, `min_y`, `min_z`,` temperature`) VALUES ("+ rms_x+", "+ rms_y+", "+ rms_z+", "+ max_x+", "+ max_y+", "+ max_z+", "+ min_x +"," +min_y +"," +min_z +"," +kub +");" rov qab msg;

Kauj Ruam 31: Tam sim no Koj Muaj Ntxiv "mysql" Node kom Khaws Cov Ntaub Ntawv, Txheeb Xyuas Koj Cov Palette Yog Nws Muaj Tam Sim No Los Yog Koj Muaj Nyem Rau Ntawm Peb Lub Nroog Tam Sim No Sab Nrauv Sab Ntawm Kev Siv Lub Pob Raws Li Qhia hauv Duab hauv qab no

Kauj ruam 32: Tam sim no Nyem rau ntawm "Manage Palette" Khawm

Kauj Ruam 33: Tam Sim No Nrhiav Mysql thiab Nyem rau ntawm 'install' Button Raws li pom hauv daim duab

Thaum nws ua tiav, koj yuav pom "mysql" ntawm qhov tam sim no nyob hauv cov xim.

Kauj Ruam 34: Tam sim no Lob tus "mysql" Node From the Palette and Double Click on It to Open Up Configuration Options

Kauj Ruam 35: Sau Koj Lub Npe Database Raws Li Koj Tsim Ua Ntej thiab Muab Lub Npe Rau Nws, Tom qab ntawd Nyem rau ntawm Daim Duab Mem hluav Tom ntej no mus rau Database txhawm rau Kho Sqldatabase Node

Kauj Ruam 36: Tam sim no Ntxiv Tus Neeg Siv = Root I.e los ntawm Default hauv Xampp thiab Lo Lus zais Yog Npaum Li Cas. Koj kuj tseem tuaj yeem tsim Tus Neeg Siv thiab Tus Kheej nkag mus rau ntawm no, Tom qab ntawd Nkag Mus Rau Koj Lub Npe Lub Npe thiab Thaj Chaw Sijhawm (xaiv tau) thiab Tom qab ntawd Nyem Hloov Kho thiab Ua tiav