Shulou(Shulou.com)05/31 Report--

What is the solution to the error report of Sky Rabbit Monitoring SQL Azure? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Today, two new SQL Azure are added, which need to be added to the Sky Rabbit Monitor for monitoring, but after adding them, it is found that the interface shows a failure.

The Heavenly Rabbit log contains the following error message:

# 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 ")

.

Judging from the contents of the log, it should be SQL Azure's firewall that rejected the connection from IP 54.222.221.177.

Solution:

Use Navicat to connect to the SQLServer database, right-click-- > SQL Azure firewall rules

Add a network segment of 54.222.221.177, such as:

After adding, the problem is resolved after restarting the process of Sky Rabbit:

[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!

Check the interface again and display normally:

The answer to what is the solution to the problem of Sky Rabbit monitoring SQL Azure error report is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.