Corrupt User Database?

Maintenance
#1

My mailinabox instance now cannot send emails.

Trying from the web interface or IMAP the mail.log shows:

Jan 1 15:53:57 box postfix/trivial-rewrite[11360]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL p
/O error?
Jan 1 15:53:58 box postfix/submission/smtpd[11361]: connect from unknown[REDACTED IPV6]
Jan 1 15:53:58 box postfix/submission/smtpd[11264]: warning: problem talking to service rewrite: Application error
Jan 1 15:53:58 box postfix/master[8926]: warning: process /usr/lib/postfix/sbin/trivial-rewrite pid 11360 exit status 1
Jan 1 15:53:58 box postfix/master[8926]: warning: /usr/lib/postfix/sbin/trivial-rewrite: bad command startup – throttl

and mail.err:
Jan 1 15:49:42 box postfix/trivial-rewrite[6392]: fatal: dict_sqlite_lookup: /etc/postfix/virtual-alias-maps.cf: SQL pr
O error?

All I did today was change a users password for them.

Am I able to restore just the user database or should I restore a full backup from a day ago?
Am I even right about the failure?

All lights are green on the dashboard. All system updates installed and the box has been rebooted.

Thanks in advance!

MiaB bricks users.sqlite after adding new user through web admin
#2

AH!
So I have fixed it for now following this advice:

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

from this thread:

So I am back in action and I also now know how it happened.
One of my users asked me the day before “I tried to change my password but it failed” and I think that was when mail sending stopped working.

Seems a pretty big issue!

#3

Now I have stopped panicking I can see it’s a well documented problem seen by a few and even fixed in v60.4

I will tell my users to avoid trying to alter passwords themselves until that lands!

#4

sudo sqlite3 users.sqlite ‘PRAGMA journal_mode=delete;’; - can give you an error with database is locked (5)

the solution I found to keeps those changes from all the passwords and users is backing up the users.sqilte file and run the sqlite3 command (above). This is what I did

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

#5

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

#6

This topic was automatically closed 40 days after the last reply. New replies are no longer allowed.