[ckan-dev] CKAN 2.3 errors spatial

Fri Mar 13 09:44:49 UTC 2015

Hi,

The current master branch of ckanext-spatial will not work with 2.3
doing to requirements incompatibilities. This should be easy to fix
but we need to set some time aside to review it properly. I'll let the
list know when we can find some resources to work on this, hopefully
very soon.

Cheers,

Adrià

On 13 March 2015 at 04:28, Florian May <florian.wendelin.mayer at gmail.com> wrote:
> Isabel, Julio,
>
> this sounds awfully familiar... "It seems SqlAlchemy have renamed
> ColumnComparator to Comparator, and used it interchangeably as shown here."
> try using @chokoswitch's patched geoalchemy (using good old
> ColumnComparator) in ckanext-spatial's pip-requirements.txt like so and
> JTS1.13 (sourceforge) as described in section "Customise SolR to CKAN
> schema" here.
>
> HTH,
> Florian
>
> On Fri, Mar 13, 2015 at 11:08 AM, Julio Acuña
> <julio.acuna.carrillo at gmail.com> wrote:
>>
>> I have the same problem, it seems that ckanext-spatial doesn't play well
>> with CKAN 2.3
>>
>> As far as I can tell, it has to do with the versions of sqlalchemy and
>> geoalchemy, maybe a patched version of geoalchemy could make the trick, but
>> I haven't try it yet.
>>
>> Check this post
>> http://gis.stackexchange.com/questions/109498/geoalchemy-attributeerror-type-object-columnproperty-has-no-attribute-colum
>>
>> On Tue, Mar 10, 2015 at 7:44 AM, Isabel Ruiz <isaruizmellado at gmail.com>
>> wrote:
>>>
>>> Hello,
>>>
>>> I have upgraded to CKAN 2.3 and I have updated all my dependences (well,
>>> I think I have updated them :) ).
>>>
>>> I have restarted jetty and apache2.
>>>
>>> When I run CKAN, it returns this spatial error:
>>>
>>> What can be wrong?
>>>
>>> Thanks !
>>>
>>>
>>> [Tue Mar 10 13:23:47.184841 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291] mod_wsgi (pid=8508): Target WSGI script
>>> '/home/ckan/ckan/lib/default/bin/malaga.py' cannot be loaded as Python
>>> module.
>>> [Tue Mar 10 13:23:47.188418 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291] mod_wsgi (pid=8508): Exception occurred processing WSGI
>>> script '/home/ckan/ckan/lib/default/bin/malaga.py'.
>>> [Tue Mar 10 13:23:47.189669 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291] Traceback (most recent call last):
>>> [Tue Mar 10 13:23:47.191245 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File "/home/ckan/ckan/lib/default/bin/malaga.py", line
>>> 11, in <module>
>>> [Tue Mar 10 13:23:47.193171 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     application = loadapp('config:%s' % config_filepath)
>>> [Tue Mar 10 13:23:47.194516 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>>> line 247, in loadapp
>>> [Tue Mar 10 13:23:47.197398 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return loadobj(APP, uri, name=name, **kw)
>>> [Tue Mar 10 13:23:47.198877 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>>> line 272, in loadobj
>>> [Tue Mar 10 13:23:47.200383 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return context.create()
>>> [Tue Mar 10 13:23:47.202156 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>>> line 710, in create
>>> [Tue Mar 10 13:23:47.204564 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return self.object_type.invoke(self)
>>> [Tue Mar 10 13:23:47.205859 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/loadwsgi.py",
>>> line 146, in invoke
>>> [Tue Mar 10 13:23:47.207260 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return fix_call(context.object, context.global_conf,
>>> **context.local_conf)
>>> [Tue Mar 10 13:23:47.208436 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/paste/deploy/util.py",
>>> line 56, in fix_call
>>> [Tue Mar 10 13:23:47.209944 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     val = callable(*args, **kw)
>>> [Tue Mar 10 13:23:47.211028 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/middleware.py", line 58,
>>> in make_app
>>> [Tue Mar 10 13:23:47.212776 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     load_environment(conf, app_conf)
>>> [Tue Mar 10 13:23:47.213900 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckan/ckan/config/environment.py", line 232,
>>> in load_environment
>>> [Tue Mar 10 13:23:47.215991 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     p.load_all(config)
>>> [Tue Mar 10 13:23:47.217006 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 134, in
>>> load_all
>>> [Tue Mar 10 13:23:47.218879 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     load(*plugins)
>>> [Tue Mar 10 13:23:47.219960 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 148, in
>>> load
>>> [Tue Mar 10 13:23:47.221032 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     service = _get_service(plugin)
>>> [Tue Mar 10 13:23:47.221484 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckan/ckan/plugins/core.py", line 254, in
>>> _get_service
>>> [Tue Mar 10 13:23:47.222504 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return plugin.load()(name=plugin_name)
>>> [Tue Mar 10 13:23:47.223038 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
>>> line 2312, in load
>>> [Tue Mar 10 13:23:47.227922 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     return self.resolve()
>>> [Tue Mar 10 13:23:47.229201 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/pkg_resources/__init__.py",
>>> line 2318, in resolve
>>> [Tue Mar 10 13:23:47.230395 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     module = __import__(self.module_name,
>>> fromlist=['__name__'], level=0)
>>> [Tue Mar 10 13:23:47.231607 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/plugin.py",
>>> line 15, in <module>
>>> [Tue Mar 10 13:23:47.236024 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     from ckanext.spatial.lib import
>>> save_package_extent,validate_bbox, bbox_query, bbox_query_ordered
>>> [Tue Mar 10 13:23:47.237258 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/lib/__init__.py",
>>> line 7, in <module>
>>> [Tue Mar 10 13:23:47.239120 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     from ckanext.spatial.model import PackageExtent
>>> [Tue Mar 10 13:23:47.240370 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/__init__.py",
>>> line 9, in <module>
>>> [Tue Mar 10 13:23:47.242079 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     from package_extent import *
>>> [Tue Mar 10 13:23:47.243367 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/src/ckanext-spatial/ckanext/spatial/model/package_extent.py",
>>> line 5, in <module>
>>> [Tue Mar 10 13:23:47.245196 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     from geoalchemy import Geometry, GeometryColumn,
>>> GeometryDDL, GeometryExtensionColumn
>>> [Tue Mar 10 13:23:47.246382 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/__init__.py",
>>> line 2, in <module>
>>> [Tue Mar 10 13:23:47.248250 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     from geoalchemy.base import *
>>> [Tue Mar 10 13:23:47.249436 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]   File
>>> "/home/ckan/ckan/lib/default/lib/python2.7/site-packages/geoalchemy/base.py",
>>> line 242, in <module>
>>> [Tue Mar 10 13:23:47.251387 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291]     class
>>> SpatialComparator(ColumnProperty.ColumnComparator):
>>> [Tue Mar 10 13:23:47.252634 2015] [:error] [pid 8508] [client
>>> 172.16.92.1:33291] AttributeError: type object 'ColumnProperty' has no
>>> attribute 'ColumnComparator'
>>> --
>>> Isabel M. Ruiz Mellado
>>> http://about.me/isabelruiz
>>>
>>> _______________________________________________
>>> ckan-dev mailing list
>>> ckan-dev at lists.okfn.org
>>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>>
>>
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>