Troubleshooting

CKAN

Resource visualization returns a server error

If the log file reports a:

(ProgrammingError) permission denied for relation _table_metadata

try resetting the select grants:

su - postgres -c "psql datastore"
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datastore;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO datastorero;

Harvest: error in fetching

The fetch log (at /var/log/ckan/fetch.log) may present errors like this one:

Traceback (most recent call last):
  File "/usr/lib/ckan/default/bin/paster", line 9, in <module>
    load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
  File "/usr/lib/ckan/default/lib/python2.6/site-packages/paste/script/command.py", line 104, in run
    invoke(command, command_name, options, args[1:])
  File "/usr/lib/ckan/default/lib/python2.6/site-packages/paste/script/command.py", line 143, in invoke
    exit_code = runner.run(args)
  File "/usr/lib/ckan/default/lib/python2.6/site-packages/paste/script/command.py", line 238, in run
    result = self.command()
  File "/usr/lib/ckan/default/src/ckanext-harvest/ckanext/harvest/commands/harvester.py", line 126, in command
    for method, header, body in consumer.consume(queue='ckan.harvest.fetch'):
  File "/usr/lib/ckan/default/src/ckanext-harvest/ckanext/harvest/queue.py", line 160, in consume
    self.redis.set(self.persistance_key(body),
  File "/usr/lib/ckan/default/src/ckanext-harvest/ckanext/harvest/queue.py", line 165, in persistance_key
    return self.routing_key + ':' + message[self.routing_key]
TypeError: cannot concatenate 'str' and 'NoneType' objects

It should be caused by changes in an harvesting source.

• Go in the CKAN admin page for the given source.
• Remove current jobs ( admin > clear > confirm )

• From the command line, run the command::

  redis-cli flushall

• As root user, restart CKAN ::

  systemctl restart supervisord

Managing Solr Indexes

If for any reason the Solr indexes will be corrupted, ask Ckan to rebuild them.

Activate the virtual environment:

. /usr/lib/ckan/default/bin/activate

Then rebuild the Solr indexes:

paster --plugin=ckan search-index rebuild  -c /etc/ckan/default/production.ini

Adding a new CKAN Administrator

Activate the virtual environment:

. /usr/lib/ckan/default/bin/activate

Then add a new admin user using the following command (replace the USERNAME with the real name of the user):

paster --plugin=ckan sysadmin add USERNAME --config=/etc/ckan/default/production.ini

If you want to change an user password, use instead the following command:

paster --plugin=ckan user setpass USERNAME -c /etc/ckan/default/production.ini

Finally for list the existing users in Ckan:

paster --plugin=ckan user list -c /etc/ckan/default/production.ini