[CKAN-support] FW: [URGENT] CKAN error message
Gavin Chait
gavin.chait at okfn.org
Wed Oct 23 14:04:55 UTC 2013
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 |
<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 (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/6dbde7a8/attachment.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/6dbde7a8/attachment-0002.png>
More information about the ckan-support
mailing list