[ckan-dev] CKAN db init issue - install from package

Mon Apr 8 06:39:17 UTC 2019

Thanks.

But I It seems to be an other issue. I’m not migrating CKAN, it’s a fresh install from package.
Other information: Postgres run on a window server

Sylvain

De : ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org] De la part de Matthew Fullerton
Envoyé : lundi 8 avril 2019 06:27
À : CKAN Development Discussions
Objet : Re: [ckan-dev] CKAN db init issue - install from package

See also here:
https://github.com/ckan/ckan/issues/3929

The quick fix might be to have the Tiger stuff removed (from PostGIS) on the Postgres server if you don't need it.

Best,
Matt

On Sat, 6 Apr 2019 at 12:00, PIERRE Sylvain <sylvain.pierre at bas-rhin.fr<mailto:sylvain.pierre at bas-rhin.fr>> wrote:
Hi list,

Purpose : install CKAN server from package on Ubuntu 16.04
Postgres: 9.6.12

After struggling with corporate network issues, I can now connect to remote Postgresql server with psql.
But when I run sudo ckan db init, I got :

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) ERREUR:  la colonne user.password n'existe pas
LINE 1: SELECT "user".password AS user_password, "user".id AS user_i...
               ^
[SQL: 'SELECT "user".password AS user_password, "user".id AS user_id, "user".name AS user_name, "user".fullname AS user_fullname, "user".email AS user_email, "user".apikey AS user_apikey, "user".created AS user_created, "user".reset_key AS user_reset_key, "user".about AS user_about, "user".activity_streams_email_notifications AS user_activity_streams_email_notifications, "user".sysadmin AS user_sysadmin, "user".state AS user_state \nFROM "user" \nWHERE "user".name = %(name_1)s OR "user".id = %(id_1)s ORDER BY "user".name \n LIMIT %(param_1)s'] [parameters: {'name_1': 'default', 'param_1': 1, 'id_1': 'default'}]

Searching , I found similar issue:
https://stackoverflow.com/questions/30666258/ckan-paster-db-init-sqlalchemy-programming-error

But it talk about install from source…
Any idea

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190408/99264b29/attachment-0002.html>