Library error when installing RhodeCode with postgres

Support
1

Hi all,

I’m trying to create a test RhodeCode instance under Ubuntu 22.04.2 LTS. I am using the latest installer build20221012_1600.

I have installed Postgres 14, configured a user for it.
When I try to install RhodeCode, I get the error sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SCRAM authentication requires libpq version 10 or above

I have updated the pg_hba so that user logs into localhost using scram-sha-256, but I don’t think the installer is even getting that far. I have verified that the libpq installed on the system is v14, so I don’t understand why this issue is happening.

2

Hi,

could you try our new docker stack that comes with postgres 14.7 ootb ?

https://hub.docker.com/r/rhodecode/rhodecode-ee

it can install both ce and ee versions.

but basically with current libpq version rhodecode supports you still need to fallback to md5 on postgres config like here:

https://code.rhodecode.com/rhodecode-enterprise-docker/files/master/config/database/pg_customized.conf?at=master#L97

3

I originally configured postgres for md5 but for some reason RhodeCode was adamant about using scram. I have no idea why, and I couldn’t find any documentation anywhere on how to make it use the more traditional login.

As an experiment, I set up Ubuntu 18 /w Postgres 10 and it installed without issue, so I’m going to do some poking to see if it can do what I need it to do. If I get past this initial evaluation, I’ll give the docker version a try. Thanks.