unixrox/prebellico

prebellico crashes when writing to sqlite database

Closed this issue · 2 comments

There appears to be a syntax error when prebellico writes to the sqlite database.

Please see trace:
Traceback (most recent call last):
File "prebellico.py", line 941, in
sniff.loop(0, inspectproto)
File "prebellico.py", line 198, in inspectproto
tcppushdiscovery(header,data)
File "prebellico.py", line 590, in tcppushdiscovery
prebellicoDb('writeToDb', 'insert into NetworkIntelligence set recordType = "enterpriseService", data = (?), associatedHost = (?), methodObtained = (?), dateObserved = (?), sourceInterface = (?)', [ enterpriseService, sourceIp, "passiveNetwork", timeStamp(), dev ] )
File "prebellico.py", line 84, in prebellicoDb
db.execute(statement, data)
sqlite3.OperationalError: near "set": syntax error

I hope this helps. Let me know if there is anything else I can provide.

Hello n8tron,

I believe that I have resolved this issue under commit 95ed101. I have pushed this to the master branch. Please work to try this again and let me know if this resolves the issue as I do not have the environment to test this one feature set at the moment.

Hello n8tr0n,

Per our discussion, since it appears that the last commit resolve the issue, I am closing this out. Thanks for submitting an issue and using Prebellico!