Usage-Stats Event table missing columns

ShinyProxy
1

Here is the usage-stats block

  usage-stats:
   - url: micrometer
   - url: jdbc:mysql://xxxx.us-east-1.rds.amazonaws.com/ShinyProxyPRD
     username: ****
     password: *****
     attributes:
     - name: upn
       expression: '#{oidcUser?.attributes?.preferred_username}'
     - name: sub
       expression: '#{oidcUser?.attributes?.sub}'

I have dropped the table and restarted ShinyProxy, but the additional columns are not created.
I also added them but nothing is logged.

Did a quick Shiny App
I do see sub and preferred_username in Sys.getenv(“ALL_ATTRIBUTES”)

container-env:
ALL_ATTRIBUTES: “#{oidcUser.attributes}”

2

Hi

I tested your config and it works locally. I guess ShinyProxy is having an issue with creating the table. Could you have a look at the logs of ShinyProxy, to see if anything is logged?