Database creation failed

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
Majestix
New user
New user
Posts: 3
Joined: 2009-07-10 09:29

Database creation failed

Post by Majestix » 2009-07-10 09:51

Hi,
I'm new with hmailserver and tried to install Build 346 (15374) on W2K3 SP2.
On this server runs already WSUS SP1 on Windows Internal Database (MICROSOFT##SSEE)
When I start the Database Setup I do the following
Step 2 Create a new hMailServer database
Step 3 MIcrosoft SQL Server
Step 4 Database server address (MYSERVERSNAME)
Database name MAILDB
use Windows authentication
Step 5 No Service selection
Step 6 The Script starts an gives the following output:

Starting task...
Please wait while creating database...
Source: ADOConnection::Execute(), Code: HM10044, Description: Error while executing SQL statement:
create proc hm_drop_table_objects
@tablename sysname
as
set nocount on
declare @constname sysname,
@cmd varchar(1024)
declare curs_constraints cursor for
select name
from sysobjects
where xtype in ('C', 'F', 'PK', 'UQ', 'D')
and (status & 64) = 0
and parent_obj = object_id(@tablename)
open curs_constraints
fetch next from curs_constraints into @constname
while (@@fetch_status = 0)
begin
select @cmd = 'ALTER TABLE ' + @tablename + ' DROP CONSTRAINT ' + @constname
exec(@cmd)
fetch next from curs_constraints into @constname
end
close curs_constraints
deallocate curs_constraints
DECLARE @indexName NVARCHAR(128)
DECLARE @dropIndexSql NVARCHAR(4000)
DECLARE tableIndexes CURSOR FOR
SELECT name FROM sysindexes
WHERE id = OBJECT_ID(@tablename) AND
indid > 0 AND indid < 255 AND
INDEXPROPERTY(id, name, 'IsStatistics') = 0
ORDER BY indid DESC
OPEN tableIndexes
FETCH NEXT FROM tableIndexes INTO @indexName
WHILE @@fetch_status = 0
BEGIN
SET @dropIndexSql = N'DROP INDEX ' + @tablename + '.' + @indexName
EXEC sp_executesql @dropIndexSql
FETCH NEXT FROM tableIndexes INTO @indexName
END
CLOSE tableIndexes
DEALLOCATE tableIndexes
return 0
Microsoft OLE DB Provider for SQL Server
DDL statement is not allowed.


The Database MAILDB was set up, but no tables were created.

Is there any expert outside to help me?

Best regards
Detlef

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: Database creation failed

Post by ^DooM^ » 2009-07-10 12:18

So your using MSSQL? Which version exactly?
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

Majestix
New user
New user
Posts: 3
Joined: 2009-07-10 09:29

Re: Database creation failed

Post by Majestix » 2009-07-10 16:24

Hi ^DooM^

So Microsoft SQL Management Studio Express says:

Microsoft SQL Server Windows Internal Database
Version 9.00.4035.00

^DooM^
Site Admin
Posts: 13861
Joined: 2005-07-29 16:18
Location: UK

Re: Database creation failed

Post by ^DooM^ » 2009-07-12 17:57

On this page it says

http://www.hmailserver.com/documentatio ... quirements
hMailServer was designed to provide, in one single download, everything you need to run an email server. hMailServer has its own integrated database server, a light-weight version of the MSSQL database server. Should you not wish to use it, you can select one of the following database engines:

* MySQL 4.1.18 or later
* Microsoft SQL Server 2000 or later (including Express, Standard and Enterprise edition)
* PostgreSQL 8 or later.
I have never heard of Microsoft SQL Server Windows Internal Database before and wouldn't even know if it falls under the requirements. At this point in time I would say it doesn't and to use the built in database instead.
If at first you don't succeed, bomb disposal probably isn't for you! ヅ

huntor
New user
New user
Posts: 12
Joined: 2008-09-09 21:25

Re: Database creation failed

Post by huntor » 2009-07-13 05:33

I am installing a new test box and when I went to install an external version of hmail it says

The MySQL client (libmysql.dll, 32 bit) could not be loaded.
hMailServer needs this file to be able to connect to MySQL.
The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.
Path: C:\Program Files (x86)\hMailServer\Bin\libmysql.dll

I assume this file was suppost to be part of the hmail install????
I have used hmail for about a year now but my old box originall had hmail 4 on it and upgraded to 5 and so on.

This file is not included in the 5.1.2-B346 version.

User avatar
mattg
Moderator
Moderator
Posts: 20532
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database creation failed

Post by mattg » 2009-07-13 07:53

Did you actually read the error message? :wink:
huntor wrote:I am installing a new test box and when I went to install an external version of hmail it says

The MySQL client (libmysql.dll, 32 bit) could not be loaded.
hMailServer needs this file to be able to connect to MySQL.
The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.
Path: C:\Program Files (x86)\hMailServer\Bin\libmysql.dll

I assume this file was suppost to be part of the hmail install????
Incorrect assumption.

hMailserver 5 is NOT open source. This falls outside of the GNU licence that ships with MySQL. hMailserver is NOT allowed to include that file with it's installation.
If you downloaded MySQL then the missing file will be included in that download. (IE you will need to copy it from the MySQL installation folder to the required hMailserver directory)
If you upgraded then the version of that file from your hMailserver Ver4 installation will still be available.

If you downloaded the 64 bit version of MySQL then search this forum, Doom has posted a copy of the 32 bit dll as required by 32 bit hMailserver.
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

huntor
New user
New user
Posts: 12
Joined: 2008-09-09 21:25

Re: Database creation failed

Post by huntor » 2009-07-13 23:00

yeah I did what you said in order to correct my issue. I then just went ahead and use the default database instead of mysql. Just had to install the backup that way and converted from the mysql database to the default sql. That worked out very nice.

Majestix
New user
New user
Posts: 3
Joined: 2009-07-10 09:29

Re: Database creation failed

Post by Majestix » 2009-07-14 21:28

Hi all,
I'm not sure, but I think that the posts are not in context with my question.
My problem was with MSSQL not MySQL :!:
Is there anybody outhere, who knows about hmailserver and windows internal database.

Best regards

User avatar
mattg
Moderator
Moderator
Posts: 20532
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Database creation failed

Post by mattg » 2009-07-15 04:05

^DooM^ wrote:I have never heard of Microsoft SQL Server Windows Internal Database before and wouldn't even know if it falls under the requirements. At this point in time I would say it doesn't and to use the built in database instead.
I too have never heard of Microsoft SQL Server Windows Internal Database either.

Googling, I see that it is a 'lite' version of SQL Express 2005.

I'd try to not use that database and see how installation goes. Multiple versions should co-exist, and I saw a Microsoft paper on upgrading WSUS from internal database to SQL express 2005, if they can't co-exist. Test first if possible - do backups etc, especially if this is a production machine...

And you are correct, someone else hijacked this thread rather than start a new one as per the forum rules...but life's like that.
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Post Reply