MIAB stop working

No sure how to explain my situation or how did started happening, 2 weeks ago it was working and sending emails and receiving emails normally, did a few ubuntu upgrades including php lastest version (no sure if the problem is from that)
I guess after upgrades the services from Ubuntu and stopped working and I see errors on the logs but I can’t understand it at all, I have been searching answer but no solution yet.

*From /var/log/mail.err
Dec 22 20:21:35 mail postfix/trivial-rewrite[25210]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL prepare failed: disk I/O error?

*From /var/log/mail.log
Dec 22 20:24:39 mail postfix/submission/smtpd[24013]: warning: problem talking to service rewrite: Application error
Dec 22 20:24:39 mail postfix/master[14507]: warning: process /usr/lib/postfix/sbin/trivial-rewrite pid 25290 exit status 1
Dec 22 20:24:39 mail postfix/smtpd[24628]: warning: problem talking to service rewrite: Connection reset by peer
Dec 22 20:24:39 mail postfix/smtpd[25253]: warning: problem talking to service rewrite: Connection reset by peer
Dec 22 20:24:39 mail postfix/smtpd[24669]: warning: problem talking to service rewrite: Application error
Dec 22 20:24:39 mail postfix/master[14507]: warning: process /usr/lib/postfix/sbin/trivial-rewrite pid 25291 exit status 1

From /var/log/nginx/error.log2022/12/22 20:12:20 [error] 23251#23251: 17 upstream timed out (110: Unknown error) while reading response header from upstream, client: ...**, server: *******, request: “POST /mail/?_task=mail&_unlock=loading1671757870356&_framed=1 HTTP/2.0”, upstream: “fastcgi://unix:/var/run/php/php8.0-fpm.sock”,

NOTE: ..*. is the IP just taking it off.

from var log mail.log
Dec 22 20:41:54 mail postfix/submission/smtpd[37014]: connect from localhost[127.0.0.1]
Dec 22 20:42:19 mail postfix/trivial-rewrite[37017]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL prepare failed: disk I/O error?
Dec 22 20:42:19 mail postfix/trivial-rewrite[37018]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL prepare failed: disk I/O error?
Dec 22 20:42:20 mail postfix/submission/smtpd[36677]: warning: problem talking to service rewrite: Application error
Dec 22 20:42:20 mail postfix/smtpd[34497]: warning: problem talking to service rewrite: Connection reset by peer
Dec 22 20:42:20 mail postfix/master[31473]: warning: process /usr/lib/postfix/sbin/trivial-rewrite pid 37017 exit status 1
Dec 22 20:42:20 mail postfix/master[31473]: warning: /usr/lib/postfix/sbin/trivial-rewrite: bad command startup – throttling
Dec 22 20:42:20 mail postfix/master[31473]: warning: process /usr/lib/postfix/sbin/trivial-rewrite pid 37018 exit status 1

after a while I get Connection error server cannot be reached

Search is your friend

1 Like

actually I found out there is an issue when the password are changed, and I get that search if your friend. This is a forum to ask for help, then why bother having a maintenance forum or a forum at all?

cd /home/user-data/mail
sudo sqlite3 users.sqlite ‘PRAGMA journal_mode=delete;’;

this is not a permanent fix, as if user keep trying to change their password would brick it again.

NOTE: if you get and Error: stepping, database is locked (5), wait 5minutes to rerun the command

The possible temporary fixes are discussed in the github thread which i linked in the above. Unfortunately there is no easy fix for MiaB as the issue is coming from 3th party packages.

No sure how is this done, I am new to this would you have a step by step guide?

After changing the users.sqlite logging mode back to delete, I ended up disabling Roundcube’s password plugin (to prevent users from changing their passwords) by using this command:

sudo nano /usr/local/lib/roundcubemail/config/config.inc.php

Then delete the password plugin from line 28, followed by Ctrl+O, Enter, and Ctrl+X. Alternatively, use sed (untested):

sudo sed -i "s/'password', //g" /usr/local/lib/roundcubemail/config/config.inc.php