[mapserver-users] oracle8.1.7 and mapserver
nida Khan
nida@webstar.co.uk
Fri, 15 Nov 2002 17:19:15 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_010E_01C28CCB.1F8BCAA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Again,
my counties table does have a sdo_geometry data type
here is desc of my table
SQL> desc counties
Name Null? Type
----------------------------------------- -------- =
----------------------------
GEOM MDSYS.SDO_GEOMETRY
COUNTY VARCHAR2(31)
FIPSSTCO VARCHAR2(5)
STATE VARCHAR2(30)
STATE_ABRV VARCHAR2(2)
FIPSST VARCHAR2(2)
LANDSQMI NUMBER
TOTPOP NUMBER
POPPSQMI NUMBER
I am wondering how mapserver knows where the database resides?=20
Where do I define my database connection parameters??
IS there any quick test to find out if mapserver is looking into right =
database?
My database is on remote machine and I'm running mapserver from my =
machine...
I also have oracle client on my machine talking to same database.
I heartly appreciate your help!
Kind Regards
Nida.
----- Original Message -----=20
From: Yu-Hsin Chen=20
To: nida Khan ; mapserver-users@lists.gis.umn.edu=20
Sent: Friday, November 15, 2002 5:15 PM
Subject: RE: [mapserver-users] oracle8.1.7 and mapserver
Nida:
Judging from your 'counties table with a column geom' it doesn't =
appear to me you're using Oracle Spacial option. You will need to have =
that option to work with MapServer. Is your 'geom' column of data type =
SDO_GEOMETRY?
You have to make sure Oracle Spacial option is in the database. By =
default, when spacial option is installed you'll have an MDSYS user id =
and schema associated with that user. If you don't see that, you'll =
have to install it first. You should have an 'md' directory under =
$ORACLE_HOME. Under md there is an admin directory which contains all =
installation scripts.
Your map file looks OK if your counties is a table contain geom column =
which is of SDO_GEOMETRY data type.
Yu-Hsin
-----Original Message-----
From: nida Khan [mailto:nida@webstar.co.uk]
Sent: Friday, November 15, 2002 9:48 AM
To: Yu-Hsin Chen; mapserver-users@lists.gis.umn.edu
Subject: Re: [mapserver-users] oracle8.1.7 and mapserver
I gave wrong example! :(
here is the right example
layer defination
LAYER
NAME counties
TYPE polygon
STATUS default
MAXSCALE 1000000
CONNECTIONTYPE oraclespatial
CONNECTION 'scott/tiger@PHAR'
DATA "GEOM from counties"
CLASS
NAME 'county'
COLOR 220 224 230
OUTLINECOLOR 0 0 0
END
END
where I have counties table with a column geom
very anxious!
Regards
Nida.
----- Original Message -----=20
From: Yu-Hsin Chen=20
To: nida Khan ; mapserver-users@lists.gis.umn.edu=20
Sent: Friday, November 15, 2002 1:34 PM
Subject: RE: [mapserver-users] oracle8.1.7 and mapserver
Nida:
You need to compile MapServer with oraclespacial.
Your Oracle RDBMS needs to have Spacial option loaded. Hopefully =
you've already got this part, it is a good learning curve if you havn't.
What web server are you using? You might need to modify the =
configuration a little.
Once you have all the correct environment and settings it WILL =
work. I'm running MapServer on a Mandrake Linux server accessing Oracle =
8.0.5 data on a UnixWare server through CGI.
Yu-Hsin
-----Original Message-----
From: nida Khan [mailto:nida@webstar.co.uk]
Sent: Friday, November 15, 2002 6:29 AM
To: mapserver-users@lists.gis.umn.edu
Subject: [mapserver-users] oracle8.1.7 and mapserver
Hi Everyone,
Is there anyway to connect to Oracle 8.1.7 database on Solaris =
via Mapserver?
I've compiled Mapserver with Postgress, but have no idea how to =
do it for Oracle now!
I would really appreciate if anyone can guide me to right =
documentation or just give me some codes!!!!
Looking forward for your replies
Regards
Nida.
------=_NextPart_000_010E_01C28CCB.1F8BCAA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi Again,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>my counties table does have a sdo_geometry data=20
type</FONT></DIV>
<DIV><FONT size=3D2>here is desc of my table</FONT></DIV>
<DIV><FONT size=3D2>SQL> desc=20
counties<BR> Name &nb=
sp; &nbs=
p;  =
; =20
Null? =
Type<BR> -----------------------------------------=20
--------=20
----------------------------<BR> GEOM &=
nbsp; &n=
bsp; &nb=
sp; &nbs=
p; =20
MDSYS.SDO_GEOMETRY<BR> COUNTY &nb=
sp; &nbs=
p;  =
; =
=20
VARCHAR2(31)<BR> FIPSSTCO &=
nbsp; &n=
bsp; &nb=
sp; =20
VARCHAR2(5)<BR> STATE  =
; =
&=
nbsp; &n=
bsp;=20
VARCHAR2(30)<BR> STATE_ABRV  =
; =
&=
nbsp; =20
VARCHAR2(2)<BR> FIPSST &nbs=
p;  =
; =
=
VARCHAR2(2)<BR> LANDSQMI &n=
bsp; &nb=
sp; &nbs=
p; =20
NUMBER<BR> TOTPOP &nb=
sp; &nbs=
p;  =
; =20
NUMBER<BR> POPPSQMI &=
nbsp; &n=
bsp; &nb=
sp; =20
NUMBER</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I am wondering how mapserver knows where the =
database resides?=20
</FONT></DIV>
<DIV><FONT size=3D2>Where do I define my database connection=20
parameters??</FONT></DIV>
<DIV><FONT size=3D2>IS there any quick test to find out if mapserver is =
looking=20
into right database?</FONT></DIV>
<DIV><FONT size=3D2>My database is on remote machine and I'm running =
mapserver=20
from my machine...</FONT></DIV>
<DIV><FONT size=3D2>I also have oracle client on my machine talking to =
same=20
database.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I heartly appreciate your help!</FONT></DIV>
<DIV><FONT size=3D2>Kind Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dychen@yorktel.com href=3D"mailto:ychen@yorktel.com">Yu-Hsin =
Chen</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dnida@webstar.co.uk=20
href=3D"mailto:nida@webstar.co.uk">nida Khan</A> ; <A=20
title=3Dmapserver-users@lists.gis.umn.edu=20
=
href=3D"mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.g=
is.umn.edu</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 15, 2002 =
5:15=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [mapserver-users]=20
oracle8.1.7 and mapserver</DIV>
<DIV><FONT size=3D2></FONT><BR></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Judging from your 'counties table with a column geom' it =
doesn't appear=20
to me you're using Oracle Spacial option. You will need to have =
that=20
option to work with MapServer. Is your 'geom' column of data =
type=20
SDO_GEOMETRY?</FONT></SPAN></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>You=20
have to make sure Oracle Spacial option is in the database. By =
default,=20
when spacial option is installed you'll have an MDSYS user id and =
schema=20
associated with that user. If you don't see that, you'll have to =
install=20
it first. You should have an 'md' directory under =
$ORACLE_HOME. =20
Under md there is an admin directory which contains all installation=20
scripts.</FONT></SPAN></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff size=3D2>Your=20
map file looks OK if your counties is a table contain geom column =
which is of=20
SDO_GEOMETRY data type.</FONT></SPAN></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Yu-Hsin</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> nida Khan=20
[mailto:nida@webstar.co.uk]<BR><B>Sent:</B> Friday, November 15, =
2002 9:48=20
AM<BR><B>To:</B> Yu-Hsin Chen;=20
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B> Re: =
[mapserver-users]=20
oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=3D2>I gave wrong example! :(</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>here is the right example</FONT></DIV>
<DIV><FONT size=3D2>layer defination</FONT></DIV>
<DIV><FONT size=3D2>LAYER<BR> NAME counties<BR> TYPE=20
polygon<BR> STATUS default<BR> MAXSCALE =
1000000<BR> =20
CONNECTIONTYPE oraclespatial<BR> CONNECTION <A=20
href=3D"mailto:'scott/tiger@PHAR'">'scott/tiger@PHAR'</A><BR> =
DATA "GEOM=20
from counties"<BR> CLASS<BR> NAME=20
'county'<BR> COLOR 220 224 =
230<BR> =20
OUTLINECOLOR 0 0 0<BR> END<BR> END</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>where I have counties table with a column=20
geom</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>very anxious!</FONT></DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- =
</DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Dychen@yorktel.com =
href=3D"mailto:ychen@yorktel.com">Yu-Hsin=20
Chen</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dnida@webstar.co.uk=20
href=3D"mailto:nida@webstar.co.uk">nida Khan</A> ; <A=20
title=3Dmapserver-users@lists.gis.umn.edu=20
=
href=3D"mailto:mapserver-users@lists.gis.umn.edu">mapserver-users@lists.g=
is.umn.edu</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 15, =
2002 1:34=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: =
[mapserver-users]=20
oracle8.1.7 and mapserver</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>You need to compile MapServer with=20
oraclespacial.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Your Oracle RDBMS needs to have Spacial option =
loaded. =20
Hopefully you've already got this part, it is a good learning =
curve if you=20
havn't.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>What web server are you using? You might need to =
modify the=20
configuration a little.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Once you have all the correct environment and settings it =
WILL=20
work. I'm running MapServer on a Mandrake Linux server =
accessing=20
Oracle 8.0.5 data on a UnixWare server through =
CGI.</FONT></SPAN></DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D545462213-15112002><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Yu-Hsin</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> nida Khan=20
[mailto:nida@webstar.co.uk]<BR><B>Sent:</B> Friday, November 15, =
2002=20
6:29 AM<BR><B>To:</B>=20
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B> =
[mapserver-users]=20
oracle8.1.7 and mapserver<BR><BR></FONT></DIV>
<DIV><FONT size=3D2>Hi Everyone,</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Is there anyway to connect to Oracle 8.1.7 =
database on=20
Solaris via Mapserver?</FONT></DIV>
<DIV><FONT size=3D2>I've compiled Mapserver with Postgress, but =
have no=20
idea how to do it for Oracle now!</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I would really appreciate if anyone can =
guide me to=20
right documentation or just give me some codes!!!!</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Looking forward for your =
replies</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Nida.</FONT></DIV>
=
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BO=
DY></HTML>
------=_NextPart_000_010E_01C28CCB.1F8BCAA0--