[Geoserver-users] JDBCConfig community module: users/groups/roles not saved

Hi all

We are using the JDBCConfig community module and everything is saved to the configured database. It works well when autoscaling multiple instances in AWS.

However, it appears as though the data/security/ directory is not part of the catalog that is saved to the database. When adding a new user, group or role, the XML files in the local data/security directory are updated.

Is this intentional or a bug? I don’t see any user configuration option to include/exclude parts of the catalog. Or does “catalog” exclude security?

Is there any way to use (or modify?) JDBCConfig to save users to the database?

Thanks

Peter

JDBCConfig is not intended to be used in isolation, please use with JDBCStore (which saves configuration files, icons, fonts, and so on into the database as blobs).

Please note that both these modules are unsupported and are seeking interested parties to work on them. Is this something your organization is in position to do?

···


Jody Garnett

Thanks Jody, that was not immediately clear. I will follow your advice - next year.

And I’ll ask about your parting question.

Regards

Peter

On Fri, 13 Dec 2019 at 10:09, Jody Garnett <jody.garnett@anonymised.com> wrote:

JDBCConfig is not intended to be used in isolation, please use with JDBCStore (which saves configuration files, icons, fonts, and so on into the database as blobs).

Please note that both these modules are unsupported and are seeking interested parties to work on them. Is this something your organization is in position to do?


Jody Garnett

On Fri, 13 Dec 2019 at 08:50, Peter Smythe <gs@anonymised.com> wrote:

Hi all

We are using the JDBCConfig community module and everything is saved to the configured database. It works well when autoscaling multiple instances in AWS.

However, it appears as though the data/security/ directory is not part of the catalog that is saved to the database. When adding a new user, group or role, the XML files in the local data/security directory are updated.

Is this intentional or a bug? I don’t see any user configuration option to include/exclude parts of the catalog. Or does “catalog” exclude security?

Is there any way to use (or modify?) JDBCConfig to save users to the database?

Thanks

Peter


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

I use both modules in production and you can always ask me for advise. I use it in combination with hz-cluster.

I have been doing fixes and improvements over the past few years, so has Steve Ikeoka for the jdbcconfig part who I think uses it in production as well with hazelcast.

Kind Regards

Niels

···

On 13/12/2019 12:07, Peter Smythe wrote:

Thanks Jody, that was not immediately clear. I will follow your advice - next year.

And I’ll ask about your parting question.

Regards

Peter

On Fri, 13 Dec 2019 at 10:09, Jody Garnett <jody.garnett@anonymised.com> wrote:

JDBCConfig is not intended to be used in isolation, please use with JDBCStore (which saves configuration files, icons, fonts, and so on into the database as blobs).

Please note that both these modules are unsupported and are seeking interested parties to work on them. Is this something your organization is in position to do?


Jody Garnett

On Fri, 13 Dec 2019 at 08:50, Peter Smythe <gs@anonymised.com> wrote:

Hi all

We are using the JDBCConfig community module and everything is saved to the configured database. It works well when autoscaling multiple instances in AWS.

However, it appears as though the data/security/ directory is not part of the catalog that is saved to the database. When adding a new user, group or role, the XML files in the local data/security directory are updated.

Is this intentional or a bug? I don’t see any user configuration option to include/exclude parts of the catalog. Or does “catalog” exclude security?

Is there any way to use (or modify?) JDBCConfig to save users to the database?

Thanks

Peter


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)

I personally like the module and would love to see those two (jdbcconfig/jdbcstore) combined. Have you and Steve considered making it an extension?

···


Jody Garnett

Hopefully questions and answers are going to stay on the geoserver-users list, where everyone can learn from them

Cheers
Andrea

···

GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa che ogni circostanza inerente alla presente email (il suo contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei comunque grato se potesse darmene notizia. This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. We remind that - as provided by European Regulation 2016/679 “GDPR” - copying, dissemination or use of this e-mail or the information herein by anyone other than the intended recipient is prohibited. If you have received this email by mistake, please notify us immediately by telephone or e-mail.

Not so far, perhaps something to look into. It’s gotten more robust and usable but there is still room for improvement, definitely. One module, sure as long as people can still configure to have one without the other I guess.

···

On 17/12/2019 08:42, Jody Garnett wrote:

I personally like the module and would love to see those two (jdbcconfig/jdbcstore) combined. Have you and Steve considered making it an extension?


Jody Garnett

On Sun, 15 Dec 2019 at 11:40, Niels Charlier <niels@anonymised.com> wrote:

I use both modules in production and you can always ask me for advise. I use it in combination with hz-cluster.

I have been doing fixes and improvements over the past few years, so has Steve Ikeoka for the jdbcconfig part who I think uses it in production as well with hazelcast.

Kind Regards

Niels

On 13/12/2019 12:07, Peter Smythe wrote:

Thanks Jody, that was not immediately clear. I will follow your advice - next year.

And I’ll ask about your parting question.

Regards

Peter

On Fri, 13 Dec 2019 at 10:09, Jody Garnett <jody.garnett@anonymised.com> wrote:

JDBCConfig is not intended to be used in isolation, please use with JDBCStore (which saves configuration files, icons, fonts, and so on into the database as blobs).

Please note that both these modules are unsupported and are seeking interested parties to work on them. Is this something your organization is in position to do?


Jody Garnett

On Fri, 13 Dec 2019 at 08:50, Peter Smythe <gs@anonymised.com> wrote:

Hi all

We are using the JDBCConfig community module and everything is saved to the configured database. It works well when autoscaling multiple instances in AWS.

However, it appears as though the data/security/ directory is not part of the catalog that is saved to the database. When adding a new user, group or role, the XML files in the local data/security directory are updated.

Is this intentional or a bug? I don’t see any user configuration option to include/exclude parts of the catalog. Or does “catalog” exclude security?

Is there any way to use (or modify?) JDBCConfig to save users to the database?

Thanks

Peter


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Why would you have one without the other?

···


Jody Garnett

I think Steve uses only jdbcconfig.

Because you want to have the catalog in a database, for example for scalability, but not necessarily the entire data directory.

···

On 07/01/2020 20:34, Jody Garnett wrote:

Why would you have one without the other?


Jody Garnett

On Fri, 20 Dec 2019 at 01:30, Niels Charlier <niels@anonymised.com> wrote:

Not so far, perhaps something to look into. It’s gotten more robust and usable but there is still room for improvement, definitely. One module, sure as long as people can still configure to have one without the other I guess.

On 17/12/2019 08:42, Jody Garnett wrote:

I personally like the module and would love to see those two (jdbcconfig/jdbcstore) combined. Have you and Steve considered making it an extension?


Jody Garnett

On Sun, 15 Dec 2019 at 11:40, Niels Charlier <niels@anonymised.com> wrote:

I use both modules in production and you can always ask me for advise. I use it in combination with hz-cluster.

I have been doing fixes and improvements over the past few years, so has Steve Ikeoka for the jdbcconfig part who I think uses it in production as well with hazelcast.

Kind Regards

Niels

On 13/12/2019 12:07, Peter Smythe wrote:

Thanks Jody, that was not immediately clear. I will follow your advice - next year.

And I’ll ask about your parting question.

Regards

Peter

On Fri, 13 Dec 2019 at 10:09, Jody Garnett <jody.garnett@anonymised.com> wrote:

JDBCConfig is not intended to be used in isolation, please use with JDBCStore (which saves configuration files, icons, fonts, and so on into the database as blobs).

Please note that both these modules are unsupported and are seeking interested parties to work on them. Is this something your organization is in position to do?


Jody Garnett

On Fri, 13 Dec 2019 at 08:50, Peter Smythe <gs@anonymised.com> wrote:

Hi all

We are using the JDBCConfig community module and everything is saved to the configured database. It works well when autoscaling multiple instances in AWS.

However, it appears as though the data/security/ directory is not part of the catalog that is saved to the database. When adding a new user, group or role, the XML files in the local data/security directory are updated.

Is this intentional or a bug? I don’t see any user configuration option to include/exclude parts of the catalog. Or does “catalog” exclude security?

Is there any way to use (or modify?) JDBCConfig to save users to the database?

Thanks

Peter


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:
- Earning your support instead of buying it, but Ian Turton: [http://www.ianturton.com/talks/foss4g.html#/](http://www.ianturton.com/talks/foss4g.html#/)
- The GeoServer user list posting guidelines: [http://geoserver.org/comm/userlist-guidelines.html](http://geoserver.org/comm/userlist-guidelines.html)

If you want to request a feature or an improvement, also see this: [https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer](https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer)

[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)


Geoserver-users mailing list

Please make sure you read the following two resources before posting to this list:

If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users