[ckan-dev] setup problem
Talat Chaudhri
talat.chaudhri at gmail.com
Fri Sep 6 09:05:01 UTC 2013
Hi Anders,
I have just written up my experience on my blog, as well as I could
remember all the steps that differed from the instructions or otherwise
confused me.
http://blog.talatchaudhri.com/2013/09/06/installing-ckan-ubuntu-13-04-tomcat7/
If anybody has any comments, answers to the various questions raised, or
suggestions for improvement, I'd be very pleased to hear them. Anyway, I
hope that somebody will get something out of my experience setting up
CKAN for the first time on Tomcat 7. Maybe this will help with future
documentation...? :-)
All the best,
Talat
On 06/09/2013 08:54, Anders Green wrote:
> Hi,
> I suspected that permissions were the problem. I will try to pinpoint
> why the setup breaks.
>
> set-permissions seem to fail somehow (and I did a vanilla flavour
> souce installation) so I guess more people than us should have
> experienced this… but I am a newbie with CKAN, so I'll wait until I
> figure it out before posting to the list:)
>
> cheers
> /Anders
> --
> Senior lecturer
> Work phone: +46 8 608 51 44
> E-mail: anders.green at sh.se <mailto:anders.green at sh.se>
> Visiting address: Moas Båge MD370
> Address:
> Södertörns högskola
> Medieteknik
> S - 141 89 HUDDINGE · Sweden
>
>
>
>
>
> On Sep 6, 2013, at 8:06 AM, Talat Chaudhri <talat.chaudhri at gmail.com
> <mailto:talat.chaudhri at gmail.com>> wrote:
>
>> Hi Anders,
>>
>> It seems like the Tomcat errors were just caused by some lines that
>> needed commenting out in the default config (and I used plain Tomcat
>> rather than Jetty because Tomcat7 has newer dependencies than the
>> ones that will currently work with Jetty on Ubuntu 13.04). I must
>> admit that it was just my ignorance of postgresql syntax, having only
>> used mysql before, and I was simply changing the permissions on the
>> wrong database!
>>
>> The way I proved to myself that Solr wasn't broken on Tomcat was by
>> breaking it and then having to put it back together again ;-)
>>
>> I'm meaning to write up what I did for anybody else wanting to use
>> Ubuntu 13.04 and Tomcat7 with CKAN. I'll let you know if I do.
>>
>> Best wishes,
>>
>>
>> Talat
>>
>> On 05/09/2013 20:04, Anders Green wrote:
>>> Hi Talat,
>>>> Fixed - cheers :-)
>>> please let us know how. I experienced the exact same problems and
>>> logged errors (without the Jetty/Tomcat issues you were describing)
>>> when installing the other day. Although the solution probably is
>>> simple it would be nice to know what was the cause of it :)
>>>
>>> best wishes
>>>
>>> /Anders Green
>>> --
>>> Senior lecturer
>>> Work phone: +46 8 608 51 44
>>> E-mail: anders.green at sh.se <mailto:anders.green at sh.se>
>>> Visiting address: Moas Båge MD370
>>> Address:
>>> Södertörns högskola
>>> Medieteknik
>>> S - 141 89 HUDDINGE · Sweden
>>>
>>>
>>>
>>>
>>>
>>> On Sep 5, 2013, at 4:43 PM, Talat Chaudhri <talat.chaudhri at gmail.com
>>> <mailto:talat.chaudhri at gmail.com>> wrote:
>>>
>>>> Fixed - cheers :-)
>>>>
>>>> On 05/09/2013 07:12, Talat Chaudhri wrote:
>>>>> Hi,
>>>>>
>>>>> Sorry to be a pain and I hope this is a genuine problem rather than me
>>>>> not doing something obvious that I should have.
>>>>>
>>>>> As a newbie here, I've managed to set up CKAN and Solr but I'm getting
>>>>> some errors that I can't seem to solve. I am running Ubuntu 13.04 and
>>>>> tomcat7 (on port 8080), so I was not able to run Solr on Jetty because
>>>>> it required tomcat6 and various dependencies. (I use tomcat7 for other
>>>>> things.) However, I got it working on tomcat7 without Jetty, as the
>>>>> instructions suggested is possible. I had to follow third-party
>>>>> instructions for this part, as there aren't complete instructions
>>>>> on the
>>>>> CKAN site for Solr on tomcat alone, just the odd reference. I replaced
>>>>> the schema.xml file via symlink as suggested.
>>>>>
>>>>> http://ckan.talatchaudhri.com <http://ckan.talatchaudhri.com/>
>>>>>
>>>>> http://localhost:8080/solr points correctly at the Solr admin
>>>>> interface,
>>>>> which works. I don't see a welcome page, just the admin interface.
>>>>>
>>>>> I'm not sure that either the Datastore and/or Solr are working
>>>>> properly.
>>>>> Symptoms are:
>>>>>
>>>>> (1) Internal Server error when going to Explore > Preview in CKAN
>>>>> (2) These log messages generated in ckan_default.error.log:
>>>>>
>>>>> [Thu Sep 05 06:34:24 2013] [error] 2013-09-05 06:34:24,225 INFO
>>>>> [ckan.lib.base] /dataset/test-data render time 0.115 seconds
>>>>> [Thu Sep 05 06:34:27 2013] [error] [client 80.229.138.88] Error -
>>>>> <class
>>>>> 'sqlalchemy.exc.ProgrammingError'>: (ProgrammingError) permission
>>>>> denied
>>>>> for relation _table_metadata
>>>>> [Thu Sep 05 06:34:27 2013] [error] [client 80.229.138.88] 'SELECT 1
>>>>> FROM "_table_metadata" WHERE name = %s AND alias_of IS NULL'
>>>>> (u'c7d91b5d-96e0-4c4a-934e-95ea6ede8f1c',)
>>>>> [Thu Sep 05 06:34:27 2013] [error] 2013-09-05 06:34:27,362 INFO
>>>>> [ckan.lib.base]
>>>>> /dataset/test-data/resource/c7d91b5d-96e0-4c4a-934e-95ea6ede8f1c
>>>>> render
>>>>> time 0.047 seconds
>>>>> [Thu Sep 05 06:34:27 2013] [error] 2013-09-05 06:34:27,477 INFO
>>>>> [ckan.lib.base] /api/i18n/en render time 0.002 seconds
>>>>>
>>>>> The only info that I could find that seemed to relate to the SQL error
>>>>> was at
>>>>> http://lists.okfn.org/pipermail/ckan-dev/2012-October/003227.html
>>>>> on this list, but running the recommended commands with the users
>>>>> ckan_default and datastore_default didn't seem to make any difference.
>>>>>
>>>>> I did check that the passwords for these users are correctly set in
>>>>> Postgres, which are also correctly set in production.ini in the places
>>>>> that are required. (I'm not all that experienced with Postgres, having
>>>>> previously used MySQL for other projects.)
>>>>>
>>>>> (3) Solr is giving errors and the Last Check (under Logging) is then
>>>>> hanging, after I reboot tomcat. At the time of writing it reads:
>>>>>
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../contrib/extraction/lib
>>>>> (resolved as:
>>>>> /var/lib/solr/collection1/../../../contrib/extraction/lib).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../dist/ (resolved as:
>>>>> /var/lib/solr/collection1/../../../dist).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../contrib/clustering/lib/
>>>>> (resolved as:
>>>>> /var/lib/solr/collection1/../../../contrib/clustering/lib).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../dist/ (resolved as:
>>>>> /var/lib/solr/collection1/../../../dist).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../contrib/langid/lib/
>>>>> (resolved
>>>>> as: /var/lib/solr/collection1/../../../contrib/langid/lib).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../dist/ (resolved as:
>>>>> /var/lib/solr/collection1/../../../dist).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../contrib/velocity/lib
>>>>> (resolved
>>>>> as: /var/lib/solr/collection1/../../../contrib/velocity/lib).
>>>>> 06:42:13 WARN SolrResourceLoader Can't find (or read)
>>>>> directory to add to classloader: ../../../dist/ (resolved as:
>>>>> /var/lib/solr/collection1/../../../dist).
>>>>>
>>>>> Unless I reboot tomcat, it never moves any further from this, and no
>>>>> more logging happens.
>>>>>
>>>>> Sorry if this isn't complete. It's from the interface. Not sure quite
>>>>> which logfile to look in.
>>>>>
>>>>> (4) When I set up the DataStore, I got the following error:
>>>>>
>>>>> AttributeError: 'NoneType' object has no attribute 'auth_audit_exempt'
>>>>>
>>>>> I'm guessing this one may be trivial but I included it in case I'm
>>>>> wrong, as I don't know whether or not it's relevant.
>>>>>
>>>>> (As far as I can see from the logs in /var/log/tomcat7, there seem
>>>>> to be
>>>>> no tomcat errors associated with Solr, although TBH it is hard to see
>>>>> through the confusing mess of errors due to an instance of Guacamole
>>>>> that I was previously running on tomcat! I have apparently killed it
>>>>> since I installed Solr - not sure how.)
>>>>>
>>>>> Are these details enough to be diagnostic? Thanks in advance for any
>>>>> time that you can give this.
>>>>>
>>>>> Best wishes,
>>>>>
>>>>>
>>>>> Talat
>>>>>
>>>>
>>>> --
>>>> Dr Talat Chaudhri
>>>> ------------------------------------------------------------
>>>> Telephone: +44 (0)7759 944485
>>>> E-mail: talat.chaudhri at gmail.com <mailto:talat.chaudhri at gmail.com>
>>>> Skype: talat.chaudhri
>>>> ------------------------------------------------------------
>>>>
>>>>
>>>> _______________________________________________
>>>> ckan-dev mailing list
>>>> ckan-dev at lists.okfn.org <mailto:ckan-dev at lists.okfn.org>
>>>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>>>> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>
>> --
>> Dr Talat Chaudhri
>> ------------------------------------------------------------
>> Telephone: +44 (0)7759 944485
>> E-mail: talat.chaudhri at gmail.com Skype: talat.chaudhri
>> ------------------------------------------------------------
>>
>
--
Dr Talat Chaudhri
------------------------------------------------------------
Telephone: +44 (0)7759 944485
E-mail: talat.chaudhri at gmail.com Skype: talat.chaudhri
------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130906/2e741357/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 600 bytes
Desc: OpenPGP digital signature
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130906/2e741357/attachment-0001.sig>
More information about the ckan-dev
mailing list