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

Mon Apr 8 04:26:32 UTC 2019

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>
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
> 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/3f699cd7/attachment-0002.html>