Icingaweb2: [dev.icinga.com #12640] MSSQL ressource not working

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/12640

Created by hroc on 2016-09-05 08:28:26 +00:00

Assignee: _hroc_
Status: _Feedback_
Target Version: _(none)_
Last Update: _2016-10-06 07:38:58 +00:00 (in Redmine)_

---

"Connection failed PDO::__construct(): SQLSTATE[IM001]: Driver does not support this function: driver does not support setting attributes"

OS: Debian 8 / Freetds 0.91-6

other people are reporting the same problem on the forums:

https://monitoring-portal.org/index.php?thread/36062-mssql-datenbanken-als-importquelle/

Attachments

• icingaweb2_mssql-error.JPG hroc - _2016-09-05 08:26:04 +00:00_

[icinga-migration]

Updated by hroc on 2016-09-06 09:21:01 +00:00

php5-sybase php5-5.6.24+dfsg-0+deb8u1
icingaweb2 2.3.4+fix-1~debmon8+1

[icinga-migration]

Updated by elippmann on 2016-10-05 14:38:55 +00:00

• Status changed from _New_ to _Feedback_
• Assigned to set to _hroc_

Hi,

Which MSSQL server are you using?

Best regards,
Eric

[icinga-migration]

Updated by hroc on 2016-10-06 07:38:58 +00:00

we are using MSSQL Server 2012

/etc/freetds/freetds.conf:

[global]
tds version = 7.1
client charset = UTF-8
text size = 64512

[SQLHOST]
host = SQLHOST
tds version = 7.1
port = 1433

[Hrocc]

any news on this? do you need more feedback?

[eyesonlyone]

A solution or at least a workaround would be very nice. I would like to import virtual machines into the director database from vcenter mssql.

[lippserd]

Apart from the commit, I strongly suggest to install the PDO adapter from Microsoft: https://github.com/Microsoft/msphpsql/releases. I consider the pdolib extension as not production ready because it seems unmaintained and lacks features like setting attributes. If you use the PDO adapter from Microsoft, make sure to set pdoType to sqlsrv in your ressources.ini.