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

Mon Aug 26 21:10:48 UTC 2013

Hi David, Adria, Sean, John….

Would appreciate someone gets back to these folks please.

Thanks

Gavin

  _____  

Gavin Chait | Head of Services | Open Knowledge Foundation
 <mailto:gavin.chait at okfn.org> gavin.chait at okfn.org | M:  +44 (0) 78 9495
7090  |  <http://okfn.org/> http://okfn.org/

From: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz] 
Sent: 25 August 2013 23:52
To: gavin.chait at okfn.org; support at ckan.org
Cc: Michael Speth
Subject: RE: URGENT: FW: CKAN setup/info

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:

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 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 |
<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: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz] 
Sent: 23 August 2013 03:42
To: 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 |
<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: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz] 
Sent: 04 July 2013 23:14
To: 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 |
<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: 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
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
 <mailto:gavin.chait at okfn.org> gavin.chait at okfn.org | M:  +44 (0) 78 9495
7090  |  <http://okfn.org/> http://okfn.org/

From: Aaron McGlinchy [mailto:McGlinchyA at landcareresearch.co.nz] 
Sent: 22 May 2013 01:18
To: 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
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
 <mailto:gavin.chait at okfn.org> gavin.chait at okfn.org | M:  +44 (0) 78 9495
7090  |  <http://okfn.org/> 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; Mark Wainwright; 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; Mark Wainwright; 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/20130826/0becdc46/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 24304 bytes
Desc: not available
URL: <https://lists.okfn.org/mailman/private/ckan-support/attachments/20130826/0becdc46/attachment-0001.jpg>