[mapserver-users] oraclespatial connect error
Yu-Hsin Chen
ychen@yorktel.com
Sat, 23 Feb 2002 10:16:14 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C1BC7D.08819FBC
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
I'm on Mandrake Linux ProSuite 8.0. Oracle is 8i 8.1.7 for Linux. I
can access my remote database through sqlplus or a perl cgi program
without problems. Mapserver was compiled with oraclespatial and the
path was pointing to the correct $ORACLE_HOME path.
I won't be able to try anything until Monday. So I will create a local
database to see if I at least can conquer the connect problem.
After that I'd have to work with the spatial issues. I'm not familiar
with Oracle spatial implementation. My need is simple: I'd like to be
able to retrieve locations from the database based on certain criteria
and plot them on the map. That's why in my original message I put the
'DATA' statement that way. I thought I could pull the latitude and
longitude data and plot them as circles (that's how I understood the
Mapserver reference manual) with that statement. If that's not the
case, Rod, I think I'll need assistance later.
Thanks.
Yu-Hsin
-----Original Message-----
From: Rodrigo Cabral
Sent: Sat 2/23/2002 8:20 AM
To: PARVILLERS; Yu-Hsin Chen
Cc: mapserver-users@lists.gis.umn.edu
Subject: Re: [mapserver-users] oraclespatial connect error
Which binary of mapserver are you using? Windows or Unix? -- just for
curiosity
Also, you could try to track the error by running sqlplus and trying to
connect to the database. You should get the same TNS error when you try
to
connect.
Rod.
----- Original Message -----
From: "PARVILLERS" <hugues@parvillers.com>
Sent: Saturday, February 23, 2002 4:40 AM
Subject: Re: [mapserver-users] oraclespatial connect error
Hello,
don't you have more than one Oracle install on your local server ? May
be
the
Oci don't look in the right tnsnames.ora file ?
Yu-Hsin Chen a =E9crit :
> Well, my problem is that the database is not on the local machine. I
> guess I could create the local database and test it out. If that is
> successful I can always create database link in Oracle to access the
> real data.
>
> Thanks for the tip on DATA. I will have more questions back on this
> item.
>
> Yu-Hsin
>
> -----Original Message-----
> From: Rodrigo Cabral
> Sent: Fri 2/22/2002 7:32 PM
> To: Yu-Hsin Chen; mapserver-users@lists.gis.umn.edu
> Cc:
> Subject: Re: [mapserver-users] oraclespatial connect error
>
> Your error means that the Oracle client cannot find the database
> (service)
> to connect. Try using simply 'username/password' for CONNECTION to see
> if
> the default service works.
>
> Also, your DATA statement is not going to work. 'circle' must be in
the
> select list. Like "circle from (select circle...)". BUT, why are you
> doing
> that? Try this:
>
> DATA "circle FROM room_geoloc"
> or
> DATA "circle FROM room_geoloc USING SRID <srid#>" if you have an srid
> number
> defined.
>
> Rod.
>
> ----- Original Message -----
> From: "Yu-Hsin Chen" <ychen@yorktel.com>
> To: <mapserver-users@lists.gis.umn.edu>
> Sent: Friday, February 22, 2002 4:04 PM
> Subject: [mapserver-users] oraclespatial connect error
>
> I've compiled mapserver 3.5 with oraclespatial option on my Mandrake
> Linux 8.0 with Oracle 8.1.7i. When I run sqlplus at Linux prompt I
can
> get to the database with un/pw@bis login. However, when I tried it
from
> a map file I get "msOCIConnect() in msOracleSpatialLayerOpen():
> OracleSpatial error. Error while trying to retrieve text for error
> ORA-12541" in my browser. ORA-12541 is "TNS:could not resolve service
> name".
>
> My map file looks like this:
>
> LAYER
> NAME "oracle"
> CONNECTIONTYPE oraclespatial
> CONNECTION 'un/pw@bis'
> DATA "circle from (select room_id, longitude, latitude from
> room_geoloc)"
> TYPE POINT
> STATUS ON
> ...
> ...
> END
>
> Thanks in advance to whoever can help me.
>
> Yu-Hsin Chen
>
>
------------------------------------------------------------------------
> Name: winmail.dat
> winmail.dat Type: application/ms-tnef
> Encoding: base64
------_=_NextPart_001_01C1BC7D.08819FBC
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
eJ8+Ig8PAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAMgAAAFJFOiBbbWFwc2VydmVyLXVz
ZXJzXSBvcmFjbGVzcGF0aWFsIGNvbm5lY3QgZXJyb3IAtRIBBYADAA4AAADSBwIAFwAKABAADgAG
ACABASCAAwAOAAAA0gcCABcACgAQAA4ABgAgAQEJgAEAIQAAAEQzNTFDNkI5Qzc3MEMxNDQ4Rjc4
NTE5QjJBNDJGOUU4ADEHAQOQBgCEEAAANwAAAAMANgAAAAAAQAA5ALyfgQh9vMEBHgA9AAEAAAAF
AAAAUkU6IAAAAAACAUcAAQAAADAAAABjPXVzO2E9IDtwPVlvcmt0ZWw7bD1ZVENNQUlMLTAyMDIy
MzE1MTYxNFotNDUyNAAeAEkAAQAAADIAAABSZTogW21hcHNlcnZlci11c2Vyc10gb3JhY2xlc3Bh
dGlhbCBjb25uZWN0IGVycm9yAAAAQABOAAAOq9JsvMEBHgBaAAEAAAAPAAAAUm9kcmlnbyBDYWJy
YWwAAAIBWwABAAAAPgAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJvZHJpZ28gQ2FicmFsAFNN
VFAAY2FicmFsQHlhZGF0YS5uZXQAAAACAVwAAQAAABcAAABTTVRQOkNBQlJBTEBZQURBVEEuTkVU
AAAeAF0AAQAAAA8AAABSb2RyaWdvIENhYnJhbAAAAgFeAAEAAAA+AAAAAAAAAIErH6S+oxAZnW4A
3QEPVAIAAAAAUm9kcmlnbyBDYWJyYWwAU01UUABjYWJyYWxAeWFkYXRhLm5ldAAAAAIBXwABAAAA
FwAAAFNNVFA6Q0FCUkFMQFlBREFUQS5ORVQAAB4AZgABAAAABQAAAFNNVFAAAAAAHgBnAAEAAAAS
AAAAY2FicmFsQHlhZGF0YS5uZXQAAAAeAGgAAQAAAAUAAABTTVRQAAAAAB4AaQABAAAAEgAAAGNh
YnJhbEB5YWRhdGEubmV0AAAAHgBwAAEAAAAuAAAAW21hcHNlcnZlci11c2Vyc10gb3JhY2xlc3Bh
dGlhbCBjb25uZWN0IGVycm9yAAAAAgFxAAEAAAAbAAAAAcG8a2PO9rrtmzlwQ/iaqhOtnVIeBwAE
DXZuAB4AcwABAAAAIgAAAG1hcHNlcnZlci11c2Vyc0BsaXN0cy5naXMudW1uLmVkdQAAAB4AdAAB
AAAAGQAAAFBBUlZJTExFUlM7IFl1LUhzaW4gQ2hlbgAAAAAeABoMAQAAAA0AAABZdS1Ic2luIENo
ZW4AAAAAHgAdDgEAAAAuAAAAW21hcHNlcnZlci11c2Vyc10gb3JhY2xlc3BhdGlhbCBjb25uZWN0
IGVycm9yAAAAAgEJEAEAAACZCQAAlQkAANkSAABMWkZ16HvJ5wMACgByY3BnMTI14jIDQ3RleAVB
AQMB908KgAKkA+MCAGNoCsBz8GV0MCAHEwKAD/MAUH8EVghVB7IRxQ5RAwEQxzL3BgAGwxHFMwRG
EMkS2xHT2wjvCfc7GL8OMDURwgxgzmMAUAsJAWQzNhFQC6bgIEknbSACIAXQAHCAZHJha2UgTAuA
EHV4IFADYFN1aQEOsCA4LjAuICByTx5AY2wecAQAH3Bp4R9xMS43IAIQBcAek7EfsUkgYwORANBj
B5BxBCBteSAYwARgH1FkimEBkWERICB0aANggHVnaCBzcWwLUMZ1BCAFsWEgcASQAyC0Y2cgkHAD
YAnAYR2wfwPwI9AIYAVAJbECYCLgc0sfsR4AcBEgcnYTIXf3I5Ah4ANwcAMQCYAmIyTB9SACcwqw
dAcxIiAeICPBzx5wKZEkMCgCcG8LgCmwdG5nI8BvKjMFoRjAYwEFQCRPUkFDTEWgX0hPTUUqcy4K
olcKhAqAIdB3AiAnBUBibx5wAaAgISuiciKwAHB52yPQK2J1K0EDIE0CICNA+nkfsVMrsC5xAxAl
URjA+yNQLwEgGFAh8AMgI0grsHsRICAxZiHBI1AygDIgc+cFQCHyBaBucQpQBcAr1NxubixSJrUt
q0EBgDVjfzRBHZAosBDwJ8Arki6Qcv5rKMQqQimGBAEKUCciHZL+biMAIQAmAAMQBzAn4Sji/x/l
OecoYCbxCfABkCmwAiB/JzIisDYAKKEgUQCQPVI6/zgzO7AeYSuhLvkYwC+gCJD/OKEykj3iBCAD
UiozI0cjgv8osB3RIlAAIAtxMfEfQQchfynzC1A7QSpBHbMqQgDAcJUfsVQ4AScEIHdoIrDXRCEi
oQWwaSWAbinRB4HYc2FnHnAh0HAmgSpCwCdEQVRBJyRAPcH/PYM35CgAMSIh0CZSJCA4IfkoMXVs
RQFL8AMgKkILYPkpsHR1AQAp8xhQK3BM9CcjQkTdKBJpcilSICj/N/JG0SZgB+Ah0DBwBIE0oN5v
BHAqMydoGMBmBJAJ8O8iUEYhHrAHQCk5RjRBSce/IaI0AFAlOzIr0yORLAfx/mRWYEsSC4A5MB2Q
MdE+g/8jkACQScFS4kzBBJAtq0aRh1cgJyAtull1LUgAkHcLkC3JLbQtXIIf4EfFTddIRFyDLbRG
A2E6DIJWcvtHsSuwQwGgHkAYoC3DBmAPAjBexAYQBUAyLzIzSWFQMDAU4Dg6HWFBCk1ZZW9exFBB
UlaESUws4FJTOyBa9ecSwCpQW1VDY17ERjEnlPYtJKBRIUA7sDSgJyAlgHknIHVtPhAJgAxwYBR1
XGJqLFFexT9RW2WdXa8pHTXWBJADYHItulcwIO8Q4C7gR+EvsW80AGWXIiA5GMAgeQhgMGBbMWc/
tCBXC4BkUKAks1UDAOZ4bxBcgCBqJKA7UWvGSmMIcW8AkHR5Ntts/HNvVmBugkvUL6IvcwDQ/zkw
KkJrky7gIrEwcAMAK3H/JFYqAy+wK2Rw9TXlK6UjRvUfsFlukXMmYUwBSIBI9PdIYAeARoBOBfB0
tEcACfD/bnNzpHcbLatWgS2rXIMf0Sdc/HAxXfwgImM4IiCsPGgkEDqRQAqxdjHB9VEhLihBPmAJ
YPIIcDEB+VZgRmVfwFNQL7FhYFZg8WGTNDo0YhhoBmjPad/zau9bf0hlMdBy0C26b2D/LrJugjiD
BGBuUTfxA6ACIP8ecB/mAIABkDHRHdFugQXA/zKUJ5VvEB4AIrAu8C20KkG9LbRPT5AjMC6jGFBv
OTDvRCEqQkexS4F0AIBH8AeB/i4pISEAKIGQoFo/ZEUk8dBcJ2U5RFIgXsAtyf4+byCLkVZgIqEm
tSBCN/P/QnsgUTsyRcUylADBMCF40f8dgJfGgjIEIEu2MgWbSCNH/yoDB5AFQJchJnFU2CBBl8bb
OoAiQ2ZL8CHGbEqxKCH/MhQjRzuwVyFEIR/lK6EiNf+Rl5ggMhEy1C2lg2WYIFnE9yEDKkIpsHAd
wkliIaMxs/+NSDVBNKBB0yOAdEFFw6E4/x9BNranl1r7p5dcj12dmCD/gNQfwF8vl/OD1B/AXoAg
kEdhQWFBYaI3OjMU4FD/YkWoAWLAsfEfwGP6Y9Bln/9mr5fVZRKzFobWuvWHX4hv/4l/rVyPonS0
B4AGIpmHH+X/IBAIkEoxIfE7M29BQmuXxuYoJ5IN4GUpl8YroXx230aAL7Fuwz70IrAnt9KUEm4v
CrAEEDkBZEmgIRJDgE9OTkVDVEnIYLszdaxnZsSHQoIBEGFL8P9UIcQUOPNaFqeXcqcFwEliv0m5
mqVfcCtlOQIfsCdPlP1JoG1wgi7xkxShV4uQLFLvuDIfsB6QHmEiT5RCFMPxS9IjT5Qu1NApIh+w
QvxVVFZgRwJuRZfGb2ArYf/KCCNQbxDFwqwiueaXxs3DOdMmRlItICLAUWBtX/NIgBhBYyKXxr5n
2W/aeyFv0FNJTkcGAFJJikSB8HMFEGQjPoHg/zPxjQcDkd8Sl8YesAbQBJD/1kcBEJwhfdanl324
rvx/D9uAGrGGImP6geF5EOAJ8G5AboA5IA6wbIMptbQ8v7c/uE6nl4PUtAGEjTKFh/wwNLUphse7
v7zPvd+nl48dkDihKEdtqDMuNSjP/SnRbwUwPfEdwiKhHgaXxu8elB+BO/sgs2kfsWyge0H/IdB1
QXW4BUAelCWxKGBLk38AcJyXecJ4DPXkMHDHYHe+QG0ABCAYUEfRH7FIUKD9QUFy1XL7A0ESPrE7
UQNhv5fGJQBGMZSkIdB5siInENhPQ0kIUDXzKFOAR0JrBBAf81MplEwxEBYwT30lIG4EwLnnBUuK
BB+wRf961ZTCdodA6A6zyBLy+h/Q5SywLQ4hNDHfcUdTssBfb3FY0R/BDAYgQiJ6gTrvS9Q7MhjA
csBsOKHEBeDH/3pB1RCnPT5RAweSwv/xP9Nz2E/40UFZY6CXxrrwTntiMC1AIikk20e68MhYVPxZ
UC1AKSsWn8jCxtD/hv4nFSjce9Or2pPfMFZgTZd/HaFM1gIq2pnVABUoF9NQqk/ecFQVKFNJgFTe
UH0NkE4VKLrw1NEjD5fkRRxORKc/qENEIWFkdv9YUzjSUJAAwqKTKlB14Egh/60vZA+nl7rwr4Ms
Hy0vLj93L04j+jDsTnpBP2D5kG57m+CUwC5OMSP5Mlm68lR+eQZwP2DqYD8wbMA90y+9BAAtk+Di
MDBfuvNFUuDPsjDPQT9g/tI2NIpvW7sCfTqAAAAAHgA1EAEAAAA9AAAAPDA1RDMxREQzNTI4NUQ0
NDg4NjEwRDhDMEMwOEY1OTYyMDkwQjkyQHl0Y21haWwueW9ya3RlbC5jb20+AAAAAB4ARxABAAAA
DwAAAG1lc3NhZ2UvcmZjODIyAAALAPIQAQAAAB8A8xABAAAAcAAAAFIARQAlADMAQQAgAFsAbQBh
AHAAcwBlAHIAdgBlAHIALQB1AHMAZQByAHMAXQAgAG8AcgBhAGMAbABlAHMAcABhAHQAaQBhAGwA
IABjAG8AbgBuAGUAYwB0ACAAZQByAHIAbwByAC4ARQBNAEwAAAALAPYQAAAAAEAABzBWKaaZe7zB
AUAACDBwZIYIfbzBAQMA3j/kBAAAAwDxPwkAAAAeAPg/AQAAAA0AAABZdS1Ic2luIENoZW4AAAAA
AgH5PwEAAABcAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPVlPUktURUwvT1U9RklS
U1QgQURNSU5JU1RSQVRJVkUgR1JPVVAvQ049UkVDSVBJRU5UUy9DTj1ZQ0hFTgAeAPo/AQAAABUA
AABTeXN0ZW0gQWRtaW5pc3RyYXRvcgAAAAACAfs/AQAAAB4AAAAAAAAA3KdAyMBCEBq0uQgAKy/h
ggEAAAAAAAAALgAAAAMA/T/kBAAAAwAZQAAAAAADABpAAAAAAAMAHUAAAAAAAwAeQAAAAAAeADBA
AQAAAAYAAABZQ0hFTgAAAB4AMUABAAAABgAAAFlDSEVOAAAAHgAyQAEAAAASAAAAY2FicmFsQHlh
ZGF0YS5uZXQAAAAeADNAAQAAABIAAABjYWJyYWxAeWFkYXRhLm5ldAAAAB4AOEABAAAABgAAAFlD
SEVOAAAAHgA5QAEAAAACAAAALgAAAAsAKQAAAAAACwAjAAAAAAADAAYQ7o0p2AMABxDQCwAAAwAQ
EAAAAAADABEQAAAAAB4ACBABAAAAZQAAAElNT05NQU5EUkFLRUxJTlVYUFJPU1VJVEU4ME9SQUNM
RUlTOEk4MTdGT1JMSU5VWElDQU5BQ0NFU1NNWVJFTU9URURBVEFCQVNFVEhST1VHSFNRTFBMVVNP
UkFQRVJMQ0dJUFIAAAAAAgF/AAEAAAA9AAAAPDA1RDMxREQzNTI4NUQ0NDg4NjEwRDhDMEMwOEY1
OTYyMDkwQjkyQHl0Y21haWwueW9ya3RlbC5jb20+AAAAAJM6
------_=_NextPart_001_01C1BC7D.08819FBC--