<p style="font-size: 12pt; font-family: Arial;"><br></p><p style="font-size: 12pt; font-family: Arial;">We have configured our Shibboleth SP (v3.2.3)  to persist session information through AWS Aurora DB <span style="font-size: 12pt; font-family: Arial;">(use Postgresql v12.4) </span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;"><br></span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;">following the instructions for Postgresql (see : </span><a href="https://shibboleth.atlassian.net/wiki/spaces/SP3/pages/2065334638/ODBCStorageService#ODBCStorageService-PostgreSQL" style="font-size: 12pt; background-color: rgb(255, 255, 255);">https://shibboleth.atlassian.net/wiki/spaces/SP3/pages/2065334638/ODBCStorageService#ODBCStorageService-PostgreSQL</a><span style="font-size: 12pt; font-family: Arial;">) </span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;"><br></span></p><p style="font-size: 12pt; font-family: Arial;">In the StorageService section, there is the possibility to specify a scheme on the connection string ?</p><p style="font-size: 12pt; font-family: Arial;"><br></p><p>e.g: </p><p><StorageService type="ODBC" id="db" cleanupInterval="900"></p><p style="font-size: 12pt; font-family: Arial;">    <ConnectionString><![CDATA[ </p><p style="font-size: 12pt; font-family: Arial;">           Driver=PostgreSQL;Server=myhostname;Port=5432;Database=secure;Uid=secure;Password=secret;<span style="font-size: 12pt; font-family: Arial; font-weight: bold;">Schema=shibboleth</span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;">    ]]></ConnectionString></span></p><p>    </StorageService></p><p><br></p><p style="font-size: 12pt; font-family: Arial;">If we execute the DDL on a dedicated schema (e.g : shibboleth) in database with multiple schema (used for other purposes)</p><p style="font-size: 12pt; font-family: Arial;">we get the error :</p><p style="font-size: 12pt; font-family: Arial;"><br></p><p>2021-07-27 20:29:19 ERROR XMLTooling.StorageService : failed to read version from database</p><p style="font-size: 12pt; font-family: Arial;">2021-07-27 20:29:19 ERROR XMLTooling.StorageService : ODBC Error: 42P01:1:7:ERROR: <span style="font-weight: bold; font-size: 12pt; font-family: Arial;">relation "version" does not exist;</span></p><p>Error while executing the query</p><p>2021-07-27 20:29:19 CRIT Shibboleth.Config : failed to instantiate StorageService (db): ODBC StorageService failed to read version from database.</p><p>2021-07-27 20:29:19 ERROR Shibboleth.Config : unable to locate StorageService (db), using arbitrary instance for ReplayCache</p><p>2021-07-27 20:29:19 ERROR Shibboleth.Config : unable to locate StorageService (db), using in-memory ArtifactMap</p><p>2021-07-27 20:29:19 FATAL Shibboleth.Config : caught exception while loading configuration: SessionCache unable to locate StorageService (db), check configuration.</p><p style="font-size: 12pt; font-family: Arial;"><br></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;">If we execute the DDL (e.g : shibboleth) in database with only one schema (e.g: shibboleth) this works!.</span><br></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;"><br></span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;">Best regards.</span></p><p style="font-size: 12pt; font-family: Arial;"><span style="font-size: 12pt; font-family: Arial;">George.</span></p>