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

Hi,

I am trying to get Roundcube to work with SQL Server 2008. Is this currently supported, or planned to be soon?

Lee

Hi there,

I tried to run the query mssql_initial.sql on SQL2008Express and got this error.

I followed all your steps but no luck.
When I went to the website, it just gave me blank screen
Hmail is running fine.

O/S: Windows Server 2003 Std R2
SQL2008Express

mssql://roundcube:mypass@hmailserver\sqlexpress/roundcube
or
mssql://roundcube:mypass@hmailserver\\sqlexpress/roundcube
or
mssql://sa:sa_pass@hmailserver\sqlexpress/roundcube

Please help !

Thank you.

I forgot to attach the error when I ran the mssql.initial.sql query on SQL2008Express

Msg 102, Level 15, State 1, Line 6
Incorrect syntax near ','.

Hope somebody can point me the right direction.

Thanks.

I have followed these instructions and I know I am really close to having this working!!

I am running 2K3 Enterprise with IIS6.
PHP 5.2.9-1 using fastcgi, mssql enabled in the config files
MSSQL Express 2005
Roundcube 0.2.1

I created the database 'roundcube' in SQL Express, opened and ran the 'mssql.initial.sql' file. It generated the following error, although it looks like it created all the tables.

Code:

Msg 102, Level 15, State 1, Line 6
Incorrect syntax near ','.

I created a user rcmail with a password of rcwebmail. Edited the db.inc.php to look like this:

Code:

$rcmail_config['db_dsnw'] = 'mssql://rcmail:rcwebmail@HMAIL\\SQLEXPRESS/roundcube';

I placed the extra code in the mssql.php file as shown below:

PHP Code:

class MDB2_Driver_mssql extends MDB2_Driver_Common
{
    // {{{ properties

    var $string_quoting = array('start' => "'", 'end' => "'", 'escape' => "'", 'escape_pattern' => false);

    var $identifier_quoting = array('start' => '[', 'end' => ']', 'escape' => ']');

    function setCharset($charset, $connection = null)
{

return true;

}

    // }}}
    // {{{ constructor 


I enable trace debugging and when I attempt to load the webmail page, this is what I get.

Code:

MDB2 Error: connect failed (-24): _doConnect: [Error message: unable to establish a connection]

Any ideas?

Hi,

If there's anyone out there still trying to get this working... like me...

In addition to the following:

1) Do NOT install the Microsoft PHP SQL Driver SQLSrv, make sure there are no references to it anywhere!
2) Ensure you have the extension=php_mssql.dll in php.ini
3) Verify that mssql is working properly by using the phpinfo() function in a php file in your mail root
4) Ensure you put the setCharSet blank function in the right place.
5) You will need to add the html_signature field and change some of the fields to allow NULLs.

I think all of the above is detailed in this post somewhere, or only a google away...

If you have the problem with SERVER\SQLEXPRESS then use the Sql Server Configuration Manager to set an Alias for the server e.g. SERVER01

This will mean instead of:

PHP Code:

mssql://user:pass@SERVER\\SQLEXPRESS/roundcube 


(which I could not get to work)

You can use:

PHP Code:

mssql://user:pass@SERVER01/roundcube 


(which is now working)

..If only I could get the plugins working properly...

Originally Posted by JabbaTek

For all of those who have been having issues with MSSQL and RoundCube, I give to you the answer.

I have RoundCube (with HMail) running in the following environment. It works great and is fast.

Windows Server 2008 Standard
IIS 7
PHP 5.x.x
Beta version on RoundCube (latest version)
Miscrosft SQL Server 2005

First you will need to have installed MSSQL. Most will be running MSDE 2000 or SQL Express 2005. Both are the free versions from Microsoft.

Second, create a database such as RoundCube. IF you have SQL Express 2005, then you will need to download (if you haven't already) SQL Management Studio Express.

Third, open the mssql.initial file found in the \SQL folder where RoundCube Mail is installed. Copy the contents of that file into a new query window in Management Studio. Make sure you selected your new database before opening a new query window to set the contect to that database. Execute the statements that you just copied in.

Fourth, you will need to edit the db.inc.php file in the Config folder. Find the line that starts with $rcmail_config['db_dsnw']. I will provide 2 examples of how to write the line. The examples assume the following:

Machine name (of host) = MAILSERVER
Database name = RoundCube
Username = rcmail
Password = webmail

Example 1:
'mssql://rcmail:webmail@MAILSERVER/RoundCube'

Example 2 (assumes you have an instance of MSSQL called SQLEXPRESS):
'mssql://rcmail:webmail@MAILSERVER\\SQLEXPRESS/RoundCube'

if you installed SQL Express 2005, you will most likely have the instance.

Last but not least, there is a missing function in the \program\lib\MDB2\Driver\mssql.php file. The function is SetCharSet. If you do not add the missing function, you will receive an error message stating that the SetCharSet method is not implemented. I have attached a copy of my mssql.php file for convenience, but here are the missing lines in that file.

function setCharset($charset, $connection = null)
{

return true;

}

Once this is all done, it should work just fine (at least the database portion).

If you have questions or run into trouble getting it to work please reply and I will be happy to try and help.

By any chance do you know how to set up the "outgoing server" on a Palm Pre so that I can reply to my company e-mail. I have been able to get my mail pushed to the Palm, but I do not know the server that Round Cube uses so that I can reply directly to those e-mails. Any help is greatly appreciated.

Joel

Hey Guys,

I installed and configured RoundCube as you wrote and it's possible to open the login-page.
My problem now is that I cannot login with my email-adresses, set up in hmailserver. I tried the internal and the external adresses but I allways get a message that the login failed.
Any idea how to log in?

Ok, got it myself.
Autocreate was set to TRUE but the mssql.initial.sql script sets the table users to NULL for most of the fields. Changed this values and now it works.

wel I've managed to get the login screen following these directions. What a PAIN PHP is on IIS 6.0

Some notes on what I've discovered.

DO NOT use the thread safe php implementation. It only makes you go bald. Appears to work but fast requests will shut down FastCGI in a heartbeat.

Now to my problem ...

The login page comes up and then, after entering credentials I get this noise:

The page cannot be displayed
You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.
--------------------------------------------------------------------------------

Please try the following:

•Contact the Web site administrator if you believe this directory should allow execute access.
HTTP Error 403.1 - Forbidden: Execute access is denied.
Internet Information Services (IIS)

SAY WHAT? Why would the login page work but subsequent pages NOT work?

Anyone else seen this?

Installation details:
Windows Server 2003 Enterprise Build 3790
FastCGI 6.1.36.1
PHP 5.2.11

Have you checked the folder privileges?