Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Mads Kiilerich
On 5/15/20 9:35 PM, Louis Bertrand wrote: I chose PostgreSQL because a) it's already installed on the eventual target server and b) I'm familiar with it. However, where is the trade-off between SQLite and PostgreSQL? Tens, hundreds, thousands? Number of users, transactions? Etc. In other

RE: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Louis Bertrand
-Original Message- From: Mads Kiilerich Sent: May 15, 2020 12:56 PM To: Louis Bertrand ; Thomas De Schampheleire Cc: Kallithea Subject: Re: db-create with PostgreSQL fails with user "user" [EXTERNAL EMAIL] On 5/15/20 10:08 AM, Louis Bertrand wrote: > Hi Thomas, > > Thanks for the

Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Mads Kiilerich
On 5/15/20 10:08 AM, Louis Bertrand wrote: 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 =

Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Louis Bertrand
Hi Thomas, I'm not familiar with how Raspberry Pi or Debian package things, but at first glance the two packages do indeed seem to be coming from different distributions. Thanks anyway --Louis From: Thomas De Schampheleire Sent: Friday, May 15, 2020

Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Thomas De Schampheleire
Hi Louis, Ok, great you found the postgreql error. Regarding npm: it seems indeed your nodejs is too new for the npm version. Based on the versions: nodejs (10.19.0~dfsg1-1+rpi1). npm (5.8.0+ds6-4+deb10u1). It seems that the nodejs installation is rpi specific. Is it coming from the same

Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Louis Bertrand
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

Re: db-create with PostgreSQL fails with user "user"

2020-05-15 Thread Thomas De Schampheleire
Hello, Could you provide the full stacktrace please? Thanks, Thomas On Fri, May 15, 2020, 04:14 Louis Bertrand 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