search

GluuFederation / community-edition-setup

Scripts and templates to automate deployment and configuration of the Gluu Server Community Edition
https://gluu.org/docs/ce
MIT License
188 stars 58 forks source link

Incorrect JDBC driver class in SAML IDP [postgresql] #946

Closed uprightech closed 1 year ago

uprightech commented 1 year ago

After installation of Gluu CE 4.5, SAML IDP does not return attributes as described in this related issue. The cause of this is during installation, the wrong JDBC driver class is specified in the file /opt/shibboleth-idp/conf/datasources.properties. The property idp.attribute.resolver.datasource.driverClass has value com.pgsql.jdbc.Driver instead of org.postgresql.Driver.

Also the property idp.attribute.resolver.datasource.jdbcUrl has the wrong value. It is currently prefixed with jdbc:pgsql instead of jdbc:postgresql.

uprightech commented 1 year ago

Unfortunately this isn't working. This results in the driverClass having the value com.postgresql.jdbc.Driver instead of org.postgresql.Driver. Note the com instead of org at the start of the driverClass and the extra jdbc right after postgresql which shouldn't figure there.

devrimyatar commented 1 year ago

This time, it should be good image

uprightech commented 1 year ago

One last thing again. The jdbc suffix after postgresql must be removed. So it is org.postgresql.Driver not org.postgresql.jdbc.Driver. This is only on postgresql.