[ckan-dev] setup problem

[Talat Chaudhri]

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


-------------- 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/20130905/88e19577/attachment-0001.sig>