[Geoserver-users] PostGIS troubles

Greetings,

My environment is Geoserver 1.3.3 with Java-BEA 1.4.2 on RHEL 4.4 x86-64. I am attempting to connect geoserver with my PostGIS database and spew all of my data out via geoserver, hehe :slight_smile:

I'm having trouble getting going...

I have a simple view of a point data table. I added the entry to the geometry_columns like the docs suggest. Geoserver seems to configure everything okay....

When I ask for a WMS GetMap with PNG output, I get a blank image with no errors appearing on the server.

When I ask for KML output, I get this error:

http://rafb.net/paste/results/HD3WUv34.html

btw,

http://docs.codehaus.org/display/GEOS/Latest

the link to geoserver-1.4-M1-bin.tar.gz is actually the zip file

Any help would be appreciated :slight_smile:
   daryl

--
/**
  * Daryl Herzmann, RHCE
  * Program Assistant -- Iowa Environmental Mesonet
  * http://mesonet.agron.iastate.edu
  */

Could you try a WFS request? That's generally the easiest to debug. KML's relatively new, so common errors can be harder to recognize.

Also can you get things working on using a real table instead of a view?

Chris

Daryl Herzmann wrote:

Greetings,

My environment is Geoserver 1.3.3 with Java-BEA 1.4.2 on RHEL 4.4 x86-64. I am attempting to connect geoserver with my PostGIS database and spew all of my data out via geoserver, hehe :slight_smile:

I'm having trouble getting going...

I have a simple view of a point data table. I added the entry to the geometry_columns like the docs suggest. Geoserver seems to configure everything okay....

When I ask for a WMS GetMap with PNG output, I get a blank image with no errors appearing on the server.

When I ask for KML output, I get this error:

http://rafb.net/paste/results/HD3WUv34.html

btw,

http://docs.codehaus.org/display/GEOS/Latest

the link to geoserver-1.4-M1-bin.tar.gz is actually the zip file

Any help would be appreciated :slight_smile:
   daryl

--
Chris Holmes
The Open Planning Project
http://topp.openplans.org

On Thu, 31 Aug 2006, Chris Holmes wrote:

Could you try a WFS request? That's generally the easiest to debug. KML's relatively new, so common errors can be harder to recognize.

Also can you get things working on using a real table instead of a view?

Thanks to the patient help of the folks on IRC. The problem was that I was connecting to the database as a user that did not have permissions to the spatial_ref_sys table.

grant select on spatial_ref_sys to geoserveruser;

has me cooking with gas now! thanks!

daryl