[mapserver-users] MySQL connection: so near, yet so far...

[Smith, Michael D ERDC-CRREL-NH]

Chris,

You'd want to set the projection in your vrt to the projection of the data
(4326). Also set the projection of your layer in mapserver to 4326.

Then set the projection of the map to 900913 to get Mapserver to reproject.

Mike


-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
Hanover, NH



On 6/22/11  10:16 AM, "Chris Green" <chris.green at ibstv.co.uk> wrote:

> Thanks Stephen
> 
> That was a useful pointer, I have the OGR connection working now. One
> remaining problem: the source data in my MySQL database is unprojected
> lat/lon, and I want to project to Google 900913.
> 
> It seems that it should be possible to get OGR to do this within the ovf
> file by including an SRS statement like <LayerSRS>EPSG:900913</LayerSRS>,
> but this doesn't work. Adding a projection statement to the layer doesn't
> help either.
> 
> Anyone know how to do this?
> 
> 
> 
> Chris 
> 
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Stephan Holl
> Sent: 22 June 2011 12:56
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] MySQL connection: so near, yet so far...
> 
> Hello Chris,
> 
> "Chris Green" <chris.green at ibstv.co.uk>, [20110622 - 12:17:35]
> 
>> I am trying to establish a MySQL connection to a Mapserver 6.0 layer
>> using OGR. After much trial and error (mostly error) I have got to the
>> point where I have an ovf file which I can test using ogrinfo, but
>> which I cannot make work in a layer.
>> 
>> My ovf file (OGR_test.ovf) is
>> 
>> <OGRVRTDataSource>
>>     <OGRVRTLayer name="OGR_test">
>> 
>> <SrcDataSource>mysql:testDB,user=root,password=mysql,port=3306,tables=
>> testTa
>> ble</SrcDataSource>
>>         <SrcSQL>SELECT City, Latitude, Longitude FROM
>> testTable</SrcSQL> <GeometryType>wkbPoint</GeometryType>
>>         <GeometryField encoding="PointFromColumns" x="Longitude"
>> y="Latitude"/>
>>     </OGRVRTLayer>
>> </OGRVRTDataSource>
>> 
>> I can successfully test this and see the data in testTable via:
>> 
>> ~# ogrinfo var/www/vhosts/mysite/httpdocs/data/OGR_test.ovf
>> 
>> 
>> However when I create a test layer I cannot establish the OGR
>> connection. I am trying with:
>> 
>> LAYER
>>   NAME "testLayer"
>>   STATUS DEFAULT
>>   TYPE POINT
>>   CONNECTIONTYPE OGR
>>   CONNECTION "OGR_test.ovf"
>>   DATA "OGR_test"
>>   CLASS
>>     NAME "MyClass"
>>     STYLE
>>       SYMBOL 'circle'
>>       SIZE 15
>>       COLOR 0 255 0
>>     END
>>   END
>> END
>> 
>> This produces an "internal server error".
>> 
>> I have also tried using an absolute path to OGR_test.ovf, still no
>> success. It seems that I have not got the CONNECTION and DATA
>> parameters right but after reading the MySQL and the OGR sections in
>> the Mapserver documentation many times I still can't figure out what
>> I'm doing wrong.
>> 
>> Can someone help?
> 
> Just a guess.
> 
> Make sure you have the exact same env-vars set for apache as you have set
> within the shell your ogrinfo-command works. Sometimes there can be a
> differnces there?
> 
> Best
> 
> Stephan
> 
> --
> Stephan Holl <stephan.holl at intevation.de> | Tel.: +49 (0)541-33 508 3663
> Intevation GmbH, Neuer Graben 17, 49074 OS  |  AG Osnabrück - HR B 18998
> Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
> 
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users