irods / irods_testing_environment

BSD 3-Clause "New" or "Revised" License
8 stars 14 forks source link

EL7 postgres projects cannot stand up iRODS due to outdated postgres libs #221

Closed SwooshyCueb closed 2 months ago

SwooshyCueb commented 2 months ago

When attempting to run tests using the EL7 postgres projects, iRODS will fail to stand up, as the postgres server uses functionality not supported by the old version of the postgres libs in the EL7 repos:

Error encountered running setup_irods:
Traceback (most recent call last):
  File "/var/lib/irods/scripts/irods/database_connect.py", line 207, in get_database_connection
    conn = pyodbc.connect(connection_string, ansi=True)
pyodbc.OperationalError: ('08001', '[08001] [unixODBC]SCRAM authentication requires libpq version 10 or above\n (101) (SQLDriverConnect)')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/irods/scripts/setup_irods.py", line 526, in main
    test_mode=options.test_mode)
  File "/var/lib/irods/scripts/setup_irods.py", line 121, in setup_server
    database_interface.setup_database_config(irods_config)
  File "/var/lib/irods/scripts/irods/database_interface.py", line 176, in setup_database_config
    if database_already_in_use_by_irods(irods_config):
  File "/var/lib/irods/scripts/irods/database_interface.py", line 73, in database_already_in_use_by_irods
    with contextlib.closing(database_connect.get_database_connection(irods_config)) as connection:
  File "/var/lib/irods/scripts/irods/database_connect.py", line 239, in get_database_connection
    raise IrodsError('%s\n%s' % (message, str(e)))
irods.exceptions.IrodsError: pyodbc encountered an error connecting to the database:
('08001', '[08001] [unixODBC]SCRAM authentication requires libpq version 10 or above\n (101) (SQLDriverConnect)')