[Mapserver-users] Re: VirtualSpatialData (OGR Connectiontype)

Thu Jan 22 15:48:30 PST 2004

Heryk,

If the connection is ok, as ogrinfo seems to suggest, I think the  
likely error is in the format of the SrcLayer entry. Your ogrinfo  
output is just the table name. If you enter

ogrinfo file.ovf tablename

you should get the table contents and you can see whether the geometry  
fields are coming through as you have specified them.

One other possibility is that the environment variables set in your  
shell and available to ogrinfo are not available to the mapserver cgi.  
I saw this problem in connecting to an oracle database on a linux  
system. I'm not sure if this applies to IIS but it's relevant for  
apache.

zak
--
Zak James
Applications and Software Development
DM Solutions Group Inc.
http://www.dmsolutions.ca

On Jan 22, 2004, at 5:46 PM, Arthur, John wrote:

> I just wanted you all to know that Héryk is not alone.  I too, am  
> having the
> exact same issue.  Works fine with ogrinfo, but not with MapServer.  I  
> only
> have one version of gdal11.dll, so there should be no issues there.
>
> Could the problem be that the precompiled version that DM provides, was
> compiled against a different version of gdal than what is provided by  
> the
> OpenEV_FW_163.zip?  Because the gdal11.dll contained in mapserver zip  
> is
> different that the version in the OpenEV_FW_163.zip.
>
> -----Original Message-----
> From: Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
> Sent: Thursday, January 22, 2004 4:59 PM
> To: 'spencer at dmsolutions.ca'
> Cc: 'Normand Savard'; 'Frank Warmerdam';
> 'Mapserver-users at lists.gis.umn.edu'; Anctil, Martin
> Subject: RE: [Mapserver-users] Re: VirtualSpatialData (OGR
> Connectiontype)
>
>
> Hi,
> Yes the ovf file works with ogrinfo.
> Martin checked the gdal11.dll and that does not seem to be the problem.
>
>
> D:\WebScripts\MapServer>ogrinfo
> D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf
> ERROR 4: Update access not supported for VRT datasources.
> Had to open data source read-only.
> INFO: Open of
> `D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'
> using driver `VRT' successful.
> 1: MGWI_TBLLOC (Point)
>
>
> As suggested, I'll "return to my mapfile"!
>
> I now have a new understanding of one of the Virtual Spatial Data
> prerequisites: "that you are not afraid to figure things out"!!
>
> (http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData)
>
> :-/
>
> Héryk
>
> -----Message d'origine-----
> De : Paul Spencer [mailto:pagameba at magma.ca]
> Envoyé : Thursday, January 22, 2004 3:09 PM
> À : Julien, Heryk
> Cc : 'Mapserver-users at lists.gis.umn.edu'
> Objet : Re: [Mapserver-users] Re: VirtualSpatialData (OGR
> Connectiontype)
>
>
> Does the ovf file work with ogrinfo?  That is the first place to start
> because it will give you more detailed debugging information.  Once  
> that
> works, then you should return to the map file.  Until you can get the
> ovf file to work with ogrinfo, you are not going to get useful  
> debugging
> information because MapServer will continue to tell you that it can't
> draw the layer with misleading information.
>
> BTW, one other thing to check .. gdal11.dll may appear in multiple
> places in your system and you may not be using the one you think you
> are.  Search your system for this file and make sure they are all the
> same, or that you are certain that mapserver is using the right one.
>
> Cheers,
>
> Paul
>
> Julien, Heryk wrote:
>
>> Hi Norm,
>> That was a cut and paste error in my email.
>> The virtual file is okay: mgwi.ovf
>>
>> I tried the mapfile LABELITEM suggestion:" may need to use table.name  
>> or
>> just name depending on your OVF file".
>>
>> I also tried a relative and absolute CONNECTION in the mapfile.
>>
>> I keep on getting the following message:
>> msDrawMap(): Image handling error. Failed to draw layer named
> 'MGWI_TBLLOC'.
>>
>> msOGRFileOpen(): OGR error. Open failed for OGR connection
>> `D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'.  
>> File
> not
>> found or unsupported format.
>>
>>
>> Héryk
>>
>>
>>
>> -----Message d'origine-----
>> De : Normand Savard [mailto:nsavard at dmsolutions.ca]
>> Envoyé : Thursday, January 22, 2004 1:48 PM
>> À : Julien, Heryk
>> Cc : 'spencer at dmsolutions.ca'; 'Frank Warmerdam';
>> 'Mapserver-users at lists.gis.umn.edu'; Anctil, Martin
>> Objet : Re: [Mapserver-users] Re: VirtualSpatialData (OGR
>> Connectiontype)
>>
>>
>> Julien,
>>
>> What is the exact name of your "ovf" file?  Because the name you
>> specified in the "CONNECTION" parameter in the map file does not match
>> the one given for you "ovf" file.
>>
>> See in your email below:  "Here is my virtual file (mgw.ovf):"
>>
>> See your "CONNECTION" parameter into your map file for your specific
>> virtual layer:
>>
>> ...
>> CONNECTIONTYPE OGR
>> CONNECTION "mgwi.ovf"
>>
>> ...
>>
>> Norm
>>
>>
>> Julien, Heryk wrote:
>>
>>
>>> Hi to all,
>>>
>>> I replaced my version of Mapserver with a precompiled one. I also
> installed
>>> the latest  version of gdal11.dll and ogrinfo from the OpenEV_FW zip.
>>>
>>> As suggested by Frank Warmerdam I used the following SrcDataSource  
>>> tag in
>>> the virtual file:
>>> <SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource>. MGWI_MAPSERVER  
>>> is the
>>> DSN for my ODBC data source.
>>>
>>> Here is the orginfo output:
>>>
>>> D:\WebScripts\MapServer>ogrinfo --formats
>>> Loaded OGR Format Drivers:
>>> -> "ESRI Shapefile" (read/write)
>>> -> "UK .NTF" (readonly)
>>> -> "SDTS" (readonly)
>>> -> "TIGER" (read/write)
>>> -> "S57" (read/write)
>>> -> "MapInfo File" (read/write)
>>> -> "DGN" (read/write)
>>> -> "VRT" (readonly)
>>> -> "AVCBin" (readonly)
>>> -> "REC" (readonly)
>>> -> "Memory" (read/write)
>>> -> "GML" (read/write)
>>> -> "ODBC" (read/write)
>>> -> "OGDI" (readonly)
>>> -> "FMEObjects Gateway" (readonly)
>>>
>>> D:\WebScripts\MapServer>ogrinfo
>>> D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf
>>> ERROR 4: Update access not supported for VRT datasources.
>>> Had to open data source read-only.
>>> INFO: Open of
>>> `D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'
>>> using driver `VRT' successful.
>>> 1: MGWI_TBLLOC (Point)
>>>
>>> When I execute Mapserver I got the following message:
>>> msDrawMap(): Image handling error. Failed to draw layer named
>>
>> 'MGWI_TBLLOC'.
>>
>>> msOGRFileOpen(): OGR error. Open failed for OGR connection  
>>> `mgwi.ovf'.
> File
>>> not found or unsupported format.
>>>
>>>
>>>
>>> Thanks for the help
>>>
>>> Héryk
>>>
>>>
>>>
>>> -----Message d'origine-----
>>> De : Normand Savard [mailto:nsavard at dmsolutions.ca]
>>> Envoyé : Wednesday, January 21, 2004 5:26 PM
>>> À : Julien, Heryk
>>> Cc : 'spencer at dmsolutions.ca'; 'Mapserver-users at lists.gis.umn.edu';
>>> Anctil, Martin
>>> Objet : Re: [Mapserver-users] Re: VirtualSpatialData (OGR
>>> Connectiontype)
>>>
>>>
>>> Julien,
>>>
>>> Just because I do not know all the steps you have done, can you tell  
>>> me
>>> if you were able to have some output form "ogrinfo" command?
>>>
>>> Norm
>>>
>>> Julien, Heryk wrote:
>>>
>>>
>>>
>>>
>>>> Hi Paul,
>>>> What do I write in the virtual file SrcDataSource tag when I log on  
>>>> a
>>>>
>>>>
>>>
>>> Access
>>>
>>>
>>>
>>>> db with no user restrictions and pass word?
>>>> I've tried the following combinations without success:
>>>>
>>>> <SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource>
>>>> <SrcDataSource>ODBC:@MGWI_MAPSERVER</SrcDataSource>
>>>> <SrcDataSource>ODBC:/@MGWI_MAPSERVER</SrcDataSource>
>>>> <SrcDataSource>ODBC:administor/@MGWI_MAPSERVER</SrcDataSource>
>>>> <SrcDataSource>ODBC:administeur/@MGWI_MAPSERVER</SrcDataSource>
>>>>
>>>> Thanks
>>>> Héryk
>>>>
>>>>
>>>> -----Message d'origine-----
>>>> De : Paul Spencer [mailto:pagameba at magma.ca]
>>>> Envoyé : Wednesday, January 21, 2004 1:43 PM
>>>> À : Julien, Heryk
>>>> Cc : 'spencer at dmsolutions.ca'; 'Mapserver-users at lists.gis.umn.edu';
>>>> Anctil, Martin
>>>> Objet : [Mapserver-users] Re: VirtualSpatialData (OGR  
>>>> Connectiontype)
>>>>
>>>>
>>>> I believe there is a limitation in the OGR OBDC connection that  
>>>> requires
>>>> that you provide a user name and password in the OVF file (I think  
>>>> that
>>>> is mentioned in the wiki also).
>>>>
>>>> Cheers,
>>>>
>>>> Paul
>>>>
>>>> Julien, Heryk wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> Hi,
>>>>> I'm trying out the Virtual Spatial Data procedure in MapServerWiki
>>>>> (http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData)  
>>>>> with
>>
>> IIS
>>
>>>>> and an Access 2000 ODBC connection.
>>>>>
>>>>> I keep on getting the following error message when I attempt ton  
>>>>> see my
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> map:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> msDrawMap(): Image handling error. Failed to draw layer named
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> 'MGWI_TBLLOC'.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> msOGRFileOpen(): OGR error. Open failed for OGR connection  
>>>>> `mgwi.ovf'.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> File
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> not found or unsupported format.
>>>>>
>>>>> Anyone can help me?
>>>>>
>>>>>
>>>>>
>>>>> Here is my virtual file (mgw.ovf):
>>>>>
>>>>> <OGRVRTDataSource>
>>>>>  <OGRVRTLayer name="MGWI_TBLLOC">
>>>>>      <SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource>
>>>>> 	<SrcLayer>tblloc</SrcLayer>
>>>>> 	<GeometryType>wkbPoint</GeometryType>
>>>>> 	<!-- LayerSRS>WGS84</LayerSRS !-->
>>>>> 	<GeometryField encoding="PointFromColumns" x="x" y="y"/>
>>>>>  </OGRVRTLayer>
>>>>> </OGRVRTDataSource>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> My virtual layer is in the same directory as my shapefiles:
>>>>>
>>>>> SHAPEPATH "d:\webcgcq\lcnp\mapserver_demo\maritimes\data\shp\geo83"
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Here is the section of my mapfile where I call my virtual layer:
>>>>>
>>>>> LAYER
>>>>> 	NAME "MGWI_TBLLOC"
>>>>> 	TYPE POINT
>>>>> 	CONNECTIONTYPE OGR
>>>>> 	CONNECTION "mgwi.ovf"
>>>>> 	DATA "MGWI_TBLLOC"
>>>>> 	STATUS DEFAULT
>>>>> 	LABELITEM "LOCID"
>>>>> 	PROJECTION
>>>>> 		"init=epsg:26920"
>>>>> 	END #projection
>>>>> 	CLASS
>>>>> 		SYMBOL 'circle'
>>>>> 		SIZE 8
>>>>> 		LABEL
>>>>> 			COLOR 132 31 31
>>>>> 			SHADOWCOLOR 218 218 218
>>>>> 			SHADOWSIZE 2 2
>>>>> 			TYPE TRUETYPE
>>>>> 			FONT arial-bold
>>>>> 			FORCE true
>>>>> 			SIZE 10
>>>>> 			POSITION auto
>>>>> 			PARTIALS FALSE
>>>>> 			MINDISTANCE 0
>>>>> 			BUFFER 2
>>>>> 		END # end of label
>>>>> 	    TEMPLATE
>>>>> "d: 
>>>>> \webcgcq\lcnp\mapserver_demo\maritimes\templates\field_capt_query.h 
>>>>> tm
> l
>>
>> "
>>
>>>>> 	END # CLASS
>>>>> END # LAYER
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ==========================================
>>>>> Héryk
>>>>> NRCan
>>>>>
>>>>> -----Message d'origine-----
>>>>> De : Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
>>>>> Envoyé : Wednesday, January 14, 2004 8:44 AM
>>>>> À : 'spencer at dmsolutions.ca'
>>>>> Cc : 'Mapserver-users at lists.gis.umn.edu'
>>>>> Objet : RE: TR: [Mapserver-users] MySQL and Mapserver
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> Héryk
>>>>>
>>>>> -----Message d'origine-----
>>>>> De : Paul Spencer [mailto:pagameba at magma.ca]
>>>>> Envoyé : Tuesday, January 13, 2004 5:00 PM
>>>>> À : Julien, Heryk
>>>>> Cc : 'Paul Spencer '; 'Mapserver-users at lists.gis.umn.edu'
>>>>> Objet : Re: TR: [Mapserver-users] MySQL and Mapserver
>>>>>
>>>>>
>>>>> Maybe you missed it?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0401/ 
>>>> msg00111.ht
> m
>>
>> l
>>
>>>>
>>>>
>>>>
>>>>
>>>>> Cheers,
>>>>>
>>>>> Paul
>>>>>
>>>>> Julien, Heryk wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Hi Paul,
>>>>>> Could you send me or post information on the "new format in
>>>>>> OGR to set up a virtual layer that can draw columns from any ODBC  
>>>>>> data
>>>>>> source and map two of the columns to x and y locations"?
>>>>>>
>>>>>> Thanks
>>>>>> Héryk
>>>>>>
>>>>>> -----Message d'origine-----
>>>>>> De : Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
>>>>>> Envoyé : Monday, January 05, 2004 9:23 AM
>>>>>> À : 'spencer at dmsolutions.ca'
>>>>>> Cc : 'Mapserver-users at lists.gis.umn.edu'
>>>>>> Objet : RE: [Mapserver-users] MySQL and Mapserver
>>>>>>
>>>>>>
>>>>>> Hi,
>>>>>> I am also very interseted in that fonction. I would like to be  
>>>>>> able to
>>>>>>
>>>>>>
>>>
>>> map
>>>
>>>
>>>
>>>>>> well positions from a database x and y colums. Would this permit  
>>>>>> me to
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>> have
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> an up to date point geometry layer which reflects the changes in  
>>>>>> my
> well
>>>>>> database? Can you send me more details?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> Héryk
>>>>>> NRCan
>>>>>>
>>>>>> -----Message d'origine-----
>>>>>> De : Paul Spencer [mailto:pagameba at magma.ca]
>>>>>> Envoyé : Saturday, January 03, 2004 4:28 PM
>>>>>> À : bartvde at xs4all.nl
>>>>>> Cc : mapserver-users at lists.gis.umn.edu
>>>>>> Objet : Re: [Mapserver-users] MySQL and Mapserver
>>>>>>
>>>>>>
>>>>>> Bart,
>>>>>>
>>>>>> if you are interested in point geometries only, there is a new  
>>>>>> format
> in
>>
>>
>>>>>> OGR to set up a virtual layer that can draw columns from any ODBC  
>>>>>> data
>>>>>> source and map two of the columns to x and y locations.  We've  
>>>>>> used it
>>>>>> for a couple of clients and it works very nicely.  If you are
> interested
>>
>>
>>>>>> I can send you more details.
>>>>>>
>>>>>> Cheers,
>>>>>>
>>>>>> Paul
>>>>>>
>>>>>> Bart van den Eijnden wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Hi list,
>>>>>>>
>>>>>>> I see in the history log that there has been some work done  
>>>>>>> recently
>>>>>>> (early December) by Attila on supporting MySQL 4.X for the MyGIS
>>>>>>> connector. Can it be used already?
>>>>>>>
>>>>>>> Also, is it possible to keep the geometries in shapefiles and use
>>>>>>> Mapserver JOINS to link to tables in MySQL?
>>>>>>>
>>>>>>> Thanks in advance for the info.
>>>>>>>
>>>>>>> Best regards,
>>>>>>> Bart
>>>>>>> _______________________________________________
>>>>>>> Mapserver-users mailing list
>>>>>>> Mapserver-users at lists.gis.umn.edu
>>>>>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> _______________________________________________
>>> Mapserver-users mailing list
>>> Mapserver-users at lists.gis.umn.edu
>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>> _______________________________________________
>>> Mapserver-users mailing list
>>> Mapserver-users at lists.gis.umn.edu
>>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>
>>>
>>
>>
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>>
>
> -- 
>   -----------------------------------------------------------------
> |Paul Spencer                           spencer at dmsolutions.ca    |
> |-----------------------------------------------------------------|
> |Applications & Software Development                              |
> |DM Solutions Group Inc                 http://www.dmsolutions.ca/|
>   -----------------------------------------------------------------
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>