Author Topic: Issue: Trouble with Roundcube installer & MSSQL 2016  (Read 103512 times)

Offline thefid

  • Newbie
  • *
  • Posts: 9
Issue: Trouble with Roundcube installer & MSSQL 2016
« on: March 04, 2017, 03:59:18 PM »
I suspect the issue is with the following section as I no longer have any "Not OK" lines...

Checking available databases
Check which of the supported extensions are installed. At least one of them is required.

MySQL:  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-mysql.php)
PostgreSQL:  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-pgsql.php)
SQLite:  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-sqlite.php)
SQLite (v2):  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-sqlite.php)
SQL Server (SQLSRV):  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-sqlsrv.php)
SQL Server (DBLIB):  NOT AVAILABLE(See http://www.php.net/manual/en/ref.pdo-dblib.php)
Oracle:  NOT AVAILABLE(See http://www.php.net/manual/en/book.oci8.php)

Everything else on the Installer page is OK, yet I still get the error message:

Sorry but your webserver does not meet the requirements for Roundcube!
Please install the missing modules or fix the php.ini settings according to the above check results.
Hint: only checks showing NOT OK need to be fixed.

EDIT to clarify: Using Windows SQL Server 2016 and PHP 7.1
« Last Edit: April 05, 2017, 08:39:26 AM by thefid »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #1 on: March 04, 2017, 04:31:31 PM »
You need to have the PHP SQLSRV PDO driver http://php.net/manual/en/ref.pdo-sqlsrv.php to be able to connect to MSSQL.

Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #2 on: March 04, 2017, 05:59:07 PM »
You need to have the PHP SQLSRV PDO driver http://php.net/manual/en/ref.pdo-sqlsrv.php to be able to connect to MSSQL.

I installed version 4.0 of the drivers you suggested and added the following lines to the ini file:
extension=php_sqlsrv_7_ts.dll
extension=php_mssql.dll
extension=msql.dll

None of those made any difference on the installer test page. I also checked the ext location for the appropriate dll files.



Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #3 on: March 04, 2017, 06:43:34 PM »
Do you have the PHP PDO driver installed?
Did you restart PHP after you installed the drivers?

Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #4 on: March 05, 2017, 02:22:45 AM »
Yes, I did restart PHP. I even restarted the machine.

The MS download had about 8 PDO related extensions available. I only added the extensions listed above in hopes it would work. Should I add all of the DLL files added by Microsoft's download?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #5 on: March 05, 2017, 01:27:50 PM »
There should be one called something like php_pdo.dll which is the base of the PDO system and needed to run any of the drivers.

Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #6 on: March 05, 2017, 05:19:54 PM »
I have attached a directory list of files. I do not have a php_pdo.dll, however we do have a few other options.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #7 on: March 05, 2017, 05:29:49 PM »
Looking at the documentation http://php.net/manual/en/pdo.installation.php it appears since PHP 5.3 you don't need the php_pdo.dll anymore. You'd want one of the php_pdo_sqlsrv_*.dll drivers, based on the documentation http://php.net/manual/en/ref.pdo-sqlsrv.php
Code: [Select]
If you are running non-thread-safe PHP (PHP 5.3), use the php_pdo_sqlsrv_53_nts.dll file. (You should use a non-thread-safe version if you are using IIS as your web server). If you are running thread-safe PHP, use the php_pdo_sqlsrv_53_ts.dll file. Similarly for PHP 5.4, use the php_pdo_sqlsrv_54_nts.dll or php_pdo_sqlsrv_54_ts.dll depending on whether your PHP installation is non-thread-safe or thread-safe.

Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #8 on: March 05, 2017, 11:35:00 PM »
With help of the suggestions here, I think I decoded the driver file names downloaded from Microsoft.

There were 8 drivers added to the extensions, 4 were not PDO, while 4 were. Of those 4 PDO, 2 were for x86 and 2 for x64. Of those 2 for my 64 bit OS, one is for Non-Thread Safe (NTS) while the other is TS. Based on this, I really only have 1 driver which is applicable.

So I added the DLL extension in the INI file and still no success. I am still not seeing any listed SQL driver in the Roundcube installer page.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #9 on: March 06, 2017, 09:07:04 AM »
Hmm, well I'm out of ideas. I'm not a Windows guy so you may get a better response on a Windows forum since this isn't really a Roundcube specific question.

Offline fluxnull

  • Newbie
  • *
  • Posts: 1
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #10 on: March 17, 2017, 04:26:22 PM »
SKaero I can get you a little further.

If you're using IIS you need to use the non thread safe version of PHP. I was doing testing on Windows 10 Pro x64, IIS, with PHP 7.1 x64 (Non Thread Safe), and MSSQL 2016 Express(ODBC 13). 

These PDO drivers work.
https://github.com/Microsoft/msphpsql/releases

Specifically
https://github.com/Microsoft/msphpsql/releases/tag/4.1.5-Windows
7.1 Driver

Place the drivers in your extension directory specified in the php.ini and add the following entries to your php.ini

extension=php_sqlsrv_71_nts.dll
extension=php_pdo_sqlsrv_71_nts.dll

Then the SQL Server (SQLSRV) will become available and the installer script will flag it as OK, however when testing the config (step 3) I kept getting issue with the roundcube installer script saying that the database was not initialized. throwing an ODBC 13 error I would provide it but I dont actively have it accessible at the moment that I'm writing this.  I tried running the database creation (.sql) script directly on the server hoping that would initialize the database appropriately.

As far as SQL is concerned I created a separate user for running roundcube exclusively. Setting both owner and dbcreator permissions for the roundcube database initially. Later in a vain effort to get it working I temporarily granted it sysadmin to no avail as a test.

Then I though perhaps the PDO driver was not working or installed correctly. So i tested it with a small PHP script to connect and return records from a database this worked without issue so it seems to be something particular to roundcubes installer script where it is failing.

One thing i will mention is when i added the extensions at the time i personally only add "extension=php_pdo_sqlsrv_71_nts.dll" however I've done some additional reading and found that its advised to add both as I mentioned above if you try this and find success let me know otherwise I will likely be testing this this weekend myself.







Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #11 on: March 30, 2017, 08:06:25 AM »
Thank you, I had wondered if there was a PHP version specific driver. That did the trick and I can get to step 3.

I did install both drivers. This link explains how:
https://msdn.microsoft.com/en-us/library/cc296203.aspx

I am now having issues with the DB user logging in (Windows Authentication VS SQL Server). I will work on that and let you know.
« Last Edit: March 30, 2017, 08:14:30 AM by thefid »

Offline thefid

  • Newbie
  • *
  • Posts: 9
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #12 on: April 06, 2017, 08:59:17 PM »
I had permission issues with the SQL server on Step 3, I resolved it by creating a user from the Root SQL Server and then going to the DB to give that user security access. Once I did that, it fixed my permission denied issue.

Thanks for everyone's help!

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Issue: Trouble with Roundcube installer & MSSQL 2016
« Reply #13 on: April 06, 2017, 11:08:11 PM »
Glad that you where able to figure out the problem. Hopefully this thread will be useful to anyone else who is trying to setup Roundcube with MSSQL.