Installation fails on "Access denied" error

Digip76 commented 4 days ago

Checklist

[X] I checked other issues already, but found no answer/solution
[X] I checked the documentation and wiki, but found no answer/solution
[X] I am running the latest version and the issue still occurs
[X] I am sure that this issue is about SteVe (and not about the charging station software or something unrelated to SteVe)

Specifications

SteVe Version     : 3.6.0
Operating system  : Ubuntu 22.04.0 LTS
JDK               : n.a.
Database          : MariaDb 10.4

Expected Behavior

Successful installation ...

Actual Behavior

[ERROR] Error Code : 1045 [ERROR] Message : Access denied for user 'steve'@'172.19.0.3' (using password: YES) [ERROR] [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException 2024/07/01 14:40:01 Ready: tcp://mariadb:3306. [INFO] Scanning for projects... [INFO] [INFO] -------------------------< de.rwth.idsg:steve >------------------------- [INFO] Building SteVe 3.6.0 [INFO] from pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- clean:3.2.0:clean (default-clean) @ steve --- [INFO] [INFO] --- enforcer:3.3.0:enforce (enforce-java) @ steve --- [INFO] Rule 0: org.apache.maven.enforcer.rules.version.RequireJavaVersion passed [INFO] [INFO] --- git-commit-id:4.9.10:revision (default) @ steve --- [INFO] [INFO] --- properties:1.1.0:read-project-properties (default) @ steve --- [INFO] [INFO] --- flyway:7.15.0:migrate (default) @ steve --- [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 5.786 s [INFO] Finished at: 2024-07-01T14:40:10Z [INFO] ------------------------------------------------------------------------ [WARNING] [WARNING] Plugin validation issues were detected in 2 plugin(s) [WARNING] [WARNING] pl.project13.maven:git-commit-id-plugin:4.9.10 [WARNING] org.flywaydb:flyway-maven-plugin:7.15.0 [WARNING] [WARNING] For more or less details, use 'maven.plugin.validation' property with one of the values (case insensitive): [BRIEF, DEFAULT, VERBOSE] [WARNING] [ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.15.0:migrate (default) on project steve: org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database (jdbc:mysql://mariadb:3306/stevedb?useSSL=true&serverTimezone=UTC) for user 'steve': Access denied for user 'steve'@'172.19.0.3' (using password: YES) [ERROR] ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ [ERROR] SQL State : 28000 [ERROR] Error Code : 1045 [ERROR] Message : Access denied for user 'steve'@'172.19.0.3' (using password: YES) [ERROR] [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException 2024/07/01 14:42:11 Ready: tcp://mariadb:3306. [INFO] Scanning for projects... [INFO] [INFO] -------------------------< de.rwth.idsg:steve >------------------------- [INFO] Building SteVe 3.6.0 [INFO] from pom.xml [INFO] --------------------------------[ jar ]--------------------------------- [INFO] [INFO] --- clean:3.2.0:clean (default-clean) @ steve --- [INFO] [INFO] --- enforcer:3.3.0:enforce (enforce-java) @ steve --- [INFO] Rule 0: org.apache.maven.enforcer.rules.version.RequireJavaVersion passed [INFO] [INFO] --- git-commit-id:4.9.10:revision (default) @ steve --- [INFO] [INFO] --- properties:1.1.0:read-project-properties (default) @ steve --- [INFO] [INFO] --- flyway:7.15.0:migrate (default) @ steve --- [INFO] ------------------------------------------------------------------------ [INFO] BUILD FAILURE [INFO] ------------------------------------------------------------------------ [INFO] Total time: 5.406 s [INFO] Finished at: 2024-07-01T14:42:21Z [INFO] ------------------------------------------------------------------------ [WARNING] [WARNING] Plugin validation issues were detected in 2 plugin(s) [WARNING] [WARNING] pl.project13.maven:git-commit-id-plugin:4.9.10 [WARNING] org.flywaydb:flyway-maven-plugin:7.15.0 [WARNING] [WARNING] For more or less details, use 'maven.plugin.validation' property with one of the values (case insensitive): [BRIEF, DEFAULT, VERBOSE] [WARNING] [ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.15.0:migrate (default) on project steve: org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database (jdbc:mysql://mariadb:3306/stevedb?useSSL=true&serverTimezone=UTC) for user 'steve': Access denied for user 'steve'@'172.19.0.3' (using password: YES) [ERROR] ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ [ERROR] SQL State : 28000 [ERROR] Error Code : 1045 [ERROR] Message : Access denied for user 'steve'@'172.19.0.3' (using password: YES) [ERROR] [ERROR] -> [Help 1] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

Steps to Reproduce the Problem

followed the installation instruction and edited main.properties
docker-compose up -d

Additional context

The mariadb container stays in a running mode, the SteVe container crashes. I can setup a remote connection with HeidSQL to the mariadb. Database stevedb exists. I have logged into the docker container and added the missing privileges, but that doesn't help. ...

lategoodbye commented 4 days ago

Did you noticed that Steve request a SSL connection to the database? Did you verified that MariaDB accept SSL connections? Did you checked the necessary SSL server certificate? Did you checked the environment has a valid date and time?

Digip76 commented 4 days ago

Did you noticed that Steve request a SSL connection to the database? Did you verified that MariaDB accept SSL connections? Did you checked the necessary SSL server certificate? Did you checked the environment has a valid date and time?

Thanks for your reaction. I have checked the environment has a valid date and time and have set it to UTC time. Al the others, No. Have I missed some points in the Configuration and Installation part? I cannot find how to do that. Do you have some guidance? Thanks!

steve-community / steve