Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro
 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: change to SQL problems Webmail Pro v3.4 Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
jordisond
Newbie
Newbie


Joined: 17 December 2006
Location: Australia
Online Status: Offline
Posts: 5
Posted: 17 December 2006 at 9:17pm | IP Logged Quote jordisond
Have installed succesfully webmail ASP Pro v3.4, using the access database. Works like a treat, but really wanted to use SQL. Tried a number ways of installing but nothing seem to create the SQL database automatically as suggested in the setup instruction?

Used the import/export utility for SQL and created the tables successfully and could connect successfully to the SQL database by selecting the appropiate settings in the admin area of webmail.

Seems there is a permissions issue with SQL databases, but cannot find instruction on what permissions need to be set for webmail to function correctly using SQL.

Am receiving HTTP 500 - Internal server error
in trying to add users or sending mail etc etc. (Successfully transfered one user from access to SQL to test sending).

Thanks in advance for some pointers.
Back to Top View jordisond's Profile Search for other posts by jordisond
 
Andrew
AfterLogic Support
AfterLogic Support


Joined: 28 April 2006
Location: United States
Online Status: Offline
Posts: 1189
Posted: 18 December 2006 at 3:55am | IP Logged Quote Andrew
WebMail Pro doesn't create database automatically, it can create all necessary tables within existing database. You should create empty database manually or use existing one (wm_ prefix is used for all names and there won't be any collisions with already existing tables).

We don't recommend using standard import/export utility because it converts WebMail database incorrectly (for instance, IDENTITY property is missing). If you need to import data from existing MS Access database to MS SQL Server database, please let us know, we'll provide you with special tool which correctly performs it.

WebMail Pro needs the following permissions over the database:
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE/DROP TABLES


If WebMail Pro has these permissions, all necessary tables will be created during saving database settings in WebMail Administration Console.

To see error details instead of HTTP 500, you should disable "Show friendly HTTP error messages" option in "Advanced" tab of MS Internet Explorer configuration or use another web browser.

Thus, please grant the appropriate permissions to the database account which you specified in WebMail Pro settings, drop all the tables created during importing via standard import/export utility, log into WebMail Administration Console, make sure all settings are specified correctly in "Database Settings" section and click "Save" to create all necessary tables.

Best regards,
Andrew
Back to Top View Andrew's Profile Search for other posts by Andrew
 
jordisond
Newbie
Newbie


Joined: 17 December 2006
Location: Australia
Online Status: Offline
Posts: 5
Posted: 18 December 2006 at 4:39am | IP Logged Quote jordisond
Thanks Andrew

Permission set correctly and it work just fine after clearing the tables, all seems to be operating correctley. Thanks for your quick response.

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

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