[ckan-dev] Error

Tue Apr 14 19:57:00 UTC 2015

Worked a treat thanks for your help

On 14 Apr 2015, at 16:53, Denis Zgonjanin <deniszgonjanin at gmail.com<mailto:deniszgonjanin at gmail.com>> wrote:

It seems like the user 'ckan_default' in your postgres database does not have the neccessary access privileges. This may fix it:

sudo -u postgres psql

then in the psql prompt, run:

GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ckan_default;

On Mon, Apr 13, 2015 at 4:10 PM, Bryan Humphreys <bryan_humphreys at corkcity.ie<mailto:bryan_humphreys at corkcity.ie>> wrote:
Hi Denis,
Thank you for your email

Tried that and this is the output, but still getting the same error

(default)root at ckan:~# sudo -u postgres createuser -S -D -R -P ckan_default
could not change directory to "/root"
Enter password for new role:
Enter it again:
createuser: creation of new role failed: ERROR:  role "ckan_default" already exi                                                                             sts
(default)root at ckan:~# sudo -u postgres createdb -O ckan_default ckan_default -E                                                                              utf-8
could not change directory to "/root"
createdb: database creation failed: ERROR:  database "ckan_default" already exis                                                                             ts
root at ckan:~# sudo -u postgres psql -l
could not change directory to "/root"
                                        List of databases
       Name        |    Owner     | Encoding |   Collate   |    Ctype    |   Access privileges
-------------------+--------------+----------+-------------+-------------+-----------------------
ckan_default      | ckan_default | UTF8     | en_IE.UTF-8 | en_IE.UTF-8 |
datastore_default | ckan_default | UTF8     | en_IE.UTF-8 | en_IE.UTF-8 |
postgres          | postgres     | UTF8     | en_IE.UTF-8 | en_IE.UTF-8 |
template0         | postgres     | UTF8     | en_IE.UTF-8 | en_IE.UTF-8 | =c/postgres          +
                   |              |          |             |             | postgres=CTc/postgres
template1         | postgres     | UTF8     | en_IE.UTF-8 | en_IE.UTF-8 | =c/postgres          +
                   |              |          |             |             | postgres=CTc/postgres
(5 rows)

From: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org<mailto:ckan-dev-bounces at lists.okfn.org>] On Behalf Of Denis Zgonjanin
Sent: 13 April 2015 15:34

To: CKAN Development Discussions
Subject: Re: [ckan-dev] Error

Thanks Bryan,

It looks like your database is not set up correctly. From your log:

ProgrammingError: (ProgrammingError) permission denied for relation _table_metadata

Try re-doing the steps in http://docs.ckan.org/en/latest/maintaining/installing/install-from-source.html#postgres-setup

On Sun, Apr 12, 2015 at 8:45 AM, Bryan Humphreys <bryan_humphreys at corkcity.ie<mailto:bryan_humphreys at corkcity.ie>> wrote:
Hi Denis,
Apologies for the late response
Attached is the log

Regards and thanks
Bryan

From: ckan-dev [mailto:ckan-dev-bounces at lists.okfn.org<mailto:ckan-dev-bounces at lists.okfn.org>] On Behalf Of Denis Zgonjanin
Sent: 09 April 2015 20:56
To: CKAN Development Discussions
Subject: Re: [ckan-dev] Error

Hi Bryan,

Can you paste what the error is from the logs? The logs should be in /var/log/apache2 or /var/log/nginx, or something along those lines depending on how you installed CKAN. There should be an *.error.log file that will hold some clues.

- Denis

On Thu, Apr 9, 2015 at 11:35 AM, Bryan Humphreys <bryan_humphreys at corkcity.ie<mailto:bryan_humphreys at corkcity.ie>> wrote:
Hi
I’m new to this so apologies if this has been asked before

I have created a new site http://data.corkcity.ie
I have try to create a new data set and add the following http://opendata.corkcity.ie/RiverLevel.csv but after I select finish I receive an internal server error

Regards
Bryan

Bryan Humphreys
Network Analyst
IS Operations
ICT and Business Services, Cork City Council
Tel: +353-(0)21-4924480<tel:%2B353-%280%2921-4924480>, Fax: +353-(0)21-4924007<tel:%2B353-%280%2921-4924007>
email: bryan_humphreys at corkcity.ie<mailto:bryan_humphreys at corkcity.ie>
Website: http://www.corkcity.ie

_______________________________________________________________________
Please consider the Environment before printing this email.
Smaoinigh ar an timpeallacht sula ndeanann tú an ríomhphost seo a phriontáil amach

Tá an post leictreonach seo, maraon le haon iatáin ceangailte leis, príobháideach agus faoi rún agus tá úsáid an ábhair úd ceadaithe dóibh siúd amháin ar a raibh an t-ábhar dírithe ó thús. D'fhéadfadh ábhar lena mbaineann úinéireacht, eolas atá faoi rún nó príbhléidí dlíthiúla bheith sa teachtaireacht seo. Níor chóir d'aon dream eile cóipeáil, tagairt do, stóráil ná úsáid a bhaint as an ábhar seo. Munar tusa an té lena mbaineann sé, ba chóir duit an r-phost seo a scriosadh ó do ríomhaire agus aon iatán a tháinig leis maraon le cóipeanna eile a bheadh déanta agat, agus cuir in iúl don té a sheol chugat í gan mhoill. Gabhaimid ár mbuíochas leat.
The information contained in this e-mail and in any attachments is confidential and is designated solely for the attention and use of the intended recipient(s). This information may be subject to legal professional privilege.  If you are not an intended recipient of this e-mail or any part of it, you should not use, disclose, copy, distribute or retain this message.  If you have received this e-mail in error, please notify the sender immediately and delete all copies of this e-mail from your computer system(s)

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150414/9244a459/attachment-0003.html>