Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect » Domains missing, SQL-Error on Users/Groups
  •  
msslovi0

Messages: 12

Karma: 0
Send a private message to this user
Hi!

I've got a huge problem with my mailserver: One of my admins was looking up some account details when he got a message box that says: Error: SQL query parse error and asked for help.

First I tried to log in to webmail, but it rejected my valid username and password when I tried to login without specifiing a domain. Logging in with user<_at_>domain works - but all my folders and mails are gone! The only available Folder is one named 'Öffentliche Ordner' [Public Folders].

So I fired up Kerio Admin and logged in. A click on 'Domain Settings - Users' and 'Domain Settings - Groups' brings up the error mentioned above. The Domain-Dropdown is empty. So I opened 'Configuration - Domains': There are no domains listed, although there are four domains configured for this server!

Logging in to the server using ssh, I tried to locate the probably corrupt SQL-Database, but couldn't find any below /opt/kerio.

Having a look at /opt/kerio/mailserver/store/mail brings up all accounts for every domain configured, so I checked the logfiles. error_log contains numerous entries, starting 2pm today, about the same time my admin called me. The error ist always the same for quite a bunch of different usernames:
[07/Feb/2006 14:00:29] mail_folder.cpp: No domain defined for user user<_at_>domain.de
so obviously the domain-records are missing

Restarting the server didn't help and there is plenty of room left on the harddrive, so this isn't an issue either.

So what can I do to recover my domains, users and emails?

Matt
  •  
winkelman

Messages: 2119
Karma: 3
Send a private message to this user
Call support: the fastest way to get out of this kind of urgent trouble.
  •  
msslovi0

Messages: 12

Karma: 0
Send a private message to this user
Subscription has expired for this server...

Matt
  •  
freakinvibe

Messages: 1540
Karma: 62
Send a private message to this user
Very basic question, do you have a backup?

Where is the SQL server setup? The standard setup on KMS is not SQL but file-based.

Regards, Pascal

Dexion AG - The Blackberry Specialists in Switzerland
https://dexionag.ch
  •  
msslovi0

Messages: 12

Karma: 0
Send a private message to this user
Of course I got backups.

The information that the standard setup is file based helped me out to get the server up and running again.

However, the message about an SQL-Error is just crap.

Locating /opt/kerio/mailserver/mailserver.cfg and comparing it to the file restored from backup listed a bunch of deletions, the most important ones probably the domain entries.

After changing the config and restarting the server everything works fine now again. But those bugs are not annoying, the are grossly negligent.

Matt

  •  
blackbox

Messages: 82
Karma: 0
Send a private message to this user
I realize this is a 4 year old thread, but it helped narrow down an unexpected problem this morning and I wanted to send thanks.

I also received the cryptic error message "sql query parse error" when attempting to view users after logging into the admin console after an apparent crash.

For those interested in the specific details:

A kernel panic (not caused by Kerio) resulted in Kerio reverting to a default/vanilla mailserver.cfg. The default mailserver.cfg also has the unfortunate side effect of nuking the local backup directory as StoreBackup is set to 0 by default.

Restoring the backup directory from tape allowed access to the recent mailserver.cfg backup.

Stopping the server, replacing mailserver.cfg from backup, and starting the server was all I needed to be back in business.













Previous Topic: mapi-provider error
Next Topic: Kerio Migration Tool on same server?
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Tue Oct 17 11:20:07 CEST 2017

Total time taken to generate the page: 0.00443 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.