While installing : Unable to obtain connection from database
When I run the below command I get "build failed message", anyone
can please help me to run the service
export MAVEN_OPTS="-Xmx100m" && mvn package
The error indicates that the password or username for the database is not correct.
The error indicates that the password or username for the database is not correct.
I have used the same username and password to create the database, also I have crosscheck the username and password on Connection details (AWS database). is this issue will be related to timezone, because whenever I will try to open SSH from the browser, I am not able to connect to Ubuntu VPS, so always I use putty SSH to connect
I have the same issue using Docker. In my case, the IP used to connect to the DB is the SteVe's Docker IP (localhost) instead of the db.ip value set in the docker configuration file under steve/src/main/resources/config/docker/main.properties.
2021/08/24 09:40:29 Waiting for: tcp://10.102.13.90:3306
2021/08/24 09:40:29 Connected to tcp://10.102.13.90:3306
[INFO] Scanning for projects...
[INFO]
[INFO] -------------------------< de.rwth.idsg:steve >-------------------------
[INFO] Building steve 3.4.5
[INFO] --------------------------------[ jar ]---------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.5:clean (default-clean) @ steve ---
[INFO]
[INFO] --- maven-enforcer-plugin:3.0.0:enforce (enforce-java) @ steve ---
[INFO]
[INFO] --- git-commit-id-plugin:4.9.10:revision (default) @ steve ---
[INFO]
[INFO] --- properties-maven-plugin:1.0.0:read-project-properties (default) @ steve ---
[INFO]
[INFO] --- flyway-maven-plugin:7.11.3:migrate (default) @ steve ---
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 8.900 s
[INFO] Finished at: 2021-08-24T09:40:40Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.11.3:migrate (default) on project steve: org.flywaydb.core.internal.exception.FlywaySqlException:
[ERROR] Unable to obtain connection from database (jdbc:mysql://10.102.13.90:3306/stevedb?useSSL=true&serverTimezone=UTC) for user 'steve': Access denied for user 'steve'@'10.102.11.172' (using password: YES)
[ERROR]
Hi Guys, Just run into this issue.
How did you overcome?
I'm using the docker method.
Thanks
My error was editing the main.properties file under the prod folder instead of docker
closing the issue due to inactivity.