steve icon indicating copy to clipboard operation
steve copied to clipboard

While installing : Unable to obtain connection from database

Open aatronics opened this issue 4 years ago • 3 comments

When I run the below command I get "build failed message", anyone steveServerError steveServerError can please help me to run the service

export MAVEN_OPTS="-Xmx100m" && mvn package

aatronics avatar Aug 01 '21 14:08 aatronics

The error indicates that the password or username for the database is not correct.

csamsel avatar Aug 01 '21 16:08 csamsel

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

aatronics avatar Aug 01 '21 16:08 aatronics

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] 

cyrilfr avatar Aug 23 '21 14:08 cyrilfr

Hi Guys, Just run into this issue.

How did you overcome?

I'm using the docker method.

Thanks

joseapdmota avatar Jan 27 '23 12:01 joseapdmota

My error was editing the main.properties file under the prod folder instead of docker

LivingWithHippos avatar Sep 06 '23 10:09 LivingWithHippos

closing the issue due to inactivity.

goekay avatar Feb 18 '24 11:02 goekay