[mapserver-users] oracle8.1.7 and mapserver
Yu-Hsin Chen
ychen@yorktel.com
Fri, 15 Nov 2002 12:15:29 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C28CCA.98B359A2
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Nida:
=20
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?
=20
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.
=20
Your map file looks OK if your counties is a table contain geom column =
which is of SDO_GEOMETRY data type.
=20
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! :(
=20
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
=20
where I have counties table with a column geom
=20
very anxious!
Regards
Nida.
=20
----- Original Message -----=20
From: Yu-Hsin Chen <mailto:ychen@yorktel.com> =20
To: nida Khan <mailto:nida@webstar.co.uk> ; =
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:
=20
You need to compile MapServer with oraclespacial.
=20
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.
=20
What web server are you using? You might need to modify the =
configuration a little.
=20
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.
=20
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,
=20
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!
=20
I would really appreciate if anyone can guide me to right documentation =
or just give me some codes!!!!
=20
Looking forward for your replies
=20
Regards
Nida.
=20
------_=_NextPart_001_01C28CCA.98B359A2
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=3D"Content-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><SPAN class=3D246590317-15112002><FONT face=3DArial color=3D#0000ff =
size=3D2>Nida:</FONT></SPAN></DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial color=3D#0000ff =
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 =
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 =
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 =
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 =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D246590317-15112002><FONT face=3DArial color=3D#0000ff =
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> =
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 =
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 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 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 =
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 6:29=20
AM<BR><B>To:</B> =
mapserver-users@lists.gis.umn.edu<BR><B>Subject:</B>=20
[mapserver-users] 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 idea=20
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></BODY></HTML>
------_=_NextPart_001_01C28CCA.98B359A2--