You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tomee.apache.org by "Alex Levin (Jira)" <ji...@apache.org> on 2021/02/02 21:07:00 UTC
[jira] [Updated] (TOMEE-2968) Postgres connection error when a
password contains "}"
[ https://issues.apache.org/jira/browse/TOMEE-2968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alex Levin updated TOMEE-2968:
------------------------------
Description:
If a password contains the "}" character (closing curly brace), the database connection cannot be established.
My resources.xml:
<Resource id="Postgres Databse" type="javax.sql.DataSource">
jdbcDriver org.postgresql.Driver
jdbcUrl jdbc:postgresql://localhost:5432/postgresdb
username scott
password tiger...}
maxActive = 250
</Resource>
Error message in the log:
2021-02-02 15:55:45 WARN [main] SqlExceptionHelper:144 - SQL Error: 0, SQLState: 28P01
2021-02-02 15:55:45 ERROR [main] SqlExceptionHelper:146 - FATAL: password authentication failed for user "scott"
was:
If a password contains the "}" (closing curly brace), the database connection cannot be established.
My resources.xml:
<Resource id="Postgres Databse" type="javax.sql.DataSource">
jdbcDriver org.postgresql.Driver
jdbcUrl jdbc:postgresql://localhost:5432/postgresdb
username scott
password tiger...}
maxActive = 250
</Resource>
Error message in the log:
2021-02-02 15:55:45 WARN [main] SqlExceptionHelper:144 - SQL Error: 0, SQLState: 28P01
2021-02-02 15:55:45 ERROR [main] SqlExceptionHelper:146 - FATAL: password authentication failed for user "scott"
> Postgres connection error when a password contains "}"
> ------------------------------------------------------
>
> Key: TOMEE-2968
> URL: https://issues.apache.org/jira/browse/TOMEE-2968
> Project: TomEE
> Issue Type: Bug
> Components: TomEE Core Server
> Affects Versions: 8.0.0-Final
> Environment: Windows 10
> Reporter: Alex Levin
> Priority: Critical
> Fix For: 8.0.0-Final
>
>
> If a password contains the "}" character (closing curly brace), the database connection cannot be established.
> My resources.xml:
> <Resource id="Postgres Databse" type="javax.sql.DataSource">
> jdbcDriver org.postgresql.Driver
> jdbcUrl jdbc:postgresql://localhost:5432/postgresdb
> username scott
> password tiger...}
> maxActive = 250
> </Resource>
> Error message in the log:
> 2021-02-02 15:55:45 WARN [main] SqlExceptionHelper:144 - SQL Error: 0, SQLState: 28P01
> 2021-02-02 15:55:45 ERROR [main] SqlExceptionHelper:146 - FATAL: password authentication failed for user "scott"
--
This message was sent by Atlassian Jira
(v8.3.4#803005)