[Bug] User manager unusable after power outage (or device unplug/replug)

lox · Wed Jan 18, 2023 1:35 am

Hello,

On an hex POE if I unplug/replug (which simulate a power outage), user-manager is unusable. All commands to it do timeout :

/user-manager/monitor 

action timed out - try again, if error continues contact MikroTik support and send
 a supout file (13)

We can plan a reboot or shutdown, but not a power outage. It seems like it is related to the sqlite db, because if I delete the files, user-manager makes new one and then works. But everything is lost. This need to be fixed.

But in the meantime, how can I recover from such an issue ?

lox · Wed Jan 18, 2023 2:00 am

I tried to fix the apparently corrupted sqlite db. Downloading um5.sqlite and um5.sqlite-wal, and then :

sqlite3 ./backup/um5.sqlite .dump | sqlite3 um5.sqlite

I then upload the new db, but user-manager is still not working (and nothing about it in logs)

[Bug] User manager unusable after power outage (or device unplug/replug)

[Bug] User manager unusable after power outage (or device unplug/replug)

Re: [Bug] User manager unusable after power outage (or device unplug/replug)

Who is online