Overview

The administrator user is getting a database connection error "DB: unable to connect to database" when Kerio Control is trying to reach the Firebird database. As a result, the Kerio Control statistics page might be shown as empty.

In the Error log, Firebird DB shows Unsuccessful execution caused by a system error message.

Solution

The common reasons for this issue are:

• Data within the database is corrupt.
• The disk is full.
• Firebird DB itself is corrupted.

Remove corrupted data

1. Log in to Kerio Control Administration.
2. Go to Status > System Health > Manage.
3. Locate the option Kerio Control Statistics.
4. Click delete all data.
   
5. Confirm the action by clicking Yes.
   
6. Restart Kerio Control.

If disk usage is full

1. Clear the logs from System Health > Manage… 
2. Delete all logs at once 
   
3. Reboot Kerio Control.

If Firebird DB itself is corrupted

1. Login to the Kerio using SSH:

2. Navigate to the /var/winroute/star/cache/ folder.

3. Delete the cache contents:
   rm -rf *
   

Testing

Start Kerio Control and check the Error logs once again. Database errors should no longer appear.