LimeSurvey 2.00+ On Linux with MSSQL 2008 Database

More
5 years 2 weeks ago #88050 by bnosie
bnosie created the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
Not having much luck installing 2.00+ on a Linux server, and connecting to a MS SQL 2008 database. pdo_sqlsrv is not an option, as this only runs on Windows. I cannot find any other documentation on installing on a MS SQL db. Anyone have any suggestions?

Please Log in to join the conversation.

More
5 years 1 week ago #88099 by fvanderstarre
fvanderstarre replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
We use FreeTDS ( www.unixodbc.org/doc/FreeTDS.html ). Hope this helps!

Please Log in to join the conversation.

More
5 years 1 week ago #88205 by bnosie
bnosie replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
Did you use this with a new installation of 2.00+? How did you get a MS SQL or ODBC to show up as an option for database type during installation? I can make an ODBC connection to the MS SQL database now from the Linux server, but cannot figure out how to get LimeSurvey to use it.

Please Log in to join the conversation.

More
5 years 1 week ago #88208 by c_schmitz
c_schmitz replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
If you have pdo_mssql activated in PHP it should show up during installation

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
5 years 1 week ago #88209 by fvanderstarre
fvanderstarre replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
I installed 1.92+.
The installation instructions say "If you configured everything correctly the LimeSurvey installer should be starting - just follow the instructions. You will be asked if to create the database and/or create the tables inside the database. Limesurvey then creates the needed tables in the database.".
You'll probably have to create an empty db first and enter the details when running the install script?
Or try and edit config.php in your Lime Survey root directory:
$databasetype = 'mssql_n';
$databaselocation = 'ms-sql-t246'; // Network location of your Database - for odbc_mssql or mssqlnative use the mssql servername, not localhost or IP
$databasename = 'LimeSurvey_test'; // The name of the database that we will create
$databaseuser = 'app_limesurvey_test'; // The name of a user with rights to create db (or if db already exists, then rights within that db)
$databasepass = '********'; // Password of db user
$dbprefix = ''; // A global prefix that can be added to all LimeSurvey tables. Use this if you are sharing
// a database with other applications. Suggested prefix is 'lime_'

Please Log in to join the conversation.

More
5 years 1 week ago #88244 by bnosie
bnosie replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
I have pdo_mssql installed, and in php_info, it shows MSSQL support enabled, but under PDO drivers, it does not show pdo_mssql. I have been searching all day on how to get this part enabled, and I keep running into things saying that it will not show up there. Not sure why. I can establish a db connection with pdo_dblib, any way to use that pdo driver? Or have any insight in configuring pdo_mssql?

Please Log in to join the conversation.

More
5 years 1 week ago #88246 by helper
helper replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
Attached my php.ini - you will need the thread safe Microsoft SQL DLL's (php_sqlsrv_54_ts.dll and php_pdo_sqlsrv_54_ts.dll - download directly from Microsoft).

We are running on Windows 2008r2 with SQL Server 2008

Please Log in to join the conversation.

More
5 years 1 week ago #88247 by bnosie
bnosie replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
My web server is 32 bit Linux, and Microsoft only has 64 bit Linux drivers for pdo_sqlsrv.

Please Log in to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #91643 by joop
joop replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
I have the same problem too.
Do I understand it right that LimeSurvey does not support MS SQL server under Linux at the moment for LimeSurvey 2.00+?
The manual says

Required: PDO database driver for MySQL (pdo_mysql or pdo_mysqli) or Postgres (pdo_pgsql) or MSSQL (pdo_sqlsrv)

.
As the pdo_sqlsrv runs only under Windows, I can't get it work under Linux, am I? Will pdo_DBLIB be supported in the future?

Best regards,

Joop
Last Edit: 4 years 10 months ago by joop.

Please Log in to join the conversation.

More
4 years 10 months ago #91644 by helper
helper replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
In retrospective, I would be curious as to why anybody would want to run anything Microsoft on any other OS-based box (including Linux). I just cannot make the case, especially since mySQL is free and M$ SQL has a charge per CPU (yeah, I'm cheap too!).

Please Log in to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #91646 by c_schmitz
c_schmitz replied the topic: LimeSurvey 2.00+ On Linux with MSSQL 2008 Database
pdo_dblib is described as 'experimental' and 'ancient' in the PHP documentation so unlikely we will support that.

We did not have the opportunity to test pdo_odbc yet.

Best regards

Carsten Schmitz
LimeSurvey project leader
Last Edit: 4 years 10 months ago by c_schmitz.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!