[ckan-dev] setup problem

[Talat Chaudhri]

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/fc72689f/attachment.sig>