oracle spatial
Daniel Goetz
madprof at GMX.CH
Wed Jun 14 03:34:02 EDT 2006
Thanks Rahkonen for your reply,
you did the .dll swapping like described in the readme-file of the ms4w package and then just used the below mentioned connection string? That's all? But when I do this and test other .map-file porjects that have worked fine before the .dll swapping on my Computer (raster-data or shapefiles) I get an apache-error. In my opinion this means that after the .dll swapping my apache-server didn't work anymore the way it should.
Again: you simplya have copied the "libmap.dll" in the "Apache/cgi-bin/ignored-libmap/oracle10g/"-folder and pasted it in the "Apache/cgi-bin"-folder and then copied the "ogr_OCI.dll" from the "ms4w/gdalplugins/ignored"-folder and pasted it in the "ms4w/gdalplugins"-folder and then restarted apache? And then everything worked fine? You are sure you haven't done anything elese?
When I try this the apache server gives an erorr-message whether I try .mapfiles using oracle spatial data or shapefiles or anything else.
Thank you again Rahkonen. Perhaps you or anybody out there has an idea what to do in my case. Thank you for your help.
regards
Daniel
-------- Original-Nachricht --------
Datum: Wed, 14 Jun 2006 10:06:18 +0300
Von: Rahkonen Jukka <Jukka.Rahkonen at MMMTIKE.FI>
An: MAPSERVER-USERS at LISTS.UMN.EDU
Betreff: Re: [UMN_MAPSERVER-USERS] oracle spatial
> Hello,
>
> I can say only that I had no problem in connecting to my Oracle 9i
> database with MS4W installation. I did just the manouvres described in the
> readme-file, and did not set any new environment variables.
> My connection string is like:
>
> CONNECTIONTYPE ORACLESPATIAL
> CONNECTION "USER/PASSWD at DB.WORLD <mailto:USER/PASSWD at DB.WORLD> "
> DATA "GEOLOC FROM GIS_POLYGONS USING UNIQUE MSLINK"
>
> Have you tried to feed the SQL statement from the error message directly
> to SQL-Plus? Do you get results then? Is your spatial table OK for
> Mapserver? I do not know exactly what Mapserver needs, but for Geoserver there must
> exist a numerical primary key, spatial index and a correct entry in
> SDO_GEOM_METADATA. In my case if I can connect my data with Geoserver it is
> available for Mapserver as well.
>
> Good luck,
>
> -Jukka Rahkonen-
>
> ________________________________
>
> Lähettäjä: UMN MapServer Users List puolesta: Daniel Goetz
> Lähetetty: ti 13.6.2006 17:00
> Vastaanottaja: MAPSERVER-USERS at LISTS.UMN.EDU
> Aihe: Re: [UMN_MAPSERVER-USERS] oracle spatial
>
>
>
> Thanks Wim for your help,
>
> but the syntax in the command-line of the browser didn't bring the
> solution.
>
> Roundup:
> I have installed Oracle 10g Release 1 client on my computer. Then unzipped
> the latest ms4w package. Did teh .dll swapping for oracle spacial support
> like described in the redme-file of the ms4w-package.
> Then I wrote a mapfile using the native oracle spatial support of the
> mapserver (not the OGR-Support).
>
> MAP
> NAME "Nbg"
> #EXTENT 426666.49 466058.21 448321.44 490754.58
> EXTENT 433000 478000 434000 479000
> #SIZE 1400 1800
> SIZE 400 400
> SHAPEPATH "/ms4w/Apache/htdocs/raster/daten"
> IMAGETYPE PNG
> IMAGECOLOR 255 255 255
> UNITS METERS
> STATUS ON
> PROJECTION
> "init=epsg:4326"
> END
>
> WEB
> IMAGEPATH "c:\ms4w\Apache\htdocs\raster\tmp\"
> IMAGEURL "/raster/tmp/"
> TEMPLATE "test_template.html"
> END
>
>
> LAYER
> NAME "RWG"
> CONNECTIONTYPE OracleSpatial
> CONNECTION "username/password at service"
> DATA "GEOM FROM RWG_TBL USING SRID 82032"
> TYPE POINT
> STATUS ON
> PROJECTION
> "init=epsg:4326"
> END
> CLASS
> NAME "Punkte"
> STYLE
> OUTLINECOLOR 128 128 128
> COLOR 225 225 185
> END
> END
> END
>
> END
>
> Then I did some settings in the httpd.cong of the apache server like
> described in the "Using oracle spatial" howto. But I don't really know whether
> this was right. In the "ENV VARS" column I added the parameter:
>
> SetEnv ORACLE_HOME "c:/ora10gR1_client"
> SetEnv TNS_ADMIN "c:/ora10gR1_client/NETWORK/ADMIN"
> SetEnv PATH "c:/ora10gr1_client/bin"
>
> I saved this and restarted apache. Then I tried to map the oracle data via
> umn-mapserver. Therefor I wrote the following in my browser:
>
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_os_native.map&layers=all&mode=map
>
> Then I get a error-message from apache:
>
> "Internal Server Error.The server encountered an internal error or
> misconfiguration and was unable to complete your request."
>
> In the errorlog of the apache the following was logged:
>
> [Tue Jun 13 15:45:56 2006] [error] [client 127.0.0.1] Premature end of
> script headers: mapserv.exe
>
> But I don't know what this means. But when I consciously do some mistake
> in the DATA expression in the .mapfile (giving a tablename that does not
> exist in the database) I get the following error-message from the mapserver
> (and not the apache):
>
> msDrawMap(): Image handling error. Failed to draw layer named 'RWG'.
> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-00942:
> Tabelle oder View nicht vorhanden . Query statement: SELECT rownum, GEOM
> FROM RWG_TBL.g WHERE SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 82032,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(433000,478000,434000,479000)
> ),'querytype=window') = 'TRUE' . Check your data statement.
>
> So you can see that mapserver is able to connect to the database, because
> it says that the Table or View is not available.
> The really astonishing is that after doing the .dll swapping for oracle
> spatial support other mapserver-projects that have worked fine on my computer
> before the swapping cause the same appache error-message.
> Could anybody imagine what might be the problem? Might it be that
> mapserver and the version of my oracle client (10g Release 1) are not compiled
> against each other? Or is there another mistake I have done?
>
> Please help me. I would be very glad and thankful for any hint. Thank you
> so much.
>
>
> regards
>
> Daniel
>
>
> -------- Original-Nachricht --------
> Datum: Mon, 12 Jun 2006 20:08:22 +0200
> Von: Wim Blanken <w.blanken at geon.nl>
> An: \'Daniel Goetz\' <madprof at GMX.CH>
> Betreff: RE: [UMN_MAPSERVER-USERS] oracle spatial
>
> > Hello Daniel,
> >
> > I think your solution is simple. You have to specify &mode=map
> > on the commandline to make it work. If you don't mapserver needs a
> > template
> > to show the results of the cgi-call.
> >
> >
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_o
> > s_ogr.map&layers=all&mode=map
> >
> >
> > Regards
> >
> > Wim Blanken
> >
> >
> > -----Original Message-----
> > From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
> > Behalf Of Daniel Goetz
> > Sent: Monday, June 12, 2006 1:54 PM
> > To: MAPSERVER-USERS at LISTS.UMN.EDU
> > Subject: [UMN_MAPSERVER-USERS] oracle spatial
> >
> > Hi,
> >
> > I have the ms4w installed on my computer and I want to map geodata,
> lying
> > in
> > a oracle spatial database on a server in the intranet, via umn
> mapserver.
> > Therefor I enabled OGR-OCI support described in the readme-file of the
> > ms4w-package (I "installed" 10g oracle instant client on my computer,
> set
> > set windows environmet variable PATH and did the described .dll
> swapping).
> >
> > Then I tested, whether OGR now supports the OCI with ogrinfo. Therefor I
> > had
> > to modify the syntax a littel bit to get information: I wrote "ogrinfo
> > "OCI:username/password at host:port/service_name" instead of described on
> the
> > ogr-site/oracle spatial "OCI:username/password at service_name". The result
> > was
> > that ogrinfo listed me the relevant tables that contain geometric data.
> >
> > Then I tried to map the data via mapserver. Therefor I wrote the
> following
> > .map-file (therefor I correspond to the example given in the "Vector
> Data
> > Access-Reference-Guide" on the mapserver-site):
> >
> > MAP
> > NAME "Oracle"
> > EXTENT 426666.49 466058.21 448321.44 490754.58
> > SIZE 1400 1800
> > SHAPEPATH "/ms4w/Apache/htdocs/raster/daten"
> > IMAGETYPE PNG
> > IMAGECOLOR 255 255 255
> > UNITS METERS
> > STATUS ON
> > CONFIG "GDAL_DRIVER_PATH" "C:/ms4w/gdalplugins"
> >
> > WEB
> > IMAGEPATH "c:\ms4w\Apache\htdocs\raster\tmp\"
> > IMAGEURL "/raster/tmp/"
> > TEMPLATE "test_template.html"
> > END
> >
> > LAYER
> > CONNECTIONTYPE OGR
> > CONNECTION "OCI:username/password at service_name"
> > DATA "RWG_TBS"
> > NAME "RWG_TBS"
> > TYPE POLYGON
> > STATUS ON
> >
> > CLASS
> > NAME "Flaeche"
> > STYLE
> > OUTLINECOLOR 128 128 128
> > COLOR 225 225 185
> > END
> > END
> > END
> > END
> >
> >
> > The template I wrote therefor is very simple:
> >
> > <html>
> > <head>
> > <title>Erstes Beispiel zum UMN Mapserver</title>
> > </head>
> >
> > <body>
> > Mapserver-Version auslesen:<br><br>[version]<br><br><br>
> > Karte einbetten:<br><br>
> > <img src="[img]"><br>
> >
> > </body>
> > </html>
> >
> > And I tried to start mapping by writing the following in my browser:
> >
> >
> http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/raster/test_o
> > s_ogr.map&layers=all&
> >
> >
> > The result was, that mapserver brought the error-message:
> >
> > "mapserv(): Web application error. No template provided. "
> >
> > Then I tested some other mapserver-test-projects, for whom I know that
> > they
> > have worked properly on my computer before the mentioned .dll swapping
> for
> > OGR-OCI support. The result was the same:
> >
> > "mapserv(): Web application error. No template provided. "
> >
> >
> > So I have three questions:
> >
> > How should mapserver know where the database is located without giving
> him
> > any information about the host-address and the port-number. Where can I
> > provide this information for the mapserver. In the case of ogrinfo I did
> > this by writing "OCI:username/password at host:port/service_name". In the
> > .mpa-file example in the "Vector-Data-Reference-Guide" they say under
> > CONECTION you should type "OCI:username/password at service_name". Where is
> > the
> > information about the location of the database?
> >
> > Second questions is: Is anything wrong with my .map-file, html-template
> or
> > the starting-command in the web-browser?
> >
> > Third: And why do the other mapserver projects, I tested before .dll
> > swapping (for OGR-COI support), work anymore. Why do I always get the
> > error-message "mapserv(): Web application error. No template provided."
> > although I changed nothing on the .map-files, the template nor the
> > command.
> >
> > I would be very pleased and hayppy and thankful if anybody would help me
> > on
> > my problem. This would really be very nice. Thank you so much for your
> > endeavors.
> >
> > Regards
> >
> > Daniel
> >
> >
> > --
> >
> >
> > Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> > Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
> >
> >
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Free Edition.
> > Version: 7.1.394 / Virus Database: 268.8.3/361 - Release Date: 6/11/2006
> >
>
> --
>
>
> "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
> Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
--
"Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
More information about the mapserver-users
mailing list