[ckan-dev] CKAN 2.3 errors spatial

• Previous message: [ckan-dev] CKAN 2.3 errors spatial
• Next message: [ckan-dev] CKAN 2.3 errors spatial
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150314/bca00934/attachment-0003.html>

• Previous message: [ckan-dev] CKAN 2.3 errors spatial
• Next message: [ckan-dev] CKAN 2.3 errors spatial
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]