Re: [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: [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
[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,tables=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] Ogr connection to mysql.
Hi to everyone! I try to read data from mysql database and i follow the direction in this example. http://mapserver.gis.umn.edu/docs/howto/ogrmysql I have created a database and a table containing coordinate pairs according to the example and placed the .ovf file inside the directory defined in shapepath. but when i run mapserver ,after some seconds i get the following message: 500 Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. I run Mysql server 5.0. Any ideas? Thank you! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] ogrinfo failure.
Hi list. I have a problem running ogrinfo.exe. When i press enter i get the following message: This application has failed to start because gdal15.dll was not found.Re-installing the application may fix this problem. Well,i re-installed ms4w but the problem remains. Does anyone know where the error might be? Thank you in advance...! ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Shp file creation
I used shapelib and particulary the shpcreate tool to create an empty shape file and then shpadd to add entriew in it. But in this way i will have to enter all data manually! Is there any other way to generate it with a more automated way? Aldo,theese tools don't produce the required .dbf file. Only .shp and .shx files appear. ---BeginMessage--- O/H Atul Dravid έγραψε: Have you tried going through shapelib documentation ? Regards, Atul Dravid -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ? ?apad Sent: Monday, August 04, 2008 11:37 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Shp file creation. Hello to everyone. I want to ask about something that i have asked before but i could not find a solution. I have measured coordinates of some points in a city and i want to render them with mapserver. I have created a csv file with these values.. LONGITUTE,LATITUDE,DESCRIPTION,ADDRESS 22.561867,39.215857,Φοιτητική Λέσχη,null 22.57267,39.212835,Πανεπιστήμιο Θεσσαλιας,Κτήριο Παπαστράτος.,argonautwn 22.57070,39.212690,Caf?-Bar Drops.,argonautwn 22.565973,39.212715,Flocafe,argonautwn 22.565865,39.212754,Reef,argonautwn 22.565830,39.212776,Jam,argonautwn ........ ........ ........ Then i use a program found here ( http://www.softpedia.com/get/Programming/Other-Programming-Files/CSV-to-Shap efile-Converter.shtml ) to create the .shp, .shx and .dbf files. But as i said before i can get no points on the map. I have some other point data and they work just fine. So i guess the problem isn't in the map file but in the data. Can anyone find the problem? Thank you all for your time! Nikos Papadakis. Univercity of Thessaly. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users I used shapelib and particulary the shpcreate tool to create an empty shape file and then shpadd to add entriew in it. But in this way i will have to enter all data manually! Is there any other way to generate it with a more automated way? Aldo,theese tools don't produce the required .dbf file. Only .shp and .shx files appear. ---End Message--- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Shp file creation.
Hello to everyone. I want to ask about something that i have asked before but i could not find a solution. I have measured coordinates of some points in a city and i want to render them with mapserver. I have created a csv file with these values.. LONGITUTE,LATITUDE,DESCRIPTION,ADDRESS 22.561867,39.215857,Φοιτητική Λέσχη,null 22.57267,39.212835,Πανεπιστήμιο Θεσσαλιας,Κτήριο Παπαστράτος.,argonautwn 22.57070,39.212690,Caf?-Bar Drops.,argonautwn 22.565973,39.212715,Flocafe,argonautwn 22.565865,39.212754,Reef,argonautwn 22.565830,39.212776,Jam,argonautwn ........ ........ ........ Then i ue a program found here ( http://www.softpedia.com/get/Programming/Other-Programming-Files/CSV-to-Shapefile-Converter.shtml ) to create the .shp, .shx and .dbf files. But as i said before i can get no points on the map. I have some other point data and they work just fine. So i guess the problem isn't in the map file but in the data. Can anyone find the problem? Thank you all for your time! Nikos Papadakis. Univercity of Thessaly. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] XLS to shape file.
Hello to everyone. i would like to ask if someone knows how can i create a shape file with points from an xls .file. In .xls file i have written the coordinates of every point of interest in the form +39,2158 +22,5618 (latitude and longitude in diffirent columns). I also have written some other information for every point in different column. 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] loadWeb(): Unknown identifier. Parsing error near (:):(line 1)
Unfortunately the error insists. I have tried every advice you gave me but stiil nothing. All the modifications i did are: 1)Check the orientation of slashes and i actually tried every possible orientation. 2)Placed the MAP keyword in the first line of .map file. 3)Tried an older version of MapServer (although there is nothing different according to the site...). Perhaps i should try it on linux? Does it make any difference at all? *test.map* MAP NAME TEST!!! SIZE 400 300 IMAGECOLOR 249 245 186 IMAGETYPE png EXTENT -1.00 -1.00 1.00 1.00 WEB TEMPLATE C:\ms4w\Apache\htdocs\test.html IMAGEPATH C:\ms4w\Apache\htdocs\tmp IMAGEURL /tmp/ END LAYER STATUS default TYPE point FEATURE POINTS 0.0 0.0 END TEXT Hello World END CLASS STYLE COLOR 255 0 0 END LABEL TYPE bitmap END END END END *test.html *html headtitleMapServer Hello World/title/head body form method=POST action=/cgi-bin/mapserv.exe input type=submit value=Click input type=hidden name=MAP value=C:\ms4w\Apache\htdocs\test.map input type=hidden name=map_web value=imagepath C:\ms4w\Apache\htdocs\tmp\ imageurl /tmp/ /form IMG SRC=[img] width=400 height=300 border=0 /body /html * * ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] loadWeb(): Unknown identifier. Parsing error near (:):(line 1)
It works!!! Paths don't need C:/ in front! Thank you. O/H Robert Sanson έγραψε: hi Here is how I reference paths in Mapserver under Windows: # this is the real filepath to the temp dir for intermediate file creation IMAGEPATH /ms4w/tmp/ms_tmp/ THis works for me. Kind regards, Robert Sanson Guillaume Sueur [EMAIL PROTECTED] 21/05/2008 4:46 a.m. if you can, yes, have a try to linux. But this should work on Windows too. it's been a long time since I haven't used MapServer on Windows, but I remember having had problems with backslashes. Can you try doubling them (ie C:\\ms4w\\Apache\\htdocs\\test.html) Can you confirm it is still the exact same error (parsing error on line 1) ? then, can you check your CR-LF as well ? Hope that helps ! Guillaume ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users