GeoServer

Versioning installation problems

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 1.6.0
  • Fix Version/s: None
  • Component/s: PostGIS
  • Labels:
    None
  • Environment:
    Linux
  • Number of attachments :
    0

Description

Only installation instructions seem to be within the Versioning download, in data_dir/README.txt.

1. Instructions do not state that "spearfish" database must be converted from PostgreSQL to PostGIS.
2. When converting to PostGIS with the lwpostgis.sql script errors occur:
...
CREATE FUNCTION
lwpostgis.sql:1257: ERROR: unterminated quoted string at or near "'

BEGIN

EXECUTE ''SET local search_path = ''||$2||'',public'';"
LINE 12: AS '
^
lwpostgis.sql:1258: ERROR: syntax error at or near "RETURN"
LINE 3: RETURN public.build_histogram2d($1,$3,$4);
^
... etc.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Scot E. Wilcoxon added a comment -

Maybe a phpPgAdmin character set problem is involved in the quoted string error? The error happened when feeding lwpostgis.sql through phpPgAdmin as an uploaded script. Same error happened with the database as LATIN1 or as SQL_ASCII (which is mentioned within the spearfish sql).

The "spearfish" database was created successfully when using the command line psql command as a postgres superuser: first within the database using "CREATE LANGUAGE plpgsql", then adding postGIS to the database with: psql -d spearfish < /usr/share/postgresql-8.2-postgis/lwpostgis.sql

Show
Scot E. Wilcoxon added a comment - Maybe a phpPgAdmin character set problem is involved in the quoted string error? The error happened when feeding lwpostgis.sql through phpPgAdmin as an uploaded script. Same error happened with the database as LATIN1 or as SQL_ASCII (which is mentioned within the spearfish sql). The "spearfish" database was created successfully when using the command line psql command as a postgres superuser: first within the database using "CREATE LANGUAGE plpgsql", then adding postGIS to the database with: psql -d spearfish < /usr/share/postgresql-8.2-postgis/lwpostgis.sql
Hide
Permalink
Scot E. Wilcoxon added a comment -

The instructions mention WEB-INF, but that is not visible in the top level geoserver directory. Maybe geoserver/webapps/geoserver/WEB-INF/lib should be mentioned so the location under "webapps" is identified.

Show
Scot E. Wilcoxon added a comment - The instructions mention WEB-INF, but that is not visible in the top level geoserver directory. Maybe geoserver/webapps/geoserver/WEB-INF/lib should be mentioned so the location under "webapps" is identified.
Hide
Permalink
Scot E. Wilcoxon added a comment -

The instructions mention two items related to DATA_DIR but it is not apparent if methods geoserver/WEB-INF/web.xml and GEOSERVER_DATA_DIR must both be done or only one of the two.

Show
Scot E. Wilcoxon added a comment - The instructions mention two items related to DATA_DIR but it is not apparent if methods geoserver/WEB-INF/web.xml and GEOSERVER_DATA_DIR must both be done or only one of the two.
Hide
Permalink
Scot E. Wilcoxon added a comment -

Altering GEOSERVER_DATA_DIR in web.xml in the geoserver directory does not seem to cause other data_dir to be used. Something is wrong with data_dir instructions.

Show
Scot E. Wilcoxon added a comment - Altering GEOSERVER_DATA_DIR in web.xml in the geoserver directory does not seem to cause other data_dir to be used. Something is wrong with data_dir instructions.

People

  • Assignee:
    Andrea Aime
    Reporter:
    Scot E. Wilcoxon
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: