Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connection Issues with MicroOcppSimulator and SteVe Using Docker #1523

Closed
EasonChen11 opened this issue Jul 30, 2024 · 10 comments · Fixed by #1542
Closed

Connection Issues with MicroOcppSimulator and SteVe Using Docker #1523

EasonChen11 opened this issue Jul 30, 2024 · 10 comments · Fixed by #1542
Labels

Comments

@EasonChen11
Copy link

EasonChen11 commented Jul 30, 2024

Hello,

I am a student currently learning about the Open Charge Point Protocol (OCPP) and am trying to set up a connection between MicroOcppSimulator(https://github.com/matth-x/MicroOcppSimulator) and SteVe using Docker. Despite following the setup instructions, I am unable to establish a successful connection. Here are the detailed steps I've taken:

  1. I have set up MicroOcppSimulator using Docker, and it starts without issues using the default settings.
  2. I have similarly set up SteVe using Docker.
  3. I created a Docker network to facilitate the connection between MicroOcppSimulator and SteVe.
  4. In SteVe, I created a virtual ChargeBoxID, which I then configured in MicroOcppSimulator, along with the Backend URL ws://172.18.0.3:8180/steve/websocket/CentralSystemService.

Despite these steps, the connection isn't successful. Could you please advise if there are any additional settings or common pitfalls that I might be missing? Any guidance or shared experiences would be greatly appreciated.

Thank you!

@jos-rk
Copy link

jos-rk commented Jul 31, 2024

I've had similar issues getting a connection to the 3.7.0 version on docker.
I still haven't succeeded despite spending many hours adjusting my configuration and checking the logs.
3.6.0 still works almost out of the box, just git clone it and edit src/main/resources/config/docker/main.properties and docker-compose.yaml and launch it.

@EasonChen11
Copy link
Author

Thank you very much for your suggestion. I successfully built and established a connection with steve using your method. Your assistance has been invaluable. Thank you for your help!

@goekay
Copy link
Member

goekay commented Aug 7, 2024

can you please post logs?

@PxCeMobGP
Copy link

I have the same issue. When taking a look with WireShark, SteVe is answering my WebSocket request with http response 302
The redirection link (inside the 302 response) is "http://192.168.0.211:8180/steve/manager/signin" which is the login page

Request Frame:

Hypertext Transfer Protocol
    GET /steve/websocket/CentralSystemService/PxC003 HTTP/1.1\r\n
    Host: 192.168.0.211:8180\r\n
    <Host: 192.168.0.211:8180\r\n>
    Upgrade: websocket\r\n
    <Upgrade: websocket\r\n>
    Connection: Upgrade\r\n
    <Connection: Upgrade\r\n>
    Sec-WebSocket-Key: x3JJHMbDL1EzLkh9GBhXDw==\r\n
    <Sec-WebSocket-Key: x3JJHMbDL1EzLkh9GBhXDw==\r\n>
    Sec-WebSocket-Protocol: ocpp1.6\r\n
    <Sec-WebSocket-Protocol: ocpp1.6\r\n>
    Sec-WebSocket-Version: 13\r\n
    <Sec-WebSocket-Version: 13\r\n>
    \r\n
    [Full request URI: http://192.168.0.211:8180/steve/websocket/CentralSystemService/PxC003]
    <Request: True>
    [HTTP request 19/19]
    [Prev request in frame: 8165]
    [Response in frame: 8612]

Response Frame:

Hypertext Transfer Protocol
    HTTP/1.1 302 Found\r\n
    Vary: Origin\r\n
    Vary: Access-Control-Request-Method\r\n
    Vary: Access-Control-Request-Headers\r\n
    Set-Cookie: JSESSIONID=node01exnyb66z9gjz1a6112air9kyr81.node0; Path=/steve\r\n
    <Set-Cookie: JSESSIONID=node01exnyb66z9gjz1a6112air9kyr81.node0; Path=/steve\r\n>
    Expires: Thu, 01 Jan 1970 00:00:00 GMT\r\n
    X-Content-Type-Options: nosniff\r\n
    X-XSS-Protection: 0\r\n
    X-Frame-Options: DENY\r\n
    Location: http://192.168.0.211:8180/steve/manager/signin\r\n
    <Location: http://192.168.0.211:8180/steve/manager/signin\r\n>
    Content-Length: 0\r\n
    <Content-Length: 0\r\n>
    \r\n
    <Response: True>
    [HTTP response 16/19]
    [Time since request: 0.011014000 seconds]
    [Prev request in frame: 6823]
    [Prev response in frame: 6828]
    [Request in frame: 7270]
    [Next request in frame: 7710]
    [Next response in frame: 7715]
    [Request URI: http://192.168.0.211:8180/steve/websocket/CentralSystemService/PxC003]

@goekay
Copy link
Member

goekay commented Aug 15, 2024

releases 3.7.0 and 3.7.1 are working fine using the following:

curl \
    --http1.1 \
    --include \
    --no-buffer \
    --header "Connection: Upgrade" \
    --header "Upgrade: websocket" \
    --header "Host: localhost:8080" \
    --header "Origin: http://localhost:8080/steve/websocket/CentralSystemService/test-station-1" \
    --header "Sec-WebSocket-Key: x3JJHMbDL1EzLkh9GBhXDw==" \
    --header "Sec-WebSocket-Version: 13" \
    --header "Sec-WebSocket-Protocol: ocpp1.6" \
    http://localhost:8080/steve/websocket/CentralSystemService/test-station-1

however HEAD fails, and i get the following response

HTTP/1.1 302 Found
Vary: Accept-Encoding
Vary: Origin
Vary: Access-Control-Request-Method
Vary: Access-Control-Request-Headers
Set-Cookie: JSESSIONID=node0ab6qn0wqgxtp12lbyjg16woje0.node0; Path=/steve
Expires: Thu, 01 Jan 1970 00:00:00 GMT
X-Content-Type-Options: nosniff
X-XSS-Protection: 0
X-Frame-Options: DENY
Location: http://localhost:8080/steve/manager/signin
Content-Length: 0

probably, a regression was introduced with the big migration in #1519

@goekay
Copy link
Member

goekay commented Aug 15, 2024

hey all, thanks for the reports and making me aware of this issue. i merged the fix into the main branch. please test the HEAD of the repo, and tell me whether the fix resolves your issues.

@PxCeMobGP
Copy link

Hi goekay,

thank you for the quick solution. Works perfectly!

@EasonChen11
Copy link
Author

Hello, thank you very much for your assistance. I encountered the following issue when trying to use the updated method:
DB log:

2024-08-16 02:24:04 2024-08-15 18:24:04 0 [Note] mysqld: ready for connections.
2024-08-16 02:24:04 Version: '10.4.30-MariaDB-1:10.4.30+maria~ubu2004'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2024-08-16 02:24:05 2024-08-15 18:24:05 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:05 2024-08-15 18:24:05 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:06 2024-08-15 18:24:06 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:07 2024-08-15 18:24:07 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:08 2024-08-15 18:24:08 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:10 2024-08-15 18:24:10 13 [Warning] Aborted connection 13 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)
2024-08-16 02:24:13 2024-08-15 18:24:13 14 [Warning] Aborted connection 14 to db: 'unconnected' user: 'unauthenticated' host: '172.28.0.3' (This connection closed normally without authentication)

App log:

2024-08-16 02:23:56 2024/08/15 18:23:56 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:23:57 2024/08/15 18:23:57 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:23:58 2024/08/15 18:23:58 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:23:59 2024/08/15 18:23:59 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:00 2024/08/15 18:24:00 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:01 2024/08/15 18:24:01 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:02 2024/08/15 18:24:02 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:03 2024/08/15 18:24:03 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:04 2024/08/15 18:24:04 Waiting for tcp://mariadb:3306: dial tcp 172.28.0.2:3306: connect: connection refused.
2024-08-16 02:24:05 2024/08/15 18:24:05 Ready: tcp://mariadb:3306.
2024-08-16 02:24:05 /bin/sh: 1: ./mvnw: not found
2024-08-16 02:24:05 2024/08/15 18:24:05 Ready: tcp://mariadb:3306.
2024-08-16 02:24:05 /bin/sh: 1: ./mvnw: not found
2024-08-16 02:24:06 2024/08/15 18:24:06 Ready: tcp://mariadb:3306.
2024-08-16 02:24:06 /bin/sh: 1: ./mvnw: not found

I followed the manual to set up the Docker project and would like to ask if there might be an error in my setup. Thank you for your response.

@juherr
Copy link
Contributor

juherr commented Aug 16, 2024

@EasonChen11 Could you try again with the change from #1319 and give use there the result of that new try?

@EasonChen11
Copy link
Author

DB log:

2024-08-17 22:58:32 2024-08-17 14:58:32+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.4.30+maria~ubu2004 started.
2024-08-17 22:58:32 2024-08-17 14:58:32+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-08-17 22:58:32 2024-08-17 14:58:32+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.4.30+maria~ubu2004 started.
2024-08-17 22:58:32 2024-08-17 14:58:32+00:00 [Note] [Entrypoint]: Initializing database files
2024-08-17 22:58:35 
2024-08-17 22:58:35 
2024-08-17 22:58:35 PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
2024-08-17 22:58:35 To do so, start the server, then issue the following command:
2024-08-17 22:58:35 
2024-08-17 22:58:35 '/usr/bin/mysql_secure_installation'
2024-08-17 22:58:35 
2024-08-17 22:58:35 which will also give you the option of removing the test
2024-08-17 22:58:35 databases and anonymous user created by default.  This is
2024-08-17 22:58:35 strongly recommended for production servers.
2024-08-17 22:58:35 
2024-08-17 22:58:35 See the MariaDB Knowledgebase at http://mariadb.com/kb
2024-08-17 22:58:35 
2024-08-17 22:58:35 Please report any problems at http://mariadb.org/jira
2024-08-17 22:58:35 
2024-08-17 22:58:35 The latest information about MariaDB is available at http://mariadb.org/.
2024-08-17 22:58:35 
2024-08-17 22:58:35 Consider joining MariaDB's strong and vibrant community:
2024-08-17 22:58:35 https://mariadb.org/get-involved/
2024-08-17 22:58:35 
2024-08-17 22:58:35 2024-08-17 14:58:35+00:00 [Note] [Entrypoint]: Database files initialized
2024-08-17 22:58:35 2024-08-17 14:58:35+00:00 [Note] [Entrypoint]: Starting temporary server
2024-08-17 22:58:35 2024-08-17 14:58:35+00:00 [Note] [Entrypoint]: Waiting for server startup
2024-08-17 22:58:36 2024-08-17 14:58:36+00:00 [Note] [Entrypoint]: Temporary server started.
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: GENERATED ROOT PASSWORD: 8LN"qJD`1%UPd:RW{V+TIEQNS;LE<KUe
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: Creating database stevedb
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: Creating user steve
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: Giving user steve access to schema stevedb
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: Securing system users (equivalent to running mysql_secure_installation)
2024-08-17 22:58:39 
2024-08-17 22:58:39 2024-08-17 14:58:39+00:00 [Note] [Entrypoint]: Stopping temporary server
2024-08-17 22:58:42 2024-08-17 14:58:42+00:00 [Note] [Entrypoint]: Temporary server stopped
2024-08-17 22:58:42 
2024-08-17 22:58:42 2024-08-17 14:58:42+00:00 [Note] [Entrypoint]: MariaDB init process done. Ready for start up.
2024-08-17 22:58:42 
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] Starting MariaDB 10.4.30-MariaDB-1:10.4.30+maria~ubu2004 source revision 928012a27ae2d1549f1b3e6975b9d22652bbea3a as process 117
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Using Linux native AIO
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Uses event mutexes
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Number of pools: 1
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-17 22:58:35 2024-08-17 14:58:35 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] InnoDB: 10.4.30 started; log sequence number 60943; transaction id 20
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Warning] 'user' entry 'root@fa137b5967b0' ignored in --skip-name-resolve mode.
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Warning] 'proxies_priv' entry '@% root@fa137b5967b0' ignored in --skip-name-resolve mode.
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] Reading of all Master_info entries succeeded
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] Added new Master_info '' to hash table
2024-08-17 22:58:36 2024-08-17 14:58:36 0 [Note] mysqld: ready for connections.
2024-08-17 22:58:36 Version: '10.4.30-MariaDB-1:10.4.30+maria~ubu2004'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  mariadb.org binary distribution
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] mysqld (initiated by: unknown): Normal shutdown
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] Event Scheduler: Purging the queue. 0 events
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] InnoDB: FTS optimize thread exiting.
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] InnoDB: Starting shutdown...
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2024-08-17 22:58:39 2024-08-17 14:58:39 0 [Note] InnoDB: Buffer pool(s) dump completed at 240817 14:58:39
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Shutdown completed; log sequence number 60952; transaction id 21
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] mysqld: Shutdown complete
2024-08-17 22:58:42 
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] Starting MariaDB 10.4.30-MariaDB-1:10.4.30+maria~ubu2004 source revision 928012a27ae2d1549f1b3e6975b9d22652bbea3a as process 1
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Using Linux native AIO
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Uses event mutexes
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Number of pools: 1
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: 10.4.30 started; log sequence number 60952; transaction id 20
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] InnoDB: Buffer pool(s) load completed at 240817 14:58:42
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] Server socket created on IP: '::'.
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] Reading of all Master_info entries succeeded
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] Added new Master_info '' to hash table
2024-08-17 22:58:42 2024-08-17 14:58:42 0 [Note] mysqld: ready for connections.
2024-08-17 22:58:42 Version: '10.4.30-MariaDB-1:10.4.30+maria~ubu2004'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
2024-08-17 22:58:43 2024-08-17 14:58:43 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '172.25.0.3' (This connection closed normally without authentication)

App log:

2024-08-17 22:58:32 2024/08/17 14:58:32 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:33 2024/08/17 14:58:33 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:34 2024/08/17 14:58:34 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:35 2024/08/17 14:58:35 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:36 2024/08/17 14:58:36 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:37 2024/08/17 14:58:37 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:38 2024/08/17 14:58:38 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:39 2024/08/17 14:58:39 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:40 2024/08/17 14:58:40 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:41 2024/08/17 14:58:41 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:42 2024/08/17 14:58:42 Waiting for tcp://mariadb:3306: dial tcp 172.25.0.2:3306: connect: connection refused.
2024-08-17 22:58:43 2024/08/17 14:58:43 Ready: tcp://mariadb:3306.
2024-08-17 22:58:43 /bin/sh: 1: ./mvnw: not found

I rebuilt using the code from #1319 and set up the project with docker compose up -d as described in the manual. The issue remains the same as before. However, I didn't encounter this problem when building with versions 3.7.0 and 3.6.

dakai-wei-of-shizen added a commit to shizen-connect/steve-forked that referenced this issue Nov 5, 2024
* Extract tag authorization in a dedicated service

* Provide location for tag status

* adding DB migration Baselinescript

* Baseline-script: insert default data into settings table

* main.yml: remove right "mysql -h 127.0.0.1 -P 3306 -uroot -proot -e "GRANT SELECT ON mysql.proc TO 'steve'@'%';" -v || true"

* B1_0_5_stevedb.sql: removed auto_increment values

* B1_0_5_stevedb.sql: change to maysqldump script

* Baseline-script: insert default data into settings table

* Baseline-script: removed unnecessary save, set and reset of DB-settings (executable comments); removed temporary tabels/views, because of that changed creation order of views transaction and ocpp_activity

* Baseline-script: because Steve supports only mysql and mariadb the executable comments are changed to commands. except "/*!999999\- enable the sandbox mode */ "

* Baseline-script: adding some comments

* Baseline-script: formating the view creation code

* Bump org.apache.maven.plugins:maven-dependency-plugin

Bumps [org.apache.maven.plugins:maven-dependency-plugin](https://github.com/apache/maven-dependency-plugin) from 3.7.0 to 3.7.1.
- [Release notes](https://github.com/apache/maven-dependency-plugin/releases)
- [Commits](https://github.com/apache/maven-dependency-plugin/compare/maven-dependency-plugin-3.7.0...maven-dependency-plugin-3.7.1)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-dependency-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.1 to 3.4.2

Bumps [org.apache.maven.plugins:maven-jar-plugin](https://github.com/apache/maven-jar-plugin) from 3.4.1 to 3.4.2.
- [Release notes](https://github.com/apache/maven-jar-plugin/releases)
- [Commits](https://github.com/apache/maven-jar-plugin/compare/maven-jar-plugin-3.4.1...maven-jar-plugin-3.4.2)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-jar-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* remove pmd github action

* main.yml: remove Grant Super priviliges; B1_0_5__stevedb.sql: remove definer statements in views

* adapt docs after #1439

SUPER is not needed anymore

* Bump org.junit:junit-bom from 5.10.2 to 5.10.3

Bumps [org.junit:junit-bom](https://github.com/junit-team/junit5) from 5.10.2 to 5.10.3.
- [Release notes](https://github.com/junit-team/junit5/releases)
- [Commits](https://github.com/junit-team/junit5/compare/r5.10.2...r5.10.3)

---
updated-dependencies:
- dependency-name: org.junit:junit-bom
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.github.spotbugs:spotbugs-maven-plugin from 4.8.5.0 to 4.8.6.2

Bumps [com.github.spotbugs:spotbugs-maven-plugin](https://github.com/spotbugs/spotbugs-maven-plugin) from 4.8.5.0 to 4.8.6.2.
- [Release notes](https://github.com/spotbugs/spotbugs-maven-plugin/releases)
- [Commits](https://github.com/spotbugs/spotbugs-maven-plugin/compare/spotbugs-maven-plugin-4.8.5.0...spotbugs-maven-plugin-4.8.6.2)

---
updated-dependencies:
- dependency-name: com.github.spotbugs:spotbugs-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jackson.version from 2.17.1 to 2.17.2

Bumps `jackson.version` from 2.17.1 to 2.17.2.

Updates `com.fasterxml.jackson.core:jackson-databind` from 2.17.1 to 2.17.2
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.module:jackson-module-jaxb-annotations` from 2.17.1 to 2.17.2
- [Commits](https://github.com/FasterXML/jackson-modules-base/compare/jackson-modules-base-2.17.1...jackson-modules-base-2.17.2)

Updates `com.fasterxml.jackson.core:jackson-annotations` from 2.17.1 to 2.17.2
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.datatype:jackson-datatype-joda` from 2.17.1 to 2.17.2
- [Commits](https://github.com/FasterXML/jackson-datatype-joda/compare/jackson-datatype-joda-2.17.1...jackson-datatype-joda-2.17.2)

---
updated-dependencies:
- dependency-name: com.fasterxml.jackson.core:jackson-databind
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.module:jackson-module-jaxb-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.core:jackson-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.datatype:jackson-datatype-joda
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump io.github.git-commit-id:git-commit-id-maven-plugin

Bumps [io.github.git-commit-id:git-commit-id-maven-plugin](https://github.com/git-commit-id/git-commit-id-maven-plugin) from 9.0.0 to 9.0.1.
- [Release notes](https://github.com/git-commit-id/git-commit-id-maven-plugin/releases)
- [Commits](https://github.com/git-commit-id/git-commit-id-maven-plugin/compare/v9.0.0...v9.0.1)

---
updated-dependencies:
- dependency-name: io.github.git-commit-id:git-commit-id-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump flyway.version from 10.15.0 to 10.15.2

Bumps `flyway.version` from 10.15.0 to 10.15.2.

Updates `org.flywaydb:flyway-mysql` from 10.15.0 to 10.15.2

Updates `org.flywaydb:flyway-maven-plugin` from 10.15.0 to 10.15.2
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.15.0...flyway-10.15.2)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Update docker-compose.yml to add restart policies

Added 'unless-stopped' restart policies to both the 'db' and 'app' services in docker-compose.yml to ensure they automatically restart unless explicitly stopped by the user.

* Bump org.apache.maven.plugins:maven-surefire-plugin from 3.3.0 to 3.3.1

Bumps [org.apache.maven.plugins:maven-surefire-plugin](https://github.com/apache/maven-surefire) from 3.3.0 to 3.3.1.
- [Release notes](https://github.com/apache/maven-surefire/releases)
- [Commits](https://github.com/apache/maven-surefire/compare/surefire-3.3.0...surefire-3.3.1)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-surefire-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump net.bytebuddy:byte-buddy from 1.14.17 to 1.14.18

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.14.17 to 1.14.18.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.17...byte-buddy-1.14.18)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* refactor: move OcppTagRepository into AuthTagService

* better msg if logs are unavailable (closes #1503)

* Bump org.projectlombok:lombok from 1.18.32 to 1.18.34

Bumps [org.projectlombok:lombok](https://github.com/projectlombok/lombok) from 1.18.32 to 1.18.34.
- [Changelog](https://github.com/projectlombok/lombok/blob/master/doc/changelog.markdown)
- [Commits](https://github.com/projectlombok/lombok/compare/v1.18.32...v1.18.34)

---
updated-dependencies:
- dependency-name: org.projectlombok:lombok
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* nits and style changes

* add license header where missing

* extract interface

reason: allow multiple implementations of the same interface to exist.
therefore, another impl (for calling external EMSP service) and bean
can exist with @Primary annotation which can take precedence

* transaction detail page shows only energy meter values (#1514)

* Bump flyway.version from 10.15.2 to 10.16.0

Bumps `flyway.version` from 10.15.2 to 10.16.0.

Updates `org.flywaydb:flyway-mysql` from 10.15.2 to 10.16.0

Updates `org.flywaydb:flyway-maven-plugin` from 10.15.2 to 10.16.0
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.15.2...flyway-10.16.0)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-pmd-plugin from 3.23.0 to 3.24.0

Bumps [org.apache.maven.plugins:maven-pmd-plugin](https://github.com/apache/maven-pmd-plugin) from 3.23.0 to 3.24.0.
- [Release notes](https://github.com/apache/maven-pmd-plugin/releases)
- [Commits](https://github.com/apache/maven-pmd-plugin/compare/maven-pmd-plugin-3.23.0...maven-pmd-plugin-3.24.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-pmd-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* migrate to jakarta and upgrade spring, jetty, cxf

* fix SecurityConfiguration

* fix http client in GithubReleaseCheckService

* fix test classes

* fix dependencies

* upgrade jetty from 11 to 12

* update ocpp-jaxb

* fix jsp world

* fix spring security

signin page was causing too many redirects to itself.

https://github.com/spring-projects/spring-security/issues/13285

* switch to openapi v3

plus: start offering swagger ui

* version bump [ci skip]

* version bump for snapshot [ci skip]

* use ocpp-jaxb tag version

* jooq: make DateTime operations through field's converter (#1520)

* validate chargeBoxId for WS connections (#1526)

* tighten regex of valid chargeBoxId definition (#1526)

* switch logic to use blacklist of chars (#1526)

* add flexibility to override default chargeBoxId validation regex (#1526)

* add error logging for violating the pattern (#1526)

* put chargeBoxId through html encoder in unknownList (#1526)

* refactor

* Encode values properly when rendering HTML pages (#1533)

* use html encoder on page: chagepointDetails (#1532)

* use html encoder on page: transactions (#1532)

* use html encoder on page: transactionDetails (#1532)

* use html encoder on page: ocppTags (#1532)

* use html encoder on page: connectorStatus (#1532)

* use html encoder on page: GetConfigurationResponse (#1532)

* use html encoder on page: taskResult (#1532)

* Bump org.hamcrest:hamcrest from 2.2 to 3.0 (#1530)

Bumps [org.hamcrest:hamcrest](https://github.com/hamcrest/JavaHamcrest) from 2.2 to 3.0.
- [Release notes](https://github.com/hamcrest/JavaHamcrest/releases)
- [Changelog](https://github.com/hamcrest/JavaHamcrest/blob/master/CHANGES.md)
- [Commits](https://github.com/hamcrest/JavaHamcrest/compare/v2.2...v3.0)

---
updated-dependencies:
- dependency-name: org.hamcrest:hamcrest
  dependency-type: direct:development
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump flyway.version from 10.16.0 to 10.17.0 (#1529)

Bumps `flyway.version` from 10.16.0 to 10.17.0.

Updates `org.flywaydb:flyway-mysql` from 10.16.0 to 10.17.0

Updates `org.flywaydb:flyway-maven-plugin` from 10.16.0 to 10.17.0
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.16.0...flyway-10.17.0)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump jetty.version from 12.0.11 to 12.0.12 (#1528)

Bumps `jetty.version` from 12.0.11 to 12.0.12.

Updates `org.eclipse.jetty:jetty-server` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.ee10:jetty-ee10-webapp` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.ee10:jetty-ee10-annotations` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.ee10:jetty-ee10-apache-jsp` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty:jetty-rewrite` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.websocket:jetty-websocket-jetty-client` from 12.0.11 to 12.0.12

Updates `org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin` from 12.0.11 to 12.0.12

---
updated-dependencies:
- dependency-name: org.eclipse.jetty:jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-webapp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-apache-jsp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty:jetty-rewrite
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.websocket:jetty-websocket-jetty-client
  dependency-type: direct:development
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* fix ObjectMapper used for API endpoint errors

reason: warnings like the following

[WARN ] 2024-08-08 23:34:20,844 org.eclipse.jetty.ee10.servlet.ServletChannel (qtp739264372-28) - handleException /steve/api/v1/transactions com.fasterxml.jackson.databind.exc.InvalidDefinitionException: Joda date/time type `org.joda.time.DateTime` not supported by default: add Module "com.fasterxml.jackson.datatype:jackson-datatype-joda" to enable handling (through reference chain: de.rwth.idsg.steve.web.api.ApiControllerAdvice$ApiErrorResponse["timestamp"])

ApiDocsConfiguration activates JacksonAutoConfiguration which creates a default/primary ObjectMapper
that is different from our ObjectMapper. this came with the spring 6.x migration since OpenApi integration
was massively refactored with that as well.

* add authorization support to open-api and swagger-ui (#1043)

* refactor

instead of creating a 2nd ObjectMapper with a custom qualifier,
override the default that comes from JacksonAutoConfiguration.

* Bump org.slf4j:slf4j-bom from 2.0.13 to 2.0.16

Bumps [org.slf4j:slf4j-bom](https://github.com/qos-ch/slf4j) from 2.0.13 to 2.0.16.
- [Commits](https://github.com/qos-ch/slf4j/compare/v_2.0.13...v_2.0.16)

---
updated-dependencies:
- dependency-name: org.slf4j:slf4j-bom
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Update mysql-connector-j (#1537)

* pom: adapted changes in mysql-connector dependency location: mysql --> com.mysql; mysql-connector-java -> mysql-connector-j, version update to 8.4.0

* pom: mysql.jdbc.version update to 9.0.0

---------

Co-authored-by: brosi <[email protected]>

* exclude websocket paths from spring security (#1523)

* disable CSRF for SOAP endpoints

* enable spring security for all profiles

reason: so far, spring security was enabled only for prod profile. the tests were running
with test profile. therefore, any security-related issue/regression was not detected.

* Implement database-based multi user system for Web UI (#1539)

* add UserDetailsService impl using Jooq

* improve impl such that it is in a working condition

* refactor: make github action checks happy

* force data type JSON in Jooq for web_user.authorities

reason: our build matrix fails for mysql, but succeeds for mariadb.
Jooq infers data type org.jooq.JSON for web_user.authorities for mysql.
on the other hand, it is String for mariadb.

example: https://github.com/steve-community/steve/actions/runs/10339451112

* tighten json logic

* add check for validating that "authorities" is an array
* store a sorted set of authorities without duplicates

* add method to delete web user by database id

reason: to be used by web pages. a better way than doing with username,
and is consistent with other delete operations we do.

* PR feedback: skip default admin user creation, if "any" admin already exists

* refactor: PR feedback

* prepare database for #1540

* PR feedback

* add license header where missing

* Bump jooq.version from 3.19.10 to 3.19.11 (#1552)

Bumps `jooq.version` from 3.19.10 to 3.19.11.

Updates `org.jooq:jooq-meta` from 3.19.10 to 3.19.11

Updates `org.jooq:jooq-codegen` from 3.19.10 to 3.19.11

Updates `org.jooq:jooq` from 3.19.10 to 3.19.11

Updates `org.jooq:jooq-codegen-maven` from 3.19.10 to 3.19.11

---
updated-dependencies:
- dependency-name: org.jooq:jooq-meta
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.jooq:jooq-codegen
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.jooq:jooq
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.jooq:jooq-codegen-maven
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump com.google.guava:guava from 33.2.1-jre to 33.3.0-jre (#1551)

Bumps [com.google.guava:guava](https://github.com/google/guava) from 33.2.1-jre to 33.3.0-jre.
- [Release notes](https://github.com/google/guava/releases)
- [Commits](https://github.com/google/guava/commits)

---
updated-dependencies:
- dependency-name: com.google.guava:guava
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api (#1550)

Bumps [jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api](https://github.com/eclipse-ee4j/jstl-api) from 3.0.0 to 3.0.1.
- [Release notes](https://github.com/eclipse-ee4j/jstl-api/releases)
- [Commits](https://github.com/eclipse-ee4j/jstl-api/commits)

---
updated-dependencies:
- dependency-name: jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump org.junit:junit-bom from 5.10.3 to 5.11.0 (#1549)

Bumps [org.junit:junit-bom](https://github.com/junit-team/junit5) from 5.10.3 to 5.11.0.
- [Release notes](https://github.com/junit-team/junit5/releases)
- [Commits](https://github.com/junit-team/junit5/compare/r5.10.3...r5.11.0)

---
updated-dependencies:
- dependency-name: org.junit:junit-bom
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump net.bytebuddy:byte-buddy from 1.14.18 to 1.14.19 (#1548)

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.14.18 to 1.14.19.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.18...byte-buddy-1.14.19)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* Bump flyway.version from 10.17.0 to 10.17.1 (#1547)

Bumps `flyway.version` from 10.17.0 to 10.17.1.

Updates `org.flywaydb:flyway-mysql` from 10.17.0 to 10.17.1

Updates `org.flywaydb:flyway-maven-plugin` from 10.17.0 to 10.17.1
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.17.0...flyway-10.17.1)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

* switch to basic auth for API access (#1545)

* switch to basic auth for API access

* PR feedback

* add cache for API users

* PR feedback

* start setting/updating api_password

* refactor: undo moveApiTokenFromConfigToDatabase prep

* switch open-api spec to basic auth (#1540)

* refactor DataSource

* make DataSource a spring bean
* move checkJavaAndMySQLOffsets() into GenericRepository
* necessary consequential changes

* Bump org.owasp.encoder:encoder-jakarta-jsp from 1.3.0 to 1.3.1

Bumps [org.owasp.encoder:encoder-jakarta-jsp](https://github.com/owasp/owasp-java-encoder) from 1.3.0 to 1.3.1.
- [Release notes](https://github.com/owasp/owasp-java-encoder/releases)
- [Commits](https://github.com/owasp/owasp-java-encoder/compare/v1.3.0...v1.3.1)

---
updated-dependencies:
- dependency-name: org.owasp.encoder:encoder-jakarta-jsp
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump flyway.version from 10.17.1 to 10.17.2

Bumps `flyway.version` from 10.17.1 to 10.17.2.

Updates `org.flywaydb:flyway-mysql` from 10.17.1 to 10.17.2

Updates `org.flywaydb:flyway-maven-plugin` from 10.17.1 to 10.17.2
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.17.1...flyway-10.17.2)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-dependency-plugin

Bumps [org.apache.maven.plugins:maven-dependency-plugin](https://github.com/apache/maven-dependency-plugin) from 3.7.1 to 3.8.0.
- [Release notes](https://github.com/apache/maven-dependency-plugin/releases)
- [Commits](https://github.com/apache/maven-dependency-plugin/compare/maven-dependency-plugin-3.7.1...maven-dependency-plugin-3.8.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-dependency-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump net.bytebuddy:byte-buddy from 1.14.19 to 1.15.0

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.14.19 to 1.15.0.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.19...byte-buddy-1.15.0)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump spring.security.version from 6.3.1 to 6.3.3

Bumps `spring.security.version` from 6.3.1 to 6.3.3.

Updates `org.springframework.security:spring-security-web` from 6.3.1 to 6.3.3
- [Release notes](https://github.com/spring-projects/spring-security/releases)
- [Changelog](https://github.com/spring-projects/spring-security/blob/main/RELEASE.adoc)
- [Commits](https://github.com/spring-projects/spring-security/compare/6.3.1...6.3.3)

Updates `org.springframework.security:spring-security-config` from 6.3.1 to 6.3.3
- [Release notes](https://github.com/spring-projects/spring-security/releases)
- [Changelog](https://github.com/spring-projects/spring-security/blob/main/RELEASE.adoc)
- [Commits](https://github.com/spring-projects/spring-security/compare/6.3.1...6.3.3)

---
updated-dependencies:
- dependency-name: org.springframework.security:spring-security-web
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.springframework.security:spring-security-config
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-checkstyle-plugin

Bumps [org.apache.maven.plugins:maven-checkstyle-plugin](https://github.com/apache/maven-checkstyle-plugin) from 3.4.0 to 3.5.0.
- [Commits](https://github.com/apache/maven-checkstyle-plugin/compare/maven-checkstyle-plugin-3.4.0...maven-checkstyle-plugin-3.5.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-checkstyle-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-surefire-plugin from 3.3.1 to 3.4.0

Bumps [org.apache.maven.plugins:maven-surefire-plugin](https://github.com/apache/maven-surefire) from 3.3.1 to 3.4.0.
- [Release notes](https://github.com/apache/maven-surefire/releases)
- [Commits](https://github.com/apache/maven-surefire/compare/surefire-3.3.1...surefire-3.4.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-surefire-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api

Bumps [jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api](https://github.com/eclipse-ee4j/jstl-api) from 3.0.1 to 3.0.2.
- [Release notes](https://github.com/eclipse-ee4j/jstl-api/releases)
- [Commits](https://github.com/eclipse-ee4j/jstl-api/commits)

---
updated-dependencies:
- dependency-name: jakarta.servlet.jsp.jstl:jakarta.servlet.jsp.jstl-api
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-surefire-plugin from 3.4.0 to 3.5.0

Bumps [org.apache.maven.plugins:maven-surefire-plugin](https://github.com/apache/maven-surefire) from 3.4.0 to 3.5.0.
- [Release notes](https://github.com/apache/maven-surefire/releases)
- [Commits](https://github.com/apache/maven-surefire/compare/surefire-3.4.0...surefire-3.5.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-surefire-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump net.bytebuddy:byte-buddy from 1.15.0 to 1.15.1

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.15.0 to 1.15.1.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.15.0...byte-buddy-1.15.1)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-pmd-plugin from 3.24.0 to 3.25.0

Bumps [org.apache.maven.plugins:maven-pmd-plugin](https://github.com/apache/maven-pmd-plugin) from 3.24.0 to 3.25.0.
- [Release notes](https://github.com/apache/maven-pmd-plugin/releases)
- [Commits](https://github.com/apache/maven-pmd-plugin/compare/maven-pmd-plugin-3.24.0...maven-pmd-plugin-3.25.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-pmd-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.mockito:mockito-junit-jupiter from 5.12.0 to 5.13.0

Bumps [org.mockito:mockito-junit-jupiter](https://github.com/mockito/mockito) from 5.12.0 to 5.13.0.
- [Release notes](https://github.com/mockito/mockito/releases)
- [Commits](https://github.com/mockito/mockito/compare/v5.12.0...v5.13.0)

---
updated-dependencies:
- dependency-name: org.mockito:mockito-junit-jupiter
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jetty.version from 12.0.12 to 12.0.13

Bumps `jetty.version` from 12.0.12 to 12.0.13.

Updates `org.eclipse.jetty:jetty-server` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.ee10:jetty-ee10-webapp` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.ee10:jetty-ee10-annotations` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.ee10:jetty-ee10-apache-jsp` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty:jetty-rewrite` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.websocket:jetty-websocket-jetty-client` from 12.0.12 to 12.0.13

Updates `org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin` from 12.0.12 to 12.0.13

---
updated-dependencies:
- dependency-name: org.eclipse.jetty:jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-webapp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-apache-jsp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty:jetty-rewrite
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.websocket:jetty-websocket-jetty-client
  dependency-type: direct:development
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.logging.log4j:log4j-bom from 2.23.1 to 2.24.0

Bumps [org.apache.logging.log4j:log4j-bom](https://github.com/apache/logging-log4j2) from 2.23.1 to 2.24.0.
- [Release notes](https://github.com/apache/logging-log4j2/releases)
- [Changelog](https://github.com/apache/logging-log4j2/blob/2.x/RELEASE-NOTES.adoc)
- [Commits](https://github.com/apache/logging-log4j2/compare/rel/2.23.1...rel/2.24.0)

---
updated-dependencies:
- dependency-name: org.apache.logging.log4j:log4j-bom
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.github.spotbugs:spotbugs-maven-plugin from 4.8.6.2 to 4.8.6.3

Bumps [com.github.spotbugs:spotbugs-maven-plugin](https://github.com/spotbugs/spotbugs-maven-plugin) from 4.8.6.2 to 4.8.6.3.
- [Release notes](https://github.com/spotbugs/spotbugs-maven-plugin/releases)
- [Commits](https://github.com/spotbugs/spotbugs-maven-plugin/compare/spotbugs-maven-plugin-4.8.6.2...spotbugs-maven-plugin-4.8.6.3)

---
updated-dependencies:
- dependency-name: com.github.spotbugs:spotbugs-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Warn about security risks

Related to #100

* Bump flyway.version from 10.17.2 to 10.18.0

Bumps `flyway.version` from 10.17.2 to 10.18.0.

Updates `org.flywaydb:flyway-mysql` from 10.17.2 to 10.18.0

Updates `org.flywaydb:flyway-maven-plugin` from 10.17.2 to 10.18.0
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.17.2...flyway-10.18.0)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* add APIs link to navigation header

* set ram percentage in Dockerfile

default is 25% which is too conservative.

details: https://developers.redhat.com/articles/2022/04/19/java-17-whats-new-openjdks-container-awareness#tuning_defaults_for_containers

* Bump org.apache.httpcomponents.client5:httpclient5 from 5.3.1 to 5.4

Bumps [org.apache.httpcomponents.client5:httpclient5](https://github.com/apache/httpcomponents-client) from 5.3.1 to 5.4.
- [Changelog](https://github.com/apache/httpcomponents-client/blob/master/RELEASE_NOTES.txt)
- [Commits](https://github.com/apache/httpcomponents-client/compare/rel/v5.3.1...rel/v5.4)

---
updated-dependencies:
- dependency-name: org.apache.httpcomponents.client5:httpclient5
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump joda-time:joda-time from 2.12.7 to 2.13.0

Bumps [joda-time:joda-time](https://github.com/JodaOrg/joda-time) from 2.12.7 to 2.13.0.
- [Release notes](https://github.com/JodaOrg/joda-time/releases)
- [Changelog](https://github.com/JodaOrg/joda-time/blob/main/RELEASE-NOTES.txt)
- [Commits](https://github.com/JodaOrg/joda-time/compare/v2.12.7...v2.13.0)

---
updated-dependencies:
- dependency-name: joda-time:joda-time
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.github.spotbugs:spotbugs-maven-plugin from 4.8.6.3 to 4.8.6.4

Bumps [com.github.spotbugs:spotbugs-maven-plugin](https://github.com/spotbugs/spotbugs-maven-plugin) from 4.8.6.3 to 4.8.6.4.
- [Release notes](https://github.com/spotbugs/spotbugs-maven-plugin/releases)
- [Commits](https://github.com/spotbugs/spotbugs-maven-plugin/compare/spotbugs-maven-plugin-4.8.6.3...spotbugs-maven-plugin-4.8.6.4)

---
updated-dependencies:
- dependency-name: com.github.spotbugs:spotbugs-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump flyway.version from 10.18.0 to 10.18.2

Bumps `flyway.version` from 10.18.0 to 10.18.2.

Updates `org.flywaydb:flyway-mysql` from 10.18.0 to 10.18.2

Updates `org.flywaydb:flyway-maven-plugin` from 10.18.0 to 10.18.2
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.18.0...flyway-10.18.2)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jackson.version from 2.17.2 to 2.18.0

Bumps `jackson.version` from 2.17.2 to 2.18.0.

Updates `com.fasterxml.jackson.core:jackson-databind` from 2.17.2 to 2.18.0
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.module:jackson-module-jakarta-xmlbind-annotations` from 2.17.2 to 2.18.0
- [Commits](https://github.com/FasterXML/jackson-modules-base/compare/jackson-modules-base-2.17.2...jackson-modules-base-2.18.0)

Updates `com.fasterxml.jackson.core:jackson-annotations` from 2.17.2 to 2.18.0
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.datatype:jackson-datatype-joda` from 2.17.2 to 2.18.0
- [Commits](https://github.com/FasterXML/jackson-datatype-joda/compare/jackson-datatype-joda-2.17.2...jackson-datatype-joda-2.18.0)

---
updated-dependencies:
- dependency-name: com.fasterxml.jackson.core:jackson-databind
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: com.fasterxml.jackson.module:jackson-module-jakarta-xmlbind-annotations
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: com.fasterxml.jackson.core:jackson-annotations
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: com.fasterxml.jackson.datatype:jackson-datatype-joda
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.google.guava:guava from 33.3.0-jre to 33.3.1-jre

Bumps [com.google.guava:guava](https://github.com/google/guava) from 33.3.0-jre to 33.3.1-jre.
- [Release notes](https://github.com/google/guava/releases)
- [Commits](https://github.com/google/guava/commits)

---
updated-dependencies:
- dependency-name: com.google.guava:guava
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.jetbrains:annotations from 24.1.0 to 25.0.0

Bumps [org.jetbrains:annotations](https://github.com/JetBrains/java-annotations) from 24.1.0 to 25.0.0.
- [Release notes](https://github.com/JetBrains/java-annotations/releases)
- [Changelog](https://github.com/JetBrains/java-annotations/blob/master/CHANGELOG.md)
- [Commits](https://github.com/JetBrains/java-annotations/compare/24.1.0...25.0.0)

---
updated-dependencies:
- dependency-name: org.jetbrains:annotations
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.mockito:mockito-junit-jupiter from 5.13.0 to 5.14.1

Bumps [org.mockito:mockito-junit-jupiter](https://github.com/mockito/mockito) from 5.13.0 to 5.14.1.
- [Release notes](https://github.com/mockito/mockito/releases)
- [Commits](https://github.com/mockito/mockito/compare/v5.13.0...v5.14.1)

---
updated-dependencies:
- dependency-name: org.mockito:mockito-junit-jupiter
  dependency-type: direct:development
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.junit:junit-bom from 5.11.0 to 5.11.2

Bumps [org.junit:junit-bom](https://github.com/junit-team/junit5) from 5.11.0 to 5.11.2.
- [Release notes](https://github.com/junit-team/junit5/releases)
- [Commits](https://github.com/junit-team/junit5/compare/r5.11.0...r5.11.2)

---
updated-dependencies:
- dependency-name: org.junit:junit-bom
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump plugin.license-maven.version from 4.5 to 4.6

Bumps `plugin.license-maven.version` from 4.5 to 4.6.

Updates `com.mycila:license-maven-plugin-git` from 4.5 to 4.6
- [Release notes](https://github.com/mathieucarbou/license-maven-plugin/releases)
- [Commits](https://github.com/mathieucarbou/license-maven-plugin/compare/license-maven-plugin-4.5...license-maven-plugin-4.6)

Updates `com.mycila:license-maven-plugin` from 4.5 to 4.6
- [Release notes](https://github.com/mathieucarbou/license-maven-plugin/releases)
- [Commits](https://github.com/mathieucarbou/license-maven-plugin/compare/license-maven-plugin-4.5...license-maven-plugin-4.6)

---
updated-dependencies:
- dependency-name: com.mycila:license-maven-plugin-git
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: com.mycila:license-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump flyway.version from 10.18.2 to 10.19.0

Bumps `flyway.version` from 10.18.2 to 10.19.0.

Updates `org.flywaydb:flyway-mysql` from 10.18.2 to 10.19.0

Updates `org.flywaydb:flyway-maven-plugin` from 10.18.2 to 10.19.0
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.18.2...flyway-10.19.0)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-surefire-plugin from 3.5.0 to 3.5.1

Bumps [org.apache.maven.plugins:maven-surefire-plugin](https://github.com/apache/maven-surefire) from 3.5.0 to 3.5.1.
- [Release notes](https://github.com/apache/maven-surefire/releases)
- [Commits](https://github.com/apache/maven-surefire/compare/surefire-3.5.0...surefire-3.5.1)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-surefire-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.logging.log4j:log4j-bom from 2.24.0 to 2.24.1

Bumps [org.apache.logging.log4j:log4j-bom](https://github.com/apache/logging-log4j2) from 2.24.0 to 2.24.1.
- [Release notes](https://github.com/apache/logging-log4j2/releases)
- [Changelog](https://github.com/apache/logging-log4j2/blob/2.x/RELEASE-NOTES.adoc)
- [Commits](https://github.com/apache/logging-log4j2/compare/rel/2.24.0...rel/2.24.1)

---
updated-dependencies:
- dependency-name: org.apache.logging.log4j:log4j-bom
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.zaxxer:HikariCP from 5.1.0 to 6.0.0

Bumps [com.zaxxer:HikariCP](https://github.com/brettwooldridge/HikariCP) from 5.1.0 to 6.0.0.
- [Changelog](https://github.com/brettwooldridge/HikariCP/blob/dev/CHANGES)
- [Commits](https://github.com/brettwooldridge/HikariCP/compare/HikariCP-5.1.0...HikariCP-6.0.0)

---
updated-dependencies:
- dependency-name: com.zaxxer:HikariCP
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.mysql:mysql-connector-j from 9.0.0 to 9.1.0

Bumps [com.mysql:mysql-connector-j](https://github.com/mysql/mysql-connector-j) from 9.0.0 to 9.1.0.
- [Changelog](https://github.com/mysql/mysql-connector-j/blob/release/9.x/CHANGES)
- [Commits](https://github.com/mysql/mysql-connector-j/compare/9.0.0...9.1.0)

---
updated-dependencies:
- dependency-name: com.mysql:mysql-connector-j
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.jetbrains:annotations from 25.0.0 to 26.0.1

Bumps [org.jetbrains:annotations](https://github.com/JetBrains/java-annotations) from 25.0.0 to 26.0.1.
- [Release notes](https://github.com/JetBrains/java-annotations/releases)
- [Changelog](https://github.com/JetBrains/java-annotations/blob/master/CHANGELOG.md)
- [Commits](https://github.com/JetBrains/java-annotations/compare/25.0.0...26.0.1)

---
updated-dependencies:
- dependency-name: org.jetbrains:annotations
  dependency-type: direct:production
  update-type: version-update:semver-major
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump net.bytebuddy:byte-buddy from 1.15.1 to 1.15.7

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.15.1 to 1.15.7.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.15.1...byte-buddy-1.15.7)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jetty.version from 12.0.13 to 12.0.14

Bumps `jetty.version` from 12.0.13 to 12.0.14.

Updates `org.eclipse.jetty:jetty-server` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.ee10:jetty-ee10-webapp` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.ee10:jetty-ee10-annotations` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.ee10:jetty-ee10-apache-jsp` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty:jetty-rewrite` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.websocket:jetty-websocket-jetty-client` from 12.0.13 to 12.0.14

Updates `org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin` from 12.0.13 to 12.0.14

---
updated-dependencies:
- dependency-name: org.eclipse.jetty:jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-webapp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-apache-jsp
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty:jetty-rewrite
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10.websocket:jetty-ee10-websocket-jetty-server
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.websocket:jetty-websocket-jetty-client
  dependency-type: direct:development
  update-type: version-update:semver-patch
- dependency-name: org.eclipse.jetty.ee10:jetty-ee10-jspc-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* adjust checkstyle [ci skip]

inline conditionals are fine in some cases. more compact and less verbose.

* migrate "header value" as "api password" to database (#1540)

* Bump org.springframework.security:spring-security-web

Bumps [org.springframework.security:spring-security-web](https://github.com/spring-projects/spring-security) from 6.3.3 to 6.3.4.
- [Release notes](https://github.com/spring-projects/spring-security/releases)
- [Changelog](https://github.com/spring-projects/spring-security/blob/main/RELEASE.adoc)
- [Commits](https://github.com/spring-projects/spring-security/compare/6.3.3...6.3.4)

---
updated-dependencies:
- dependency-name: org.springframework.security:spring-security-web
  dependency-type: direct:production
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.mockito:mockito-junit-jupiter from 5.14.1 to 5.14.2

Bumps [org.mockito:mockito-junit-jupiter](https://github.com/mockito/mockito) from 5.14.1 to 5.14.2.
- [Release notes](https://github.com/mockito/mockito/releases)
- [Commits](https://github.com/mockito/mockito/compare/v5.14.1...v5.14.2)

---
updated-dependencies:
- dependency-name: org.mockito:mockito-junit-jupiter
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump jackson.version from 2.18.0 to 2.18.1

Bumps `jackson.version` from 2.18.0 to 2.18.1.

Updates `com.fasterxml.jackson.core:jackson-databind` from 2.18.0 to 2.18.1
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.module:jackson-module-jakarta-xmlbind-annotations` from 2.18.0 to 2.18.1
- [Commits](https://github.com/FasterXML/jackson-modules-base/compare/jackson-modules-base-2.18.0...jackson-modules-base-2.18.1)

Updates `com.fasterxml.jackson.core:jackson-annotations` from 2.18.0 to 2.18.1
- [Commits](https://github.com/FasterXML/jackson/commits)

Updates `com.fasterxml.jackson.datatype:jackson-datatype-joda` from 2.18.0 to 2.18.1
- [Commits](https://github.com/FasterXML/jackson-datatype-joda/compare/jackson-datatype-joda-2.18.0...jackson-datatype-joda-2.18.1)

---
updated-dependencies:
- dependency-name: com.fasterxml.jackson.core:jackson-databind
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.module:jackson-module-jakarta-xmlbind-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.core:jackson-annotations
  dependency-type: direct:production
  update-type: version-update:semver-patch
- dependency-name: com.fasterxml.jackson.datatype:jackson-datatype-joda
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump com.github.spotbugs:spotbugs-maven-plugin from 4.8.6.4 to 4.8.6.5

Bumps [com.github.spotbugs:spotbugs-maven-plugin](https://github.com/spotbugs/spotbugs-maven-plugin) from 4.8.6.4 to 4.8.6.5.
- [Release notes](https://github.com/spotbugs/spotbugs-maven-plugin/releases)
- [Commits](https://github.com/spotbugs/spotbugs-maven-plugin/compare/spotbugs-maven-plugin-4.8.6.4...spotbugs-maven-plugin-4.8.6.5)

---
updated-dependencies:
- dependency-name: com.github.spotbugs:spotbugs-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump flyway.version from 10.19.0 to 10.20.1

Bumps `flyway.version` from 10.19.0 to 10.20.1.

Updates `org.flywaydb:flyway-mysql` from 10.19.0 to 10.20.1

Updates `org.flywaydb:flyway-maven-plugin` from 10.19.0 to 10.20.1
- [Release notes](https://github.com/flyway/flyway/releases)
- [Commits](https://github.com/flyway/flyway/compare/flyway-10.19.0...flyway-10.20.1)

---
updated-dependencies:
- dependency-name: org.flywaydb:flyway-mysql
  dependency-type: direct:production
  update-type: version-update:semver-minor
- dependency-name: org.flywaydb:flyway-maven-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-dependency-plugin

Bumps [org.apache.maven.plugins:maven-dependency-plugin](https://github.com/apache/maven-dependency-plugin) from 3.8.0 to 3.8.1.
- [Release notes](https://github.com/apache/maven-dependency-plugin/releases)
- [Commits](https://github.com/apache/maven-dependency-plugin/compare/maven-dependency-plugin-3.8.0...maven-dependency-plugin-3.8.1)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-dependency-plugin
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.httpcomponents.client5:httpclient5 from 5.4 to 5.4.1

Bumps [org.apache.httpcomponents.client5:httpclient5](https://github.com/apache/httpcomponents-client) from 5.4 to 5.4.1.
- [Changelog](https://github.com/apache/httpcomponents-client/blob/rel/v5.4.1/RELEASE_NOTES.txt)
- [Commits](https://github.com/apache/httpcomponents-client/compare/rel/v5.4...rel/v5.4.1)

---
updated-dependencies:
- dependency-name: org.apache.httpcomponents.client5:httpclient5
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump net.bytebuddy:byte-buddy from 1.15.7 to 1.15.9

Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 1.15.7 to 1.15.9.
- [Release notes](https://github.com/raphw/byte-buddy/releases)
- [Changelog](https://github.com/raphw/byte-buddy/blob/master/release-notes.md)
- [Commits](https://github.com/raphw/byte-buddy/compare/byte-buddy-1.15.7...byte-buddy-1.15.9)

---
updated-dependencies:
- dependency-name: net.bytebuddy:byte-buddy
  dependency-type: direct:development
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-checkstyle-plugin

Bumps [org.apache.maven.plugins:maven-checkstyle-plugin](https://github.com/apache/maven-checkstyle-plugin) from 3.5.0 to 3.6.0.
- [Commits](https://github.com/apache/maven-checkstyle-plugin/compare/maven-checkstyle-plugin-3.5.0...maven-checkstyle-plugin-3.6.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-checkstyle-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.apache.maven.plugins:maven-pmd-plugin from 3.25.0 to 3.26.0

Bumps [org.apache.maven.plugins:maven-pmd-plugin](https://github.com/apache/maven-pmd-plugin) from 3.25.0 to 3.26.0.
- [Release notes](https://github.com/apache/maven-pmd-plugin/releases)
- [Commits](https://github.com/apache/maven-pmd-plugin/compare/maven-pmd-plugin-3.25.0...maven-pmd-plugin-3.26.0)

---
updated-dependencies:
- dependency-name: org.apache.maven.plugins:maven-pmd-plugin
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>

* Bump org.junit:junit-bom from 5.11.2 to 5.11.3

Bumps [org.junit:junit-bom](https://github.com/junit-team/junit5) from 5.11.2 to 5.11.3.
- [Release notes](https://github.com/junit-team/junit5/releases)
- [Commits](https://github.com/junit-team/junit5/compare/r5.11.2...r5.11.3)

---
updated-dependencies:
- dependency-name: org.junit:junit-bom
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>

---------

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: Julien Herr <[email protected]>
Co-authored-by: fnkbsi <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Co-authored-by: Sevket Gökay <[email protected]>
Co-authored-by: Andrei <[email protected]>
Co-authored-by: Julien Herr <[email protected]>
Co-authored-by: brosi <[email protected]>
Co-authored-by: Julien Herr <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants