Uploaded image for project: 'Project Quay'
  1. Project Quay
  2. PROJQUAY-3269

Quay can't start if DB_URI password contains special characters

XMLWordPrintable

      When the DB_URI password contains special characters, Quay 3.6.2 cannot start:

      DB_URI: postgresql://testuser2:test#123%456@172.24.10.50/quay2

      During validation:

      | Database               | Could not connect to database. Error: parse "postgresql://testuser2:test": invalid port ":test" after host |     |

      If validation is ignored via the IGNORE_VALIDATION=true parameter, the following is reported by sqlalchemy:

      Traceback (most recent call last):
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/base.py", line 2276, in _wrap_pool_connect
    return fn()
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 303, in unique_connection
    return _ConnectionFairy._checkout(self)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 773, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 492, in checkout
    rec = pool._do_get()
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py", line 139, in _do_get
    self._dec_overflow()
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
    raise value
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/impl.py", line 136, in _do_get
    return self._create_connection()
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 308, in _create_connection
    return _ConnectionRecord(self)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 437, in __init__
    self.__connect(first_connect_check=True)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/pool/base.py", line 652, in __connect
    connection = pool._invoke_creator(self)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
    return dialect.connect(*cargs, **cparams)
  File "/usr/local/lib64/python3.8/site-packages/sqlalchemy/engine/default.py", line 489, in connect
    return self.dbapi.connect(*cargs, **cparams)
  File "/usr/local/lib64/python3.8/site-packages/psycopg2/__init__.py", line 126, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  password authentication failed for user "testuser2"
FATAL:  password authentication failed for user "testuser2"

      Putting the password in various quotation marks doesn't work, the only thing that works is changing the password for the user. Marking this as critical, the issue should be resolved as soon as possible.

        1. image-2022-02-22-11-16-14-211.png
          image-2022-02-22-11-16-14-211.png
          336 kB
        2. image-2022-02-22-11-29-14-516.png
          image-2022-02-22-11-29-14-516.png
          349 kB
        3. image-2022-03-29-11-21-02-343.png
          image-2022-03-29-11-21-02-343.png
          328 kB
        4. image-2022-04-06-10-39-22-358.png
          image-2022-04-06-10-39-22-358.png
          334 kB

              syahmed@redhat.com Syed Ahmed
              rhn-support-ibazulic Ivan Bazulic
              luffy zhang luffy zhang
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: