Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
icinga-migration opened this issue Sep 5, 2016 · 6 comments
Closed

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

icinga-migration opened this issue Sep 5, 2016 · 6 comments
Labels
bug Something isn't working
Milestone

Comments

@icinga-migration
Copy link

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

@icinga-migration
Copy link
Author

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
Copy link
Author

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
Copy link
Author

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

@icinga-migration icinga-migration added feedback bug Something isn't working labels Jan 17, 2017
@Hrocc
Copy link

Hrocc commented Jan 19, 2017

any news on this? do you need more feedback?

@eyesonlyone
Copy link

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
Copy link
Member

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.

@lippserd lippserd added this to the 2.4.2 milestone Sep 20, 2017
lippserd added a commit that referenced this issue Sep 20, 2017
…e pdolib extension

fixes #2545

(cherry picked from commit f25420f)
Signed-off-by: Eric Lippmann <eric.lippmann@icinga.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants