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

Wed Oct 23 15:15:23 UTC 2013

Was that by us or by them? Checking.

By the by, this is a serious effort by St Andrews to see if CKAN can be used
for RDM, so worth us supporting them.

G

  _____  

Gavin Chait

Head of Services | skype: whythawk | M:  +44 (0) 78 9495 7090 |
<https://twitter.com/GavinChait> @GavinChait

The
<http://www.google.com/url?q=http%3A%2F%2Fokfn.org%2F&sa=D&sntz=1&usg=AFQjCN
G2PcKjUT2LrlbSh4JGbu1dt-bNyg> Open Knowledge Foundation

Empowering through Open Knowledge

 <http://okfn.org/> http://okfn.org/ |  <http://twitter.com/OKFN> @okfn |
<https://www.facebook.com/OKFNetwork> OKF on Facebook |
<http://blog.okfn.org/> Blog | <http://okfn.org/about/newsletter>
Newsletter

From: David Raznick [mailto:david.raznick at okfn.org] 
Sent: 23 October 2013 15:52
To: Gavin Chait
Cc: support at ckan.org; Nigel Babu
Subject: Re: FW: [URGENT] CKAN error message

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
<tel:%2B44%C2%A0%280%29%C2%A078%C2%A09495%C2%A07090>  (0) 78 9495 7090 |
<https://twitter.com/GavinChait> @GavinChait

The
<http://www.google.com/url?q=http%3A%2F%2Fokfn.org%2F&sa=D&sntz=1&usg=AFQjCN
G2PcKjUT2LrlbSh4JGbu1dt-bNyg> Open Knowledge Foundation

Empowering through Open Knowledge

 <http://okfn.org/> http://okfn.org/ |  <http://twitter.com/OKFN> @okfn |
<https://www.facebook.com/OKFNetwork> OKF on Facebook |
<http://blog.okfn.org/> Blog | <http://okfn.org/about/newsletter>
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> 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] 
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
<tel:%2B44%C2%A0%280%29%C2%A078%C2%A09495%C2%A07090>  (0) 78 9495 7090 |
<https://twitter.com/GavinChait> @GavinChait

The
<http://www.google.com/url?q=http%3A%2F%2Fokfn.org%2F&sa=D&sntz=1&usg=AFQjCN
G2PcKjUT2LrlbSh4JGbu1dt-bNyg> Open Knowledge Foundation

Empowering through Open Knowledge

 <http://okfn.org/> http://okfn.org/ |  <http://twitter.com/OKFN> @okfn |
<https://www.facebook.com/OKFNetwork> OKF on Facebook |
<http://blog.okfn.org/> Blog | <http://okfn.org/about/newsletter>
Newsletter

From: Anna Clements [mailto: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> 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 

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:  <mailto:ag242 at st-andrews.ac.uk>
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/f2bad63a/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/f2bad63a/attachment-0003.png>