search

GluuFederation / oxTrust

Gluu Server UI for managing authentication, authorization and users.
https://gluu.org/docs/ce
MIT License
134 stars 60 forks source link

identity service failing in 4.5.5-1 when using mysql as backend #2434

Closed mzico closed 1 month ago

mzico commented 1 month ago

Installed Gluu 4.5.5-1 with mysql as backend. Service shibboleth is selected during installation. Identity is not starting properly.

Identity jetty log saying... 

2024-08-27 18:54:05,274 INFO  [main] [org.gluu.oxtrust.service.ShibbolethInitializer] (ShibbolethInitializer.java:43) - IDP config generation is set to true
2024-08-27 18:54:05.367:WARN :oejw.WebAppContext:main: Failed startup of context o.e.j.w.WebAppContext@e70f13a{oxTrust Server,/identity,[file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/oxtrust-static-4.5.5.Final.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/scim-model-4.5.5.Final.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/omnifaces-2.6.9.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/bootsfaces-1.5.0.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/primefaces-13.0.3.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/richfaces-a4j-4.5.19-gluu.Final.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/richfaces-4.5.19-gluu.Final.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/richfaces-core-4.5.19-gluu.Final.jar!/META-INF/resources, jar:file:///opt/jetty-10.0/temp/jetty-localhost-8082-identity_war-_identity-any-3127302310425495860/webapp/WEB-INF/lib/jakarta.faces-2.3.18.jar!/META-INF/resources],UNAVAILABLE}{/opt/gluu/jetty/identity/webapps/identity.war}
org.gluu.persist.exception.EntryPersistenceException: Failed to find entries with key: 'trustRelationships'
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntriesImpl(SqlEntryManager.java:495)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntries(SqlEntryManager.java:390)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:191)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:158)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:164)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38)
    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:106)
    at org.gluu.persist.PersistenceEntryManager$EntityManager$1037559105$Proxy$_$$_WeldClientProxy.findEntries(Unknown Source)
    at org.gluu.oxtrust.service.TrustService.getAllActiveTrustRelationships(TrustService.java:147)
    at org.gluu.oxtrust.service.TrustService$Proxy$_$$_WeldClientProxy.getAllActiveTrustRelationships(Unknown Source)
    at org.gluu.oxtrust.service.ShibbolethInitializer.createShibbolethConfiguration(ShibbolethInitializer.java:45)
    at org.gluu.oxtrust.service.ShibbolethInitializer$Proxy$_$$_WeldClientProxy.createShibbolethConfiguration(Unknown Source)
    at org.gluu.oxtrust.service.AppInitializer.applicationInitialized(AppInitializer.java:208)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:85)
    at org.jboss.weld.injection.MethodInvocationStrategy$SimpleMethodInvocationStrategy.invoke(MethodInvocationStrategy.java:168)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
    at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
    at javax.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:124)
    at org.jboss.weld.util.Observers.notify(Observers.java:166)
    at org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
    at org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
    at org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
    at org.jboss.weld.bootstrap.BeanDeploymentModule.fireEvent(BeanDeploymentModule.java:93)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.fireEventForApplicationScope(HttpContextLifecycle.java:161)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.contextInitialized(HttpContextLifecycle.java:147)
    at org.jboss.weld.module.web.servlet.WeldInitialListener.contextInitialized(WeldInitialListener.java:99)
    at org.jboss.weld.servlet.api.helpers.ForwardingServletListener.contextInitialized(ForwardingServletListener.java:34)
    at org.jboss.weld.environment.servlet.EnhancedListener.onStartup(EnhancedListener.java:66)
    at org.eclipse.jetty.servlet.ServletContainerInitializerHolder.doStart(ServletContainerInitializerHolder.java:148)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    at org.eclipse.jetty.servlet.ServletContextHandler$ServletContainerInitializerStarter.doStart(ServletContextHandler.java:1658)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:369)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:901)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:40)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:183)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:516)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:210)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:462)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:61)
    at org.eclipse.jetty.util.Scanner$DiscreteListener.pathAdded(Scanner.java:284)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:896)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:862)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:769)
    at org.eclipse.jetty.util.Scanner.startScanning(Scanner.java:658)
    at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:630)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:182)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:605)
    at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:246)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.server.Server.start(Server.java:470)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
    at org.eclipse.jetty.server.Server.doStart(Server.java:415)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1919)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.eclipse.jetty.start.Main.invokeMain(Main.java:229)
    at org.eclipse.jetty.start.Main.start(Main.java:528)
    at org.eclipse.jetty.start.Main.main(Main.java:76)
Caused by: 
Failed to build search entries query. Key: 'trustRelationships', expression: 'doc.gluuStatus = active'
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.searchImpl(SqlOperationServiceImpl.java:498)
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.search(SqlOperationServiceImpl.java:415)
    at org.gluu.persist.sql.impl.SqlEntryManager.searchImpl(SqlEntryManager.java:555)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntriesImpl(SqlEntryManager.java:486)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntries(SqlEntryManager.java:390)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:191)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:158)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:164)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38)
    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:106)
    at org.gluu.persist.PersistenceEntryManager$EntityManager$1037559105$Proxy$_$$_WeldClientProxy.findEntries(Unknown Source)
    at org.gluu.oxtrust.service.TrustService.getAllActiveTrustRelationships(TrustService.java:147)
    at org.gluu.oxtrust.service.TrustService$Proxy$_$$_WeldClientProxy.getAllActiveTrustRelationships(Unknown Source)
    at org.gluu.oxtrust.service.ShibbolethInitializer.createShibbolethConfiguration(ShibbolethInitializer.java:45)
    at org.gluu.oxtrust.service.ShibbolethInitializer$Proxy$_$$_WeldClientProxy.createShibbolethConfiguration(Unknown Source)
    at org.gluu.oxtrust.service.AppInitializer.applicationInitialized(AppInitializer.java:208)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:85)
    at org.jboss.weld.injection.MethodInvocationStrategy$SimpleMethodInvocationStrategy.invoke(MethodInvocationStrategy.java:168)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
    at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
    at javax.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:124)
    at org.jboss.weld.util.Observers.notify(Observers.java:166)
    at org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
    at org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
    at org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
    at org.jboss.weld.bootstrap.BeanDeploymentModule.fireEvent(BeanDeploymentModule.java:93)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.fireEventForApplicationScope(HttpContextLifecycle.java:161)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.contextInitialized(HttpContextLifecycle.java:147)
    at org.jboss.weld.module.web.servlet.WeldInitialListener.contextInitialized(WeldInitialListener.java:99)
    at org.jboss.weld.servlet.api.helpers.ForwardingServletListener.contextInitialized(ForwardingServletListener.java:34)
    at org.jboss.weld.environment.servlet.EnhancedListener.onStartup(EnhancedListener.java:66)
    at org.eclipse.jetty.servlet.ServletContainerInitializerHolder.doStart(ServletContainerInitializerHolder.java:148)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    at org.eclipse.jetty.servlet.ServletContextHandler$ServletContainerInitializerStarter.doStart(ServletContextHandler.java:1658)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:369)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:901)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:40)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:183)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:516)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:210)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:462)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:61)
    at org.eclipse.jetty.util.Scanner$DiscreteListener.pathAdded(Scanner.java:284)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:896)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:862)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:769)
    at org.eclipse.jetty.util.Scanner.startScanning(Scanner.java:658)
    at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:630)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:182)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:605)
    at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:246)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.server.Server.start(Server.java:470)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
    at org.eclipse.jetty.server.Server.doStart(Server.java:415)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1919)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.eclipse.jetty.start.Main.invokeMain(Main.java:229)
    at org.eclipse.jetty.start.Main.start(Main.java:528)
    at org.eclipse.jetty.start.Main.main(Main.java:76)
Caused by: 
com.querydsl.core.QueryException: Caught SQLSyntaxErrorException for select doc.gluuEntityType, doc.gluuSAMLspMetaDataSourceType, doc.displayName, doc.gluuSpecificRelyingPartyConfig, doc.description, doc.inum, doc.gluuTrustDeconstruction, doc.oxAuthPostLogoutRedirectURI, doc.gluuStatus, doc.gluuValidationLog, doc.gluuValidationStatus, doc.gluuEntityId, doc.spLogoutRedirectUrl, doc.researchAndScholarshipEnabled, doc.gluuProfileConfiguration, doc.gluuReleasedAttribute, doc.gluuTrustContact, doc.gluuContainerFederation, doc.gluuSAMLspMetaDataURL, doc.gluuIsFederation, doc.gluuSAMLmaxRefreshDelay, doc.url, doc.o, doc.gluuSAMLspMetaDataFN, doc.gluuSAMLMetaDataFilter, doc.dn, doc.doc_id|from gluudb.gluuSAMLconfig doc|where doc.gluuStatus = ?|limit ?|offset ?
    at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
    at com.querydsl.sql.Configuration.translate(Configuration.java:507)
    at com.querydsl.sql.AbstractSQLQuery.getResults(AbstractSQLQuery.java:311)
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.searchImpl(SqlOperationServiceImpl.java:473)
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.search(SqlOperationServiceImpl.java:415)
    at org.gluu.persist.sql.impl.SqlEntryManager.searchImpl(SqlEntryManager.java:555)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntriesImpl(SqlEntryManager.java:486)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntries(SqlEntryManager.java:390)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:191)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:158)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:164)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38)
    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:106)
    at org.gluu.persist.PersistenceEntryManager$EntityManager$1037559105$Proxy$_$$_WeldClientProxy.findEntries(Unknown Source)
    at org.gluu.oxtrust.service.TrustService.getAllActiveTrustRelationships(TrustService.java:147)
    at org.gluu.oxtrust.service.TrustService$Proxy$_$$_WeldClientProxy.getAllActiveTrustRelationships(Unknown Source)
    at org.gluu.oxtrust.service.ShibbolethInitializer.createShibbolethConfiguration(ShibbolethInitializer.java:45)
    at org.gluu.oxtrust.service.ShibbolethInitializer$Proxy$_$$_WeldClientProxy.createShibbolethConfiguration(Unknown Source)
    at org.gluu.oxtrust.service.AppInitializer.applicationInitialized(AppInitializer.java:208)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:85)
    at org.jboss.weld.injection.MethodInvocationStrategy$SimpleMethodInvocationStrategy.invoke(MethodInvocationStrategy.java:168)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
    at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
    at javax.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:124)
    at org.jboss.weld.util.Observers.notify(Observers.java:166)
    at org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
    at org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
    at org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
    at org.jboss.weld.bootstrap.BeanDeploymentModule.fireEvent(BeanDeploymentModule.java:93)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.fireEventForApplicationScope(HttpContextLifecycle.java:161)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.contextInitialized(HttpContextLifecycle.java:147)
    at org.jboss.weld.module.web.servlet.WeldInitialListener.contextInitialized(WeldInitialListener.java:99)
    at org.jboss.weld.servlet.api.helpers.ForwardingServletListener.contextInitialized(ForwardingServletListener.java:34)
    at org.jboss.weld.environment.servlet.EnhancedListener.onStartup(EnhancedListener.java:66)
    at org.eclipse.jetty.servlet.ServletContainerInitializerHolder.doStart(ServletContainerInitializerHolder.java:148)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    at org.eclipse.jetty.servlet.ServletContextHandler$ServletContainerInitializerStarter.doStart(ServletContextHandler.java:1658)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:369)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:901)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:40)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:183)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:516)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:210)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:462)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:61)
    at org.eclipse.jetty.util.Scanner$DiscreteListener.pathAdded(Scanner.java:284)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:896)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:862)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:769)
    at org.eclipse.jetty.util.Scanner.startScanning(Scanner.java:658)
    at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:630)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:182)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:605)
    at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:246)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.server.Server.start(Server.java:470)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
    at org.eclipse.jetty.server.Server.doStart(Server.java:415)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1919)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.eclipse.jetty.start.Main.invokeMain(Main.java:229)
    at org.eclipse.jetty.start.Main.start(Main.java:528)
    at org.eclipse.jetty.start.Main.main(Main.java:76)
Caused by: 
java.sql.SQLSyntaxErrorException: Unknown column 'doc.spLogoutRedirectUrl' in 'field list'
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
    at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
    at com.querydsl.sql.AbstractSQLQuery.getResults(AbstractSQLQuery.java:292)
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.searchImpl(SqlOperationServiceImpl.java:473)
    at org.gluu.persist.sql.operation.impl.SqlOperationServiceImpl.search(SqlOperationServiceImpl.java:415)
    at org.gluu.persist.sql.impl.SqlEntryManager.searchImpl(SqlEntryManager.java:555)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntriesImpl(SqlEntryManager.java:486)
    at org.gluu.persist.sql.impl.SqlEntryManager.findEntries(SqlEntryManager.java:390)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:191)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:158)
    at org.gluu.persist.impl.BaseEntryManager.findEntries(BaseEntryManager.java:164)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38)
    at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:106)
    at org.gluu.persist.PersistenceEntryManager$EntityManager$1037559105$Proxy$_$$_WeldClientProxy.findEntries(Unknown Source)
    at org.gluu.oxtrust.service.TrustService.getAllActiveTrustRelationships(TrustService.java:147)
    at org.gluu.oxtrust.service.TrustService$Proxy$_$$_WeldClientProxy.getAllActiveTrustRelationships(Unknown Source)
    at org.gluu.oxtrust.service.ShibbolethInitializer.createShibbolethConfiguration(ShibbolethInitializer.java:45)
    at org.gluu.oxtrust.service.ShibbolethInitializer$Proxy$_$$_WeldClientProxy.createShibbolethConfiguration(Unknown Source)
    at org.gluu.oxtrust.service.AppInitializer.applicationInitialized(AppInitializer.java:208)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:95)
    at org.jboss.weld.injection.StaticMethodInjectionPoint.invoke(StaticMethodInjectionPoint.java:85)
    at org.jboss.weld.injection.MethodInvocationStrategy$SimpleMethodInvocationStrategy.invoke(MethodInvocationStrategy.java:168)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:330)
    at org.jboss.weld.event.ObserverMethodImpl.sendEvent(ObserverMethodImpl.java:308)
    at org.jboss.weld.event.ObserverMethodImpl.notify(ObserverMethodImpl.java:286)
    at javax.enterprise.inject.spi.ObserverMethod.notify(ObserverMethod.java:124)
    at org.jboss.weld.util.Observers.notify(Observers.java:166)
    at org.jboss.weld.event.ObserverNotifier.notifySyncObservers(ObserverNotifier.java:285)
    at org.jboss.weld.event.ObserverNotifier.notify(ObserverNotifier.java:273)
    at org.jboss.weld.event.ObserverNotifier.fireEvent(ObserverNotifier.java:177)
    at org.jboss.weld.bootstrap.BeanDeploymentModule.fireEvent(BeanDeploymentModule.java:93)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.fireEventForApplicationScope(HttpContextLifecycle.java:161)
    at org.jboss.weld.module.web.servlet.HttpContextLifecycle.contextInitialized(HttpContextLifecycle.java:147)
    at org.jboss.weld.module.web.servlet.WeldInitialListener.contextInitialized(WeldInitialListener.java:99)
    at org.jboss.weld.servlet.api.helpers.ForwardingServletListener.contextInitialized(ForwardingServletListener.java:34)
    at org.jboss.weld.environment.servlet.EnhancedListener.onStartup(EnhancedListener.java:66)
    at org.eclipse.jetty.servlet.ServletContainerInitializerHolder.doStart(ServletContainerInitializerHolder.java:148)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:114)
    at org.eclipse.jetty.servlet.ServletContextHandler$ServletContainerInitializerStarter.doStart(ServletContextHandler.java:1658)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:369)
    at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1304)
    at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:901)
    at org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:306)
    at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:532)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.bindings.StandardStarter.processBinding(StandardStarter.java:40)
    at org.eclipse.jetty.deploy.AppLifeCycle.runBindings(AppLifeCycle.java:183)
    at org.eclipse.jetty.deploy.DeploymentManager.requestAppGoal(DeploymentManager.java:516)
    at org.eclipse.jetty.deploy.DeploymentManager.addApp(DeploymentManager.java:151)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.fileAdded(ScanningAppProvider.java:210)
    at org.eclipse.jetty.deploy.providers.WebAppProvider.fileAdded(WebAppProvider.java:462)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider$1.fileAdded(ScanningAppProvider.java:61)
    at org.eclipse.jetty.util.Scanner$DiscreteListener.pathAdded(Scanner.java:284)
    at org.eclipse.jetty.util.Scanner.reportAddition(Scanner.java:896)
    at org.eclipse.jetty.util.Scanner.reportDifferences(Scanner.java:862)
    at org.eclipse.jetty.util.Scanner.scan(Scanner.java:769)
    at org.eclipse.jetty.util.Scanner.startScanning(Scanner.java:658)
    at org.eclipse.jetty.util.Scanner.doStart(Scanner.java:630)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.deploy.providers.ScanningAppProvider.doStart(ScanningAppProvider.java:182)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.deploy.DeploymentManager.startAppProvider(DeploymentManager.java:605)
    at org.eclipse.jetty.deploy.DeploymentManager.doStart(DeploymentManager.java:246)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:171)
    at org.eclipse.jetty.server.Server.start(Server.java:470)
    at org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:121)
    at org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:89)
    at org.eclipse.jetty.server.Server.doStart(Server.java:415)
    at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:93)
    at org.eclipse.jetty.xml.XmlConfiguration.main(XmlConfiguration.java:1919)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.eclipse.jetty.start.Main.invokeMain(Main.java:229)
    at org.eclipse.jetty.start.Main.start(Main.java:528)
    at org.eclipse.jetty.start.Main.main(Main.java:76)
2024-08-27 18:54:05.390:INFO :oejs.AbstractConnector:main: Started ServerConnector@426a15b4{HTTP/1.1, (http/1.1)}{localhost:8082}
2024-08-27 18:54:05.392:INFO :oejs.Server:main: Started Server@20d7d6fb{STARTING}[10.0.18,sto=5000] @35580ms
mzico commented 1 month ago

@uprightech : any idea on above?

iromli commented 1 month ago

@mzico the issue of missing column is fixed in gluufederation/oxtrust:4.5.5-2 image.

moabu commented 1 month ago

tied to https://github.com/GluuFederation/oxTrust/pull/2432 and should be closed as the fix is in 4.5.5-2

https://github.com/GluuFederation/oxTrust/issues/2434#issuecomment-2313487169

mzico commented 1 month ago

This fixed!