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: https://github.com/certtools/intelmq/blob/79cae294a74ab77f09b1f371a19f04ad65abab12/docs/user/bots.rst#L4089-L4094

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.