[postgis-users] PostGIS problems...

[strk]

gayathri wrote:
> Hi:
> I have been tring to solve this problem and have not been to identify the
> reasons yet...
> 
> Here's is what I have, 
> 
> My Postgres Database server is in my local domain and has postgresql
> installed in the /usr/share/pgsql/data ( A directory) I had created...
> instead of the /var/lib/pgsql/data
> 
> All the configuration files live here (pg_hba.conf, postgresql.conf...)
> 
> I have enable tcpip_sockets -true and set pg_hba.conf to allow my clients
> elsewhere (not in my domain) to access the DB server....
> 
> I am able to connect to my linux server through ODBC...do data
> transfer....etc.,
> 
> but, mapserver .map file will not be successful in seeing the Postgres
> server....
> 
> The postgis connection is given as,
> 
> CONNECTION "user=geopostgres password=***** dbname=ACCO_Data host=myserver
> port=5432"
> 
> It returns an error message,
> 
> "msPOSTGISLayerOpen(): Query error. Error parsing POSTGIS connection
> information. "
> 
> Any explanation to this behavior...Appreciate any help.
> thanks,
> Gayathri

Is the dbname really "ACCO_Data" or it is "acco_data" ?
The error messages of mapserver are often hard to understand,
and the Case of postgres identifier seem to be a BIG problem
for it ...

--strk;