[Geoserver-users] Problem with using PostgreSQL as an authentication provider

I’m trying to setup system where I can use PostgreSQL to store all roles, users, groups, etc. related information and then use same users to login.

I have followed the tutorial, I’m able to add new users to database table, I can even see the users and the encrypted passwords in db, but I’m not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com

Hi,
thinking out loud, did you just configure the authentication provider you
created?
That is not enough, it needs to be put among the enabled ones in the
provider chain (just below the authentication providers list).

See also this tutorial:
https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <krishnaglodha@anonymised.com>
wrote:

I’m trying to setup system where I can use PostgreSQL to store all roles,
users, groups, etc. related information and then use same users to login.

I have followed the tutorial, I’m able to add new users to database table,
I can even see the users and the encrypted passwords in db, but I’m not
able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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

--

Regards, Andrea Aime

== 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.*

I can confirm this is what we have done successfully. I also missed the
step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the Provider
Chain.
!image.png|743x478
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <andrea.aime@anonymised.com>
wrote:

Hi,
thinking out loud, did you just configure the authentication provider you
created?
That is not enough, it needs to be put among the enabled ones in the
provider chain (just below the authentication providers list).

See also this tutorial:
https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <krishnaglodha@anonymised.com>
wrote:

I’m trying to setup system where I can use PostgreSQL to store all roles,
users, groups, etc. related information and then use same users to login.

I have followed the tutorial, I’m able to add new users to database
table, I can even see the users and the encrypted passwords in db, but I’m
not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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

--

Regards, Andrea Aime

== 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.*
_______________________________________________
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

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope this
will make it clear.
IMG 1 - setting up filter chain
!image.png|743x478
IMG 2 - Setting up user and groups in postgres table
!IMG 1.png|1636x558
IMG 3 - Setting up roles in postgres table
!IMG 2.png|1496x1374
IMG 4 - Changing default role service to role service from Postgres
!IMG 3.png|1076x1376

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 2:16 AM Vera Green <vera.green.ca@anonymised.com> wrote:

I can confirm this is what we have done successfully. I also missed the
step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the Provider
Chain.
!IMG 4.png|776x710
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <andrea.aime@anonymised.com>
wrote:

Hi,
thinking out loud, did you just configure the authentication provider you
created?
That is not enough, it needs to be put among the enabled ones in the
provider chain (just below the authentication providers list).

See also this tutorial:
JDBC Authentication Provider — GeoServer Training

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <krishnaglodha@anonymised.com>
wrote:

I’m trying to setup system where I can use PostgreSQL to store all
roles, users, groups, etc. related information and then use same users to
login.

I have followed the tutorial, I’m able to add new users to database
table, I can even see the users and the encrypted passwords in db, but I’m
not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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:
Earning Your Support Instead of Buying it
- The GeoServer user list posting guidelines:
User group posting guidelines

If you want to request a feature or an improvement, also see this:
Successfully requesting and integrating new features and improvements in GeoServer · geoserver/geoserver Wiki · GitHub

Geoserver-users@lists.sourceforge.net
geoserver-users List Signup and Options

--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit
GeoSolutions Enterprise Support Services 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 x.com
------------------------------------------------------- *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.*
_______________________________________________
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:
Earning Your Support Instead of Buying it
- The GeoServer user list posting guidelines:
User group posting guidelines

If you want to request a feature or an improvement, also see this:
Successfully requesting and integrating new features and improvements in GeoServer · geoserver/geoserver Wiki · GitHub

Geoserver-users@lists.sourceforge.net
geoserver-users List Signup and Options

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope this
will make it clear.
IMG 1 - setting up filter chain
IMG 2 - Setting up user and groups in Postgres table
IMG 3 - Setting up roles in Postgres table
IMG 4 - Changing default role service to role service from Postgres

Please check the drive for images
https://drive.google.com/drive/folders/1OE6bVn9ccyld5bJq19hdJe_foywMH5f0?usp=sharing

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 9:30 AM krishna lodha <krishnaglodha@anonymised.com>
wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope this
will make it clear.
IMG 1 - setting up filter chain
!image.png|743x478
IMG 2 - Setting up user and groups in postgres table
!IMG 1.png|1636x558
IMG 3 - Setting up roles in postgres table
!IMG 2.png|1496x1374
IMG 4 - Changing default role service to role service from Postgres
!IMG 3.png|1076x1376

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 2:16 AM Vera Green <vera.green.ca@anonymised.com>
wrote:

I can confirm this is what we have done successfully. I also missed the
step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the Provider
Chain.
!IMG 4.png|776x710
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <andrea.aime@anonymised.com>
wrote:

Hi,
thinking out loud, did you just configure the authentication provider
you created?
That is not enough, it needs to be put among the enabled ones in the
provider chain (just below the authentication providers list).

See also this tutorial:
JDBC Authentication Provider — GeoServer Training

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <krishnaglodha@anonymised.com>
wrote:

I’m trying to setup system where I can use PostgreSQL to store all
roles, users, groups, etc. related information and then use same users to
login.

I have followed the tutorial, I’m able to add new users to database
table, I can even see the users and the encrypted passwords in db, but I’m
not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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:
Earning Your Support Instead of Buying it
- The GeoServer user list posting guidelines:
User group posting guidelines

If you want to request a feature or an improvement, also see this:
Successfully requesting and integrating new features and improvements in GeoServer · geoserver/geoserver Wiki · GitHub

Geoserver-users@lists.sourceforge.net
geoserver-users List Signup and Options

--

Regards, Andrea Aime

== GeoServer Professional Services from the experts! Visit
GeoSolutions Enterprise Support Services 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 x.com
------------------------------------------------------- *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.*
_______________________________________________
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:
Earning Your Support Instead of Buying it
- The GeoServer user list posting guidelines:
User group posting guidelines

If you want to request a feature or an improvement, also see this:
Successfully requesting and integrating new features and improvements in GeoServer · geoserver/geoserver Wiki · GitHub

Geoserver-users@lists.sourceforge.net
geoserver-users List Signup and Options

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

When you "test connection" does it work?

Vera

On Thu., Feb. 25, 2021, 5:12 a.m. krishna lodha, <krishnaglodha@anonymised.com>
wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope this
will make it clear.
IMG 1 - setting up filter chain
IMG 2 - Setting up user and groups in Postgres table
IMG 3 - Setting up roles in Postgres table
IMG 4 - Changing default role service to role service from Postgres

Please check the drive for images
https://drive.google.com/drive/folders/1OE6bVn9ccyld5bJq19hdJe_foywMH5f0?usp=sharing

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 9:30 AM krishna lodha <krishnaglodha@anonymised.com>
wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope this
will make it clear.
IMG 1 - setting up filter chain
!image.png|743x478
IMG 2 - Setting up user and groups in postgres table
!IMG 1.png|1636x558
IMG 3 - Setting up roles in postgres table
!IMG 2.png|1496x1374
IMG 4 - Changing default role service to role service from Postgres
!IMG 3.png|1076x1376

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 2:16 AM Vera Green <vera.green.ca@anonymised.com>
wrote:

I can confirm this is what we have done successfully. I also missed the
step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the Provider
Chain.
!IMG 4.png|776x710
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <
andrea.aime@anonymised.com> wrote:

Hi,
thinking out loud, did you just configure the authentication provider
you created?
That is not enough, it needs to be put among the enabled ones in the
provider chain (just below the authentication providers list).

See also this tutorial:
https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <krishnaglodha@anonymised.com>
wrote:

I’m trying to setup system where I can use PostgreSQL to store all
roles, users, groups, etc. related information and then use same users to
login.

I have followed the tutorial, I’m able to add new users to database
table, I can even see the users and the encrypted passwords in db, but I’m
not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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

--

Regards, Andrea Aime

== 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.*
_______________________________________________
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

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

If the test connection is working you should be able to log into geoserver
as a PG user now.

To help you resolve further issues you'll have to provide details about
what part is not working for you. It seams you have established the
connection correctly.

Vera

On Thu., Feb. 25, 2021, 7:49 a.m. krishna lodha, <krishnaglodha@anonymised.com>
wrote:

Still not working :frowning:
If it's not too much trouble, we can jump on a quick call if possible.

On Thu, Feb 25, 2021 at 8:18 PM Vera Green <vera.green.ca@anonymised.com>
wrote:

Okay awesome.
So your issue is resolved now?
Or what is not working?
Vera

On Thu., Feb. 25, 2021, 7:46 a.m. krishna lodha, <krishnaglodha@anonymised.com>
wrote:

yes, the test connection works, and I also can see the new users/
groups/ roles when I add them in db

On Thu, Feb 25, 2021 at 8:07 PM Vera Green <vera.green.ca@anonymised.com>
wrote:

When you "test connection" does it work?

Vera

On Thu., Feb. 25, 2021, 5:12 a.m. krishna lodha, <
krishnaglodha@anonymised.com> wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope
this will make it clear.
IMG 1 - setting up filter chain
IMG 2 - Setting up user and groups in Postgres table
IMG 3 - Setting up roles in Postgres table
IMG 4 - Changing default role service to role service from Postgres

Please check the drive for images
https://drive.google.com/drive/folders/1OE6bVn9ccyld5bJq19hdJe_foywMH5f0?usp=sharing

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 9:30 AM krishna lodha <krishnaglodha@anonymised.com>
wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope
this will make it clear.
IMG 1 - setting up filter chain
!image.png|743x478
IMG 2 - Setting up user and groups in postgres table
!IMG 1.png|1636x558
IMG 3 - Setting up roles in postgres table
!IMG 2.png|1496x1374
IMG 4 - Changing default role service to role service from Postgres
!IMG 3.png|1076x1376

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 2:16 AM Vera Green <vera.green.ca@anonymised.com>
wrote:

I can confirm this is what we have done successfully. I also missed
the step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the
Provider Chain.
!IMG 4.png|776x710
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <
andrea.aime@anonymised.com> wrote:

Hi,
thinking out loud, did you just configure the authentication
provider you created?
That is not enough, it needs to be put among the enabled ones in
the provider chain (just below the authentication providers list).

See also this tutorial:
https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <
krishnaglodha@anonymised.com> wrote:

I’m trying to setup system where I can use PostgreSQL to store all
roles, users, groups, etc. related information and then use same users to
login.

I have followed the tutorial, I’m able to add new users to
database table, I can even see the users and the encrypted passwords in db,
but I’m not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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

--

Regards, Andrea Aime

== 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.*
_______________________________________________
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

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

OIC. I think you disabled connection from geoserver with your step 4: IMG
4 - Changing default role service to role service from Postgres

You want to keep that as it was so a geoserver user can log in. I think
what you did is allowing ONLY PG users.

Vera

On Thu., Feb. 25, 2021, 7:57 a.m. krishna lodha, <krishnaglodha@anonymised.com>
wrote:

Currently, I can log in if I user credentials "postgres:postgres" , which
are credentials for the postgres. But If I create a new user via geoserver
e.g. (new_user:new_password) , these credentials will go and seat in the
Users table in Postgres, but I won't be able to use them to login in
geoserver, although If I create new Postgres user
with new_user:new_password, then I will be able to login in geoserver.
That means, only people who can login in Postgres are able to login in
geoserver

On Thu, Feb 25, 2021 at 8:23 PM Vera Green <vera.green.ca@anonymised.com>
wrote:

If the test connection is working you should be able to log into
geoserver as a PG user now.

To help you resolve further issues you'll have to provide details about
what part is not working for you. It seams you have established the
connection correctly.

Vera

On Thu., Feb. 25, 2021, 7:49 a.m. krishna lodha, <krishnaglodha@anonymised.com>
wrote:

Still not working :frowning:
If it's not too much trouble, we can jump on a quick call if possible.

On Thu, Feb 25, 2021 at 8:18 PM Vera Green <vera.green.ca@anonymised.com>
wrote:

Okay awesome.
So your issue is resolved now?
Or what is not working?
Vera

On Thu., Feb. 25, 2021, 7:46 a.m. krishna lodha, <
krishnaglodha@anonymised.com> wrote:

yes, the test connection works, and I also can see the new users/
groups/ roles when I add them in db

On Thu, Feb 25, 2021 at 8:07 PM Vera Green <vera.green.ca@anonymised.com>
wrote:

When you "test connection" does it work?

Vera

On Thu., Feb. 25, 2021, 5:12 a.m. krishna lodha, <
krishnaglodha@anonymised.com> wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope
this will make it clear.
IMG 1 - setting up filter chain
IMG 2 - Setting up user and groups in Postgres table
IMG 3 - Setting up roles in Postgres table
IMG 4 - Changing default role service to role service from Postgres

Please check the drive for images
https://drive.google.com/drive/folders/1OE6bVn9ccyld5bJq19hdJe_foywMH5f0?usp=sharing

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 9:30 AM krishna lodha <
krishnaglodha@anonymised.com> wrote:

Hi Vera and Andrea,
Thanks for your reply,
I have attached all the steps that I have followed till now. Hope
this will make it clear.
IMG 1 - setting up filter chain
!image.png|743x478
IMG 2 - Setting up user and groups in postgres table
!IMG 1.png|1636x558
IMG 3 - Setting up roles in postgres table
!IMG 2.png|1496x1374
IMG 4 - Changing default role service to role service from Postgres
!IMG 3.png|1076x1376

Please let me know if any other settings need to be changed.

On Thu, Feb 25, 2021 at 2:16 AM Vera Green <vera.green.ca@anonymised.com>
wrote:

I can confirm this is what we have done successfully. I also
missed the step of adding to the provider chain at first.
Make sure to add the PG authentication ABOVE the default in the
Provider Chain.
!IMG 4.png|776x710
Hope this helps,
Vera

On Tue, Feb 23, 2021 at 9:01 AM Andrea Aime <
andrea.aime@anonymised.com> wrote:

Hi,
thinking out loud, did you just configure the authentication
provider you created?
That is not enough, it needs to be put among the enabled ones in
the provider chain (just below the authentication providers list).

See also this tutorial:
https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html

Cheers
Andrea

On Thu, Feb 18, 2021 at 5:45 AM Krishnaglodha <
krishnaglodha@anonymised.com> wrote:

I’m trying to setup system where I can use PostgreSQL to store
all roles, users, groups, etc. related information and then use same users
to login.

I have followed the tutorial, I’m able to add new users to
database table, I can even see the users and the encrypted passwords in db,
but I’m not able to login using those credentials.

What can be wrong?

Thank you,
Krishna G. Lodha
http://krishnaglodha.com
_______________________________________________
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

--

Regards, Andrea Aime

== 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.*
_______________________________________________
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

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com

--
Thank you,
Krishna G. Lodha
http://krishnaglodha.com