python - 使用python进行Nmap扫描并存储在mysql中

Question

使用 nmap 扫描一系列 ip 的 python 代码，然后将这些 ip 单独存储在 mysql 表中。

当我们需要扫描一定范围的ip时如何扫描，例如172.27.20.130-140。并将所有ip存储在mysql表中。现在需要搜索一个范围，并且每个ip应该存储在表中。

#NMAP SCANNING CODE
    nmScan=nmap.PortScanner()
    host=self._firstname.value     # taking input from a pyforms gui input field
    result=nmScan.scan(hosts=host, arguments='-sV -v -p 1-1024')
    print('Host : %s (%s)' % (host, nmScan[host].hostname()))
    print('State : %s' % nmScan[host].state())
    for proto in nmScan[host].all_protocols():
        print('----------')
        print('Protocol : %s' % proto)
        lport = nmScan[host][proto].keys()
        #lport.sort()
        for port in lport:
            thisDict = nmScan[host][proto][port]
            print ('port : %s\tstate : %s\tVersion:%s,v%s'% (port, nmScan[host][proto][port]['state'],thisDict['product'] ,thisDict['version']))


 #INSERT into INPUT table CODE
    try:
        connection = mysql.connector.connect(host='localhost',
                                database='testdb',
                                 user='root',
                                 password='Pooja@123')
        cursor = connection.cursor()
        sql_insert_query = """ INSERT INTO input (sno,ip) VALUES (%s,%s)"""
        so=cursor.lastrowid
        sno=so
        ip=self._firstname.value     # taking input from a pyforms gui input field
        insert_tuple = (sno,ip)
        result = cursor.execute(sql_insert_query, insert_tuple)
        print("inserted")
        connection.commit()
    except mysql.connector.Error as error :
        connection.rollback() #rollback if any exception occured
        print("Failed inserting record into input table {}".format(error))
    finally:
        #closing database connection.
        if(connection.is_connected()):
            cursor.close()
            connection.close()
            print("MySQL connection is closed")

Answer 1

ipaddress 模块对于此类事情非常有用:

In [1]: import ipaddress

In [2]: addr = ipaddress.IPv4Address('172.27.20.130')

In [3]: print(addr)
172.27.20.130

In [4]: print(addr + 1)
172.27.20.131