[postgis-users]CONNECTION to database thru Mapserver
Ethan Alpert
ealpert at digitalglobe.com
Mon Mar 14 15:19:05 PST 2005
Did you try what the error message says to try?
ie:
the_geom from spots using SRID=<your SRID>
or
the_geom from (select * from spots) as foo using unique oid using srid =
<your SRID>
The latter requires you to set up an oid index:
create INDEX spots_oid on spots (oid);
-e
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of w m
Sent: Monday, March 14, 2005 3:43 PM
To: PostGIS Users Discussion
Subject: RE: [postgis-users]CONNECTION to database thru
Mapserver
Thank You Doug and Ethan:)
The connection is fine now. there were some things that did
needed to be changed in the configuration files.
Now I get the error below. I did some search and I think that I
would have to upgrade postgis, is it true?
msDrawMap(): Image handling error. Failed to draw layer named
'Hotspots'.
prep_DB(): Query error. Error executing POSTGIS DECLARE (the
actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d()),'NDR'),OID::text from WHERE &&
setSRID('BOX3D(-73.992437 45.0227318333333,-73.174263
45.9772681666667)'::BOX3D, find_srid('','','') )'
Postgresql reports the error as 'ERROR: syntax error at or near
"WHERE" at character 104 '
More Help:
Error with POSTGIS data variable. You specified '<check your
.map file>'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique
<column name> using SRID=<srid#>'
Make sure you put in the 'using unique <column name>' and 'using
SRID=#' clauses in.
For more help, please see
http://postgis.refractions.net/documentation.php
Mappostgis.c - version of Jan 23/2004.
msPOSTGISLayerParseData(): Query error. Error parsing POSTGIS
data variable. Must contain 'geometry_column from table_name' or 'geom
from (subselect) as foo' (couldnt find ' from '). More help:
Error with POSTGIS data variable. You specified 'the_geom FROM
Hotspots'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique
<column name> using SRID=<srid#>'
Make sure you put in the 'using unique <column name>' and 'using
SRID=#' clauses in.
For more help, please see
http://postgis.refractions.net/documentation.php
Mappostgis.c - version of Jan 23/2004.
Ethan Alpert <ealpert at digitalglobe.com> wrote:
Maybe there's a case sensitivity problem. Try using all
lower case for your db name.
-e
-----Original Message-----
From:
postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of w m
Sent: Monday, March 14, 2005 2:33 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users]CONNECTION to
database thru Mapserver
the configuration files are fine and they allow
the connections....but still to no avail after changing STATUS to
DEFAULT i still get the same errors. if i change STATUS to ON i dont
see the points on the map but tehre are no errors.....
Doug_Newcomb at fws.gov wrote:
Wokar,
Check your postgresql.conf file to see
if you are allowing tcp/ip
connections and your pg_hba.conf file to
see if you are allowing
connections from 132.205.108.60
Doug
Doug Newcomb
USFWS
Raleigh, NC
919-856-4520 ext. 14
doug_newcomb at fws.gov
------------------------------------------------------------------------
---------------------------------
The opinions I express are my own and
are not representative of the
official policy of the U.S.Fish and
Wildlife Service or Dept. of Interior.
I left my signature file in /dev/null
|---------+--------------------------------------------->
| | w m |
| | Sent by: |
| | postgis-users-bounces at postgis.refr|
| | actions.net |
| | |
| | |
| | 03/14/2005 02:12 PM |
| | Please respond to PostGIS Users |
| | Discussion |
| | |
|---------+--------------------------------------------->
>-----------------------------------------------------------------------
----------------------|
| |
| To: PostGIS Users Discussion |
| cc: |
| Subject: Re: [postgis-users]CONNECTION
to database thru Mapserver |
>-----------------------------------------------------------------------
----------------------|
Thanks for your reply. when I changed my
STAUS to Default it gives me the
following error:
msDrawMap(): Image handling error.
Failed to draw layer named 'Hotspots'.
msPOSTGISLayerOpen(): Query error.
couldnt make connection to DB with
connect string 'user=project
password=test dbname=Montreal
host=132.205.108.60'.
Error reported was 'could not connect to
server: Connection refused Is the
server running on host "132.205.108.60"
and accepting TCP/IP connections on
port 5432? '.
This error occured whe n trying to make
a connection to the specified
postgresql server.
Most commonly this is caused by
(1) incorrect connection string
(2) you didnt specify a 'user=...' in
your connection string
(3) the postmaster (postgresql server)
isnt running
(4) you are not allowing TCP/IP
connection to the postmaster
(5) your postmaster is not running on
the correct port - if its not on 5432
you must specify a 'port=...'
(6) the security on your system does not
allow the webserver (usually user
'nobody') to make socket connections to
the post master
(7) you forgot to specify a 'host=...'
if the postmaster is on a different
machine
(8) you made a typo
My server is running, what I am not sure
is (4) and (5). Can you please
explain me how can I check the above.
Also the user name and password is
the user name and password for the
database right?
pram at pramcentral.com wrote:
----- Original Message -----
From: "w m"
To: "P ostGIS Users Discussion"
Subject: Re: [postgis-users]CONNECTION
to database thru Mapserver
Date: Mon, 14 Mar 2005 09:02:56 -0800
(PST)
>
> Thank You for your response.
> i made the changes that you suggested
but i still have no luck in
> displaying the points on the map. I'm
not sure if a connection is
> being established to the database or
not...how can i know that??
> and instead of local host i also tried
to insert the ip address of
> my server but it still didnt work nor
did i get any errors.
> any help would be appreciated greately
> thank you
> wokar
>
> LAYER
> CONNECTIONTYPE postgis
> NAME "Spots" # my table name
> CONNECTION "user=test password=test
dbname=MyDataBase host=localhost"
> DATA "the_geom FROM Spots" # the_geom
column from table Spots
> STATUS ON
> TYPE POINT
> CLASS
> COLOR 0 0 0
> OUTLINECOLOR 0 0 0
> SIZE 2
> END< BR>> ; END
>
Have you tried with STATUS DEFAULT
instead of STATUS ON
-Prashanth
--
HTMLX.com
Mapserver, Mapscript, PHP Hosting
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best
spam protection around
http://mail.yahoo.com
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources
site!
<http://us.rd.yahoo.com/evt=31637/*http://smallbusiness.yahoo.com/resour
ces/>
________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
<http://us.rd.yahoo.com/evt=31637/*http://smallbusiness.yahoo.com/resour
ces/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050314/43275d9d/attachment.html>
More information about the postgis-users
mailing list