ODBCStorageService : Set a custom schema on ConnectionString.

[xinoxs78 at alice.it]

We have configured our Shibboleth SP (v3.2.3)  to persist session 
information through AWS Aurora DB (use Postgresql v12.4)

following the instructions for Postgresql (see : 
https://shibboleth.atlassian.net/wiki/spaces/SP3/pages/2065334638/ODBCStorageService#ODBCStorageService-PostgreSQL 
<https://shibboleth.atlassian.net/wiki/spaces/SP3/pages/2065334638/ODBCStorageService#ODBCStorageService-PostgreSQL> 
)

In the StorageService section, there is the possibility to specify a 
scheme on the connection string ?

e.g:
<StorageService type="ODBC" id="db" cleanupInterval="900">
     <ConnectionString><![CDATA[
 
Driver=PostgreSQL;Server=myhostname;Port=5432;Database=secure;Uid=secure;Password=secret;Schema=shibboleth
     ]]></ConnectionString>
     </StorageService>

If we execute the DDL on a dedicated schema (e.g : shibboleth) in 
database with multiple schema (used for other purposes)
we get the error :

2021-07-27 20:29:19 ERROR XMLTooling.StorageService : failed to read 
version from database
2021-07-27 20:29:19 ERROR XMLTooling.StorageService : ODBC Error: 
42P01:1:7:ERROR: relation "version" does not exist;
Error while executing the query
2021-07-27 20:29:19 CRIT Shibboleth.Config : failed to instantiate 
StorageService (db): ODBC StorageService failed to read version from 
database.
2021-07-27 20:29:19 ERROR Shibboleth.Config : unable to locate 
StorageService (db), using arbitrary instance for ReplayCache
2021-07-27 20:29:19 ERROR Shibboleth.Config : unable to locate 
StorageService (db), using in-memory ArtifactMap
2021-07-27 20:29:19 FATAL Shibboleth.Config : caught exception while 
loading configuration: SessionCache unable to locate StorageService 
(db), check configuration.

If we execute the DDL (e.g : shibboleth) in database with only one 
schema (e.g: shibboleth) this works!.

Best regards.
George.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20210727/47d10cdd/attachment.htm>