[GeoNode-users] Geonode & Geoserver - Secure WMS

Wed Jan 24 23:18:12 PST 2018

Olivier,

IMHO this approach is just an over engineering to achieve your use case.
I would use an external common LDAP for that scope which is cleaner from an architectural point of view.

Francesco

Il 25 gen 2018, 04:34 +0100, Olivier Dalang <olivier.dalang at gmail.com>, ha scritto:
> Hi,
>
> We have very similar requirements here.
>
> I'm currently trying to set this up by sharing user tables between Geonode and Geoserver at database level rather than using OAuth2 calls.
>
> It works like this :
>
> 1/ Create a JDBC user/group service
> 2/ Create a authkey authentication using "user properties" (this works by reading a "UUID" property for each user)
> 3/ Change usersddl.xml to create updatable views instead of tables to "proxy" django's tables so that they can be used by geoserver. This must be done for user, user_props (to set the UUID to Django's tokens), and also for groups. Another approach is not to create the tables at all, but customize the queries (but it's more work in the end).
> 4/ Create a Django PasswordHasher so that Django and Geoserver's hashes are compatible
>
> This way, Geonode and Geoserver users are synced at the database level. It means that Geoserver users/groups can be used through basic http authentication (when connecting from a desktop GIS client for example) and also when using a key in the URL (to display map tiles from the browser for example). As Django tokens expire, it's not too bad if someone gets hold of a token. And the nice thing is that if you use updatable views in postgres, you can add/edit users/groups from within Geoserver or Geonode.
>
> This whole idea seems works well (at least during my early tests), except for step 4. I've been trying to setup Strong PBE Encryption for Django, but couldn't make it work (see this thread https://lists.osgeo.org/pipermail/geonode-users/2018-January/004059.html). Currently, I'm using plain text passwords for my tests, but I'd definitely need to sort step 4 out for this to be usable safely in production.
>
> I'm just in the middle of this, so I don't have a nice code example to share (besides what I shared in that other thread), but if this is of some interest to you, I'll be happy to do so in a few days...
>
> Kind regards,
>
> Olivier
>
>
>
>
>
>
> > On Tue, Jan 23, 2018 at 9:02 AM, Pascal Coulon <Pascal.Coulon at scisys.co.uk> wrote:
> > > Brilliant – very useful – exactly what we are about to implement. If this works as per explained we will feedback here.
> > >
> > > Pascal Coulon
> > > GIS Technical Architect - Enterprise Solutions & Defence
> > > SCISYS UK Limited
> > > T: +44 (0)117 9165237 | F: +44 (0)1249 465237 | M:+44 (0) 7876397844
> > > E: pascal.coulon at scisys.co.uk | http://www.scisys.co.uk
> > >
> > > From: Francesco Bartoli [mailto:xbartolone at gmail.com]
> > > Sent: 22 January 2018 20:59
> > > To: Alessio Fabiani
> > > Cc: Pascal Coulon; geonode-users at lists.osgeo.org
> > > Subject: Re: [GeoNode-users] Geonode & Geoserver - Secure WMS
> > >
> > > Never tried this https://github.com/GeoNode/geonode/pull/3415 but it should allow to get an access token from external applications.
> > >
> > > @Pascal, it is worth a look and maybe a PR for geonode docs on how to use it.
> > >
> > > Thanks
> > > Francesco
> > >
> > > Il giorno 22/gen/2018, alle ore 19:02, Alessio Fabiani <alessio.fabiani at geo-solutions.it> ha scritto:
> > >
> > >
> > > Hello Pascal,
> > > currently, without further customizations, the only way to access resources from external clients is by putting the valid OAUth2 access_token generated by GeoNode into the OWS request URL parameters.
> > >
> > > To retrieve this, you need to log into GeoNode, go to any layer details, click on "Download Layer" and copy the "access_token" query parameter from any of the generated query strings.
> > >
> > > There are plans to make it more easy for the users to retrieve the access_token from GeoNode in the future, but currently this is the only way to do this.
> > >
> > >
> > > Regards,
> > > Alessio Fabiani
> > > ==
> > > GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information.
> > > ==
> > >
> > > Ing. Alessio Fabiani
> > > @alfa7691
> > > Founder/Technical Lead
> > >
> > > GeoSolutions S.A.S.
> > > Via di Montramito 3/A
> > > 55054  Massarosa (LU)
> > > Italy
> > > phone: +39 0584 962313
> > > fax:     +39 0584 1660272
> > > mob:   +39 331 6233686
> > >
> > > http://www.geo-solutions.it
> > > http://twitter.com/geosolutions_it
> > >
> > > -------------------------------------------------------
> > > AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
> > > Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
> > > The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility  for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.
> > >
> > > 2018-01-22 18:50 GMT+01:00 Pascal Coulon <Pascal.Coulon at scisys.co.uk>:
> > > Hello,
> > >
> > > I have a use case where I need to securely access OGC services managed by GeoNode, Geoserver and GeoFence. Access is required outside Geonode portal into third party application: desktop, other spatial web portal, etc.
> > >
> > > Geonode is used as the gateway to manage all datasets. On setting the permissions on a given datasets the relevant permissions are being pushed to GeoFence via its rest API. By default a ground data rule is set by default in GeoFence that prevent accessing / viewing all datasets; which means that then datasets would only be visible based on permissions set in GeoNode.
> > >
> > > The above part makes sense as long as one browses the data only in GeoNode. However, as soon as one wants to access the OGC end points in say QGIS / ArcMAP (e.g. wms, wfs) available on http://mydomain/geoserver/geonode/wms, you are not anymore authenticated. I have already looked into basic authentication; but as far as I understand it, this approach requires recreating the Geonode user in GeoServer.
> > >
> > > What are the options then for a desktop / third party application’s user to access the secure OGC end-points managed through Geonode? Which Geoserver authentication filter one should use?
> > >
> > > Hope this makes sense. Any thoughts or pointer would be greatly appreciated.
> > >
> > > Cheers,
> > >
> > > Pascal
> > >
> > >
> > > SCISYS UK Limited. Registered in England and Wales No. 4373530.
> > > Registered Office: Methuen Park, Chippenham, Wiltshire SN14 0GB, UK.
> > >
> > > Before printing, please think about the environment.
> > >
> > >
> > > _______________________________________________
> > > geonode-users mailing list
> > > geonode-users at lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/geonode-users
> > >
> > > _______________________________________________
> > > geonode-users mailing list
> > > geonode-users at lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/geonode-users
> > >
> > >
> > > SCISYS UK Limited. Registered in England and Wales No. 4373530.
> > > Registered Office: Methuen Park, Chippenham, Wiltshire SN14 0GB, UK.
> > >
> > > Before printing, please think about the environment.
> > >
> > > _______________________________________________
> > > geonode-users mailing list
> > > geonode-users at lists.osgeo.org
> > > https://lists.osgeo.org/mailman/listinfo/geonode-users
> > >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20180125/8ccf5ecd/attachment-0001.html>