Jukka It seems I celebrated too soon.....although this now succeeds:
~# ogrinfo mysql:testDB,user=root,password=mysql,port=3306 ...when I try to create an ovf file like so: <OGRVRTDataSource> <OGRVRTLayer name="testLayer"> <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 get the error "Unable to open datasource 'var/www/vhosts/mysite/httpdocs/OGR_test.ovf' with the following drivers." This is followed by the list of drivers which includes MySQL. Something wrong in my ovf file? Chris -----Original Message----- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Chris Green Sent: 22 June 2011 08:29 To: 'Rahkonen Jukka'; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Mapserver layer - MySQL connection Jukka You are a genius -it worked! Thanks -----Original Message----- From: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] Sent: 22 June 2011 08:26 To: Chris Green; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Mapserver layer - MySQL connection Hi, Try first by removing the space characters after separating commas. -Jukka Rahkonen- ________________________________________ Lähettäjä: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] käyttäjän Chris Green [chris.gr...@ibstv.co.uk] puolesta Lähetetty: 22. kesäkuuta 2011 10:12 Vastaanottaja: mapserver-users@lists.osgeo.org Aihe: [mapserver-users] Mapserver layer - MySQL connection Hi all Im using Mapserver 6.0 and I have GDAL 1.8.0 installed, running under Ubuntu 10.04. I am trying to make a connection from a layer to MySQL, following the guidance given in the MySQL section of Mapserver documentation. My problem is that when I try to connect using ogrinfo like: ~# ogrinfo mysql:testDB, user=root, password=mysql, port=3306 I get a mySQL connect failure message ERROR 1: MySQL connect failed for: testDB, Access denied for userroot@localhost (using password: NO) It seems that MySQL is refusing this connection request because the password that I entered in the ogrinfo command is not being passed to MySQL and I cant find a way to overcome this. The same user name and password work fine if I access MySQL directly rather than via ogrinfo. Does anyone have an idea what my problem is? Chris _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users