Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro

 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: error connecting to MySQL database Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
chrisb
Newbie
Newbie


Joined: 25 August 2010
Online Status: Offline
Posts: 3
Posted: 25 August 2010 at 7:55am | IP Logged Quote chrisb

Hi, I'm having trouble installing the .NET version of WebMail.

The install runs through to the database setup page, I enter my MySQL database details, but when I click 'test connection', I just get the following error message:

Connect unsuccessful!: Internal Server Error. Please, contact your system administrator in order to report the problem.

There is nothing in the event log for this error. I've tested the database connection settings and they're fine. How can I find out what the actual error is?

Thanks,

Chris.
Back to Top View chrisb's Profile Search for other posts by chrisb
 
vsadoug
Newbie
Newbie
Avatar

Joined: 23 August 2010
Location: United States
Online Status: Offline
Posts: 13
Posted: 25 August 2010 at 12:34pm | IP Logged Quote vsadoug

make sure you have the Mysql odbc connector installed.
http://dev.mysql.com/downloads/connector/odbc/3.51.html
Back to Top View vsadoug's Profile Search for other posts by vsadoug
 
chrisb
Newbie
Newbie


Joined: 25 August 2010
Online Status: Offline
Posts: 3
Posted: 26 August 2010 at 5:45am | IP Logged Quote chrisb

Thanks for the link, but surely if I type in the MySQL connection details I shouldn't need ODBC?

I guess I could use ODBC instead - if only it would work! I just downloaded the connector and it isn't showing up when I try to add it to my ODBC Data Sources. Really odd.
Back to Top View chrisb's Profile Search for other posts by chrisb
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092
Posted: 26 August 2010 at 5:56am | IP Logged Quote Igor

The thing is, you'll need ODBC Connector to access MySQL from ASP.NET application, even if you don't use ODBC access directly. Thus, make sure that the connector is installed (version 3.51 is highly recommended, newer versions might not work in some cases), fill in the fields (username/password/hostname/database) and hopefully this will do the trick.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
chrisb
Newbie
Newbie


Joined: 25 August 2010
Online Status: Offline
Posts: 3
Posted: 26 August 2010 at 6:08am | IP Logged Quote chrisb

Well, it looks like I'm getting there :)

My server is the 64-bit version of Windows 2008, so I had to install the latest 64-bit data connector.

However, from a technical standpoint, the code seems to use the MySQL .NET connector. ASP.NET doesn't need ODBC if you're using the .NET connector.

Why have an option to leave ODBC greyed out if you actually need it?

Back to Top View chrisb's Profile Search for other posts by chrisb
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide