[CKAN-support] FW: [URGENT] CKAN error message

David Raznick david.raznick at okfn.org
Wed Oct 23 14:51:36 UTC 2013


Hello

I have fixed this now.  The filestore was reconfigured.

Thanks

David


On 23 October 2013 15:04, Gavin Chait <gavin.chait at okfn.org> wrote:

> Hi,****
>
> ** **
>
> The Filestore isn’t working on the St Andrews site. Some setting we left
> undone?****
>
> ** **
>
> Thanks ****
>
> ** **
>
> Gavin****
>
> ** **
> ------------------------------
>
> *Gavin Chait***
>
> Head of Services | skype: whythawk | M:  +44 (0) 78 9495 7090 | *
> @GavinChait <https://twitter.com/GavinChait>*****
>
> *The Open Knowledge Foundation<http://www.google.com/url?q=http%3A%2F%2Fokfn.org%2F&sa=D&sntz=1&usg=AFQjCNG2PcKjUT2LrlbSh4JGbu1dt-bNyg>
> *****
>
> *Empowering through Open Knowledge*****
>
> *http://okfn.org/* | *@okfn <http://twitter.com/OKFN>* | *OKF on Facebook<https://www.facebook.com/OKFNetwork>
> * | *Blog <http://blog.okfn.org/>* | Newsletter<http://okfn.org/about/newsletter>
> ****
>
> ** **
>
> *From:* Birgit Plietzsch [mailto:bp10 at st-andrews.ac.uk]
> *Sent:* 23 October 2013 15:03
> *To:* gavin.chait at okfn.org
> *Cc:* Athos Georgiou; Anna Clements
> *Subject:* RE: CKAN error message****
>
> ** **
>
> Hello Gavin****
>
> ** **
>
> Many thanks for getting this sorted.****
>
> ** **
>
> I notice that in the quote you provided us with the setup of the file
> store and data store were included. Yet we are unable to upload any data
> into CKAN. All we can do is just link to existing datasets. Am I
> overlooking the obvious?****
>
> ** **
>
> Thanks****
>
> Birgit****
>
> ** **
>
> ** **
>
> --****
>
> Dr Birgit Plietzsch****
>
> Research Computing Team Leader, IT Services****
>
> University of St Andrews, St Andrews, Fife, KY16 9AL****
>
> ** **
>
> T: 01334 462315  |  F: 01334 462759  | E: bp10 at st-andrews.ac.uk  |  W:
> http://www.st-andrews.ac.uk/its****
>
> ** **
>
> Research Computing blog: http://research-computing.wp.st-andrews.ac.uk/ **
> **
>
> ** **
>
> The University of St Andrews is a charity registered in Scotland: No
> SC013532****
>
> ** **
>
> *From:* Gavin Chait [mailto:gavin.chait at okfn.org <gavin.chait at okfn.org>]
> *Sent:* 18 October 2013 17:33
> *To:* Anna Clements
> *Cc:* Athos Georgiou; Birgit Plietzsch
> *Subject:* RE: CKAN error message****
>
> ** **
>
> And apologies for the delay. I’ve been on leave and only returned to the
> UK this morning.****
>
> ** **
>
> Regards****
>
> ** **
>
> Gavin****
>
> ** **
> ------------------------------
>
> *Gavin Chait***
>
> Head of Services | skype: whythawk | M:  +44 (0) 78 9495 7090 | *
> @GavinChait <https://twitter.com/GavinChait>*****
>
> *The Open Knowledge Foundation<http://www.google.com/url?q=http%3A%2F%2Fokfn.org%2F&sa=D&sntz=1&usg=AFQjCNG2PcKjUT2LrlbSh4JGbu1dt-bNyg>
> *****
>
> *Empowering through Open Knowledge*****
>
> *http://okfn.org/* | *@okfn <http://twitter.com/OKFN>* | *OKF on Facebook<https://www.facebook.com/OKFNetwork>
> * | *Blog <http://blog.okfn.org/>* | Newsletter<http://okfn.org/about/newsletter>
> ****
>
> ** **
>
> *From:* Anna Clements [mailto:akc at st-andrews.ac.uk <akc at st-andrews.ac.uk>]
>
> *Sent:* 18 October 2013 17:24
> *To:* gavin.chait at okfn.org
> *Cc:* Athos Georgiou; Birgit Plietzsch
> *Subject:* RE: CKAN error message****
>
> ** **
>
> Gavin****
>
> ** **
>
> Are you able to answer Birgit's question below?****
>
> ** **
>
> Many thanks****
>
> ** **
>
> Anna ****
>
> ______________________________________________________
> Anna Clements | Head of Research Data and Information Services
>
> University of St Andrews Library | North Street | St Andrews | KY16 9TR|
> T:01334 462761 | @AnnaKClements****
> ------------------------------
>
> *From:* Birgit Plietzsch
> *Sent:* 10 October 2013 17:17
> *To:* gavin.chait at okfn.org
> *Cc:* Anna Clements; Athos Georgiou
> *Subject:* FW: CKAN error message****
>
> Hello Gavin****
>
>  ****
>
> We noticed that unlike with other vanilla installations of CKAN now on our
> test servers we encounter issues visualising data with the installation
> that the OKFN did for us. Athos believes he has tracked down the issue to a
> problem with one of the database tables. Please see his email below. Would
> you be able to shed some light on this, please, so that we end up with a
> CKAN installation as was agreed?****
>
>  ****
>
> Many thanks****
>
> Birgit****
>
>  ****
>
>  ****
>
> --****
>
> Dr Birgit Plietzsch****
>
> Research Computing Team Leader, IT Services****
>
> University of St Andrews, St Andrews, Fife, KY16 9AL****
>
>  ****
>
> T: 01334 462315  |  F: 01334 462759  | E: bp10 at st-andrews.ac.uk  |  W:
> http://www.st-andrews.ac.uk/its****
>
>  ****
>
> Research Computing blog: http://research-computing.wp.st-andrews.ac.uk/ **
> **
>
>  ****
>
> The University of St Andrews is a charity registered in Scotland: No
> SC013532****
>
>  ****
>
> *From:* Athos Georgiou
> *Sent:* 10 October 2013 12:03
> *To:* Birgit Plietzsch
> *Subject:* CKAN error message****
>
>  ****
>
> Hello, ****
>
>  ****
>
> Following a recent installation of CKAN on a  debian box I have
> encountered an error in visualizing the data after an import. ****
>
>  ****
>
> [Mon Oct 07 14:31:20 2013] [error] [client 127.0.0.1] Error - <class
> 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) permission denied
> for relation _table_metadata****
>
>  ****
>
>  ****
>
> I have 2 databases: ckan and ckan_datastore as show below****
>
>  ****
>
>              Name      |        Owner        |              Encoding |
> Collate            |    Ctype             |Access privileges****
>
>
> ----------------+---------------------+----------+-------------+-------------+---------------------------------------------
> ****
>
>             ckan           | ckan                                     |
> UTF8     | en_GB.UTF-8 | en_GB.UTF-8 |
> =Tc/ckan                                   +****
>
>                                  |
>                           |                |
>     |                              | ckan=CTc/ckan****
>
> ckan_datastore | datastore_readwrite   | UTF8     | en_GB.UTF-8 |
> en_GB.UTF-8 | =Tc/datastore_readwrite                    +****
>
>                                  |
>                            |                |
>      |                            |
> datastore_readwrite=CTc/datastore_readwrite+****
>
>                 |                                                |
>        |                             |                            |
> datastore_readonly=c/datastore_readwrite****
>
>  ****
>
> After having observed the apache log file for CKAN the problem seems to be
> in a view named “table_metadata” inside the ckan_datastore Database.****
>
>  ****
>
>  ****
>
> The view description is below.****
>
>  ****
>
> ckan_datastore=> \d+ _table_metadata****
>
>             View "public._table_metadata"****
>
>   Column  | Type | Modifiers | Storage  | Description****
>
> ----------+------+-----------+----------+-------------****
>
> _id      | text |           | extended |****
>
> name     | name |           | plain    |****
>
> oid      | oid  |           | plain    |****
>
> alias_of | name |           | plain    |****
>
> View definition:****
>
> SELECT DISTINCT substr(md5(dependee.relname::text ||
> COALESCE(dependent.relname, ''::name)::text), 0, 17) AS _id,
> dependee.relname AS name, dependee.oid, dependent.relname AS alias_of****
>
>    FROM pg_class dependee****
>
>    LEFT JOIN pg_rewrite r ON r.ev_class = dependee.oid****
>
>    LEFT JOIN pg_depend d ON d.objid = r.oid****
>
>    LEFT JOIN pg_class dependent ON d.refobjid = dependent.oid****
>
>   WHERE (dependee.oid <> dependent.oid OR dependent.oid IS NULL) AND
> ((dependee.relname IN ( SELECT pg_tables.tablename****
>
>    FROM pg_tables)) OR (dependee.relname IN ( SELECT pg_views.viewname****
>
>    FROM pg_views))) AND dependee.relnamespace = (( SELECT pg_namespace.oid
> ****
>
>    FROM pg_namespace****
>
>   WHERE pg_namespace.nspname = 'public'::name))****
>
>   ORDER BY dependee.oid DESC;****
>
>  ****
>
> At this point, every registered member in CKAN has to be able to visualize
> imported data but the owner is ckan_readwrite. Adding permission for all
> users to access ckan_readwrite may solve this issue. I have tried:****
>
>  ****
>
> ALTER DEFAULT PRIVILEGES FOR USER datastore_readwrite IN SCHEMA public
> GRANT SELECT ON TABLES TO datastore_readonly;****
>
>  ****
>
> But have seen no results.****
>
>  ****
>
> I would appreciate any help regarding this issue****
>
>  ****
>
> Thank you****
>
>  ****
>
> *Athos Georgiou*****
>
> *Application Developer - Research Computing *****
>
> [image: Description: Description: Description: Description: Description:
> Description: Description: cid:46E12C47-B748-4BCA-B41C-A94306C93BF6]****
>
> *IT Services, University of St Andrews, St Andrews, Fife, KY16 9AL*****
>
> *Tel: **01334 4644731   E-mail: ag242 at st-andrews.ac.uk*****
>
>  ****
>
> The University of St Andrews is a charity registered in Scotland (No
> SC013532)****
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20131023/78d195af/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 13560 bytes
Desc: not available
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20131023/78d195af/attachment-0003.png>


More information about the ckan-support mailing list