Unable to Write New Scan Report to Existing Database

[Niba-nazar]

Hi,

We are encountering an issue when attempting to write a new scan report generated by nmap-formatter to an old scan report. Specifically, when trying to dump the new database file to the old one, we are receiving the following error messages:

Could you advise if there is an option to write a new scan report to the existing database without causing these errors?
Additionally, we would like to maintain a history of scan results within this single database by separating any session or other identifiers from each new generated DB before merging it into the main database. Is there an option for this?

Any guidance or suggestions on how to resolve this would be greatly appreciated.

[vdjagilev]

Hi @Niba-nazar
Can you check if problematic database contains nf_schema table? I think the database that you are trying to save to does not has this table and therefore nmap-formatter tries to create other database tables and fails because they exist already.

Try to run this query on your database directly:

CREATE TABLE IF NOT EXISTS nf_schema (
	version text
);
INSERT INTO nf_schema VALUES ("3.0.2");

And try re-running.

[Niba-nazar]

Hi,

Yes, the table nf_schema already exists in both database files as mentioned.

[vdjagilev]

@Niba-nazar does nf_schema has any records?

SELECT version FROM nf_schema LIMIT 1

If it doesn't then it makes sense that it fails. Try to add new value there:

INSERT INTO nf_schema VALUES ("3.0.2");