TravisFSmith / SweetSecurity

Network Security Monitoring on Raspberry Pi type devices
Apache License 2.0
778 stars 189 forks source link

sqlite3 create db script needs column for omp_id #11

Closed n00btotal closed 7 years ago

n00btotal commented 8 years ago

Currently this gives you an error:

networkDiscovery.py (line 138)

c.execute("INSERT INTO hosts VALUES ('" + hostname + "'," + str(ip2long(ipaddress)) + ",'" + macaddress + "','" + macvendor + "','" + omp_id + "')")

Unless you ad a fifth text column for omp_id in your SweetSecurity.db.

I suggest the following c.execute('''CREATE TABLE hosts(hostname text, ip4 integer, mac text, vendor text, ompid text)''')

to replace line 10 in SweetSecurityDB.py c.execute('''CREATE TABLE hosts(hostname text, ip4 integer, mac text, vendor text)''')

TravisFSmith commented 7 years ago

OpenVas is no longer installed along with Sweet Security.