ME020556 - ERR: Logging into Web mail produces a "configuration repository" error when using a database.


SYMPTOMS

The following error is displayed when a user tries to logging into the MailEnable web mail interface:

MailEnable WebMail - MEWebMail::oLogin.GetLogin Error (ME-WM-002) Problem Accessing Configuration Repository. Please check Permissions to Configuration Repository.

The Windows event log will report the following when the above error occurs:

MailEnable Database Provider error: 0

   FAILURE: (SQLDriverConnect), Module: w3wp.exe; Error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

CAUSE

64-bit ODBC DSN has not been configured for the server when using either MySQL or Microsoft SQL Server database as the MailEnable configuration repository.

RESOLUTION

When running the MailEnable web mail interface on a 64-bit version of Microsoft Windows in 64-bit mode it is required that the 64-bit ODBC DSN connector is configured manually. The steps below explain the procedure involved for both MySQL and Microsoft SQL server:

MySQL:

  • Download the latest MySQL ODBC driver from the following location:  http://www.mysql.com/downloads/connector/odbc/
  • Open up a Windows Command prompt and type: odbcad32.exe
  • Navigate to the "System DSN" tab.
  • Click on the "Add.." Button.
  • In the "Create new data source" window select: MySQL ODBC 5.x driver.
In the MySQL ODBC Data source configuration window specify the following parameters:
  • Data Souce Name: MailEnable-MySQL
  • Description: MailEnable
  • Database Server: localhost (or the IP address where the MySQL database resides)
  • Port: 3306 (or the port number that the MySQL instance has been configured to run on)
  • User: (MySQL username)
  • Password: (MySQL password)
  • Database: mailenable
  • Click on the "test" button to ensure that the connection is successful

Microsoft SQL Server:

  • Open up a Windows Command prompt and type: odbcad32.exe
  • Navigate to the "System DSN" tab.
  • Click on the "Add.." Button.
  • In the "Create new data source" window select: SQL Server or SQL Server Native client 10.0 (If running SQL Server 2005 later).
In the SQL server ODBC Data source configuration window specify the following parameters:
  • Name: MailEnable-SQL Server
  • Description: MailEnable Database
  • Server: (local) (Or the IP address or servername where SQL server resides) then click "Next".
  • Select the option "With SQL server authentication using a login ID and password entered by the user" (usually "sa" as default SQL server login ID) and click "Next".
  • Tick "Change default database to:" and use the dropdown menu to select "MailEnable". Click "Next" and then "Finish".
  • Use the "Test Data Source" button to ensure database connectivity is successful.

WORKAROUND

A work around is to run the web mail client under 32-bit mode.

For web mail running under IIS6 please review the following article: http://support.microsoft.com/?id=894435

For web mail running under IIS7 please follow the steps below:

  • Navigate to Control Panel > Administrative Tools > Internet Informations Services (IIS) Manager
  • Expand tree and click on "Application Pools".
  • In the Application Pools list locate and click on "MailEnableAppPool".
  • In the "Actions" window click on "Advanced Settings...".
  • In the "Advanced Settings" window within the "General" section, set the option "Enable 32-bit applications" to "True".
  • Click "Ok" and right click on the "MailEnableAppPool" and select "Recycle".


Product:MailEnable
Category:Configuration
Module:WebMail
Keywords:database SQL server MySQL mysql sql MEWebMail::oLogin.GetLogin Error ME-WM-002
Class:ERR: Product Error
Revised:Thursday, June 2, 2016
Author:
Publisher:MailEnable