Hi Mauro Thanks for your answers to this thread, all your information is correct :-)
Cheers Christian On Thu, Nov 6, 2014 at 3:56 PM, Mauro Bartolomeoli < [email protected]> wrote: > Hi Benito, > > 2014-11-06 15:44 GMT+01:00 Cosme Benito <[email protected]>: > >> Hi Mauro, >> >> Yes you are correct, I made that exact mistake and realized soon after >> that the Authentication did not work as I thought it would J >> >> >> >> I just tried the UserGroupService with a PostGIS database and it seems to >> work great. I didn’t actually try using the REST API but the users I >> create in the database seem to be immediately available on GeoServer. >> However when trying with a SQLite database it simply crashes L >> >> >> >> java.lang.RuntimeException: java.io.IOException: >> org.apache.commons.dbcp.SQLNestedException: Cannot create >> PoolableConnectionFactory (SQLite supports only TRANSACTION_SERIALIZABLE >> and TRANSACTION_READ_UNCOMMITTED.) >> > > As you say, I think SQLLite is not currently supported (or tested by > someone). > > >> >> >> I don’t mind this being the only Authentication Provider in GeoServer, >> this is acceptable and perfectly fine. I already have User/Role tables and >> being able to configure them on XML files would be a pretty good solution >> for me, can you point me into the correct file(s)? I can’t seem to be able >> to find them. >> > > The standard xml files are automatically created in the GeoServer > data_dir, in the security/usergroup/<name_of_your_service> subfolder when > you create a JDBC UserGroup service with standard options (from my > experience they seem to be created after the first attempt of usage, so not > exactly when you create the service). I include the standard ones as > attachments. To customize it for your needs you have to change the > users_dml.xml file (the other one is for tables creation, but in your case > the tables are already there). You have to restart Geoserver after updating > the file. > You may have problems with passwords, because you need to store them in > one of the encryption formats supported by GeoServer (or in plain text) to > work correctly. > > >> >> >> Thanks a lot, you have already helped a ton! >> >> Cosme Benito >> > > You are welcome. > > Mauro > > -- > == > GeoServer Professional Services from the experts! Visit > http://goo.gl/NWWaa2 for more information. > == > > Dott. Mauro Bartolomeoli > @mauro_bart > Senior Software Engineer > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > > 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. > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
