Hello all I must be missing a key step. I've set up a JDBC user/group service, and can see my users and groups in the Geoserver admin interface. I've set up JDBC authentication, and can successfully authenticate as a database user when using the JDBC auth "Test connection with user/password".
I've granted read permissions on a test workgroup and layer in it to ROLE_AUTHENTICATED. I've enabled WMS, but cannot connect to the WMS service from QGIS. I also cannot log in to the Geoserver admin interface with a JDBC user. This is maybe not surprising, as I've not give the user ADMIN or GROUP_ADMIN permissions. If I set up a JDBC role service and assign that role (as well as specifying the ADMIN and GROUP_ADMIN users), I am locked out of Geoserver admin completely (when I enable the JDBC role service). There are quite a few moving parts involved, and it's maybe not the easiest to describe or figure out on the mailing list, but any insight would be incredibly helpful. Many thanks Tom -- -- Sign up to our mailing list for updates on news, products, conferences, events and training Astun Technology Ltd, t:+44 1372 744 009 contact us online <https://www.astuntechnology.com/contact-us/> web: astuntechnology.com <https://www.astuntechnology.com/> twitter:@astuntech <https://twitter.com/astuntech> iShare - enterprise geographic intelligence platform <https://www.astuntechnology.com/cloud-products/ishare/> GeoServer, PostGIS and QGIS training <https://www.astuntechnology.com/training/> Support <https://www.astuntechnology.com/support/> Company registration no. 5410695. Registered in England and Wales. Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no. 864201149. _______________________________________________ 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#/ - The GeoServer user list posting guidelines: 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 Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
