[opencms-dev] [SOLVED] RE: Issue Running OpenCms in Docker

[Ramon Gavira Sáenz]

It Works if we set a Mariadb minor versión like  10.4.28

Probably there is an incopatibility with latest versión of mariadv

Regards

De: opencms-dev <opencms-dev-bounces at opencms.org> En nombre de Ramon Gavira Sáenz via opencms-dev
Enviado el: martes, 14 de febrero de 2023 19:55
Para: opencms-dev at opencms.org
CC: Ramon Gavira Sáenz <ramon.gavira at sagasoluciones.com>
Asunto: [opencms-dev] Issue Running OpenCms in Docker

Hello people,

I am trying to deploy OpenCms14 in Docker, but the MariaDB container doesn't deploy correctly, It's like root can't access even on the Mariabd own container.

Less from the other container, OpenCms setup process throws this error:

2023-02-14 19:45:36 Setup-Bean initialized successfully.
2023-02-14 19:45:37 Exception: java.sql.SQLInvalidAuthorizationSpecException: Could not connect to address=(host=mysql)(port=3306)(type=master) : (conn=5) Access denied for user 'root'@'172.27.0.3' (using password: YES)
2023-02-14 19:45:37 Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:66)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:192)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1392)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)
2023-02-14 19:45:37     at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)
2023-02-14 19:45:37     at org.mariadb.jdbc.Driver.connect(Driver.java:89)
2023-02-14 19:45:37     at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
2023-02-14 19:45:37     at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
2023-02-14 19:45:37     at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:518)
2023-02-14 19:45:37     at org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:488)
2023-02-14 19:45:37     at org.opencms.setup.CmsAutoSetup.setupDB(CmsAutoSetup.java:283)
2023-02-14 19:45:37     at org.opencms.setup.CmsAutoSetup.run(CmsAutoSetup.java:215)
2023-02-14 19:45:37     at org.opencms.setup.CmsAutoSetup.main(CmsAutoSetup.java:135)
2023-02-14 19:45:37 Caused by: java.sql.SQLInvalidAuthorizationSpecException: (conn=5) Access denied for user 'root'@'172.27.0.3' (using password: YES)
2023-02-14 19:45:37 Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:66)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:187)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:767)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:553)
2023-02-14 19:45:37     at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1387)
2023-02-14 19:45:37     ... 10 more
2023-02-14 19:45:37
2023-02-14 19:45:37 An error occurred during the setup process with the following error message:
2023-02-14 19:45:37 DB Connection test faild.
2023-02-14 19:45:37 Please have a look into the opencms log file for detailed information.


May be I am missing something in Docker-compose file?? If I deploy de Mariadb image without using compose it seems to be ok, but not wher I try with the two services together

Thanks in advance

Ramón Gavira Sáenz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20230214/be06af48/attachment.htm>