oracle spatial
Daniel Goetz
madprof at GMX.CH
Wed Jun 14 07:01:36 EDT 2006
Hi Jukka,
thank you again for your help. You think it should be possible to map differnt file-formats (shapefiles, oracle spatial, raster-data, etc.) at the same time even if you have changed the .dll files for orcale support?
The suggestions you made in your e-mail, that I should test a new, "untouched" installation of ms4w on another computer, i have already tested. I installed ms4w, tested some shapfiles and raster data and they worked. then I did the .dll swapping and neither the oracledata nor other file-formats work. I always get an apache-error-message. except for I point to a table that does not exist in the database in the DATA-experssion of the mapfile. then I get the mapserver-error-message you mentioned in your last email.
And yes, I testes the unsuccessful SQL (correcting the consciously wrong tablename_experssion) and it workes fine. Perhaps you can email me your mapfile, in which you point to an oracle spatial database. Perhaps I do a mistake in the mypfile. Would be very nice. Thank you for your endeavor and your time and your help.
regards
Daniel
-------- Original-Nachricht --------
Datum: Wed, 14 Jun 2006 13:25:58 +0300
Von: Rahkonen Jukka <Jukka.Rahkonen at MMMTIKE.FI>
An: MAPSERVER-USERS at LISTS.UMN.EDU
Betreff: Re: [UMN_MAPSERVER-USERS] oracle spatial
> Hi,
>
> There will be no problem with other data sources once you get it running.
> Try to eliminate one problem at a time. For example, if you should have a
> spare PC available, you could make a clean MS4W install. Try some shapefile
> and raster layers to see that they work before changing those two system
> files. After the change your mapfile should still work. After that you may
> add your Oracle layer. Did you already try the unsuccessful SQL directly?
>
> 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'
>
> -Jukka-
>
>
> -----Alkuperäinen viesti-----
> Lähettäjä: Daniel Goetz [mailto:madprof at gmx.ch]
> Lähetetty: 14. kesäkuuta 2006 13:07
> Vastaanottaja: Rahkonen Jukka; MAPSERVER-USERS at LISTS.UMN.EDU
> Aihe: Re: Re: [UMN_MAPSERVER-USERS] oracle spatial
>
> Jukka,
>
> thank you again for your help and your tests.
>
> Now I have a general question: Is it not possible to map shapefile or
> raster data after swapping the .dll-files to get oracle spatial support. Do I
> have to paste the "old" libmap.dll in the cgi-bin folder before mapping
> shapefile (or other formats) again? I thought it is possible to map oracle
> spatial data and other file-formats (e.g. shapefiles) at the same time? Am I
> wrong with this assumption?
>
> Thank you for your answer and your help. May Thanks.
>
> regards
>
> Daniel
> -------- Original-Nachricht --------
> Datum: Wed, 14 Jun 2006 12:24:22 +0300
> Von: Rahkonen Jukka <Jukka.Rahkonen at MMMTIKE.FI>
> An: MAPSERVER-USERS at LISTS.UMN.EDU
> Betreff: Re: [UMN_MAPSERVER-USERS] oracle spatial
>
> > Hi,
> >
> > Yes, I made a test with a fresh installation and playing with those
> > two files is really enough to make Oracle available for me. Switching
> > back to the original libmap.dll does not effect the other layers, but
> > Oracle layer disappears, naturally. Rename it, restart Apache, and it
> > is back, even without closing the MapLab application in between. I
> > don't have any idea why .dll swapping harms your old projects.
> >
> > -Jukka-
> >
> >
> >
> >
> > -----Alkuperäinen viesti-----
> > Lähettäjä: UMN MapServer Users List
> > [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] Puolesta Daniel Goetz
> > Lähetetty: 14. kesäkuuta 2006 10:34
> > Vastaanottaja: MAPSERVER-USERS at LISTS.UMN.EDU
> > Aihe: Re: [UMN_MAPSERVER-USERS] oracle spatial
> >
> > 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"
> > > 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/raste
> > > r/ 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(43
> > > 30
> > > 00,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/raste
> > > r/
> > > 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/raste
> > > r/
> > > 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
>
> --
>
>
> "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
> Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
More information about the mapserver-users
mailing list