db-create with PostgreSQL fails with user "user"

[Thomas De Schampheleire]

Hello,

Could you provide the full stacktrace please?

Thanks,
Thomas

On Fri, May 15, 2020, 04:14 Louis Bertrand <Louis.Bertrand at durhamcollege.ca>
wrote:

> 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.
> _______________________________________________
> kallithea-general mailing list
> kallithea-general at sfconservancy.org
> https://lists.sfconservancy.org/mailman/listinfo/kallithea-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sfconservancy.org/pipermail/kallithea-general/attachments/20200515/103b8e5c/attachment.html>