So my problem is similar to this thread, presumably after user changed their password through roundcube MiaB bricked and
sqlite3 users.sqlite PRAGMA journal_mode=delete;’;
fixed it for us. I’ve also disabled “password” plugin in roundcube config. But now adding new user through web admin also causes same problem and I’m a bit lost
Error log after trying to add user:
postfix/smtpd[16765]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL finalize failed for query ‘SELECT destination from (SELECT destination, 0 as priority FROM aliases WHERE source=‘key@mydomainhere’ AND destination<>’’ UNION SELECT email as destination, 1 as priority FROM users WHERE email=‘key@mydomainhere’ UNION SELECT destination, 2 as priority FROM auto_aliases WHERE source=‘key@mydomainhere’ AND destination<>’’) ORDER BY priority LIMIT 1;’: database is locked
postfix/trivial-rewrite[17448]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL prepare failed: database is locked?