[ckan-dev] setup problem

Fri Sep 6 06:06:17 UTC 2013

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://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
------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130906/3e2d6e5d/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/3e2d6e5d/attachment-0001.sig>