db-create with PostgreSQL fails with user "user"

Louis Bertrand Louis.Bertrand at durhamcollege.ca
Fri May 15 01:57:40 UTC 2020


Hello,
I get a strange exception when trying to create the database for a fresh installation of Kallithea. The exception complains about unknown user "user" even though I specified --user=Kallithea on the command line.

The full command line, run as user Kallithea:
$ kallithea-cli db-create -c my.ini --user=kallithea --password=blahblah --email=kallithea at domain.tld --repos=/var/lib/kallithea/repos

The exception seems to be raised by psycopg2 when connecting to the database, and called from sqlalchemy:
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  password authentication failed for user "user"

The user kallithea exists as a PostgreSQL role and has createdb permission, but it seems that the user name doesn't get through to sqlalchemy because it's using "user" instead of the name supplied on the command line.

Any ideas? Full rollback available if you wish.

Thanks
 --Louis


Louis Bertrand, P.Eng.
Professor, School of Science and Engineering Technology
Durham College, Oshawa ON Canada

________________________________

________________________________
This message is intended only for the named recipients. This message may contain information that is confidential or exempt from disclosure under applicable law. Any dissemination or copying of this message by anyone other than a named recipient is strictly prohibited. If you are not a named recipient or an employee or agent responsible for delivering this message to a named recipient, please notify us immediately, and permanently destroy this message and any copies you may have. Warning: Email may not be secure unless properly encrypted.


More information about the kallithea-general mailing list