intelmq_psql_initdb does not work for SQLite

[sebix]

The SQL output bot documentation says, the SQLite database can be initialized with the intelmq_psql_initdb's initdb.sql:

intelmq/docs/user/bots.rst

Lines 4089 to 4094 in 79cae29

	Create the new database (you can ignore all errors since SQLite doesn't know all SQL features generated for PostgreSQL):
	.. code-block:: bash
	sqlite3 your-db.db
	sqlite> .read /tmp/initdb.sql

However, that does not work:

sqlite> .read /tmp/initdb.sql
Parse error near line 86: near "USING": syntax error
   "idx_events_classification.identifier" ON events USING btree ("classification
                                      error here ---^
[etc... for all indices]

[aaronkaplan]

okay, so would it need an intelmq_sqlite_initdb then?

[sebix]

Or a generic command, and a parameter to switch between databases, e.g. intelmq.bots.outputs.sql.output --generate-initdb --sqlite.

[aaronkaplan]

Also fine. Whatever works.

…

On 13.07.2022, at 15:58, Sebastian ***@***.***> wrote: Or a generic command, and a parameter to switch between databases, e.g. intelmq.bots.outputs.sql.output --generate-initdb --sqlite. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.