Some times, after proceed with the Installation, if any step has not been taken into account, the UI will not be available. One of this cases is when the password encryption has not been modified to md5 in PostgreSQL versions 13 or higher.
The following can be found on tomcat logs:
2022-06-09 14:08:26.507 50901 [main] ERROR org.springframework.boot.SpringApplication - Application startup failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateDatastoreServiceRegistry': Cannot resolve reference to bean 'hibernateDatastore' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'hibernateDatastore': Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.grails.orm.hibernate.HibernateDatastore]: Constructor threw exception; nested exception is java.lang.NoSuchFieldError:
SASL_PREPARATION
The issue can be solved by:
1 - Configure the password_encryption to md5 on postgres.conf with a text editor, as it follows:
password_encryption = md5 # scram-sha-256 or md5
To know the path of the file:
$ sudo su postgres
$ psql -c 'SHOW config_file'
$ exit
2- Stop the docker stack
$ cd docker
$ docker-compose down
3 - Drop the iriusprod user and db
$ sudo su - postgres
$ psql
postgres=# drop user iriusprod;
postgres=# drop database iriusprod;
4 - Restart the postgresql service
$ sudo systemctl restart postgresql
5 - Recreate the iriusprod user and db
postgres=# create user iriusprod with createdb password 'alongandcomplexpassword2523';
postgres=# create database iriusprod with owner='iriusprod';
6 - Start the docker stack
$ docker-compose up -d
Comments
0 comments
Article is closed for comments.