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: [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
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.
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
