my $dbh = DBI->connect("dbi:SQLite:dbname=$database",
undef,
undef,
{
AutoCommit => 0,
RaiseError => 1,
on_connect_do => "PRAGMA foreign_keys = ON",
sqlite_open_flags => "DBD::SQLite::OPEN_READONLY",
})
or die("Could not open database '$database': $!\n");
####
2025-11-04T14:02:51.130580+00:00 ID28399 kernel: [5084204.347595] audit: type=1400 audit(1762264971.124:63): apparmor="DENIED" operation="open" profile="/var/www/fcgi/foo.fcgi" name="/var/www/db/foo.sqlite3" pid=377569 comm="search.fcgi" requested_mask="wc" denied_mask="wc" fsuid=1002 ouid=1002
####
/var/www/db/foo.sqlite3 kr,