Thread: Here is the answer for setting up RoundCube Mail and MSSQL Server

JABBATEK YOU ARE AN !!! I LOVE YOU!!!

I was having issues with my server and your solution above works perfectly

I have been searching everywhere for this solution and you solved it!!

THANK YOU!

-Rilla

In addition to all that I have explained, you will need to make sure that the username you plan to use to connect to the RoundCube Mail database has read/write permissions to that database.

I got these settings to work by using the default config files. I copied the config files into a backup file and edited the deafult config files. I did not use the roundcube configurator.

JabbaTek - How did you manage the config files for your server?

-Rob

The "configurator" or the web page admin interface does not provide an option for MSSQL. So it does not know how to configure it. I did the same as you, I had to manually edit the db.inc.php file.

If figured out the how to format the string by looking at the parseDSN function.

I got the db connection to work, then I got the method not implemented error. I figured out that the mssql.php, along with the others like mysql.php, override a base class of mdb2.php. That's where I discovered that the setCharSet function was missing from the mssql.php file. SQL server doesn't support the commands it was trying to perform so I removed the code and had the function just return true. It worked and the error went away.

If you get an error stating that Inerting a null value caused a constraint violation, you will need to open the affected table, usually the Users table and set the columns to allow null. If you need help with this on MSSQL, please let me know.

If you do not want to ask questions in the thread, you can send me a private message.

It also appears that the scripts to create the tables for RC Mail in an MSSQL database have an error. The piece that creates the Identities table leaves off a column. It does not add the "html_signature" column (w/o quotes). You will need to add this column manually to your Identities table so you can create an identity so you can send messages.

Below is the information for creating the column in the IDentities table.

Name: html_signature
Data Type: bit
Allow Null: False or No
Default Value: 0

It turns out that RC Mail will not work with an instance of mssql other than the default machine name. So let's say your server name is MAILSERVER. With SQL 2005 and up, if you install the express (free) versions, they create an instance called SLEXPRESS automatically. This means that the host (server) that you would refer to is actually MAILSERVER\SQLEXPRESS.

The parseDsn function is not setup to handle this scenario. I will be working on fixing the parseDsn function and submitting it for download and for inclusion (hopefully) in future releases.

I will post the fix along with a complete guide to setting up with mssql, once I have the function fixed. The guide will include all of the kinks previously mentioned.

Hmmm..

First some details:

Windows SRV 2008
IIS 7
PHP 5.2.6
hMail
Roundcube 0.2 Beta (latest DL)
SQL Server 2005 std. (installed with instancename 'SQLSERVER')
Database is uprunning (can login via webinterface and see the full DB with full tables as in mssql.initial)
I have defined the user as DBO

Connection string:
$rcmail_config = 'mssql://rcwebmail:webmail@localhost\\SQLServer/RoundCube';

Tried with and without a defined DSN - gave me same result

The result is, that roundcube cant connect to the database.

Can some tell me whats missing or what i'm doing wrong ?

/ Bronx

MSSQL Server does not use "localhost" as an identifier. You have to use either "(Local)" with the parenthesis but not the quotes, or you need to use the machine name in place of localhost. If your machine name is SERVER then either of the following examples should work.

'mssql://rcwebmail:webmail@(Local)\\SQLServer/RoundCube';

'mssql://rcwebmail:webmail@SERVER\\SQLServer/RoundCube';

If neither of the above examples work, let me know. There may be an issue with using named instances with RC Mail which I may have figured out how to fix.

Also, make sure that mssql appears in the list of extensions when you run phpinfo().