| Author |
|
evanrich2
Newbie
Joined: 01 October 2010
Online Status: Offline
Posts: 8
|
| Posted: 01 October 2010 at 4:27pm | IP Logged
|
|
|
Saw some screenshots of AfterLogic webmail, and had to try it out to see how good it was. I've managed to get up to the point where you enter your database information, but no matter what I try, I can't get it to work. I've tried Microsft SQL and Access files, but can't figure out whats wrong.
I've turned on logging as well, but a log file does not get generated. The error I am getting is:
Code:
| Connect unsuccessful!: Internal Server Error. Please, contact your system administrator in order to report the problem. |
|
|
my settings are as follows:
SQL username: webmailadmin
SQL password: admin_12345
database (i created one in Microsoft SQL server 2008 R2: webmail
host:
I've tried "localhost", "192.168.0.103", "WHITE-DWARF". "127.0.0.1", and even my domain name as the host setting, nothing seems to work, i constantly get that same message.
I've tried enabling every TCP/IP option for the SQL server, granting full permissions to everything, and cannot figure this out. I have HMailServer on the same box, and it has no problem connecting to the SQL server (on the same box) and other applications can connect fine, just afterlogic cannot. I've search through the 5 pages of posts that are tagged with "MS SQL" and nothing listed there has helped.
Thanks in advance if anyone has any ideas.
|
| Back to Top |
|
| |
evanrich2
Newbie
Joined: 01 October 2010
Online Status: Offline
Posts: 8
|
| Posted: 01 October 2010 at 4:29pm | IP Logged
|
|
|
Oh i forgot to add, I've even tried using just the MS Access database, but dont know how to specify the path to it...do I just put in \APP_DATA\DB\_webmail.mdb? I tried that and it also didn't work, as well as multiple ODBC strings from the web.
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6124
|
| Posted: 04 October 2010 at 1:15am | IP Logged
|
|
|
First of all, what Windows version are you using? Is it 32-bit or 64-bit?
I understand you were supplying SQL credentials and not Windows ones for MS SQL access, correct?
Try checking special debug logs, they might contain additional information on the error's reason.
You can also try installing MySQL, you'll need ODBC Connector to have it working with WebMail Pro ASP.NET.
Quote:
| do I just put in \APP_DATA\DB\_webmail.mdb |
|
|
Yes, that should be good, you might try using full path as well.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
evanrich2
Newbie
Joined: 01 October 2010
Online Status: Offline
Posts: 8
|
| Posted: 04 October 2010 at 1:25pm | IP Logged
|
|
|
Igor,
Thanks for the reply. I'm using x64. After mucking with it for literally 4-5 days, i finally just went and co-installed Mysql and the MySQL odbc connector. I now have a MySQL database that works with afterlogic webmail, although I'll keep trying to figure out why MSSQL Didn't work. In addition, I was able to connect to the MS Access database, however i still got errors after completion and nothing worked. MySQL is working however.
Thanks for the reply.
|
| Back to Top |
|
| |
franky2611
Newbie
Joined: 13 October 2010
Location: Germany
Online Status: Offline
Posts: 1
|
| Posted: 13 October 2010 at 2:58am | IP Logged
|
|
|
Hi Igor,
I've the same problem using Win 2003 and MS SQL 2008. I also tried the mdb file, but it didn't work. I won't install mysql, so I still need a solution (MSSQL or mdb). Do you or anybody else have an idea?
Thanks for the help
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6124
|
| Posted: 13 October 2010 at 3:05am | IP Logged
|
|
|
Are you running 32-bit or 64-bit version of Windows? If you enable debug logs, what error messages do you get there?
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
evanrich2
Newbie
Joined: 01 October 2010
Online Status: Offline
Posts: 8
|
| Posted: 02 January 2011 at 1:14am | IP Logged
|
|
|
I finally figured out what my issue was. I had given up before, and just run MySQL along side MS SQL (using it for a number of other things), but having two SQL servers running on the same machine was starting to bug me. I looked back into this, and realized that I only had "Windows Authentication" enabled for the SQL server. After changing it to mixed mode, I was able to connect. Thought I'd post my fix in case anyone else had this problem.
I am happy to say I can finally delete mysql and just stick with one database platform.
|
| Back to Top |
|
| |
infovivek
Newbie
Joined: 27 June 2011
Location: India
Online Status: Offline
Posts: 1
|
| Posted: 27 June 2011 at 5:28am | IP Logged
|
|
|
Hi
Im facing the same issue
Code:
Connect unsuccessful!: Internal Server Error. Please, contact your system administrator in order to report the problem. |
|
|
I've mysql fully installed with connectors. But still facing same issue. Please help me resolve the issue. Please help me to use access database "_webmail.mdb".
System Info:
- Windows server 2008 r2
- hMail Server
Thanks
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6124
|
| Posted: 27 June 2011 at 5:32am | IP Logged
|
|
|
Current version of WebMail Pro does not support MS Access database. And in case if you're speaking of some older version, it is highly recommended to use MS SQL or MySQL.
To track down system-level errors, special debug log should be enabled and examined. In most cases, issues like this are caused by missing or incompatible driver/connector.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: can’t finish install due to database
Privacy policy |
Refund policy