[ckan-dev] Installing CKAN from package, set permissions for DataStore fails.

[Henrik Aagaard Sørensen]

PostGreSQL 8.4 caused the problem. Installing/upgrading to 9.1 fixed everything.

Fra: ckan-dev-bounces at lists.okfn.org [mailto:ckan-dev-bounces at lists.okfn.org] På vegne af Henrik Aagaard Sørensen
Sendt: 11. juni 2013 12:22
Til: 'ckan-dev at lists.okfn.org'
Emne: [ckan-dev] Installing CKAN from package, set permissions for DataStore fails.

I've installed CKAN from a package and want to activate DataStore. Everything runs fine until Set Permissions is due.
Option 1 is via the Paster Command which aren't used when installing from a package. Option 2 fails with the following:

An error occured: ERROR:  syntax error at or near "ALL"
LINE 1: GRANT SELECT ON ALL TABLES IN SCHEMA public TO "datastore_de...

I've ignored Option 3...

Can someone help out with setting permissions correctly when installing from package?

Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130611/d61de34b/attachment-0001.html>