[Geoserver-users] JDBC authorization not creare users.

I try to make JDBC auth on Geoserver. I use this tutorial http://geoserver.geo-solutions.it/edu/en/security/index.html# .

I create Group, User and JDBC Provider.

My user login:pass postgres:postgres. But i cant login with this login:pass only with default PostgreSQL user - postgres:123456.

I try to create new user test_user:test but same can’t login with it. Whats can be wrong?

Geoserver 2.3.5

If you add a user you have to add the user

  1. to the user group service
  2. create a postgres user with the same name

Postgres is responsible for checking the password. A good practice is to create a new user group service without passwords and use this user group service.

Christian

···

On Wed, Aug 28, 2013 at 8:40 AM, Макс Кливер <dh0m0ch@anonymised.com> wrote:

I try to make JDBC auth on Geoserver. I use this tutorial http://geoserver.geo-solutions.it/edu/en/security/index.html# .

I create Group, User and JDBC Provider.

My user login:pass postgres:postgres. But i cant login with this login:pass only with default PostgreSQL user - postgres:123456.

I try to create new user test_user:test but same can’t login with it. Whats can be wrong?

Geoserver 2.3.5


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk


Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Please stay on the mailing list.

Can you send me a zip file containing the log file.

Christian

···

On Wed, Aug 28, 2013 at 10:13 AM, Макс Кливер <dh0m0ch@anonymised.com> wrote:

Yeah i write something wrong. When i says that create Group i mean Group Service.

In Geoserver logs and found this lines:

2013-08-28 14:07:08,633 WARN [geoserver.security] - JDBC connect error
org.springframework.security.authentication.AuthenticationServiceException: JDBC connect error

Caused by: org.postgresql.util.PSQLException: ???: ??? “new_user” ?? ??? ??? ??? (?? ???)

So Geoserver cant connect to PostgreSQL? But its take stores from POstgreSQL and when i create Provider and Group Service it’s says that Connection Successful.

Whats wrong?

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

On Wed, Aug 28, 2013 at 2:06 PM, Christian Mueller <christian.mueller@anonymised.com> wrote:

If you add a user you have to add the user

  1. to the user group service
  2. create a postgres user with the same name

Postgres is responsible for checking the password. A good practice is to create a new user group service without passwords and use this user group service.

Christian

On Wed, Aug 28, 2013 at 8:40 AM, Макс Кливер <dh0m0ch@anonymised.com.> wrote:

I try to make JDBC auth on Geoserver. I use this tutorial http://geoserver.geo-solutions.it/edu/en/security/index.html# .

I create Group, User and JDBC Provider.

My user login:pass postgres:postgres. But i cant login with this login:pass only with default PostgreSQL user - postgres:123456.

I try to create new user test_user:test but same can’t login with it. Whats can be wrong?

Geoserver 2.3.5


Learn the latest–Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk


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

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH