Post-install test failed due to -178000(AUTHENTICATION_ERROR)

[yr-wang-hit]

Post-install test failed due to -178000(AUTHENTICATION_ERROR)

[yr-wang-hit]

clear the database and Reinstall irods, now I can use ils and iput normally. But /usr/sbin/irodsTestPutGet always cause:
Error: cannot open data object for writing ["/zone1/home/rods/post_install_test.1713667257490298.txt"]

[alanking]

It's hard to say from here what may have happened. If it's possible to try again from the start, please confirm that the iRODS administrator password is being entered correctly. Of course, please do not post any of that information here. :)

You mentioned clearing the database and re-installing iRODS. I would also say to make sure that you clear out a few key directories after uninstalling iRODS because these are not done automatically:

• /var/lib/irods
• /etc/irods
• /tmp/irods

I'm wondering whether a client environment from a past installation exists or existed in /var/lib/irods/.irods and perhaps interfered with the setup.

And now, a story: I tried this out myself using Centos 7 and Postgres 14.8 in the irods_testing_environment (https://github.com/irods/irods_testing_environment) and was able to run the setup script successfully. There were, however, a few hiccups, so I'm going to document what happened for posterity. If you want to follow along using the testing environment, you'll notice that Centos 7/Postgres 14.8 project does not exist, but it's pretty easy to add - especially if you just want to set things up manually.

Anyway, I encountered an issue when trying to communicate with the database (way before the put/get test):

-------------------------------------------
Database Type: postgres
ODBC Driver:   PostgreSQL
Database Host: 9c197e3af943
Database Port: 5432
Database Name: ICAT
Database User: irods
-------------------------------------------

Please confirm [yes]: 
Database password: 
Error encountered running setup_irods:
Traceback (most recent call last):
  File "/var/lib/irods/scripts/irods/database_connect.py", line 206, 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 525, in main
    test_mode=options.test_mode)
  File "/var/lib/irods/scripts/setup_irods.py", line 123, 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 240, in get_database_connection
    sys.exc_info()[2])
  File "/var/lib/irods/scripts/irods/six.py", line 671, in reraise
    raise value.with_traceback(tb)
  File "/var/lib/irods/scripts/irods/database_connect.py", line 206, in get_database_connection
    conn = pyodbc.connect(connection_string, ansi=True)
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)')

After jumping through some hoops (configuring the PostgreSQL yum repository and installing the version 14 packages as described here: https://www.postgresql.org/download/linux/redhat/) I was able to install a later version of the postgresql packages and proceed past this error. After that, I used pretty much all of the "default" answers (see https://docs.irods.org/4.3.1/getting_started/installation/#catalog-service-provider) and everything worked fine, including the put/get test.

[yr-wang-hit]

Thanks Alan, everything goes well now.