Issues with ODBCStorageService

[Thomas Rudolf]

Dear all,

I am trying to set up session storage with a SQL Server for our shibboleth SP3 but can not get shibboleth to connect to SQL Server DB.

In our shibboleth2.xml we have the following connection string:

"<ConnectionString>DRIVER=freetds;SERVER=mssql.shared-shibboleth_default;UID=<user>;PWD=<pwd>;DATABASE=shibboleth;APP=shibboleth</ConnectionString>"

Unfortunately, with this configuration I get:

"ODBC Error: 08S01:2:20009:[FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist"

When I try to connect to the db from the command line within the shibboleth container like so "tsql -S mssql -U sa -P Testing0! -D shibboleth" i get a working connection.

Note: For the tsql command both mssql and mssql.shared-shibboleth_default work as server. (Both versions have been unsuccessfully tried for the connection string as well)

We're using shibboleth 3.1.0 running on centOS8 and SQL Server 2019, SQL Server is running on default port 1433, both SP3 & MSSql are dockerized and share the "shared-shibboleth_default" network.

Any kind of help or pointers as to what to try or better debug this issue are much appreciated.

Best,
Thomas Rudolf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20211104/c7e9bc0c/attachment.htm>