[
https://issues.apache.org/jira/browse/FINERACT-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Omar Baqueiro updated FINERACT-1800:
------------------------------------
Description:
When trying to deploy Fineract using the `docker-compose-postgresql.yml` file,
there are multiple errors:
# First, if we attempt to run the default configuration by running:
{code:java}
git clone https://github.com/apache/fineract.git
cd fineract
docker-compose -f docker-compose-postgresql.yml up
{code}
We get the following error:
{code:java}
fineract-server_1 | . ____ _ __ _ _
fineract-server_1 | /
/ __' __ _ ()_ __ __ _ \ \ \ \
fineract-server_1 | ( ( )___ | '_ | '| | ' \/ _` | \ \ \ \
fineract-server_1 |
/ __)| |)| | | | | || (_| | ) ) ) )
fineract-server_1 | ' |___| .|| ||| |_, | / / / /
fineract-server_1 | =========||==============|_/=////
fineract-server_1 | :: Spring Boot :: (v2.6.0)
fineract-server_1 |
fineract-server_1 | 2022-11-08 19:55:12.243 INFO 8 — [ main]
org.apache.fineract.ServerApplication : Starting ServerApplication using
Java 11.0.13 on 077bd22e6c42 with PID 8 (/app started by root in /)
fineract-server_1 | 2022-11-08 19:55:12.249 INFO 8 — [ main]
org.apache.fineract.ServerApplication : No active profile set, falling back
to default profiles: basicauth
fineract-server_1 | 2022-11-08 19:55:18.396 INFO 8 — [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8080 (http) 8443 (https)
fineract-server_1 | 2022-11-08 19:55:20.130 ERROR 8 — [ main]
com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool
initialization.
fineract-server_1 |
fineract-server_1 | java.sql.SQLNonTransientConnectionException: Could not
connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to
connect to host:localhost, port:3306. Connection refused (Connection refused)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:194)
fineract-server_1 | at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
fineract-server_1 | at
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
fineract-server_1 | at org.mariadb.jdbc.Driver.connect(Driver.java:89)
fineract-server_1 | at
com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
fineract-server_1 | at
com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
fineract-server_1 |
{code}
Which means that the application is not using the provided PostgreSQL
connection as defined in the HIKARI_* variables in the docker compose.
Then if we go ahead and un-comment the `fineract_` variables in the
docker-compose-postgresql.yml file:
{code:java}
#- fineract_tenants_driver=org.postgresql.Driver
#-
fineract_tenants_url=jdbc:postgresql://fineractpostgresql:5432/fineract_tenants
#- fineract_tenants_uid=postgres
#- fineract_tenants_pwd=skdcnwauicn2ucnaecasdsajdnizucawencascdca{code}
We get a different error:
{code:java}
fineract-server_1 |
/ __)| |)| | | | | || (_| | ) ) ) )
fineract-server_1 | ' |___| .|| ||| |_, | / / / /
fineract-server_1 | =========||==============|_/=////
fineract-server_1 | :: Spring Boot :: (v2.6.0)
fineract-server_1 |
fineract-server_1 | 2022-11-08 19:58:24.014 INFO 8 — [ main]
org.apache.fineract.ServerApplication : Starting ServerApplication using
Java 11.0.13 on 76fd60fa8f35 with PID 8 (/app started by root in /)
fineract-server_1 | 2022-11-08 19:58:24.017 INFO 8 — [ main]
org.apache.fineract.ServerApplication : No active profile set, falling back
to default profiles: basicauth
fineract-server_1 | 2022-11-08 19:58:30.415 INFO 8 — [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8080 (http) 8443 (https)
fineract-server_1 | 2022-11-08 19:58:31.267 ERROR 8 — [ main]
com.zaxxer.hikari.HikariConfig : Failed to load driver class
org.postgresql.Driver from HikariConfig class classloader
jdk.internal.loader.ClassLoaders$AppClassLoader@67424e82
fineract-server_1 | 2022-11-08 19:58:31.273 ERROR 8 — [ main]
o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context.
Exception: org.springframework.beans.factory.UnsatisfiedDependencyException.
Message: Error creating bean with name 'securityConfig': Unsatisfied dependency
expressed through field 'userDetailsService'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'userDetailsService': Unsatisfied dependency expressed
through field 'platformUserRepository'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'appUserRepository' defined in org.apache.fineract.useradmini
{code}
Which appears to be ( _Failed to load driver class org.postgresql.Driver from
HikariConfig class)_ that the PostgreSQL library is missing in the Docker
image of Fineract.
was:
When trying to deploy Fineract using the `docker-compose-postgresql.yml` file,
there are multiple errors:
# First, if we attempt to run the default configuration by running:
``` git clone [https://github.com/apache/fineract.git]
cd fineract
docker-compose -f docker-compose-postgresql.yml up
```
We get the following error:
```
fineract-server_1 | . ____ _ __ _ _
fineract-server_1 | /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
fineract-server_1 | ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
fineract-server_1 | \\/ ___)| |_)| | | | | || (_| | ) ) ) )
fineract-server_1 | ' |____| .__|_| |_|_| |_\__, | / / / /
fineract-server_1 | =========|_|==============|___/=/_/_/_/
fineract-server_1 | :: Spring Boot :: (v2.6.0)
fineract-server_1 |
fineract-server_1 | 2022-11-08 19:55:12.243 INFO 8 --- [ main]
org.apache.fineract.ServerApplication : Starting ServerApplication using
Java 11.0.13 on 077bd22e6c42 with PID 8 (/app started by root in /)
fineract-server_1 | 2022-11-08 19:55:12.249 INFO 8 --- [ main]
org.apache.fineract.ServerApplication : No active profile set, falling back
to default profiles: basicauth
fineract-server_1 | 2022-11-08 19:55:18.396 INFO 8 --- [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8080 (http) 8443 (https)
fineract-server_1 | 2022-11-08 19:55:20.130 ERROR 8 --- [ main]
com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool
initialization.
fineract-server_1 |
fineract-server_1 | java.sql.SQLNonTransientConnectionException: Could not
connect to address=(host=localhost)(port=3306)(type=master) : Socket fail to
connect to host:localhost, port:3306. Connection refused (Connection refused)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:194)
fineract-server_1 | at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)
fineract-server_1 | at
org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
fineract-server_1 | at
org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
fineract-server_1 | at org.mariadb.jdbc.Driver.connect(Driver.java:89)
fineract-server_1 | at
com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
fineract-server_1 | at
com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
fineract-server_1 |
```
Which means that the application is not using the provided PostgreSQL
connection as defined in the HIKARI_* variables in the docker compose.
Then if we go ahead and un-comment the `fineract_` variables in the
docker-compose-postgresql.yml file:
```
#- fineract_tenants_driver=org.postgresql.Driver
#-
fineract_tenants_url=jdbc:postgresql://fineractpostgresql:5432/fineract_tenants
#- fineract_tenants_uid=postgres
#- fineract_tenants_pwd=skdcnwauicn2ucnaecasdsajdnizucawencascdca
```
We get a different error:
```
ineract-server_1 | \\/ ___)| |_)| | | | | || (_| | ) ) ) )
fineract-server_1 | ' |____| .__|_| |_|_| |_\__, | / / / /
fineract-server_1 | =========|_|==============|___/=/_/_/_/
fineract-server_1 | :: Spring Boot :: (v2.6.0)
fineract-server_1 |
fineract-server_1 | 2022-11-08 19:58:24.014 INFO 8 --- [ main]
org.apache.fineract.ServerApplication : Starting ServerApplication using
Java 11.0.13 on 76fd60fa8f35 with PID 8 (/app started by root in /)
fineract-server_1 | 2022-11-08 19:58:24.017 INFO 8 --- [ main]
org.apache.fineract.ServerApplication : No active profile set, falling back
to default profiles: basicauth
fineract-server_1 | 2022-11-08 19:58:30.415 INFO 8 --- [ main]
o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
8080 (http) 8443 (https)
fineract-server_1 | 2022-11-08 19:58:31.267 ERROR 8 --- [ main]
com.zaxxer.hikari.HikariConfig : Failed to load driver class
org.postgresql.Driver from HikariConfig class classloader
jdk.internal.loader.ClassLoaders$AppClassLoader@67424e82
fineract-server_1 | 2022-11-08 19:58:31.273 ERROR 8 --- [ main]
o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context.
Exception: org.springframework.beans.factory.UnsatisfiedDependencyException.
Message: Error creating bean with name 'securityConfig': Unsatisfied dependency
expressed through field 'userDetailsService'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'userDetailsService': Unsatisfied dependency expressed
through field 'platformUserRepository'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'appUserRepository' defined in org.apache.fineract.useradmini
```
Which appears to be ( Failed to load driver class org.postgresql.Driver from
HikariConfig class) that the PostgreSQL library is missing in the Docker image
of Fineract.
> docker-compose-postgresql.yml Error when spinning up
> ----------------------------------------------------
>
> Key: FINERACT-1800
> URL: https://issues.apache.org/jira/browse/FINERACT-1800
> Project: Apache Fineract
> Issue Type: Bug
> Components: Deployment
> Reporter: Omar Baqueiro
> Priority: Major
>
> When trying to deploy Fineract using the `docker-compose-postgresql.yml`
> file, there are multiple errors:
>
> # First, if we attempt to run the default configuration by running:
>
> {code:java}
> git clone https://github.com/apache/fineract.git
> cd fineract
> docker-compose -f docker-compose-postgresql.yml up
> {code}
>
>
> We get the following error:
> {code:java}
>
> fineract-server_1 | . ____ _ __ _ _
> fineract-server_1 | /
> / __' __ _ ()_ __ __ _ \ \ \ \
> fineract-server_1 | ( ( )___ | '_ | '| | ' \/ _` | \ \ \ \
> fineract-server_1 |
> / __)| |)| | | | | || (_| | ) ) ) )
> fineract-server_1 | ' |___| .|| ||| |_, | / / / /
> fineract-server_1 | =========||==============|_/=////
> fineract-server_1 | :: Spring Boot :: (v2.6.0)
> fineract-server_1 |
> fineract-server_1 | 2022-11-08 19:55:12.243 INFO 8 — [ main]
> org.apache.fineract.ServerApplication : Starting ServerApplication using
> Java 11.0.13 on 077bd22e6c42 with PID 8 (/app started by root in /)
> fineract-server_1 | 2022-11-08 19:55:12.249 INFO 8 — [ main]
> org.apache.fineract.ServerApplication : No active profile set, falling
> back to default profiles: basicauth
> fineract-server_1 | 2022-11-08 19:55:18.396 INFO 8 — [ main]
> o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
> 8080 (http) 8443 (https)
> fineract-server_1 | 2022-11-08 19:55:20.130 ERROR 8 — [ main]
> com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during
> pool initialization.
> fineract-server_1 |
> fineract-server_1 | java.sql.SQLNonTransientConnectionException: Could
> not connect to address=(host=localhost)(port=3306)(type=master) : Socket fail
> to connect to host:localhost, port:3306. Connection refused (Connection
> refused)
> fineract-server_1 | at
> org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73)
> fineract-server_1 | at
> org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:194)
> fineract-server_1 | at
> org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)
> fineract-server_1 | at
> org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
> fineract-server_1 | at
> org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
> fineract-server_1 | at org.mariadb.jdbc.Driver.connect(Driver.java:89)
> fineract-server_1 | at
> com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
> fineract-server_1 | at
> com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
> fineract-server_1 |
> {code}
>
>
> Which means that the application is not using the provided PostgreSQL
> connection as defined in the HIKARI_* variables in the docker compose.
>
> Then if we go ahead and un-comment the `fineract_` variables in the
> docker-compose-postgresql.yml file:
>
> {code:java}
> #- fineract_tenants_driver=org.postgresql.Driver
> #-
> fineract_tenants_url=jdbc:postgresql://fineractpostgresql:5432/fineract_tenants
> #- fineract_tenants_uid=postgres
> #- fineract_tenants_pwd=skdcnwauicn2ucnaecasdsajdnizucawencascdca{code}
>
> We get a different error:
>
>
>
> {code:java}
> fineract-server_1 |
> / __)| |)| | | | | || (_| | ) ) ) )
> fineract-server_1 | ' |___| .|| ||| |_, | / / / /
> fineract-server_1 | =========||==============|_/=////
> fineract-server_1 | :: Spring Boot :: (v2.6.0)
> fineract-server_1 |
> fineract-server_1 | 2022-11-08 19:58:24.014 INFO 8 — [ main]
> org.apache.fineract.ServerApplication : Starting ServerApplication using
> Java 11.0.13 on 76fd60fa8f35 with PID 8 (/app started by root in /)
> fineract-server_1 | 2022-11-08 19:58:24.017 INFO 8 — [ main]
> org.apache.fineract.ServerApplication : No active profile set, falling
> back to default profiles: basicauth
> fineract-server_1 | 2022-11-08 19:58:30.415 INFO 8 — [ main]
> o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s):
> 8080 (http) 8443 (https)
> fineract-server_1 | 2022-11-08 19:58:31.267 ERROR 8 — [ main]
> com.zaxxer.hikari.HikariConfig : Failed to load driver class
> org.postgresql.Driver from HikariConfig class classloader
> jdk.internal.loader.ClassLoaders$AppClassLoader@67424e82
> fineract-server_1 | 2022-11-08 19:58:31.273 ERROR 8 — [ main]
> o.s.b.web.embedded.tomcat.TomcatStarter : Error starting Tomcat context.
> Exception: org.springframework.beans.factory.UnsatisfiedDependencyException.
> Message: Error creating bean with name 'securityConfig': Unsatisfied
> dependency expressed through field 'userDetailsService'; nested exception is
> org.springframework.beans.factory.UnsatisfiedDependencyException: Error
> creating bean with name 'userDetailsService': Unsatisfied dependency
> expressed through field 'platformUserRepository'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating bean
> with name 'appUserRepository' defined in org.apache.fineract.useradmini
> {code}
>
> Which appears to be ( _Failed to load driver class org.postgresql.Driver from
> HikariConfig class)_ that the PostgreSQL library is missing in the Docker
> image of Fineract.
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
