[ckan-dev] CKAN 2.3 errors spatial

Adrià Mercader adria.mercader at okfn.org
Wed Apr 8 09:42:48 UTC 2015


Hi,

ckanext-spatial should now work with CKAN 2.3.
Please see previous email on the list for details.

Thanks

Adrià

On 23 March 2015 at 02:43, Florian May <florian.wendelin.mayer at gmail.com> wrote:
> Mol be, Adria!
>
> Give me a yell if there's anything I can assist you with. Happy to put in a
> few dev hours if required - keen to learn how to upgrade third party deps
> like leaflet-draw.
>
> Cheers,
> Florian
>
> On Sat, Mar 21, 2015 at 1:20 AM, Adrià Mercader <adria.mercader at okfn.org>
> wrote:
>>
>> Thanks Florian,
>>
>> I have some time set aside next week to bring ckanext-spatial up to
>> speed with 2.3 and will definitely check your pointers.
>>
>>
>> Adrià
>>
>> On 17 March 2015 at 17:44, Julio Acuña <julio.acuna.carrillo at gmail.com>
>> wrote:
>> > Thanks Florian and Adrià, I will be looking forward for the fix.
>> >
>> > On Fri, Mar 13, 2015 at 9:17 PM, Florian May
>> > <florian.wendelin.mayer at gmail.com> wrote:
>> >>
>> >> Adrià,
>> >>
>> >> I've had a shot at fixing these. I suggest the fixes should be re-done
>> >> in
>> >> a more orderly fashion, but see my comments on details of the upgrade
>> >> and my
>> >> sandbox (link in comments) for a working implementation.
>> >> Happy to assist / re-implement where appropriate and required!
>> >>
>> >> https://github.com/ckan/ckanext-spatial/pull/93
>> >>
>> >> Cheers,
>> >> Florian
>> >>
>> >> On Fri, Mar 13, 2015 at 5:44 PM, Adrià Mercader
>> >> <adria.mercader at okfn.org>
>> >> wrote:
>> >>>
>> >>> 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
>> >>> >
>> >>> _______________________________________________
>> >>> 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
>> >
>> _______________________________________________
>> 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
>



More information about the ckan-dev mailing list