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

Tue Apr 9 06:24:02 UTC 2019

What makes me think that this might be the problem is that you indicated in
your message that you don't have control over the Postgres server - "After
struggling with corporate network issues, I can now connect to *remote*
Postgresql server" - PostGIS is an extension to Postgres and it often gets
installed and automatically creates this table that can cause a problem for
CKAN. But maybe I am barking up the wrong tree :-)

-Matt

On Mon, 8 Apr 2019 at 18:14, PIERRE Sylvain <sylvain.pierre at bas-rhin.fr>
wrote:

> 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
> *En**voyé :* 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>
> 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
>
> _______________________________________________
> 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/20190409/c6bb6d71/attachment-0002.html>