[mapserver-users] Connection to Mysql 5.0

[Νίκος Παπαδάκης]

O/H Fawcett, David έγραψε:
> Nikos, 
>
> Is it possible that MapServer is using a different ogr binary than the
> one that you are hitting from the command line.  This is really a
> question for the MS4W people and not you, I guess.  
>
> One possible reason that you are having this problem would be if
> MapServer was compiled with a different ogr than the one that you are
> hitting with your commandline and the one that MapServer is using wasn't
> compiled with MySQL support.  
>
> I am guessing that the MS4W maintainers could prove or destroy this
> theory pretty quickly...
>
> David.
>
> -----Original Message-----
> From: mapserver-users-bounces at lists.osgeo.org
> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of
> nipapada at gmail.com
> Sent: Tuesday, August 12, 2008 10:00 AM
> To: mapserver-users at lists.osgeo.org
> Subject: [mapserver-users] Connection to Mysql 5.0
>
>
> Hello to everyone!
>
> i have a problem in implementing the example i found in 
> http://mapserver.gis.umn.edu/docs/howto/ogrmysql.
> I want to project some points on the map.
> I have created the .ovf file and the database i want to access with some
>
> appropriate data.
> I have also created a user and granted it with all privileges. (GRANT
> ALL ON 'dbase_name'.* to 'user'@localhost identified by 'password');
>
> When i use command prompt to connect to mysql with ogrinfo.exe 
> everything goes fine!
> (ogrinfo.exe -al 
> MYSQL:my_db,user='user',password='password',host=localhost,port=3306,tab
> les=points;).
> The results i get are information about the table contained in database 
> and the contents of the selected table.
>
> Next i run  ogrinfo.exe -al /path/to/ovf_file.ovf   and again i get the 
> result i expected..
> (except from the warning
> "ERROR 4: Update access not supported fow VRT datasources
> Had to open data source in read-only" which is fine according to the 
> example!).
>
> But when i use the .ovf file through the .map file ,and after a few 
> seconds,i get the message :
>
>
>   /Internal Server Error/
>
> /The server encountered an internal error or misconfiguration and was 
> unable to complete your request./
>
> /Please contact the server administrator, admin at local.domain and inform 
> them of the time the error occurred, and anything you might have done 
> that may have caused the error./
>
> /More information about this error may be available in the server error 
> log./
>
>
> Can anyone help me becuse i'm stuck with this.
> Is it preferable to access mysql with php\mapscript instead?
>
> And if yes,is there any informative tutorial???
>
> Thank you in advance!
> Nikos Papadakis.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>   
Well. The ogrinfo i am using is installed with mapserver 
(ms4w-2.2.7-setup.exe).
and the ogrinfo.exe is in C:\ms4w\tools\gdal-ogr.
So i guess that mapserver is using the same binary...

Anyway,i hope i get an answer !!!
Thank you.