Adam Salach ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=62778c5cea6ca00069722401 ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) / Bug ( https://osgeo-org.atlassian.net/browse/GEOS-10485?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) GEOS-10485 ( https://osgeo-org.atlassian.net/browse/GEOS-10485?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) Importer extension error during importing table - permission denied ( https://osgeo-org.atlassian.net/browse/GEOS-10485?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) Issue Type: Bug Assignee: Unassigned Attachments: image-20220508-092905.png Created: 08/May/22 11:33 AM Environment: geoserver 2.20.2 Priority: Medium Reporter: Adam Salach ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=62778c5cea6ca00069722401 ) Hi, I’m using Geoserver Importer extension to load multiple PostGIS tables into geoserver. I definied connection to PostGIS db and it works fine. I see the list of all tables in specific schema (“data”). ( https://osgeo-org.atlassian.net/secure/attachment/33872/33872_image-20220508-092905.png ) When i try to load the selected table i received the following error: java.io.IOException: Error occurred creating table at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:743) at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144) at org.geoserver.importer.Importer.loadIntoDataStore(Importer.java:1447) at org.geoserver.importer.Importer.doIndirectImport(Importer.java:1209) at org.geoserver.importer.Importer.run(Importer.java:1015) at org.geoserver.importer.Importer.runInternal(Importer.java:975) at org.geoserver.importer.Importer$3.callInternal(Importer.java:1055) at org.geoserver.importer.Importer$3.callInternal(Importer.java:1047) at org.geoserver.importer.Importer$SecurityContextCopyingJob.call(Importer.java:1091) at org.geoserver.importer.job.Job.call(Job.java:16) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for schema data Position: 14 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:735) ... 13 more The current user has already privilage to usage “data” schema. When I try to add this table in the standard way without using the Importer Extension, everything is ok. There are no permission errors . ( https://osgeo-org.atlassian.net/browse/GEOS-10485#add-comment?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10485#add-comment?atlOrigin=eyJpIjoiNjBhOTI0NDdjNjY3NDA2OWJkZjY4MDE4YmY2MDgyYTUiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100198- sha1:6a78b33 )
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
