Uploaded image for project: 'TomEE'
  1. TomEE
  2. TOMEE-2968

Postgres connection error when a password contains "}"

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 7.0.5, 8.0.0-Final, 7.1.4, 8.0.6
    • Fix Version/s: 7.0.10, 7.1.5, 8.0.7, 8.0.8
    • Component/s: TomEE Core Server
    • Labels:
      None
    • Environment:
      Windows 10
    • Flags:
      Important

      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"

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rzo1 Richard Zowalla
                Reporter:
                alexlevin Alex Levin
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 5.5h
                  5.5h