[mapserver-users] Mysql Ogr Error
Rahkonen Jukka (Tike)
jukka.rahkonen at mmmtike.fi
Sun Feb 16 05:49:53 PST 2014
Hi,
Error tells now that field "pangalan" is missing. You have gone further.
- Jukka-
________________________________
Lähettäjä: rkrojero<mailto:rkrojero at gmail.com>
Lähetetty: 16.2.2014 15:33
Vastaanottaja: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Aihe: Re: [mapserver-users] Mysql Ogr Error
regarding your suggestion on changing 'name' to something else I already Did
it.
Rahkonen Jukka (Tike) wrote
> What did you mean with that? Mapserver reads MySQL through GDAL so you
> should compile GDAL with MySQL and Mapserver with that GDAL. I am sorry if
> I am lost because I do not compile anything myself.
> For fixing the issue the first step is to get GDAL with MySQL support.
> Before you have such all other work you do is wasting everybody's time.
>
> I do not believe much in my theory of reserved keyword "name" but I have
> experienced something like that myself. If something works with v. 5.0
> does not guarantee that it works as such with v. 6.2. If, once you have a
> proper GDAL with MySQL and Mapserver with that GDAL, you still face a
> problem, I would recommend to have try escaping "name". It means 10
> seconds work for you to edit your mapfile and try. That is not much wasted
> time at all even if it had no effect at all.
>
> -Jukka Rahkonen-
Sorry I meant the compiled Gdal has --with-mysql on it. Yep will look for a
Gdal that has mysql support. I dont know where to start though.
Already checked the 'name' theory
I changed
> <OGRVRTDataSource>
>
> <OGRVRTLayer name="govtpoints">
>
> <SrcDataSource>
> MYSQL:mapresearch,user=devuser,password=devpassword,host=127.0.0.1,port=3306,tables=establishment
> </SrcDataSource>
>
> <SrcSQL>
> SELECT esname, longlat_x, longlat_y FROM establishment WHERE esname like
> "%Barangay%Hall%" AND layer_type = "GOVT"
> </SrcSQL>
>
> <GeometryType>
> wkbPoint
> </GeometryType>
>
> <GeometryField encoding="PointFromColumns" x="longlat_x" y="longlat_y" />
>
> </OGRVRTLayer>
> </OGRVRTDataSource>
even the .map
> LAYER
> NAME "govt"
> STATUS OFF
> CONNECTIONTYPE OGR
> CONNECTION "/home/mapserv/mapresearch/ovf/govt.ovf"
> DATA "govtpoints"
> TYPE POINT
> LABELITEM "pangalan"
> LABELMAXSCALEDENOM 3500
>
> CLASS
> SYMBOL "/usr/local/apache2/htdocs/symbols/govt.gif"
> SIZE 12
>
> LABEL
> COLOR 0 0 128
> TYPE TRUETYPE
> FONT arial
> SIZE 7
> MAXSIZE 7
> ANTIALIAS TRUE
> POSITION CR
> PARTIALS FALSE
> MINDISTANCE 300
> BUFFER 5
> FORCE FALSE
> OFFSET 5 0
> END
> END
> END
Yea same error occured
> msDrawMap(): Image handling error. Failed to draw layer named 'govt'.
> msOGRLayerInitItemInfo(): OGR error. Invalid Field name: pangalan
Next option is to look for a Gdal that supports mysql.
Im currently reading this one..
http://mapserver.org/input/vector/mysql.html
Thanks for your quick response. Will let you know how if this works. Thank
you very much
-karl
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mysql-Ogr-Error-tp5103949p5104059.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140216/d0482401/attachment.htm>
More information about the MapServer-users
mailing list