Import Data unable to connect to and create PostGIS DataStore

Description

When going through Import Data screen to connect to a postgis database, create a new workspace, and create a new store it comes back with `No data to import was found` and the following logs:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 06 Mar 11:34:46 ERROR [geoserver.importer] - Failed to init the context java.io.IOException: Unable to find data store for specified parameters at org.geoserver.importer.Database.prepare(Database.java:60) at org.geoserver.importer.Importer.addTasks(Importer.java:472) at org.geoserver.importer.Importer.init(Importer.java:440) at org.geoserver.importer.Importer.init(Importer.java:425) at org.geoserver.importer.Importer.createContext(Importer.java:369) at org.geoserver.importer.Importer$3.callInternal(Importer.java:387) at org.geoserver.importer.Importer$3.callInternal(Importer.java:384) at org.geoserver.importer.Importer$SecurityContextCopyingJob.call(Importer.java:992) at org.geoserver.importer.job.Job.call(Job.java:16) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

This only effects importer:

  • Table imported into PostGIS using QGIS DBManager,

  • Manually creating a PostGIS store and publishing the table works

  • Importer works to publish a local shapefile (creating a new shapefile store)

  • Import works to publish a local shapefile (importing into manually created PostGIS store)

Environment

Confirmed on Ubuntu and Liniux against PostGIS 2.5 / PostgreSQL 9.6

Status

Assignee

Andrea Aime

Reporter

Jody Garnett

Triage

Fix versions

Affects versions

2.15.0

Components

Priority

Medium
Configure