[CKAN-support] URGENT: FW: CKAN setup/info

Aaron McGlinchy McGlinchyA at landcareresearch.co.nz
Sun Aug 25 22:51:37 UTC 2013


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130825/8e0b3c4b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 24304 bytes
Desc: image002.jpg
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130825/8e0b3c4b/attachment-0002.jpg>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: ckan_datastore_error.txt
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130825/8e0b3c4b/attachment-0002.txt>
-------------- next part --------------
An embedded message was scrubbed...
From: "ckan-dev-request at lists.okfn.org" <ckan-dev-request at lists.okfn.org>
Subject: ckan-dev Digest, Vol 34, Issue 9 Datastore and CSV Preview
Date: Tue, 6 Aug 2013 10:56:07 +0000
Size: 12899
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130825/8e0b3c4b/attachment.mht>


More information about the ckan-support mailing list