[mapserver-users] Connexion between Mapserver & MySql

[Till Adams]

Clement,

look on the mapserver homepage, I've sent a mysql/ovf howto document 
there last year. It describes step by step what to do.
http://mapserver.gis.umn.edu/docs/howto/debian-odbc-mysql

There is another one:
http://mapserver.gis.umn.edu/docs/howto/ogrmysql

Hope that helps!
Regards, Till

> Hi!
>
> I would like use Database data to print point on my map.
> I searched on the web and found the method to that.
> So, I have the following code in a .ovf file:
>
> -------------------------
>
>     
>
>         MYSQL:gpvfr,user=gpvfr2,password=********,host=localhost,port=3306,tables=terrain 
>         SELECT a.oaci, lat, 'long', nom FROM terrain t,airfields a WHERE a.oaci = t.oaci
>
>         EPSG:27582
>
>         wkbPoint
>         
>
>     
>  
> ---------------------------------
>
> And when I run ogrinfo on this file, I obtain:
>
> -----------------------
> ERROR 1: MySQL connect failed for: gpvfr,user=gpvfr2,password=31p87qr2,host=localhost,port=3306,tables=terrain;airfields
> Access denied for user 'gpvfr2'@'localhost' (using password: YES)
> FAILURE:
> Unable to open datasource `var/www/html/ms/map_files/mysql.ovf' with the following drivers.
>   -> ESRI Shapefile
>   -> MapInfo File
>   -> UK .NTF
>   -> SDTS
>   -> TIGER
>   -> S57
>   -> DGN
>   -> VRT
>   -> REC
>   -> Memory
>   -> BNA
>   -> CSV
>   -> GML
>   -> GPX
>   -> KML
>   -> GeoJSON
>   -> GMT
>   -> SQLite
>   -> MySQL
>   -> AVCBin
>
> ----------------------
>
> I'm sure of the connexion informations and MySql is installed on my system and GDAL library has been built with ogr option.
>
> Where is the problem?
>
> Thanks for your help and sorry for my English, I'm frenchy :)
> Sincerely yours
> Clement
>
> _________________________________________________________________
> Découvrez les profils Messenger de vos amis !
> http://home.services.spaces.live.com/_______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>   


-- 
----------------------------------------------------------
terrestris GmbH & Co. KG
Irmintrudisstrasse 17
53111 Bonn
Germany

Till Adams
Geschäftsführung

Tel: +49 (0)228 / 962 899-52
Fax: +49 (0)228 / 962 899-57
adams at terrestris.de http://www.terrestris.de
Amtsgericht Bonn, HRA 6835
---------------------------------------------------------

Komplementärin:

terrestris Verwaltungs GmbH

vertreten durch:
Hinrich Paulsen, Till Adams