Really struggling to get docker setup

[isaaclw]

I'm running debian bookworm:

$ cat /etc/debian_version 
12.9

And I feel like i have some computer familiarity, but I guess I'm a bit new to docker, and it refuses to set up.

I'm using the basic install from the main page. I set random values for these variables in server.env

MYSQL_PSW=
MYSQL_ROOT_PASSWORD=
JWT_SECRET=

I had to modify the .yml to say version: '3' and the top after removing: name: plant-it

Other than that I've made no changes.

I ran: sudo docker-compose -f docker-compose.yml up so that I could see the output.

The last thing in the output was:

server_1  | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.DatabaseException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
server_1  |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1802) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:601) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:523) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:336) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:288) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:334) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:312) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:365) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     ... 98 common frames omitted
server_1  | Caused by: liquibase.exception.LiquibaseException: liquibase.exception.DatabaseException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
server_1  |     at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:272) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1849) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1798) ~[spring-beans-6.2.0.jar!/:6.2.0]
server_1  |     ... 107 common frames omitted
server_1  | Caused by: liquibase.exception.DatabaseException: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
server_1  |     at liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:264) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at liquibase.Scope.lambda$child$0(Scope.java:194) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at liquibase.Scope.child(Scope.java:203) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at liquibase.Scope.child(Scope.java:193) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at liquibase.Scope.child(Scope.java:172) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:255) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     ... 109 common frames omitted
server_1  | Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
server_1  |     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:81) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:55) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:65) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:911) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:137) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:98) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:111) ~[HikariCP-5.1.0.jar!/:na]
server_1  |     at liquibase.integration.spring.SpringLiquibase.lambda$afterPropertiesSet$0(SpringLiquibase.java:259) ~[liquibase-core-4.30.0.jar!/:na]
server_1  |     ... 114 common frames omitted
server_1  | Caused by: com.mysql.cj.exceptions.CJException: Access denied for user 'plantit'@'172.18.0.4' (using password: YES)
server_1  |     at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62) ~[na:na]
server_1  |     at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502) ~[na:na]
server_1  |     at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486) ~[na:na]
server_1  |     at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:52) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:95) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:140) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:118) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:855) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:778) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:747) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:148) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:461) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:206) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1333) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.NativeSession.connect(NativeSession.java:155) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:851) ~[mysql-connector-j-9.1.0.jar!/:9.1.0]
server_1  |     ... 126 common frames omitted
server_1  | 

Any tips for how to get this to work?

[GerardPolloRebozado]

I had same issue for some reasson you cannot change that values leave them default

[mgrumpeli]

Hi, I habe the same problem using Raspberry Pi 4 and docker. I didn't change the name and pssword section but it's maybe not relevant, is it?

I don't know what the problem is really so if anyone can help maybe?:)

[astappiev]

Hi, the reason is that the password is not set for a MySQL user.
MySQL container expects to have a password in MYSQL_PASSWORD variable, while plant-it in MYSQL_PSW.
Moreover, MYSQL_USER not MYSQL_USERNAME.

To fix this, modify your .env:

# MySQL variables
MYSQL_DATABASE=plantit
MYSQL_USER=plantit
MYSQL_PASSWORD=secure_password
MYSQL_RANDOM_ROOT_PASSWORD=true

# planit variables
MYSQL_USERNAME=${MYSQL_USER}
MYSQL_PSW=${MYSQL_PASSWORD}