Home » Forums » ejabberd & XMPP » ejabberd Administration

Problems with Microsoft SQL Server database creation

Submitted by mlogan on Tue, 2009-07-28 15:43

I've installed eJabberd a couple of times now on different windows machines. Both times its been up and running with minimal problems. Now I want to migrate to SQL server so that we can integrate it into another system that we're writing, but the database creation fails.

My problem comes when I try to create the sql database. I installed SQL 2000 (with service packs). I created the ejabberd database. I grabbed the mssql.sql out of the 2.0.5 source package and opened it in query analyzer. When I run it to create the database structure, I get all kinds of errors. The first is that its using BIGINT UNSIGNED - there is no unsigned in sql server that I can find.

I went back to the 2.0.4 and 2.0.3 packages and they have that same UNSIGNED value in there.

So, it seems that the file is wrong. Am I missing something? Do I need a newer sql version or something like that? Do I have the wrong sql file?

Any feedback would be greatly appreciated.

‹ ejabberd 2.0.1 (solved: mod_*_odbc) and (unsolved: roster status updates) How to store conversations in logs? ›

> Do I have the wrong sql

Submitted by mfoss on Mon, 2009-08-03 09:54.

> Do I have the wrong sql file?

Yes, it seems the mssql.sql file included in ejabberd is only usable by some MSSQL versions.

There was a change in SVN r1558:

* src/odbc/mssql2000.sql: Script for MSSQL 2000
* src/odbc/mssql2005.sql: Script for MSSQL 2005
* src/odbc/mssql.sql: removed

So the future ejabberd 2.1.0 will have two versions of the file.

You can get those files here:
http://svn.process-one.net/ejabberd/trunk/src/odbc/

Let's hope those files from SVN work correctly with 2.0.5.

»
Syndicate content

User login