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

PIERRE Sylvain sylvain.pierre at bas-rhin.fr
Fri Apr 5 13:27:37 UTC 2019


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190405/33296b2a/attachment.html>


More information about the ckan-dev mailing list