Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

limesurvey on RHEL6 with sqlserver

  • juanjo76
  • juanjo76's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 4 months ago #144470 by juanjo76
limesurvey on RHEL6 with sqlserver was created by juanjo76
Hello,

I am trying to install limesurvey on RHEL6 with php 5.3.3 and DB sqlserver (2008 R2). I have seen that I must use the pdo_dblib, but I have a problem with this configurarion. I get this problem:

SQLSTATE[01002] Adaptive Server connection failed (severity 9)

My configuration is:


- pdo_dblib

# php -m| grep dblib
pdo_dblib

- freetds.conf
[TS]
host = XXX.domain
port = 1433
tds version = 7.3
client charset = UTF-8

- admin.php

return array(
'name' => 'LimeSurvey',
'components' => array(
'db' => array(
'connectionString' => 'dblib:host=XXX.domain:1433;dbname=LIMESURVEY',
'username' => 'myusername',
'password' => 'mypassword',
'charset' => 'ansi',
'tablePrefix' => '',
'initSQLs'=>array('SET DATEFORMAT ymd;','SET QUOTED_IDENTIFIER ON;'),
),

// Uncomment the following line if you need table-based sessions
// 'session' => array (
// 'class' => 'application.core.web.DbHttpSession',
// 'connectionID' => 'db',
// 'sessionTableName' => '{{sessions}}',
// ),

'urlManager' => array(
'urlFormat' => 'get',
'rules' => require('routes.php'),
'showScriptName' => true,
),

any idea about this problema?
The topic has been locked.
More
7 years 4 months ago #144473 by fvanderstarre
Replied by fvanderstarre on topic limesurvey on RHEL6 with sqlserver
I think it's recommended to have "tds version = 8.0" in freetds.conf; and I'm wondering about 'charset' => 'ansi' in your config.php - should be 'charset => 'utf-8' ?
At least that works for me (RHEL7 - PHP 5.6.27).
Consider updating your php version too, because 5.3.3. has been end-of-life for a long time now (even 5.5 is no longer maintained).
Hope this helps! Frank
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose