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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 12, 2008 10:00 AM To: mapserver-users@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, [EMAIL PROTECTED] 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@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