[strongSwan] Database logging for sqlite3 (for ipsec pool)

[divya mohan]

Hi,

I'm using sqlite3 for storing leases (via ipsec pool).
I would like to get some logs (either in syslog; or in a separate
database table for logs) when there is any insert/update/delete done
on the leases table.

I assume this might be achievable by using 'CREATE TRIGGER' statements
in the db to collect logs. Have anyone already implemented this?

Or, is there any other way to log the state changes of lease table?

- Divya