-
Notifications
You must be signed in to change notification settings - Fork 12
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Setup tables on ckan 2.5.1 #228
Comments
This extension is based on CKAN 2.2 and has not been tested in latest versions. |
Any idea why? Did ckan team changed the schema? Or is the record something related to this extension only? |
Have you created the CSW-related tables before trying to enable the The above stacktrace clearly says:
This table ( |
I used the paster setup commands which (at the source code) says it will install databases and such |
Was it successfull? Can you post the output? |
yes, no errors. output: 2016-02-04 15:03:05,703 DEBUG [ckanext.harvest.model] Harvest tables already exist |
The above example is initializing harvester-related tables ( To set things up for
|
my bad, this is the correct output. i'm also attaching the apache output when adding a new dataset $ paster --plugin=ckanext-publicamundi publicamundi -c /etc/ckan/default/production.ini setup [Thu Feb 04 15:04:11.351316 2016] [:error] [pid 14423:tid 140692961957632] 2016-02-04 15:04:11,351 DEBUG [ckanext.publicamundi.plugins] A package was updated: 9d3182c4-1ddf-4f9c-9fd8-5a067419116b [Thu Feb 04 15:04:11.613543 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] SERVER_SOFTWARE: 'Apache/2.4.7 (Ubuntu)' [Thu Feb 04 15:04:11.613581 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] [Thu Feb 04 15:04:11.613624 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] [Thu Feb 04 15:04:11.613660 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] WSGI Variables [Thu Feb 04 15:04:11.613688 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] -------------- [Thu Feb 04 15:04:11.613718 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] application: <fanstatic.publisher.Delegator object at 0x7ff5889e3350> [Thu Feb 04 15:04:11.613748 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] beaker.cache: <beaker.cache.CacheManager object at 0x7ff5889e33d0> [Thu Feb 04 15:04:11.613789 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] beaker.get_session: <bound method SessionMiddleware._get_session of <beaker.middleware.SessionMiddleware object at 0x7ff5889c9510>> [Thu Feb 04 15:04:11.613828 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] beaker.session: {'_accessed_time': 1454598251.601952, '_creation_time': 1454598251.601952} [Thu Feb 04 15:04:11.613871 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] fanstatic.needed: <fanstatic.core.NeededResources object at 0x7ff587b531d0> [Thu Feb 04 15:04:11.613910 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.application_group: 'default.ckanhosted.com|' [Thu Feb 04 15:04:11.613956 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.callable_object: 'application' [Thu Feb 04 15:04:11.614010 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.enable_sendfile: '0' [Thu Feb 04 15:04:11.614048 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.handler_script: '' [Thu Feb 04 15:04:11.614078 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.input_chunked: '0' [Thu Feb 04 15:04:11.614107 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.listener_host: '' [Thu Feb 04 15:04:11.614138 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.listener_port: '8080' [Thu Feb 04 15:04:11.614180 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.process_group: 'ckan_default' [Thu Feb 04 15:04:11.614210 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.queue_start: '1454598251287557' [Thu Feb 04 15:04:11.614241 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.request_handler: 'wsgi-script' [Thu Feb 04 15:04:11.614271 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.script_reloading: '1' [Thu Feb 04 15:04:11.614303 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] mod_wsgi.version: (3, 4) [Thu Feb 04 15:04:11.614350 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] paste.cookies: (<SimpleCookie: auth_tkt='80119b2b1134599b8f1c52edff60b885569fcdb0deimos!userid_type:unicode' ckan='d38bcf19a660ca76f9d333f473291401774640821fb4016dd2be473393ce258d4bc1db9c'>, 'auth_tkt="80119b2b1134599b8f1c52edff60b885569fcdb0deimos!userid_type:unicode"; ckan=d38bcf19a660ca76f9d333f473291401774640821fb4016dd2be473393ce258d4bc1db9c') [Thu Feb 04 15:04:11.614398 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] paste.registry: <paste.registry.Registry object at 0x7ff587ac9550> [Thu Feb 04 15:04:11.614448 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] paste.throw_errors: True [Thu Feb 04 15:04:11.614493 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] pylons.action_method: <bound method PackageController.new_resource of <ckan.controllers.package.PackageController object at 0x7ff5862adb50>> [Thu Feb 04 15:04:11.614538 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] pylons.controller: <ckan.controllers.package.PackageController object at 0x7ff5862adb50> [Thu Feb 04 15:04:11.614577 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] pylons.environ_config: {'session': 'beaker.session', 'cache': 'beaker.cache'} [Thu Feb 04 15:04:11.614607 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] pylons.pylons: <pylons.util.PylonsContext object at 0x7ff5862ad790> [Thu Feb 04 15:04:11.614637 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] pylons.routes_dict: {'action': u'new_resource', 'controller': u'package', 'id': u'testeas'} [Thu Feb 04 15:04:11.614667 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] repoze.who.api: <repoze.who.api.API object at 0x7ff5889c96d0> [Thu Feb 04 15:04:11.614703 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] repoze.who.identity: <repoze.who identity (hidden, dict-like) at 140692494284016> [Thu Feb 04 15:04:11.614742 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] repoze.who.logger: <logging.Logger object at 0x7ff58f3e3950> [Thu Feb 04 15:04:11.614783 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] repoze.who.plugins: {'ckan.lib.authenticator:UsernamePasswordAuthenticator': <ckan.lib.authenticator.UsernamePasswordAuthenticator object at 0x7ff58f3e3990>, 'friendlyform': <FriendlyFormPlugin 140692535854544>, 'auth_tkt': <CkanAuthTktCookiePlugin 140692535854480>} [Thu Feb 04 15:04:11.614816 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] routes.route: <routes.route.Route object at 0x7ff588af5f90> [Thu Feb 04 15:04:11.614846 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] routes.url: <routes.util.URLGenerator object at 0x7ff5862ad2d0> [Thu Feb 04 15:04:11.614887 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] webob._parsed_post_vars: (MultiDict([('id', ''), ('url', 'https://mail.google.com/mail/u/0/#inbox/152ad1c1a956d462'), ('upload', ''), ('clear_upload', ''), ('name', 'fff'), ('description', ''), ('format', ''), ('save', 'go-metadata')]), <FakeCGIBody at 0x7ff5862ad710 viewing MultiDict([('id...a')])>) [Thu Feb 04 15:04:11.614953 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] webob._parsed_query_vars: (GET([]), '') [Thu Feb 04 15:04:11.615007 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] webob.adhoc_attrs: {'errors': 'ignore', 'response': <Response at 0x7ff587b55850 200 OK>, 'language': 'en-us'} [Thu Feb 04 15:04:11.615117 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] webob.is_body_readable: True [Thu Feb 04 15:04:11.615149 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] webob.is_body_seekable: False [Thu Feb 04 15:04:11.615189 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] wsgi process: 'Multi process AND threads (?)' [Thu Feb 04 15:04:11.615229 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7ff587b890a8> [Thu Feb 04 15:04:11.615266 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] wsgiorg.routing_args: (<routes.util.URLGenerator object at 0x7ff5862ad2d0>, {'action': u'new_resource', 'controller': u'package', 'id': u'testeas'}) [Thu Feb 04 15:04:11.615299 2016] [:error] [pid 14423:tid 140692961957632] [remote 127.0.0.1:15018] ------------------------------------------------------------ [Thu Feb 04 15:04:11.689639 2016] [:error] [pid 14423:tid 140692961957632] 2016-02-04 15:04:11,689 INFO [ckan.lib.base] /dataset/new_resource/testeas render time 0.073 seconds [Thu Feb 04 15:04:12.183827 2016] [:error] [pid 14423:tid 140692878030592] 2016-02-04 15:04:12,183 INFO [ckan.lib.base] /api/i18n/en render time 0.002 seconds |
Cannot reproduce this problem on ckan 2.2. Until we support newer ckan versions, i suggest that you try to re-use the CSW-related model and create it (on the target database) using plain sqlalchemy. |
Using newer version of ckan 2.5.1 with this extensions brings some problems:
-geoalchemy is no longer supported with current sqlalchemy version, udpated references to geoalchemy2
as of right now I only have enabled publicamundi_package, dont know if this is related to my error or not
-i adressed some of this issues, but after trying to add a dataset to ckan i got this error:
[Thu Feb 04 14:43:05.951355 2016] [:error] [pid 14422:tid 140692987135744] [remote 127.0.0.1:7082] ProgrammingError: (ProgrammingError) relation "records" does not exist
[Thu Feb 04 14:43:05.951362 2016] [:error] [pid 14422:tid 140692987135744] [remote 127.0.0.1:7082] LINE 2: FROM records
[Thu Feb 04 14:43:05.951369 2016] [:error] [pid 14422:tid 140692987135744] [remote 127.0.0.1:7082] ^
[Thu Feb 04 14:43:05.951379 2016] [:error] [pid 14422:tid 140692987135744] [remote 127.0.0.1:7082] 'SELECT records.identifier AS records_identifier, records.typename AS records_typename, records.schema AS records_schema, records.mdsource AS records_mdsource, records.insert_date AS records_insert_date, records.xml AS records_xml, records.anytext AS records_anytext, records.language AS records_language, records.type AS records_type, records.title AS records_title, records.title_alternate AS.............
The text was updated successfully, but these errors were encountered: