db-create with PostgreSQL fails with user "user"

Fri May 15 08:08:02 UTC 2020

Hi Thomas,

Thanks for the prompt reply but it turns out that it's pilot error. The name 'user' came from my.ini, where the postgresql URL was set to default. After setting the URL correctly

   sqlalchemy.url = postgresql://kallithea:S3CR3T@localhost/kallithea
  (not the real password)

the database seems to be initialized correctly.

However the next step crashes on 'npm install' (see text below).

With apt-get I can confirm that npm and nodejs are at the latest available versions but that seems to be the problem:

  nodejs is already the newest version (10.19.0~dfsg1-1+rpi1).

  npm is already the newest version (5.8.0+ds6-4+deb10u1).
npm does not recognize version NodeJS 10.x as valid.

I should mention here that I am using a Raspberry Pi mostly because it's what I have on hand. I'm trying to prototype the system so that I can get our college IT dept to install it on a public facing server for student work. The college server is running Ubuntu 18.04.4 LTS. The Pi is running Raspbian 10 (buster). If the Pi is not suitable or supported, I can switch to a VM running internally (access via VPN).

Thanks in advance

 --Louis

Full text of output:

(kallithea-venv) kallithea at raspberrypi:~/kallithea$ kallithea-cli front-end-build
Running 'npm install' to install front-end dependencies from package.json
npm WARN npm npm does not support Node.js v10.19.0
npm WARN npm You should probably upgrade to a newer version of node as we
npm WARN npm can't make any promises that npm will work with this version.
npm WARN npm Supported releases of Node.js are the latest release of 4, 6, 7, 8, 9.
npm WARN npm You can find the latest version at https://nodejs.org/
npm WARN notice [SECURITY] bootstrap has the following vulnerability: 1 moderate. Go here for more details: https://www.npmjs.com/advisories?search=bootstrap&version=3.3.7 - Run `npm i npm at latest -g` to upgrade your npm version, and then `npm audit` to get more info.
npm WARN tar write after end
npm WARN notice [SECURITY] clean-css has the following vulnerability: 1 low. Go here for more details: https://www.npmjs.com/advisories?search=clean-css&version=3.4.28 - Run `npm i npm at latest -g` to upgrade your npm version, and then `npm audit` to get more info.
npm WARN tar write after end
npm WARN tar write after end
npm ERR! cb() never called!

npm ERR! This is an error with npm itself. Please report this error at:
npm ERR!     <https://github.com/npm/npm/issues>

npm ERR! A complete log of this run can be found in:
npm ERR!     /var/lib/kallithea/.npm/_logs/2020-05-15T07_32_43_524Z-debug.log
Traceback (most recent call last):
  File "/var/lib/kallithea/kallithea-venv/bin/kallithea-cli", line 11, in <module>
    load_entry_point('Kallithea', 'console_scripts', 'kallithea-cli')()
  File "/var/lib/kallithea/kallithea-venv/lib/python3.7/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/var/lib/kallithea/kallithea-venv/lib/python3.7/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/var/lib/kallithea/kallithea-venv/lib/python3.7/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/var/lib/kallithea/kallithea-venv/lib/python3.7/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/var/lib/kallithea/kallithea-venv/lib/python3.7/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/var/lib/kallithea/kallithea/kallithea/bin/kallithea_cli_front_end.py", line 46, in front_end_build
    subprocess.check_call(['npm', 'install'], cwd=front_end_dir, shell=kallithea.is_windows)
  File "/usr/lib/python3.7/subprocess.py", line 347, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['npm', 'install']' returned non-zero exit status 1

________________________________
From: Thomas De Schampheleire <patrickdepinguin at gmail.com>
Sent: Friday, May 15, 2020 2:03 AM
To: Louis Bertrand
Cc: Kallithea
Subject: Re: db-create with PostgreSQL fails with user "user"

[EXTERNAL EMAIL]
Hello,

Could you provide the full stacktrace please?

Thanks,
Thomas

On Fri, May 15, 2020, 04:14 Louis Bertrand <Louis.Bertrand at durhamcollege.ca<mailto: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<mailto:kallithea-general at sfconservancy.org>
https://lists.sfconservancy.org/mailman/listinfo/kallithea-general
u