[ckan4rdm] Can't get datastore to install

Fri Oct 31 01:48:32 UTC 2014

Hi Claire,

just out of interest, how are you running the CKAN instances, and are you
running the datapusher as well? Are you running *paster serve* *<config>*
or serving them through apache/mod_wsgi?

I had some issues getting that one to work (CKAN install from source on a
Ubuntu 14.04 AWS VM) as the user running the processes didn't have write
permissions to the log file directories as per config files. I had to chown
the directories and chmod the logfiles (some had to be created first).

It would be helpful to see what the CKAN / datapusher logfiles say about
your error.

Cheers,
Florian

On Wed, Oct 29, 2014 at 10:23 PM, Claire Reis <Claire.Reis at umanitoba.ca>
wrote:

>  Hi,
>
> We have recently installed CKAN 2.2 from package on an Ubuntu 12.0.04
> machine.  WE have gotten the file upload plugin working, but cannot get the
> datastore working.  We get all the way through to set permissions (which
> seems to work) but when we test the set-up with the curl GET command the
> error returned is can’t connect to host.
>
> I have even gone in and looked at the set_permissions.sql file which did
> not in fact seemed to be changed, and changed the settings to:
>
> Main CKAN database: ckan_default
>
> Datastoredb: datastore_default
>
> CKANuser postgres: ckan_default (also tried postgres)
>
> Datastore user that can write and read: datastore_default
>
>
>
> We initially followed the instructions from
>
> http://docs.ckan.org/en/943-writing-extensions-tutorial/datastore.html
>
> and used Option 1 – paster command but couldn’t get the test to work so
> moved to option 3 - and copied the set_permissions.sql file to
> set_permissions_new.sql file where I changed the above settings, ran the
> sudo -u postgres psql postgres -f set_permissions_new.sql – which seemed to
> work and tried the curl test-set-up again which still fails.
>
>
>
> Any suggestions?
>
>
>
>
>
> In the SQL database, there is a database named ckan_default with
> ckan_default owner and datastore_default with ckan_default owner.  There is
> also a user – datastore_default.  All databases are UTF-8 encoded.
>
>
>
> Thank you,
>
>
>
> Claire Herbert
>
> Coordinator
>
> Lake Winnipeg Basin Information Network
>
>
>
> Centre For Earth Observation Science
>
> Department of Environment and Geography
>
> 522 Wallace Building
>
> University of Manitoba
>
> Winnipeg, Canada, R3T 3N2
>
> Phone: (204) 474-8657
>
>
>
> Follow us on twitter - @LWBIN_UM
>
> Web: http://lwbi.cc.umanitoba.ca/
>
>
>
> _______________________________________________
> ckan4rdm mailing list
> ckan4rdm at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan4rdm
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan4rdm/attachments/20141031/eb15ea5a/attachment-0003.html>