天兔監控SQL Azure報錯解決案例
今天新增了兩臺SQL Azure,需要加入到天兔監控裡進行監控,但加完後發現介面裡顯示失敗。
天兔日誌有如下錯誤資訊:
# cat /usr/local/lepus/logs/lepus.log
..............................................................................................
2017-10-23 08:08:15 [WARNING] check sqlserver sc-stable.database.chinacloudapi.cn:1433 :
(40615, "Cannot open server 'sc-stable' requested by the login. Client with IP address
'54.222.221.177' is not allowed to access the server.
To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database
to create a firewall rule for this IP address or address range.
It may take up to five minutes for this change to take effect.DB-Lib error message 40615,
severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n")
...............................................................................................
根據日誌內容判斷應該是SQL Azure的防火牆拒絕了來自IP為54.222.221.177的連線。
解決方案:
用Navicat連線SQLServer資料庫,右鍵-->SQL Azure防火牆規則
新增54.222.221.177網段,比如:
新增完後重啟天兔程式後問題得到解決:
[root@c58c333ef639 logs]# lepus stop
lepus processes id 17026 been stop
lepus processes id 17042 been stop
lepus processes id 17370 been stop
lepus processes id 17546 been stop
lepus processes id 17594 been stop
lepus processes id 17625 been stop
[root@c58c333ef639 logs]# /usr/local/sbin/lepus: line 16: 17026 Terminated nohup python lepus.py &>logs/lepus.log
[root@c58c333ef639 logs]# lepus start
lepus server start success!
再次檢視介面顯示正常:
天兔日誌有如下錯誤資訊:
# cat /usr/local/lepus/logs/lepus.log
..............................................................................................
2017-10-23 08:08:15 [WARNING] check sqlserver sc-stable.database.chinacloudapi.cn:1433 :
(40615, "Cannot open server 'sc-stable' requested by the login. Client with IP address
'54.222.221.177' is not allowed to access the server.
To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database
to create a firewall rule for this IP address or address range.
It may take up to five minutes for this change to take effect.DB-Lib error message 40615,
severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n")
...............................................................................................
根據日誌內容判斷應該是SQL Azure的防火牆拒絕了來自IP為54.222.221.177的連線。
解決方案:
用Navicat連線SQLServer資料庫,右鍵-->SQL Azure防火牆規則
新增54.222.221.177網段,比如:
新增完後重啟天兔程式後問題得到解決:
[root@c58c333ef639 logs]# lepus stop
lepus processes id 17026 been stop
lepus processes id 17042 been stop
lepus processes id 17370 been stop
lepus processes id 17546 been stop
lepus processes id 17594 been stop
lepus processes id 17625 been stop
[root@c58c333ef639 logs]# /usr/local/sbin/lepus: line 16: 17026 Terminated nohup python lepus.py &>logs/lepus.log
[root@c58c333ef639 logs]# lepus start
lepus server start success!
再次檢視介面顯示正常:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/15498/viewspace-2146266/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 搭建Lepus 天兔 監控MySQLMySql
- 天兔資料庫監控系統主頁面報錯顯示缺少core/Common.php檔案的解決方案資料庫PHP
- 解決MMM啟動監控報錯的問題
- 天兔(Lepus)監控作業系統(OS)安裝配置作業系統
- 【SQL監控】SQL完全監控的指令碼SQL指令碼
- 【SQL】Oracle資料庫SQL監控報告示例SQLOracle資料庫
- Mybatis批量更新SQL報錯☞解決辦法MyBatisSQL
- Nagios監控MySQL報錯:NRPE: Unable to read output的詳細解決過程iOSMySql
- 常用監控SQLSQL
- 工業物聯網案例:注塑機PLC聯網監控解決方案
- 聊聊前端監控——錯誤監控篇前端
- mybatis報錯解決MyBatis
- oracle 長sql監控OracleSQL
- Oracle常用監控SQLOracleSQL
- 企業IT監控網管解決方案
- 智慧工廠影片監控解決方案
- 同事寫的監控Logical Standby SQL apply 程式stop的監控報警指令碼SQLAPP指令碼
- 監控寶SQL Server效能監控的功能和配置SQLServer
- 解決fitz模組報錯
- SS報錯的解決
- 解決eslint報錯EsLint
- iText中文,報錯解決
- Oracle-常用監控SQLOracleSQL
- Oracle常用監控SQL(轉)OracleSQL
- 監控影片儲存壓縮解決方案
- 智慧工地影片監控系統解決方案
- 智慧校園監控系統解決方案
- java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä‘ is unrecognized...報錯解決JavaSQLExceptionServerZed
- 報表開啟慢跟蹤難?可通過效能監控快速解決
- 【python 監控報警】python自動發微信監控報警Python
- hive使用報錯解決方法Hive
- npm install 報錯解決NPM
- Windows分割槽報錯解決Windows
- supervisor使用報錯解決
- SQL Server資料庫監控SQLServer資料庫
- JS錯誤監控 上報後臺你瞭解多少?JS
- Laravel-查詢-ONLY_FULL_GROUP_BY SQL 模式-報錯限制-解決LaravelSQL模式
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error