[Mapserver-users] Virtual Spatial Data

[Frank Warmerdam]

we wei wrote:
> Hi list,
>  
> I am working on a problem in connecting ODBC to postgresql from 
> mapserver.  I am using the suggestion from wiki, but i have a question 
> on the tip wiki provided though. 
>  
> It mentioned that we need to configure the apache by
> 1.Enable mod_env 
> 2.add lines like: setenv ORACLE_HOME /path/ 
> 3.restart apache
>  
> I am not quite sure about step 2.  What is the variable ORACLE_HOME and 
> the "path" refer to?  In my case I am using Postgresql, so what should 
> be the environment variable's name ? and what will be the path it is 
> related to ? Will the path mean the folder has the postgresql driver 
> installed or the folder that the postgresql installed ?

We Wei,

If you are using Postgresql you don't need to set the ORACLE_HOME environment
variable. That was just one example of the sort of stuff you might need to do.
You likely don't need to set any environment variables for Postgres.

You do need to ensure that ODBC access to the database works for the user that
MapServer will run as (nobody, www-data, or an apache user or something like that).
You might test this by running the unix odbc client as the web user.

eg.

su
Password: <root password>
su - www-data
isql <your_dsn>

Or it may work differently for you.  The point is, it is up to you to first
ensure that ODBC access is working before you start using OGR and MapServer.

Best regards,

-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent