未知错误11(未知错误1000)

而域名和IP地址信息都是非常基础的信息。目前互联网上很多网站都提供了域名信息、IP地址、归属地的查询。本文利用Python Flask实现了域名和IP信息的聚合网站。

因为域名和IP地址信息会发生变化，为了减轻接口压力，存储在本地数据库，新鲜度保持一周。每个查询首先从本地数据库获取信息。如果本地数据库信息可用并且不超过一周，将从本地数据库获得该信息。如果没有，将从其他网站获取并更新到本地数据库。

首先，获取域名的WHOIS信息

互联网上有很多提供WHOIS信息查询的网站。这里以为例，实现WHOIS信息的查询和分析。

import requestsfrom bs4 import BeautifulSoupheaders = { 'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36'}def getwhoisinfobychinafu(domain): ret_result = {} result=getWhoisInfoFromDB(domain) if len(result)==0: whois_service_url = ' post_data={"domain":domain} try: post_result=requests.post(whois_service_url,post_data) if post_result.status_code == 200: ret_str = post_result.content.decode('utf-8') soup = BeautifulSoup(ret_str, 'lxml') items_tr =soup.find(name='table',attrs={'class':'listtable'}).find_all(name='tr') for item_tr in items_tr: td_item=item_tr.find(name='td') if 'colspan' in td_item.attrs: key_name='详情' key_value=td_item.find(name='div',id='tab1').text else: key_name=item_tr.find(name='th').text key_value=item_tr.find(name='td').text ret_result[key_name]=key_value addchinafuWhoisInfo2DB(ret_result) except Exception as r: print('未知错误 %s' % (r)) #ret_result = json.dumps(ret_result, ensure_ascii=False) else: ret_result=result[0] return ret_resultdef getWhoisInfoFromDB(domainname): whoisInfos=db.session.execute('select * from whoisinfo where domain_name="%s" and updated_time > DATE_SUB(CURDATE(), INTERVAL 1 WEEK)' % domainname).fetchall() whoisInfo_dics=[] for whoisInfo in whoisInfos: chinafuwhoisinfo_dic=chinafuwhoisinfo2dic(whoisInfo) whoisInfo_dics.append(chinafuwhoisinfo_dic) return whoisInfo_dicsdef addchinafuWhoisInfo2DB(chinafuWhoisInfo_dic): chinafuWhois=WhoisInfo() chinafuWhois.domain_name=chinafuWhoisInfo_dic.get('域名DomainName') chinafuWhois.domain_status=chinafuWhoisInfo_dic.get('域名状态Domain Status','') chinafuWhois.registrar=chinafuWhoisInfo_dic.get('注册商Sponsoring Registrar','') chinafuWhois.name_server=chinafuWhoisInfo_dic.get('DNS 服务器Name Server','') chinafuWhois.registrar_creation_date=chinafuWhoisInfo_dic.get('注册日期Registration Date','') chinafuWhois.registrar_updated_date = chinafuWhoisInfo_dic.get('更新日期Update Date', '') chinafuWhois.registrar_expiry_date = chinafuWhoisInfo_dic.get('到期日期Expiration Date', '') chinafuWhois.detail=chinafuWhoisInfo_dic.get('详情', '')[0:] chinafuWhois.source = '中国福网' db.session.execute('delete from whoisinfo where domain_name="%s" and source="%s"' % (chinafuWhoisInfo_dic.get('域名DomainName'), chinafuWhois.source)) db.session.add(chinafuWhois) db.session.commit()

这里为了减少直接从其他网站获取WHOIS信息的压力，存储本地数据库。每次，WHOIS信息首先从本地数据库获得。如果本地数据库信息可用且持续时间不超过一周，则从其他网站获取并更新到本地数据库。这里getWhoisInfoFromDB实现了一周新鲜度的数据，addchinafuWhoisInfo2DB实现了将获取的信息保存到本地数据库。

第二，根据域名解析IP

根据域名，解析IP代码:

def getIPbyDomain(domain): addr='' try: myaddr = socket.getaddrinfo(domain, 'http') addr=myaddr[0][4][0] except Exception as e: print(e) return addr第三，获取IP信息

获取IP信息的API接口也有很多，比如淘宝的 IP Info IP API 离线库。

从淘宝IP获取IP信息def getipinfobytaobao(ip): taobaoIp_url = ' post_data={"ip":ip,"accessKey":"alibaba-inc"} ret_ipinfo= {} try: return_data=requests.post(taobaoIp_url,post_data) #其中返回数据中code的值的含义为，0：成功，1：服务器异常，2：请求参数异常，3：服务器繁忙，4：个人qps超出 return_json=json.loads(return_data.text) if return_json['code']==0: ret_ipinfo['ip']=return_json['data']['ip'] ret_ipinfo['country']=return_json['data']['country'] ret_ipinfo['region']=return_json['data']['region'] ret_ipinfo['org']='' ret_ipinfo['city'] = return_json['data']['city'] ret_ipinfo['isp']=return_json['data']['isp'] ret_ipinfo['loc'] = '' ret_ipinfo['timezone'] = '' ret_ipinfo['source']='淘宝IP' addIPInfo2DB(ret_ipinfo) except Exception as e: print('未知错误 %s' % (e)) return ret_ipinfo从ipinfo.io获取IP信息def getipinfobyipinfo(ip): api_url=' ipinfo = {} try: req_return = requests.get(api_url) if req_return.status_code == 200: ipinfo = json.loads(req_return.text) ipinfo['source']='ipinfo.io' addIPInfo2DB(ipinfo) except Exception as e: print('未知错误 %s' % (e)) return ipinfo从ip-api.com获取知识产权信息def getipinfobyipapi(ip): api_url=' ipinfo={} try: req_return=requests.get(api_url) if req_return.status_code==200: ipinfo=json.loads(req_return.text) ipinfo['ip'] = ip ipinfo['source'] = 'ip-api.com' ipinfo['loc'] = str(ipinfo['lat'])+','+str(ipinfo['lon']) addIPInfo2DB(ipinfo) except Exception as e: print('未知错误 %s' % (e)) return ipinfo从GeoLite脱机库中获取IP信息

有关如何获取GeoLite离线库以及如何阅读的详细信息，请参见:

def getipinfobygeoip2(ip): ipinfo={} dbdir=Config.geoLiteDBdir with geoip2.database.Reader(dbdir) as reader: response = reader.city(ip) ipinfo['ip'] =ip ipinfo['country'] = response.country.names['zh-CN'] ipinfo['region'] ='' ipinfo['city']=response.city.name ipinfo['org'] ='' ipinfo['loc'] = str(response.location.latitude)+','+str(response.location.longitude) ipinfo['timezone'] = response.location.time_zone ipinfo['source'] = 'GeoIP' addIPInfo2DB(ipinfo) return ipinfo第四，构建FLASK Web应用程序来查询聚合的域名和IP信息。1.FLASK Web应用程序的工程组织

2.配置数据和读取配置数据。1)配置数据

配置数据放在。环境和。flaskenv分别为，其中。env是私有配置信息，例如项目中使用的数据库链接。。flaskenv是Flask运行环境的信息。env的配置信息如下:

DEV_DATABASE_URI = 'mysql+ = 'mysql+ = 'mysql+ = TrueSECRET_KEY=your secret key

的配置信息。falskenv如下:

1FLASK_ENV=development2)读取配置数据。

通过config.py读取和管理配置数据

import osfrom dotenv import load_dotenvbasedir=os.path.abspath(os.path.dirname(__file__))flaskenv_path=os.path.join(basedir,'.flaskenv')env_path=os.path.join(basedir,'.env')if os.path.exists(flaskenv_path): load_dotenv(flaskenv_path)if os.path.exists(env_path): load_dotenv(env_path)class Config: geoLiteDBdir=os.path.join(basedir,'GeoLite2\GeoLite2-City.mmdb') flaskenv = os.getenv('FLASK_ENV','development') SECRET_KEY=os.getenv('SECRET_KEY','123!@#') SQLALCHEMY_TRACK_MODIFICATIONS=os.getenv('SQLALCHEMY_TRACK_MODIFICATIONS') SQLALCHEMY_DATABASE_URI = os.getenv('DEV_DATABASE_URI') @staticmethod def init_app(app): passclass DevelopmentConfig(Config): DEBUG=True SQLALCHEMY_DATABASE_URI = os.getenv('DEV_DATABASE_URI')class TestingConfig(Config): TESTING=True SQLALCHEMY_DATABASE_URI = os.getenv('TEST_DATABASE_URI')class ProductionConfig(Config): SQLALCHEMY_DATABASE_URI = os.getenv('PROD_DATABASE_URI')config={ 'development':DevelopmentConfig, 'testing':TestingConfig, 'production':ProductionConfig, 'default':DevelopmentConfig}3.接口和路由

界面很简单，就一个域名/IP输入框。输入域名或IP后，可以查询相应的域名信息或IP信息，并显示在界面上。

金甲2接口的模板index.html代码如下:

{% extends "bootstrap/base.html" %}{% block title %}InfoCol{% endblock %}{% block head %} {{ super() }} <style></style>{% endblock %}{% block body %} {% block navbar %} <div class="navbar navbar-inverse" role="navigation"> <div class="container"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="/">InfoCol</a> </div> <div class="navbar-collapse collapse"> <ul class="nav navbar-nav"> <li><a href="/">Home</a></li> </ul> </div> </div> </div> {% endblock %} {% block content %} <div class="container"> <div class="page-header " > <form method="post" class="center-block"> <div class="center-block" style="text-align:center"> {{ form.hidden_tag() }} {{ form.name.label }}{{ form.name() }} {{ form.submit() }} </div> </form> </div> <div> {% if whois_info %} <table class="table table-bordered"> <tr><th colspan="2">{{ name }}的Whois信息</th></tr> {% for item in whois_info %} {% if item!='详情' %} <tr><td style="width: 20%">{{ item }}</td><td style="width: 80%">{{ whois_info[item] }}</td></tr> {% else %} <tr> <td style="width: 20%"> <a role="button" data-toggle="collapse" href="#collapseExample" aria-expanded="false" aria-controls="collapseExample"> {{ item }} </a> </td> <td style="width: 80%"> <div class="collapse" id="collapseExample"> <div class="well"> {{ whois_info[item] }} </div> </div> </td> </tr> {% endif %} {% endfor %} </table> {% endif %} {% if ipinfos|length>0 %} <table class="table table-bordered"> <tr><th>IP</th><th>国家/地区</th><th>省份</th><th>城市</th><th>机构</th><th>ISP</th><th>经纬度</th><th>来源</th></tr> {% for ipinfo in ipinfos %} <tr> <td>{{ ipinfo['ip'] }}</td> <td>{{ ipinfo['country'] }}</td> <td>{{ ipinfo['region'] }}</td> <td>{{ ipinfo['city'] }}</td> <td>{{ ipinfo['org'] }}</td> <td>{{ ipinfo['isp'] }}</td> <td>{{ ipinfo['loc'] }}</td> <td> {% if ipinfo['source']=='ipinfo.io' %} <a href=" ipinfo['ip'] }}" target="_blank">{{ ipinfo['source'] }}</a> {% elif ipinfo['source']=='ip-api.com'%} <a href=" ipinfo['ip'] }}" target="_blank">{{ ipinfo['source'] }}</a> {% else %} {{ ipinfo['source'] }} {% endif %} </td> </tr> {% endfor %} </table> {% endif %} </div> </div> {% endblock %}{% endblock %}

在路由过程中，获取表单中的信息，判断是域名还是IP。如果是域名，则获取whois信息，根据域名获取IP信息。如果输入是IP，获取IP信息并反馈给页面。

('/',methods=['GET','POST'])def index(): name = '' ipinfos = [] whois_info = '' form = InputForm() if form.validate_on_submit(): name = form.name.data if checkip(name): ipinfos = getipinfo(name) else: whois_info = getwhoisinfo(name) whois_ip = getIPbyDomain(name) if checkip(whois_ip): ipinfos = getipinfo(whois_ip) form.name.data = '' return render_template('index.html',form=form, name=name, ipinfos=ipinfos, whois_info=whois_info)4、最终效果。

到目前为止，已经用Python快速实现了一个简单的域名和IP信息聚合网站。

所有源代码:

演讲地址:

原文链接：