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

divya mohan m.divya.mohan at zoho.com
Fri Jun 19 07:54:00 CEST 2015


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

More information about the Users mailing list