[ckan-dev] setup problem

Thu Sep 5 19:04:00 UTC 2013

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
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> 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   Skype: talat.chaudhri
> ------------------------------------------------------------
> 
> 
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130905/1e1ffca1/attachment-0001.html>