after upgrade ShinyProxy I have login problem.
I use OIDC with my own auth server to login to shiny. Everythink work well on 2.3.1, after update to 2.6.1 I have redirection loop. In my shinyproxy.log I can see:
Using generated security password: 6b5a0b37-7d15-441b-82c2-7b521390f98c
…
2022-01-28 11:10:53.561 WARN 1617 — [main] org.thymeleaf.templatemode.TemplateMode : [THYMELEAF][main] Template Mode ‘HTML5’ is deprecated. Using Template Mode ‘HTML’ instead.
2022-01-28 11:10:53.566 INFO 1617 — [main] e.o.c.stat.StatCollectorFactory : Enabled. Sending usage statistics to jdbc:mysql://xx.xxx.xx.xxx:3306/admdev_test.
2022-01-28 11:10:53.875 INFO 1617 — [main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService
2022-01-28 11:10:53.876 INFO 1617 — [main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService ‘taskExecutor’
2022-01-28 11:10:54.198 INFO 1617 — [main] o.s.b.a.w.s.WelcomePageHandlerMapping : Adding welcome page template: index
2022-01-28 11:10:54.727 INFO 1617 — [main] o.s.l.c.support.AbstractContextSource : Property ‘userDn’ not set - anonymous context will be used for read-write operations
2022-01-28 11:10:54.983 INFO 1617 — [main] io.undertow : starting server: Undertow - 2.2.8.Final
2022-01-28 11:10:55.007 INFO 1617 — [main] org.xnio : XNIO version 3.8.4.Final
2022-01-28 11:10:55.033 INFO 1617 — [main] org.xnio.nio : XNIO NIO Implementation Version 3.8.4.Final
2022-01-28 11:10:55.145 INFO 1617 — [main] org.jboss.threads : JBoss Threads version 3.1.0.Final
2022-01-28 11:10:55.231 INFO 1617 — [main] o.s.b.w.e.undertow.UndertowWebServer : Undertow started on port(s) 8080 (http)
2022-01-28 11:10:55.378 INFO 1617 — [main] io.undertow.servlet : Initializing Spring embedded WebApplicationContext
2022-01-28 11:10:55.378 INFO 1617 — [main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 141 ms
2022-01-28 11:10:55.397 INFO 1617 — [main] o.s.b.a.e.web.EndpointLinksResolver : Exposing 1 endpoint(s) beneath base path ‘/actuator’
2022-01-28 11:10:55.471 INFO 1617 — [main] io.undertow : starting server: Undertow - 2.2.8.Final
2022-01-28 11:10:55.517 INFO 1617 — [main] o.s.b.w.e.undertow.UndertowWebServer : Undertow started on port(s) 9090 (http)
2022-01-28 11:10:55.537 INFO 1617 — [main] e.o.c.util.StartupEventListener : Started ShinyProxy 2.6.0 (ContainerProxy 0.8.10)
2022-01-28 11:10:55.537 INFO 1617 — [main] e.o.c.service.AppRecoveryService : Recovery of running apps disabled
2022-01-28 11:11:19.442 INFO 1617 — [XNIO-1 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet ‘dispatcherServlet’
2022-01-28 11:11:19.443 INFO 1617 — [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet ‘dispatcherServlet’
2022-01-28 11:11:19.451 INFO 1617 — [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 8 ms
2022-01-28 11:11:42.879 INFO 1617 — [XNIO-1 task-1] e.o.containerproxy.service.UserService : User logged in [user: [email protected]]
2022-01-28 11:11:42.880 INFO 1617 — [XNIO-1 task-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting…
2022-01-28 11:11:44.122 ERROR 1617 — [XNIO-1 task-1] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
java.sql.SQLException: Access denied for user ‘admdev’@‘Debian-95-stretch-64-LAMP’ (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.25.jar!/:8.0.25]
2022-01-28 11:11:44.127 ERROR 1617 — [XNIO-1 task-1] io.undertow.request : UT005023: Exception handling request to /login/oauth2/code/shinyproxy
java.lang.reflect.UndeclaredThrowableException: Failed to invoke event listener method
HandlerMethod details:
Bean [eu.openanalytics.containerproxy.stat.impl.JDBCCollector]
Method [public void eu.openanalytics.containerproxy.stat.impl.AbstractDbCollector.onUserLoginEvent(eu.openanalytics.containerproxy.event.UserLoginEvent) throws java.io.IOException]
Resolved arguments:
[0] [type=eu.openanalytics.containerproxy.event.UserLoginEvent] [value=eu.openanalytics.containerproxy.event.UserLoginEvent[source=eu.openanalytics.containerproxy.service.UserService@751817d9]]
at org.springframework.context.event.ApplicationListenerMethodAdapter.doInvoke(ApplicationListenerMethodAdapter.java:322) ~[spring-context-5.2.15.RELEASE.jar!/:5.2.15.RELEASE]
information about mysql user (admdev) i have only in m server side. Settings for my mysql is ok so firstly i have info about successful login. I dont know why it show this error then. Also everything work ok when I downgrade to 2.3.1 i dont need to change anything in my server side.
Maybe anyone know what can i do to fix it?