[mapserver-users] Connection to Mysql 5.0

[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