Windows system event log displays the following error when trying to authenticate against the MailEnable services when using MySQL as the configuration repository.
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 = '22.214.171.124') 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
MySQL "wait_timeout" value has been exceeded and the connection that MailEnable has made to the database is no longer valid.
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
|Keywords:||MySQL authentication MySQL server has gone away|
|Class:||TRB: Troubleshooting (Configuration or Environment)|
|Revised:||Wednesday, May 4, 2016|