Hello all. In a map I show points which are retrieved from a mysql database. After a while, I get the error message: Warning: [MapServer Error]: msOGRFileNextShape(): MySQL error message:MySQL server has gone away
I suspect that pmapper stores the connection to mysql in the session and after a while, it expires. Is this correct? The reason I belive this is that in the begining the error does not apear. Only after a couple of minutes it starts occuring. The connection and the sql query is specified in a ovf file. The map uses the OGR driver to get the data. After a discussion in the mapserver mailing list, it seems that the problem is in pmapper and not in mapserver. As an evidence of this, the url: http://cgdi-dev.geoconnections.org/prototypes/owsview/index.html?context=http://cgdi-dev.geoconnections.org/prototypes/owsview/cache/11931537643005_1_1_0.xml shows the data fine without any errors. Also, if I use the cgi interface to mapserver, as in this url: http://mathind.csd.auth.gr/cgi-bin/mapserv?map=/home/anakreon/public_html/pmapper-3.1.0/config/default/ekby.map&mode=map&layer=countries&layer=sites the map is displayed without any errors. Could someone confirm my hypothesis about the storage of the connection in the session? If you want to see the problem, visit: http://mathind.csd.auth.gr/~anakreon/pmapper-3.1.0/map.phtml Anakreon ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users