ME020535 - TRB: Intermittent authentication failures when using MySQL database as the configuration repository


SYMPTOMS

Windows system event log displays the following error when trying to authenticate against the MailEnable services when using MySQL as the configuration repository.

Example:

The description for Event ID 10000 from source MailEnable cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

MailEnable Database Provider error: 0
FAILURE: (SELECT   ID,Mode,AddressMask,Status,Account,AccessRight FROM POP_ACCESS WHERE ((Mode = 1) AND (AddressMask = '89.42.140.213') AND (AccessRight = 'CONNECT') AND ID > 0) ORDER BY ID  LIMIT 1;), Module: MEPOPS.EXE; Error: [MySQL][ODBC 5.1 Driver][mysqld-5.1.39-community-log]MySQL server has gone away


the message resource is present but the message is not found in the string/message table

CAUSE

MySQL "wait_timeout" value has been exceeded and the connection that MailEnable has made to the database is no longer valid.

RESOLUTION

A default installation of MySQL will keep a connection open for 8 hours. If MailEnable does not make a query within this time, the error is produced the first time a query is done. Subsequent queries will work. If you expect that services will not be accessed for 8 hours or more you should increase the MySQL wait time.

Please consult within the following MySQL guide on how to increase the "wait_timeout" value: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout

 



Product:MailEnable (Ent-Any)
Category:Environment
Module:Providers
Keywords:MySQL authentication MySQL server has gone away
Class:TRB: Troubleshooting (Configuration or Environment)
Revised:Wednesday, May 4, 2016
Author:
Publisher:MailEnable