Cannot access Fusion PBX Web Portal and phones cannot register

Status
Not open for further replies.

kwangmien

Member
Oct 3, 2018
59
1
8
52
Hi,

Our Fusion PBX version is 4.4.6. There are 816 extensions and 68 domains in the system.

We have encountered a serious issue with our Fusion PBX. When the issue happened, we could not access to the Fusion PBX Web Portal and all the phones cannot register to the Fusion PBX.

The resources (cpu, memory, disk space) at the time of outage is in order.

A check on Freeswitch logs in /var/log/freeswitch/freeswitch.log shows there are a number of "NATIVE SQL ERR [database disk image is malformed]
" error messages.

May I know what is the cause of this and how can this be resolved ?

Thank you.

Regards,
Kwang Mien
 

Adrian Fretwell

Well-Known Member
Aug 13, 2017
1,388
364
83
Sounds like you have a corrupted database, if you are using SQlite as your FreeSwitch DB (default install), you should see some files in the location /var/lib/freeswitch/db/. It is normally safe to delete everything in there and restart FreeSwitch.

Always make a backup before doing anything, especially deleting, so you can always get back to where you are now.

I'm not sure why you can't access the Fusion Web Pages, unless maybe you also have issues with your Postgresql database.
 
Last edited:

kwangmien

Member
Oct 3, 2018
59
1
8
52
Thanks for the info. Do you know what are the reasons for the SQLite database to be corrupted ?
 

Adrian Fretwell

Well-Known Member
Aug 13, 2017
1,388
364
83
Thanks for the info. Do you know what are the reasons for the SQLite database to be corrupted ?
There are many possible reasons, it's most often caused by a process/machine crash or a power failure, but can also be the result of early or partial disk failure. Did the machine get restarted, have you checked uptime?

The kernel generally logs any diagnostic messages about I/O issues, you can see what is logged with the dmesg command. If you think there may be a disk issue other tools are useful such as fsck, smartctl and badblocks.

Have you had a look at the postgresql log files (/var/log/posgresql/)?

It's difficult to diagnose something at a distance, the more information you provide the more we can try to help.
 

kwangmien

Member
Oct 3, 2018
59
1
8
52
When the issue happened, I restarted the machine, but that it did resolve the issue. Only after clearing the *.db files in /var/lib/freeswitch/db/ and restart freeswitch, registration and web portal issues are resolved.

Is the problem due to too many sip registration as i understand that the SQLite database contains sip registration information ?
 

Dee

Member
Jun 7, 2019
50
3
8
35
We experienced similar issue as well - same as you over 150 domains all working well and we had this database failure.

We just simply restored back to the old back up as we had so many users on my system.

Interested to also know what could have caused the issue you reported above.
 

DigitalDaz

Administrator
Staff member
Sep 29, 2016
3,038
556
113
If its the sql db, just stop freeswitch, DELETE the db and restart. No need to restore anything. The freeswitch db only stores the current state.
 
Status
Not open for further replies.