[CKAN-support] URGENT: FW: CKAN setup/info
Sean Hammond
sean.hammond at okfn.org
Tue Aug 27 09:13:46 UTC 2013
Error - <class 'sqlalchemy.exc.ProgrammingError'>:
(ProgrammingError) permission denied for schema a public
This looks like your postgres datastore database user doesn't have the
right postgres permissions. Looking at the database permissions you sent
us and comparing it to my own setup, I see a few things wrong:
- Your ckan_default database is owned by user postgres, should be owned
by user ckan_default
- Your datastore_default database is owned by user postgres, should be owned
by user ckan_default
- I have en_US.UTF-8 in the collate and ctype columns for all databases,
you have C, not sure if this is important
- Your access privileges column is also different to mine
The first two points (database ownerships) are probably what's causing
your error. Do you have data in these ckan_default and datastore_default
databases yet? If not, I recommend deleting them and following the CKAN
docs to set them up again. If you can't delete them then you can try
changing the owners with a couple of commands in the psql shell, like:
ALTER DATABASE ckan_default OWNER TO ckan_default;
ALTER DATABASE datastore_default OWNER TO ckan_default;
On Sun, Aug 25, 2013 at 10:51:37PM +0000, Aaron McGlinchy wrote:
> Hi,
> Regards the preview question, specifically we were testing a CSV file.
>
> Checking it appears to preview a txt file OK. Pdf files it does not preview, but that is because “no handler defined for data type pdf”. It does preview a jpg image as well.
> When we click to preview a CSV file it starts to attempt the preview and then returns error:
>
> [cid:image002.jpg at 01CEA24A.3B6EA670]
>
> After searching the help forum we found this problem which sounded similar to ours (http://lists.okfn.org/pipermail/ckan-dev/2013-June/005177.html ) so we setup the datastore as per http://docs.ckan.org/dv/latest/datastore.html#datastorer. We still could not preview the CSV file, and the error log from the Datastore is attached.
>
> Domink gave us a suggestion via the listserver (email attached), but then indicated it might be an issue that was solved when we update to v2.1. We’ve installed the update and problem persists, so it could be the permissions – we have not changed them yet.
>
> The database persmissions are:
>
> postgres-# \l
> List of databases
> Name | Owner | Encoding | Collate | Ctype | Access privileges
> -------------------+----------+-----------+---------+-------+------------------------------
> ckan_default | postgres | UTF8 | C | C | =T/postgres +
> | | | | | postgres=CTc/postgres +
> | | | | | ckan_default=CTc/postgres
> datastore_default | postgres | UTF8 | C | C | =T/postgres +
> | | | | | postgres=CTc/postgres +
> | | | | | ckan_default=CTc/postgres +
> | | | | | datastore_default=c/postgres
> postgres | postgres | SQL_ASCII | C | C |
> template0 | postgres | SQL_ASCII | C | C | =c/postgres +
> | | | | | postgres=CTc/postgres
> template1 | postgres | SQL_ASCII | C | C | =c/postgres +
> | | | | | postgres=CTc/postgres
>
> For DB: ckan_default db
> postgres: CREATE | TEMPORARY | CONNECT
> ckan_default: CREATE | TEMPORARY | CONNECT
>
> For DB: postgres
> postgres: CREATE | TEMPORARY | CONNECT
> ckan_default: CREATE | TEMPORARY | CONNECT
> datastore_default: CONNECT
>
> Michael was wondering what are the necessary permissions for ckan_default & datastore_default? Looking at /usr/lib/ckan/default/src/ckan/ckanext/datastore/bin/set_permissions.sql, it looks like ckan_default needs to have SELECT not just CONNECT?
>
> Thanks
> Aaron
>
> From: Gavin Chait [mailto:gavin.chait at okfn.org]
> Sent: Friday, 23 August 2013 7:17 p.m.
> To: Aaron McGlinchy
> Cc: Michael Speth
> Subject: RE: URGENT: FW: CKAN setup/info
>
> Hi Aaron,
>
> For the data preview, it would be good to know the specific problem. Is it not working at all or is it certain data types don’t preview? A screenshot can sometimes be of use here, depending on the problem.
>
> For the second, we are in the process of writing up our theme documentation (i.e. improving it to the point it becomes much easier to understand) and there are a few people who could help with this query. I’ll pass it on to them and get back to you.
>
> As far as process, please email support at ckan.org<mailto:support at ckan.org> and we’ll make sure we get back to you with answers. The more detail the better on queries
>
> I’ll get back to you as soon as I can.
>
> 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: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz]
> Sent: 23 August 2013 03:42
> To: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>
> Cc: Michael Speth
> Subject: RE: URGENT: FW: CKAN setup/info
>
> Hi Gavin,
> We have a first few things that we would like your help with under our support plan.
>
>
> a) We have encountered trouble getting the data preview function to work, and
>
> b) We were trying to change the background image using the theming and changes to the CSS/LESS, but had trouble. We’ve found out how to do simple changes like that in the Config options CSS, but for future reference it would be good to get up to speed on how to start more advanced theming (we don’t actually have a desired theme we want to apply, so this would be learning which we could apply when we do. Perhaps teaching us how to change the background via the CSS/LESS could be a training example?).
>
> My initial thought is that rather than you guys just fixing things, we try and upskill ourselves in the process – so maybe you assessing the problem and then talking us through fixing?
>
> I’ve cc in Michael Speth who is the technical person who is setting up CKAN for us, and who you would need to liaise with.
>
> So, when would you be able to assist us with this, how long do you think it should take, how would you like to work it…
>
> Thanks
> Aaron
>
> From: Gavin Chait [mailto:gavin.chait at okfn.org]
> Sent: Tuesday, 16 July 2013 7:59 p.m.
> To: Aaron McGlinchy
> Subject: RE: URGENT: FW: CKAN setup/info
>
> Hi,
>
> Just to let you know that we’ve just changed our sprint process to a two-week cycle to shorten the lead times on committing time for clients. Our latest sprint kicked off today and we would need to have any required support time agreed by the Thursday before the kick-off of the next sprint.
>
> Thanks and 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: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz]
> Sent: 04 July 2013 23:14
> To: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>
> Subject: RE: URGENT: FW: CKAN setup/info
>
> Hi Gavin,
> we'll have a bit of a play with CKAN which we have now got up and running here, and work out what our needs and priorities are, and what we will need help with.
>
> I'm sure there will be a few simple things for a start, but for the moment I don't have any specific issues. Some things we identify will likely be learnig about stuff CkAN already does (e.g. doing some theming), whilst others may be more specific issues e.g. integrating the CKAN login with our network login, and others might be issues that would need to be addressed as part of a wider interest group (i.e. things we as a research organisation would like, but perhaps alone cannot fully cover the time and effort required to solve so would look to draw in wider input of ideas/requirements/resources to address for the wider community benefit).
>
> Once I have some firmer ideas I'll get in touch.
>
> Cheers
> Aaron
> ________________________________
> From: Gavin Chait [gavin.chait at okfn.org]
> Sent: Monday, 1 July 2013 7:32 p.m.
> To: Aaron McGlinchy
> Subject: RE: URGENT: FW: CKAN setup/info
> Hi Aaron,
>
> It would be good to start discussing any support requirements you have so that we can schedule the time into our sprint process.
>
> Thanks and 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: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz]
> Sent: 20 June 2013 23:03
> To: Michelle Heydon
> Cc: Gavin Chait; Open Knowledge Foundation Accounts
> Subject: RE: URGENT: FW: CKAN setup/info
>
> Excellent, thanks.
>
> From: Michelle Heydon [mailto:michelle.heydon at okfn.org]
> Sent: Friday, 21 June 2013 10:02 a.m.
> To: Aaron McGlinchy
> Cc: Gavin Chait; Open Knowledge Foundation Accounts
> Subject: Re: URGENT: FW: CKAN setup/info
>
> Dear Aaron,
>
> Happy to oblige! Please find attached our invoice, as requested.
>
> We do not have a New Zealand dollar bank account, so if you could make payment to the GBP account, that would be most appreciated.
>
> Regards,
>
> Michelle
> Michelle Heydon
> Head of Operations | skype: Michelle.Heydon | +44 (0)7773 427303
> The Open Knowledge Foundation<http://okfn.org/>
> Empowering through Open Knowledge
> http://www.okfn.org | @okfn<https://twitter.com/OKFN> | OKF on Facebook<http://www.facebook.com/OKFNetwork> | Blog<http://blog.okfn.org/> | Newsletter<http://okfn.org/?s=Newsletter>
>
> ________________________________
> From: Aaron McGlinchy<mailto:McGlinchyA at landcareresearch.co.nz>
> Sent: 20/06/2013 03:06
> To: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>
> Subject: RE: CKAN setup/info
> Hi Gavin
> I have been able to confirm $15,000 from my budget to buy a support block.
>
> I want to pay it from this year’s budget (our financial year ends June 30). For this to be Ok would you be able to invoice me for NZ$15,000 for “Setup and configuration support for CKAN data repository” and separately we can sort out any documentation for the service to be provided and the dates concerned?
>
> I would need the invoice ASAP so I can pay before June 30th.
>
> Many thanks
>
> Aaron McGlinchy
> Research Data Manager
> Manaaki Whenua - Landcare Research
> PO Box 69040, Lincoln 7640
> Canterbury
> NEW ZEALAND
> www.landcareresearch.co.nz<http://www.landcareresearch.co.nz/>
>
> Ph 03 321 9999
> Fax 03 321 9732
>
> From: Gavin Chait [mailto:gavin.chait at okfn.org]
> Sent: Wednesday, 22 May 2013 8:50 p.m.
> To: Aaron McGlinchy
> Subject: RE: CKAN setup/info
>
> Hi Aaron,
>
> I attach a quote for the base set-up of a demo site on your server. Assuming that Ubuntu is installed and we can SSH into a virtual machine, or similar, then this is a fairly rapid turn-around. We usually prefer our artwork provided in vector format, but – for the purposes of the demo – it can be a PNG file.
>
> We can also offer batches of support days (at 10 days per batch) for NZ$15,000 per 10 day block. These can be drawn down for support, customisation, training and such-like.
>
> I look forward to supporting your open data initiative and hope to hear from you soon.
>
> Kind regards
>
> Gavin
>
> ________________________________
> Gavin Chait | Head of Services | Open Knowledge Foundation
> gavin.chait at okfn.org<mailto:gavin.chait at okfn.org> | M: +44 (0) 78 9495 7090 | http://okfn.org/
>
> From: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz]
> Sent: 22 May 2013 01:18
> To: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>
> Subject: RE: CKAN setup/info
>
> Hi Gavin,
> I believe it will be a Ubuntu 12.04 install. Redesign would be absolutely minor – a simple logo which I can send you (what specs suit?). Once we have it up and running I’d look at any further theming myself in time.
> Cheers
> Aaron
>
> From: Gavin Chait [mailto:gavin.chait at okfn.org]
> Sent: Monday, 20 May 2013 9:55 p.m.
> To: Aaron McGlinchy; 'Darwin Peltan'
> Cc: 'Mark Wainwright'; info at ckan.org<mailto:info at ckan.org>
> Subject: RE: CKAN setup/info
>
> Hi Aaron,
>
> We would be pleased to offer a quote to deploy CKAN for you. We are currently mid-way through our three-week sprint and the next kicks off 3 June. We would begin implementation then.
>
> I would also appreciate it if you could confirm the server stack for us. We normally deploy on Ubuntu 12.04 but can install on alternative setups (although it takes slightly longer). Plus, as far as redesign is concerned, is this fairly minor (e.g. could you provide us with the artwork you would require?). I can then review and present you with a formal quote.
>
> Thanks and regards
>
> Gavin
>
>
> ________________________________
> Gavin Chait | Head of Services | Open Knowledge Foundation
> gavin.chait at okfn.org<mailto:gavin.chait at okfn.org> | M: +44 (0) 78 9495 7090 | http://okfn.org/
>
> From: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz]
> Sent: 20 May 2013 05:20
> To: Darwin Peltan
> Cc: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>; Mark Wainwright; info at ckan.org<mailto:info at ckan.org>
> Subject: RE: CKAN setup/info
>
> Hi Darwin/Gavin/Mark,
> I’ve had further discussions with our IT guys, and now looks like we will get you do to the installation. They (IT) are having a meeting next week at which they’ll confirm who is our best person to act as a technical liaison with you – I’ll put you in touch once I know.
>
> So if you can pencil some time in your diary to fit the work in that would be good.
>
> Meantime, if there are any questions you’d like us to answer let me know and we may be able to keep things moving along ahead of them identifying a specific person.
>
> Regards
> Aarib
>
>
> From: Darwin Peltan [mailto:darwin.peltan at okfn.org]
> Sent: Thursday, 16 May 2013 8:18 p.m.
> To: Aaron McGlinchy
> Cc: gavin.chait at okfn.org<mailto:gavin.chait at okfn.org>; Mark Wainwright; info at ckan.org<mailto:info at ckan.org>; Nick Spencer; Robert Gibb; Greg Jones
> Subject: Re: CKAN setup/info
>
> Hi Aaron,
>
> [The entire original message is not included.]
>
>
> ________________________________
>
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
>
> ________________________________
>
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
>
> ________________________________
>
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
>
> ________________________________
>
> Please consider the environment before printing this email
> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> The views expressed in this email may not be those of Landcare Research New Zealand Limited. http://www.landcareresearch.co.nz
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] Error - <class 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) permission denied for schem
> a public
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] 'CREATE TYPE "nested" AS (json text, extra text)' {}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] URL: http://ckan.zen.landcareresearch.co.nz/api/3/action/datastore_search?resource_id=_table_meta
> data
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/errormiddleware.py', line 162 in
> __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] app_iter = self.application(environ, sr_checker)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] resp = self.call_func(req, *args, **self.kwargs)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return self.func(req, *args, **kwargs)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/publisher.py', line 234 in __ca
> ll__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return request.get_response(self.app)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_respo
> nse
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] application, catch_exc_info=False)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_appl
> ication
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] app_iter = application(self.environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 147 in __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] resp = self.call_func(req, *args, **self.kwargs)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/dec.py', line 208 in call_func
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return self.func(req, *args, **kwargs)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/fanstatic/injector.py', line 54 in __call
> __
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] response = request.get_response(self.app)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1053 in get_respo
> nse
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] application, catch_exc_info=False)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/webob/request.py', line 1022 in call_appl
> ication
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] app_iter = application(self.environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/beaker/middleware.py', line 73 in __call_
> _
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return self.app(environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/routes/middleware.py', line 131[117/1245]
> __
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] response = self.app(environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 125 in __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] response = self.dispatch(controller, environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/wsgiapp.py', line 324 in dispatch
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return controller(environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckan/controllers/api.py', line 70 in __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return base.BaseController.__call__(self, environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckan/lib/base.py', line 289 in __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] res = WSGIController.__call__(self, environ, start_response)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 221 in
> __call__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] response = self._dispatch_call()
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 172 in
> _dispatch_call
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] response = self._inspect_call(func)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 107 in
> _inspect_call
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] result = self._perform_call(func, args)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/pylons/controllers/core.py', line 60 in _
> perform_call
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return func(**args)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckan/controllers/api.py', line 184 in action
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] result = function(context, request_data)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckan/logic/__init__.py', line 324 in wrapped
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return _action(context, data_dict, **kw)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckan/logic/__init__.py', line 380 in wrapper
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return action(context, data_dict)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckanext/datastore/logic/action.py', line 241 in datastore_se
> arch
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] result = db.search(context, data_dict)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckanext/datastore/db.py', line 1074 in search
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] _cache_types(context)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/src/ckan/ckanext/datastore/db.py', line 140 in _cache_types
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] .format('json' if native_json else 'text'))
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1449 in
> execute
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] params)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line[78/1245]
> _execute_text
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] statement, parameters
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1698 in
> _execute_context
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] context)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/base.py', line 1691 in
> _execute_context
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] context)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File '/usr/lib/ckan/default/lib/python2.7/site-packages/sqlalchemy/engine/default.py', line 331 i
> n do_execute
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] cursor.execute(statement, parameters)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] ProgrammingError: (ProgrammingError) permission denied for schema public
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] 'CREATE TYPE "nested" AS (json text, extra text)' {}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] CGI Variables
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] -------------
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] CKAN_CURRENT_URL: '/api/3/action/datastore_search?resource_id=_table_metadata'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] CKAN_LANG: 'en'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] CKAN_LANG_IS_DEFAULT: True
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] CONTENT_TYPE: '; charset=utf-8'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] DOCUMENT_ROOT: '/etc/apache2/htdocs'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] GATEWAY_INTERFACE: 'CGI/1.1'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] HTTP_ACCEPT: '*/*'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] HTTP_CONNECTION: 'close'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] HTTP_HOST: 'ckan.zen.landcareresearch.co.nz'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] HTTP_USER_AGENT: 'curl/7.22.0 (x86_64-pc-linux-gnu) libcurl/7.22.0 OpenSSL/1.0.1 zlib/1.2.3.4 l
> ibidn/1.23 librtmp/2.3'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] PATH_INFO: '/api/3/action/datastore_search'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] PATH_TRANSLATED: '/etc/ckan/default/apache.wsgi/api/3/action/datastore_search'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] QUERY_STRING: 'resource_id=_table_metadata'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] REMOTE_ADDR: '127.0.0.1'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] REMOTE_PORT: '50699'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] REQUEST_METHOD: 'GET'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] REQUEST_URI: '/api/3/action/datastore_search?resource_id=_table_metadata'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SCRIPT_FILENAME: '/etc/ckan/default/apache.wsgi'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_ADDR: '127.0.0.1'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_ADMIN: '[no address given]'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_NAME: 'ckan.zen.landcareresearch.co.nz'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_PORT: '80' [38/1245]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_PROTOCOL: 'HTTP/1.0'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_SIGNATURE: '<address>Apache/2.2.22 (Ubuntu) Server at ckan.zen.landcareresearch.co.nz Po
> rt 80</address>\\n'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] SERVER_SOFTWARE: 'Apache/2.2.22 (Ubuntu)'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] WSGI Variables
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] --------------
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] application: <fanstatic.publisher.Delegator object at 0x7f9deeccdc50>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] beaker.cache: <beaker.cache.CacheManager object at 0x7f9deeccd390>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] beaker.get_session: <bound method SessionMiddleware._get_session of <beaker.middleware.SessionM
> iddleware object at 0x7f9deeccdd90>>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] beaker.session: {'_accessed_time': 1375324873.17686, '_creation_time': 1375324873.17686}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] fanstatic.needed: <fanstatic.core.NeededResources object at 0x7f9def048c90>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.application_group: 'default.ckanhosted.com|'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.callable_object: 'application'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.handler_script: ''
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.input_chunked: '0'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.listener_host: ''
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.listener_port: '8080'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.process_group: 'ckan_default'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.request_handler: 'wsgi-script'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.script_reloading: '1'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] mod_wsgi.version: (3, 3)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] paste.cookies: (<SimpleCookie: >, '')
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] paste.parsed_dict_querystring: (MultiDict([('resource_id', '_table_metadata')]), 'resource_id=_
> table_metadata')
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] paste.parsed_querystring: ([('resource_id', '_table_metadata')], 'resource_id=_table_metadata')
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] paste.registry: <paste.registry.Registry object at 0x7f9def048a90>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] paste.throw_errors: True
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.action_method: <bound method ApiController.action of <ckan.controllers.api.ApiController
> object at 0x7f9def053650>>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.controller: <ckan.controllers.api.ApiController object at 0x7f9def053650>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.environ_config: {'session': 'beaker.session', 'cache': 'beaker.cache'}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.pylons: <pylons.util.PylonsContext object at 0x7f9def053590>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.routes_dict: {'action': u'action', 'controller': u'api', 'ver': 3, 'logic_function': u'd
> atastore_search'}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] pylons.status_code_redirect: True
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] repoze.who.logger: <logging.Logger object at 0x7f9deeccd050>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] repoze.who.plugins: {'openid': <OpenIdIdentificationPlugin 140316292995024>, 'friendlyform': <F
> riendlyFormPlugin 140316292968592>, 'ckan.lib.authenticator:UsernamePasswordAuthenticator': <ckan.lib.authenticator.UsernamePasswordAuthenticator objec
> t at 0x7f9def031150>, 'auth_tkt': <AuthTktCookiePlugin 140316292970000>, 'ckan.lib.authenticator:OpenIDAuthenticator': <ckan.lib.authenticator.OpenIDAu
> thenticator object at 0x7f9def0310d0>}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] routes.route: <routes.route.Route object at 0x7f9deeaafe90>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] routes.url: <routes.util.URLGenerator object at 0x7f9def053450>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] webob._parsed_query_vars: (GET([('resource_id', '_table_metadata')]), 'resource_id=_table_metad
> ata')
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] webob.adhoc_attrs: {'response': <Response at 0x7f9def048d90 200 OK>, 'language': 'en-us'}
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] wsgi process: 'Multi process AND threads (?)'
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f9def04f828>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] wsgi.version: (1, 1)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7f9def053450>, {'action': u'action
> ', 'controller': u'api', 'ver': 3, 'logic_function': u'datastore_search'})
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] ------------------------------------------------------------
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] <p>Additionally an error occurred while sending the <weberror.reporter.EmailReport
> er object at 0x7f9def142610> report:
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1]
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] <pre>Traceback (most recent call last):
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/errormiddleware.py", line 450,
> in send_report
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] rep.report(exc_data)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/ckan/default/lib/python2.7/site-packages/weberror/reporter.py", line 45, in repo
> rt
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] server = smtplib.SMTP(self.smtp_server)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/python2.7/smtplib.py", line 249, in __init__
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] (code, msg) = self.connect(host, port)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/python2.7/smtplib.py", line 309, in connect
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] self.sock = self._get_socket(host, port, self.timeout)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/python2.7/smtplib.py", line 284, in _get_socket
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] return socket.create_connection((port, host), timeout)
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] File "/usr/lib/python2.7/socket.py", line 571, in create_connection
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] raise err
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] error: [Errno 111] Connection refused
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] </pre>
> [Thu Aug 01 14:41:13 2013] [error] [client 127.0.0.1] </p>
>
> Date: Tue, 6 Aug 2013 10:56:07 +0000
> From: "ckan-dev-request at lists.okfn.org" <ckan-dev-request at lists.okfn.org>
> To: "ckan-dev at lists.okfn.org" <ckan-dev at lists.okfn.org>
> Subject: ckan-dev Digest, Vol 34, Issue 9 Datastore and CSV Preview
> Sender: "ckan-dev-bounces at lists.okfn.org" <ckan-dev-bounces at lists.okfn.org>
>
> Send ckan-dev mailing list submissions to
> ckan-dev at lists.okfn.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> or, via email, send a message with subject or body 'help' to
> ckan-dev-request at lists.okfn.org
>
> You can reach the person managing the list at
> ckan-dev-owner at lists.okfn.org
>
> When replying, please edit your Subject line so it is more specific than "Re: Contents of ckan-dev digest..."
>
>
> Today's Topics:
>
> 2. Re: Datastore and preview of CSV file (Dominik Moritz)
> 3. Re: (no subject) (Isabel Ruiz)
> 4. Undelete a dataset (Isabel Ruiz)
> 5. Re: Undelete a dataset (Stefan Oderbolz)
> 6. Re: Undelete a dataset (Isabel Ruiz)
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 6 Aug 2013 11:37:51 +0200
> From: Dominik Moritz <dominik.moritz at okfn.org>
> Subject: Re: [ckan-dev] Datastore and preview of CSV file
> To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
> Message-ID: <FD01DA29-FFD3-4620-8CE7-1A1551984A6D at okfn.org>
> Content-Type: text/plain; charset="us-ascii"
>
> Hey Aaron,
>
> We just noticed there is a but that has been fixed in 2.1 but not in 2.0 which causes the problem with the datastore that you reported. You can either wait for CKAN 2.0.2 which will include the fix [1] or just connect to your database with psql and execute: "CREATE TYPE "nested" AS (json text, extra text)" (on pg 9.1 and below) or "CREATE TYPE "nested" AS (json json, extra text)" (pg 9.2 and higher).
>
> I'm sorry about the inconveniences,
> Dominik
>
> [1] https://github.com/okfn/ckan/pull/1160
>
>
> On 6 Aug 2013, at 00:03, Dominik Moritz <dominik.moritz at okfn.org> wrote:
>
> > Hey Aaron,
> >
> > The log says that there is a problem with the permissions (permission denied for schema public). During set-up, you created two users for the datastore. One with only read permissions and one with write permissions. The second user seems to have the wrong permissions. Could you rerun the step that sets the permissions? If that doesn't help, try one of the other options. You can try the permissions by connecting directly to the database using psql and the read-write user. You should be able to create tables and types with that user.
> >
> > If that doesn't help either, please tell me a little bit more about your set-up.
> >
> > Having said this, the error from you email is not related to the datastore. The problem here (DNS lookup failed for URL) is that the resource you are trying to preview is in a location that cannot be reached from the internet. As long as your resource is not in the datastore, the file needs to be accessible from the web to be previewable.
> >
> > Best wishes,
> > Dominik
> >
> >
> > On 5 Aug 2013, at 23:40, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz> wrote:
> >
> >> Hi, we have setup the datastore and configured the database as per
> >> http://docs.ckan.org/dv/latest/datastore.html
> >>
> >> However when we go to preview the file we get an error:
> >>
> >> "This resource can not be previewed at the moment.
> >> Could not load preview: DataProxy returned an error (Data transformation failed. error: An error occured while connecting to the server: DNS lookup failed for URL: http://ckan.zen.landcareresearch.co.nz/storage/f/2013-08-01T02%3A56%3A29.990Z/track2.csv)"
> >>
> >> The datastore error log generated is attached (too long to include in message). Any help appreciated.
> >>
> >> Thanks
> >> Aaron
> >>
> >> ________________________________
> >>
> >> Please consider the environment before printing this email
> >> Warning: This electronic message together with any attachments is confidential. If you receive it in error: (i) you must not read, use, disclose, copy or retain it; (ii) please contact the sender immediately by reply email and then delete the emails.
> >> The views expressed in this email may not be those of Landcare
> >> Research New Zealand Limited. http://www.landcareresearch.co.nz
> >> <ckan_datastore_error.txt>___________________________________________
> >> ____
> >> ckan-dev mailing list
> >> ckan-dev at lists.okfn.org
> >> http://lists.okfn.org/mailman/listinfo/ckan-dev
> >> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
> >
> > Dominik Moritz
> > CKAN developer | skype: d.moritz | @doobly_doo The Open Knowledge
> > Foundation Empowering through Open Knowledge http://okfn.org/ |
> > @okfn | http://ckan.org | @CKANproject
> >
>
> Dominik Moritz
> CKAN developer | skype: d.moritz | @doobly_doo The Open Knowledge Foundation Empowering through Open Knowledge http://okfn.org/ | @okfn | http://ckan.org | @CKANproject
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: signature.asc
> Type: application/pgp-signature
> Size: 495 bytes
> Desc: Message signed with OpenPGP using GPGMail
> URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/b95f2939/attachment-0001.pgp>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 6 Aug 2013 11:54:03 +0200
> From: Isabel Ruiz <isaruizmellado at gmail.com>
> Subject: Re: [ckan-dev] (no subject)
> To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
> Message-ID:
> <CAP6nqLJ65VnZGr0iSDryk0GiuLfmmYCXyhdShZXGsGh2AvFEWQ at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Ignore this please, I have not write a subject
>
> Sorry.
>
>
> On Tue, Aug 6, 2013 at 11:14 AM, Isabel Ruiz <isaruizmellado at gmail.com>wrote:
>
> > Hi!
> >
> > I have ckan 2.0.1
> >
> > I have deleted a dataset, if I edit it, it shows state = deleted
> >
> > How can I recover it? I mean, how can I public it?
> >
> > Thanks
> >
> > --
> > Isabel M. Ruiz Mellado
> > http://about.me/isabelruiz
> >
> > _______________________________________________
> > ckan-dev mailing list
> > ckan-dev at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/ckan-dev
> > Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
> >
> >
>
>
> --
> Isabel M. Ruiz Mellado
> http://about.me/isabelruiz
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/77af1e54/attachment-0001.htm>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 6 Aug 2013 11:54:27 +0200
> From: Isabel Ruiz <isaruizmellado at gmail.com>
> Subject: [ckan-dev] Undelete a dataset
> To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
> Message-ID:
> <CAP6nqL+tFLNwssQ4Q1b0SFVYCTgEJzA5K=GbSxYx3bjkxBJUvA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi!
>
> I have ckan 2.0.1
>
> I have deleted a dataset, if I edit it, it shows state = deleted
>
> How can I recover it? I mean, how can I public it?
>
> Thanks
>
> --
> Isabel M. Ruiz Mellado
> http://about.me/isabelruiz
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/51e99432/attachment-0001.htm>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 6 Aug 2013 12:09:41 +0200
> From: Stefan Oderbolz <stefan.oderbolz at liip.ch>
> Subject: Re: [ckan-dev] Undelete a dataset
> To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
> Message-ID:
> <CAARrFXea5KJGKBWiuUZ+wLG4WBQb9BZ=eZCKiYAgFRL6ZTyTdg at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I think this is still a missing feature (see https://github.com/okfn/ckan/issues/868). If I'm not wrong you can only "undelete" it if you change the value directly in the database (see tables package and package_revision). Currently there is not even a possibility to do this the command line.
>
> Maybe you can try to purge the dataset completly and then re-insert
> (import?) it.
>
> Regards Stefan
>
>
> On Tue, Aug 6, 2013 at 11:54 AM, Isabel Ruiz <isaruizmellado at gmail.com>wrote:
>
> > Hi!
> >
> > I have ckan 2.0.1
> >
> > I have deleted a dataset, if I edit it, it shows state = deleted
> >
> > How can I recover it? I mean, how can I public it?
> >
> > Thanks
> >
> > --
> > Isabel M. Ruiz Mellado
> > http://about.me/isabelruiz
> >
> > _______________________________________________
> > ckan-dev mailing list
> > ckan-dev at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/ckan-dev
> > Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
> >
> >
>
>
> --
> Liip AG // Feldstrasse 133 // CH-8004 Zurich Tel +41 43 500 39 80 // GnuPG 0x7B588C67 // www.liip.ch
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/1df3341f/attachment-0001.htm>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 6 Aug 2013 12:55:41 +0200
> From: Isabel Ruiz <isaruizmellado at gmail.com>
> Subject: Re: [ckan-dev] Undelete a dataset
> To: CKAN Development Discussions <ckan-dev at lists.okfn.org>
> Message-ID:
> <CAP6nqLJ5aQwpFr+bZSjtzq-TmmydGAKCe4KedSTUgbG6uk4tQA at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Thanks Stefan,
>
> I have changed state=active in package and package_revision tables.
>
> And I cannot see the datasets I have deleted.
>
> Do I have to reindex solr? (if I have to... what is the command to reindex?)
>
>
>
>
>
>
> On Tue, Aug 6, 2013 at 12:09 PM, Stefan Oderbolz <stefan.oderbolz at liip.ch>wrote:
>
> > I think this is still a missing feature (see
> > https://github.com/okfn/ckan/issues/868). If I'm not wrong you can
> > only "undelete" it if you change the value directly in the database
> > (see tables package and package_revision). Currently there is not even
> > a possibility to do this the command line.
> >
> > Maybe you can try to purge the dataset completly and then re-insert
> > (import?) it.
> >
> > Regards Stefan
> >
> >
> > On Tue, Aug 6, 2013 at 11:54 AM, Isabel Ruiz <isaruizmellado at gmail.com>wrote:
> >
> >> Hi!
> >>
> >> I have ckan 2.0.1
> >>
> >> I have deleted a dataset, if I edit it, it shows state = deleted
> >>
> >> How can I recover it? I mean, how can I public it?
> >>
> >> Thanks
> >>
> >> --
> >> Isabel M. Ruiz Mellado
> >> http://about.me/isabelruiz
> >>
> >> _______________________________________________
> >> ckan-dev mailing list
> >> ckan-dev at lists.okfn.org
> >> http://lists.okfn.org/mailman/listinfo/ckan-dev
> >> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
> >>
> >>
> >
> >
> > --
> > Liip AG // Feldstrasse 133 // CH-8004 Zurich Tel +41 43 500 39 80
> > // GnuPG 0x7B588C67 // www.liip.ch
> >
> > _______________________________________________
> > ckan-dev mailing list
> > ckan-dev at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/ckan-dev
> > Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
> >
> >
>
>
> --
> Isabel M. Ruiz Mellado
> http://about.me/isabelruiz
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130806/b635f50b/attachment.htm>
>
> ------------------------------
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/optionss/ckan-dev
>
>
> End of ckan-dev Digest, Vol 34, Issue 9
> ***************************************
> _______________________________________________
> CKAN-support mailing list
> CKAN-support at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-support
More information about the ckan-support
mailing list