:::
1. 氣體感測器next
南工高瞻_資料傳輸課程

一、下載安裝MQTT

Mosquitto官網下載（mosquitto.org/download）

安裝是會出現以下訊息

二、取得三個必要的dll檔

主要是需另外下載三個dll檔

pthreadVC2.dll
libeay32.dll
ssleay32.dll

ftp://sourceware.org/pub/pthreads-win32/dll-latest/dll/x86/

可下載 pthreadVC2.dll (程式提供連結已無法連線)

http://slproweb.com/products/Win32OpenSSL.html

下載 Win32_OpenSSL_v1.0.2L_Light，32位元版本的OpenSSL安裝程式並執行它，最後設定畫面，選擇第二個，方便擷取dll檔。

可取得libeay32.dll、ssleay32.dll

三、將三個dll檔接複製到C:\Program Files (x86)\mosquitto

再重新安裝MQTT就不會有錯誤訊息了。

四、啟動Mosquitto伺服器

工具列按右鍵→工作管理員

工作管理員→服務→找到mosquitto按右鍵→啟動

五、檢查服務，開通防火牆

在命令提示字元執行netstat -an|find "1883"，確認服務已經啟動

新增防火牆規則，開通防火牆。

 

參考資料：https://swf.com.tw/?p=1005

1. 氣體感測器next

友善列印 & 下載 PDF 匯出 MarkDown 格式

搜尋

進階搜尋

錯誤訊息
未知: Array and string offset access syntax with curly braces is deprecated 在檔案中的第 /include/functions.encoding.php 列 40
未知: Array and string offset access syntax with curly braces is deprecated 在檔案中的第 /include/functions.encoding.php 列 40
未知: Array and string offset access syntax with curly braces is deprecated 在檔案中的第 /include/functions.encoding.php 列 73
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 505
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 119
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 505
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 119
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 119
未知: Function get_magic_quotes_gpc() is deprecated 在檔案中的第 /class/libraries/vendor/xoops/xmf/src/Request.php 列 119
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
警告: str_repeat(): Second argument has to be greater than or equal to 0 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined variable: disabled 在檔案中的第 /modules/tad_book3/function.php 列 818
通知: Undefined index: prev 在檔案中的第 /modules/tad_book3/page.php 列 58
通知: Undefined index: bootstrap 在檔案中的第 /modules/tadtools/preloads/core.php 列 68
已棄用
資料庫語法
0.000069 - SET SQL_BIG_SELECTS = 1
0.000682 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC
0.000320 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '4sfg3u76q03us193vmadgvjgmv'
0.000295 - SELECT * FROM modules WHERE dirname = 'tad_book3'
0.000542 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '9')
0.000300 - SELECT * FROM config WHERE (`conf_modid` = '9') ORDER BY conf_order ASC
0.000307 - select a.tbsn,a.title,b.author,a.category,a.page,a.paragraph,a.sort from tad_book3_docs as a left join tad_book3 as b on a.tbsn=b.tbsn where a.tbdsn='76'
0.000216 - SELECT tbsn,title FROM tad_book3 ORDER BY sort
0.000267 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC
0.000273 - SELECT COUNT(*) FROM banner
0.000202 - SELECT * FROM banner LIMIT 1, 1
0.004076 - UPDATE banner SET impmade = 1277919 WHERE bid = 2
0.000244 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC
0.001183 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3)
0.000849 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,9) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,18,15,16,20,19,58,60,61,73,72,74,71,76,75,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,111,109,110,112,113,114,115,116,117,118,119,120,121,122,123) ORDER BY b.weight, m.block_id
0.000572 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'system_block_search.tpl') ORDER BY tpl_refid
0.003610 - update tad_book3_docs set `count` = `count`+1 where tbdsn='76'
0.000192 - select * from tad_book3_docs where tbdsn='76'
0.000146 - select * from tad_book3 where tbsn='14'
0.000175 - select mid from modules where dirname='tad_book3'
0.000368 - desc `tad_book3_data_center` `sort`
0.000282 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_book3_data_center` where `mid`= '9' and `col_name`='read_tbdsn_date' and `col_sn`='76' order by `sort` , `data_sort`
0.001016 - select tbdsn,title,content,category,page,paragraph,sort,enable,uid,from_tbdsn from tad_book3_docs where tbsn='14' and `enable`='1' order by category,page,paragraph,sort
0.001038 - select tbdsn,title,category,page,paragraph,sort from tad_book3_docs where tbsn='14' and (`content` != '' or `from_tbdsn` != 0) and enable='1' order by category,page,paragraph,sort
0.000227 - SELECT * FROM modules WHERE dirname = 'tadtools'
0.000277 - SELECT * FROM config WHERE (`conf_modid` = '4') ORDER BY conf_order ASC
0.000148 - select mid from modules where dirname='tad_book3'
0.000282 - desc `tad_book3_data_center` `sort`
0.000162 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_book3_data_center` where `mid`= '9' and `col_name`='video_tbdsn_date' and `col_sn`='76' order by `sort` , `data_sort`
0.000183 - select groupid,name from groups
0.000257 - select * from `tad_book3_files_center` where `col_name`='mp4' and `col_sn`='76' and `kind`='file' order by sort limit 0,1
0.000208 - select `tt_theme`,`tt_use_bootstrap`,`tt_bootstrap_color`,`tt_theme_kind` from `tadtools_setup` where `tt_theme`='school2015'
0.000448 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (`tpl_tplset` = 'default' AND `tpl_file` = 'tadbook3_index.tpl') ORDER BY tpl_refid
0.000204 - SELECT * FROM modules WHERE dirname = 'tad_themes'
0.000216 - SELECT * FROM config WHERE (`conf_modid` = '3') ORDER BY conf_order ASC
0.000169 - select `tt_bootstrap_color` from tadtools_setup where `tt_theme`='school2015'
0.000256 - select * from tad_themes where `theme_name`='school2015'
0.000180 - select conf_value from config where conf_title ='_MD_AM_DEBUGMODE'
0.000326 - select * from tad_themes_blocks where `theme_id`='7'
0.000190 - select mid from modules where dirname='tad_themes'
0.000434 - desc `tad_themes_data_center` `sort`
0.000140 - select `col_sn`,`data_name`,`data_sort`, `data_value` from `tad_themes_data_center` where `mid`= '3' and `col_name`='theme_id' and `col_sn`='7' order by `sort` , `data_sort`
0.000184 - select conf_value from config where conf_name ='allow_register'
0.000290 - select `mid`, `name`, `dirname` from modules where isactive='1' and hasmain='1' and weight!=0 order by weight
0.000131 - SELECT * FROM modules WHERE dirname = 'tad_blocks'
0.000153 - select conf_value from config where conf_title ='_MD_AM_DEBUGMODE'
0.000258 - select count(*) from priv_msgs where `to_userid` ='0' and `read_msg`=0 group by `to_userid`
0.000363 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='0' and status='1' order by position
0.000172 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='11' and status='1' order by position
0.000152 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='14' and status='1' order by position
0.000149 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='15' and status='1' order by position
0.000105 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='17' and status='1' order by position
0.000122 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='16' and status='1' order by position
0.000108 - select `menuid`, `itemname`, `itemurl`, `target`, `icon`, `link_cate_name`, `link_cate_sn`, `read_group` from tad_themes_menu where of_level='18' and status='1' order by position
0.000303 - select a.* from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id where a.`col_name`='slide' and b.`theme_name`='school2015'
0.000185 - SELECT * FROM modules WHERE dirname = 'tad_login'
0.000314 - SELECT * FROM config WHERE (`conf_modid` = '14') ORDER BY conf_order ASC
總計: 57
區塊
搜尋: 沒有快取
總計: 1
額外資訊
包含檔案: 204 檔案
使用記憶體: 6957576 bytes
計時
XOOPS 使用 0.116 秒來載入。
XOOPS Boot 使用 0.027 秒來載入。
Module init 使用 0.008 秒來載入。
XOOPS output init 使用 0.032 秒來載入。
Module display 使用 0.025 秒來載入。
Page rendering 使用 0.022 秒來載入。