Re: [mapserver-users] PHP run-time substitute CGI parameter problem
Substitution is only done via the CGI. If you're using MapScript just change the value directly. Steve From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] on behalf of akoel [ak...@freemail.hu] Sent: Friday, November 09, 2012 6:11 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] PHP run-time substitute CGI parameter problem I have this part of a MAP file: /LAYER ... DATA . =%selected_nid% --- VALIDATION "selected_nid" "^[0-9]+$" END ... END/ I want to substitute the "selected_nid" variable in run-time under PHP script. (I can do it with Openlayers) The problem is that I could not find any Layer-function for this. Somebody has any idea what can I do? I thought that there was an alternative for this problem. I put the variable into the METADATA section like this: /LAYER ... DATA . =%selected_nid% --- METADATA "selected_nid*_validation_pattern*" "^[0-9]+$" END ... END/ And in the PHP script I wrote this: /... $selected_layer->setMetaData( "selected_nid", $selected_nid ); ... / But it did not substituted the variable. thanks in advance -- View this message in context: http://osgeo-org.1560.n6.nabble.com/PHP-run-time-substitute-CGI-parameter-problem-tp5015290.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ 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
[mapserver-users] PHP run-time substitute CGI parameter problem
I have this part of a MAP file: /LAYER ... DATA . =%selected_nid% --- VALIDATION "selected_nid" "^[0-9]+$" END ... END/ I want to substitute the "selected_nid" variable in run-time under PHP script. (I can do it with Openlayers) The problem is that I could not find any Layer-function for this. Somebody has any idea what can I do? I thought that there was an alternative for this problem. I put the variable into the METADATA section like this: /LAYER ... DATA . =%selected_nid% --- METADATA "selected_nid*_validation_pattern*" "^[0-9]+$" END ... END/ And in the PHP script I wrote this: /... $selected_layer->setMetaData( "selected_nid", $selected_nid ); ... / But it did not substituted the variable. thanks in advance -- View this message in context: http://osgeo-org.1560.n6.nabble.com/PHP-run-time-substitute-CGI-parameter-problem-tp5015290.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapCache - how to avoid errors that stops the seeder
hi there, I'm using latest stable MapServer and MapCache on CentOS 6.x but after 1 hour running the seeder, it dumped to: * http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> msDrawMap(): Image handling error. Failed to draw layer named 'pol_my_layer'. msOGRFileNextShape(): OGR error. IllegalArgumentException: Invalid number of points in LinearRing found 3 - must be 0 or >= 4 Is there any way to avoid the seeder stopping this execution? eg.: just log or output the message on terminal and then fill the current request with some specific file like /my/path/image_with_general_error_msg.png. thanks for any help Eduardo Patto Kanegae http://www.webmapit.com | @webmapit ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] tinyows
On 12-11-09 9:50 AM, Alexandre Dubé wrote: > Finally, here's a trick I use when debuggin POST requests. I use the > wget command to quickly launch requests and see their result using the > --post-data argument to send the GML GetFeature request. > > wget "http://localhost/cgi-bin/tinyows"; > --post-data='' > --header="Content-Type: application/xml; charset=UTF-8" -O /tmp/ttt.txt > Cool trick Alexandre! -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] tinyows
Hi,
Yeah, playing with WFS in OpenLayers and TinyOWS can be tricky. I've
had similar problem to yours in the past and I'm on Linux platforms, so
I don't think it's related to Windows.
Jukka gave good advices, but I wouldn't give up trying using TinyOWS
yet. Here's some more advices.
First, I'd recommend that you create a small OpenLayers demo map with
less tools possible only to test your layer. Then, choose EPSG:32740 as
your demo projection. Worry about reprojection later.
Double-check each configuration elements :
use a full url : http://localhost/cgi-bin/tinyows
schema_dir="C:\ms4w\apps\tinyows\schema\">
dbname="watergis" port="5432"/>
http://www.tinyows.org/";
email="tinyows-us...@lists.maptools.org" />
> use a word you would use for all your layers. The tinyows demo
config proposes "tows". Make sure it's also used in your
OpenLayers.Protocol.WFS configuration
ns_uri="http://localhost/";
name="pipeline_segment"
title="pipeline_segment"
table= "pipeline_segment"
srid="32740"
schema="water"/>
wfs = new OpenLayers.Layer.Vector("Editable Features", {
strategies: [new OpenLayers.Strategy.BBOX(), saveStrategy],
projection: new OpenLayers.Projection("EPSG:31467"),
// use 32740 instead
protocol: new OpenLayers.Protocol.WFS({
version: "1.1.0",
// > try with 1.0.0 too
srsName: "EPSG:32740",
url: "http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe";,
// Use the exact same url host has you have setup as your
layer ns_uri
featureNS : "tows",
// the featureNS has to be equal to the 'ns_uri' you
defined in your config, so "http://localhost/";
featureType: "pipeline_segment",
geometryName: "geometry",
schema:
"http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=water:pipeline_segment";
// I usually don't define the schema property at all
assuming that the config 'schema_dir' is properly set (you should make
sure its value is ok)
})
});
For comparison, here's a tows config and OL layer definition that worked
for me.
### TinyOWS config
online_resource="http://labs.mapgears.com/weather-sites-tinyows-1.0.0.fcgi";
schema_dir="/usr/local/share/tinyows/schema/">
http://labs.mapgears.com/";
email="ad...@mapgears.com" />
http://labs.mapgears.com/";
name="root" >
### The apache config used to bind TinyOWS to this config using a
different url
FastCgiServer /usr/lib/cgi-bin/tinyows-1.0.0-weather-sites.fcgi
-initial-env
TINYOWS_CONFIG_FILE=/opt/labs/weather-sites/etc/tinyows/config.xml
ScriptAlias "/weather-sites-tinyows-1.0.0.fcgi"
"/usr/lib/cgi-bin/tinyows-1.0.0-weather-sites.fcgi"
### The OpenLayers.Layer object using the OpenLayers.Protocol.WFS
var layer = new OpenLayers.Layer.Vector("Sites", {
strategies: [new OpenLayers.Strategy.BBOX()],
projection: new OpenLayers.Projection("EPSG:4326"),
protocol: new OpenLayers.Protocol.WFS({
version: "1.0.0",
srsName: "EPSG:4326",
url: 'http://labs.mapgears.com/weather-sites-tinyows-1.0.0.fcgi',
featureNS : 'http://labs.mapgears.com/',
featureType: "sites_view",
outputFormat: "application/json",
readFormat: new OpenLayers.Format.GeoJSON(),
geometryName: "pos"
})
});
Finally, here's a trick I use when debuggin POST requests. I use the
wget command to quickly launch requests and see their result using the
--post-data argument to send the GML GetFeature request.
wget "http://localhost/cgi-bin/tinyows";
--post-data=''
--header="Content-Type: application/xml; charset=UTF-8" -O /tmp/ttt.txt
HTH,
Alexandre
On 12-11-09 05:04 AM, Rahkonen Jukka wrote:
Hi,
Forum is right but obviously there are not many people doing WFS-T with
OpenLayers against TinyOWS installed on Windows. If you are totally jammed I
would recommend you to leave TinyOWS aside for a while and try to make your
OpenLayers application to work with Geoserver WFS-T. I believe you will have
success with it.
-Jukka Rahkonen-
-Alkuperäinen viesti-
Lähettäjä: aho [mailto:forum.emai...@googlemail.com]
Lähetetty: 9. marraskuuta 2012 11:27
Vastaanottaja: sdi...@volz.ua
Kopio: Rahkonen Jukka; mapserver-users@lists.osgeo.org
Aihe: Re: [mapserver-users] tinyows
Hi again,
I am still searching and not finding something. I setup everything again with
the WFS-T tutorial. Now I am getting the following error message:
[Thu Nov 08 16:32:21 2012] [ERROR] local list type: A type, derived by list or
union, must have the simple ur-type definition as base type, not
'{http://www.opengis.net/gml}doubleOrNullList'.
Am I right with this forum? Because actually nobody replies.
Am 11/6/2012 1:30 PM, schrieb aho:
Hey,
Re: [mapserver-users] fast cgi MapServer (version 6.0.3) vs cgi with awms getmap request
Hello Thomas, > In FastCGI mode, a connection will be kept open during the > lifecycle of the fastcgi process, i.e. the connection will > not be closed at the end of a request. Damn, you're right. Had a look at the code and tracking down the chain I saw: mapserv.c: msFreeMapServObj() maptemplate.c: msFreeMap() mapobject.c: msCloseConnections() mapfile.c: vtable->LayerCloseConnection() [for each layer] But PostGIS layers don't provide a LayerCloseConnection() and use the pooling API instead - and that is the magic that keeps the connection. Sorry for the confusion. > It should be noted that these limitations would also apply to a > homemade mapscript script that reuses a mapObj for multiple requests. I overcame that problem by using msCopyMap(). It's not that elegant than using separate datastructure for service config and work data but still avoids the costly invocation of the parser. Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] tinyows
Hi,
Forum is right but obviously there are not many people doing WFS-T with
OpenLayers against TinyOWS installed on Windows. If you are totally jammed I
would recommend you to leave TinyOWS aside for a while and try to make your
OpenLayers application to work with Geoserver WFS-T. I believe you will have
success with it.
-Jukka Rahkonen-
> -Alkuperäinen viesti-
> Lähettäjä: aho [mailto:forum.emai...@googlemail.com]
> Lähetetty: 9. marraskuuta 2012 11:27
> Vastaanottaja: sdi...@volz.ua
> Kopio: Rahkonen Jukka; mapserver-users@lists.osgeo.org
> Aihe: Re: [mapserver-users] tinyows
>
> Hi again,
>
> I am still searching and not finding something. I setup everything again with
> the WFS-T tutorial. Now I am getting the following error message:
>
> [Thu Nov 08 16:32:21 2012] [ERROR] local list type: A type, derived by list or
> union, must have the simple ur-type definition as base type, not
> '{http://www.opengis.net/gml}doubleOrNullList'.
>
> Am I right with this forum? Because actually nobody replies.
>
>
>
>
> Am 11/6/2012 1:30 PM, schrieb aho:
> > Hey,
> >
> > I still havn´t found the problem with the tinyows - but at the moment
> > there is no error message when i am loading the wfs. Also fiddler
> > doesn´t list the tinyows.exe anymore. But my proxy is correct - I can
> > load it via uDig and ArcMap. QGIS has a problem, but there is not a
> > single error in the tinyows log file - just events and sqls are
> > listed, that looks quite good. With Open layers there is nothing
> > logged - it seems like the request is not send.
> >
> > Is there any limitation for the version? I downloaded the latest
> > (2.12) one, but on the tinyows page is version 2.09 listed?!
> >
> > Kind regards
> >
> > Am 11/2/2012 3:29 PM, schrieb Serge Dikiy:
> >> Hi,
> >>
> >>
> http://translate.google.com/translate?sl=ru&tl=en&js=n&prev=_t&hl=en&;
> >> ie=UTF-8&layout=2&eotf=1&u=http%3A%2F%2Fgis-
> lab.info%2Fforum%2Fviewto
> >> pic.php%3Ff%3D41%26t%3D10329
> >>
> >>
> >> BR
> >>
> >> On Fri, Nov 2, 2012 at 4:15 PM, aho
> >> wrote:
> >>> Hi Jukka,
> >>>
> >>> ok, I solved the problem with the requests. The following returns
> >>> from
> >>> tinyOWS:
> >>>
> >>> >>> xmlns='http://www.opengis.net/ows'
> >>> xmlns:ows='http://www.opengis.net/ows'
> >>> xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
> >>> xsi:schemaLocation='http://www.opengis.net/ows
> >>> http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd'
> >>> version='1.1.0' language='en'>
> >>>>>> locator='request'>
> >>>XML request isn't valid
> >>>
> >>>
> >>>
> >>> Here is the errorlog:
> >>>
> >>> Fri Nov 02 15:11:46 2012] [EVENT] == FCGI START == [Fri Nov 02
> >>> 15:11:46 2012] [QUERY] >>> xmlns:wfs="http://www.opengis.net/wfs"; service="WFS"
> version="1.0.0"
> >>> xsi:schemaLocation="http://www.opengis.net/wfs
> >>> http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd water
> >>> http://127.0.0.1:8000/redir/cgi-
> bin/tinyows.exe?service=wfs&request=GetFeature&version=1.0.
> 0&typename=water:armature"
> >>>
> >>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-
> instance"> >>> typeName="feature:armature" xmlns:feature="water"> >>>
> xmlns:ogc="http://www.opengis.net/ogc";> >g
> >>> eometry >>>
> >>> xmlns:gml="http://www.opengis.net/gml";
> >>> srsName="EPSG:32740"> >>> decimal="." cs="," ts=" ">-2866.3885602952,-1910.9257068634
> >>>
> 2866.3885602952,1910.9257068634 >>> X>
> >>>
> >>> [Fri Nov 02 15:11:46 2012] [ERROR] Element
> >>> '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a
> >>> schema at location
> >>> 'localhost/cgi-
> bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.
> 0'.
> >>>
> >>> Skipping the import.
> >>>
> >>> [Fri Nov 02 15:11:46 2012] [ERROR] Element
> >>> '{http://www.opengis.net/wfs}GetFeature': No matching global
> >>> declaration available for the validation root.
> >>>
> >>> [Fri Nov 02 15:11:46 2012] [ERROR] XML request isn't valid [Fri Nov
> >>> 02 15:11:46 2012] [EVENT] == FCGI SHUTDOWN == [Fri Nov 02 15:11:46
> >>> 2012] [EVENT] == TINYOWS SHUTDOWN ==
> >>>
> >>> Has it something to do with the schema? I found a post with
> >>> something similar
> >>> (http://osgeo-org.1560.n6.nabble.com/TinyOWS-wrong-call-in-
> OpenLayer
> >>> s-InvalidParameterValue-XML-request-isn-t-valid-td5009059.html)
> >>>
> >>> and replaced all my old tinyows files and copied the ones from the
> >>> ms4w homepage.
> >>>
> >>> Do you have some more ideas?
> >>>
> >>> Am 11/2/2012 10:56 AM, schrieb Rahkonen Jukka:
> >>>
> >>> Hi,
> >>>
> >>> Yes, it seems to be OpenLayers question then. However, do still
> >>> capture the requests because without them you cannot understand
> what
> >>> happens really. My guess is that something in wrong in how
> >>> EPSG:31467 and EPSG:32740 are used and OpenLayers is requesting data
> >>> from a place where there are no data.
> >>>
> >>> -Jukka-
> >>>
> >>> aho wrote:
> >>>
> >>>
> >>> Hi Jukka,
> >>>
> >>> thanks a lot for your answer
Re: [mapserver-users] tinyows
Hi again,
I am still searching and not finding something. I setup everything again
with the WFS-T tutorial. Now I am getting the following error message:
[Thu Nov 08 16:32:21 2012] [ERROR] local list type: A type, derived by
list or union, must have the simple ur-type definition as base type, not
'{http://www.opengis.net/gml}doubleOrNullList'.
Am I right with this forum? Because actually nobody replies.
Am 11/6/2012 1:30 PM, schrieb aho:
Hey,
I still havn´t found the problem with the tinyows - but at the moment
there is no error message when i am loading the wfs. Also fiddler
doesn´t list the tinyows.exe anymore. But my proxy is correct - I can
load it via uDig and ArcMap. QGIS has a problem, but there is not a
single error in the tinyows log file - just events and sqls are
listed, that looks quite good. With Open layers there is nothing
logged - it seems like the request is not send.
Is there any limitation for the version? I downloaded the latest
(2.12) one, but on the tinyows page is version 2.09 listed?!
Kind regards
Am 11/2/2012 3:29 PM, schrieb Serge Dikiy:
Hi,
http://translate.google.com/translate?sl=ru&tl=en&js=n&prev=_t&hl=en&ie=UTF-8&layout=2&eotf=1&u=http%3A%2F%2Fgis-lab.info%2Fforum%2Fviewtopic.php%3Ff%3D41%26t%3D10329
BR
On Fri, Nov 2, 2012 at 4:15 PM, aho
wrote:
Hi Jukka,
ok, I solved the problem with the requests. The following returns from
tinyOWS:
locator='request'>
XML request isn't valid
Here is the errorlog:
Fri Nov 02 15:11:46 2012] [EVENT] == FCGI START ==
[Fri Nov 02 15:11:46 2012] [QUERY] http://www.opengis.net/wfs"; service="WFS" version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd water
http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe?service=wfs&request=GetFeature&version=1.0.0&typename=water:armature";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>xmlns:ogc="http://www.opengis.net/ogc";>geometry
xmlns:gml="http://www.opengis.net/gml";
srsName="EPSG:32740">
decimal="." cs="," ts=" ">-2866.3885602952,-1910.9257068634
2866.3885602952,1910.9257068634
[Fri Nov 02 15:11:46 2012] [ERROR] Element
'{http://www.w3.org/2001/XMLSchema}import': Failed to locate a
schema at
location
'localhost/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'.
Skipping the import.
[Fri Nov 02 15:11:46 2012] [ERROR] Element
'{http://www.opengis.net/wfs}GetFeature': No matching global
declaration
available for the validation root.
[Fri Nov 02 15:11:46 2012] [ERROR] XML request isn't valid
[Fri Nov 02 15:11:46 2012] [EVENT] == FCGI SHUTDOWN ==
[Fri Nov 02 15:11:46 2012] [EVENT] == TINYOWS SHUTDOWN ==
Has it something to do with the schema? I found a post with something
similar
(http://osgeo-org.1560.n6.nabble.com/TinyOWS-wrong-call-in-OpenLayers-InvalidParameterValue-XML-request-isn-t-valid-td5009059.html)
and replaced all my old tinyows files and copied the ones from the ms4w
homepage.
Do you have some more ideas?
Am 11/2/2012 10:56 AM, schrieb Rahkonen Jukka:
Hi,
Yes, it seems to be OpenLayers question then. However, do still
capture the
requests because without them you cannot understand what happens
really. My
guess is that something in wrong in how EPSG:31467 and EPSG:32740
are used
and OpenLayers is requesting data from a place where there are no data.
-Jukka-
aho wrote:
Hi Jukka,
thanks a lot for your answer and the good tips! I tried all of the
links
and they are working. Also I checked it in QGIS and there I can load it
too.
So I guess it will be better to write again to the openlayers
mailinglist?!
Am 11/2/2012 10:21 AM, schrieb Rahkonen Jukka:
Hi,
You must capture the traffic between OpenLayers and TinyOWS. I am using
myself Fiddler2 proxy but I suppose that Firebug can show you what
OpenLayers is sending and high enough TinyOWS logging level will
also gather
requests into tinyows log. The software is not important but you
just have
to get the requests so you can resend them with a browser or some
other tool
that yuo can control and see what happens. You can also include the
requests
in your further mails. Then the question will be "OpenLayers is
sending this
and TinyOWS is sending back that, what's wrong?" and it will be much
easier
to answer.
As always with WFS, start with these requests with a browser before
doing
anything with OpenLayers:
http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe?service=wfs&request=GetCapabilities&version=1.1.0
http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe?service=wfs&request=DescribeFeatureType&version=1.1.0&typename=water:pipeline_segment
http://127.0.0.1:8000/redir/cgi-bin/tinyows.exe?service=wfs&request=GetFeature&version=1.1.0&typename=water:pipeline_segment&maxFeatures=10
If all those requests work you know that TinyOWS works with those basic
requests and if OpenLayers application does not get data the reason in
probably in the application code.
-Juk
Re: [mapserver-users] fast cgi MapServer (version 6.0.3) vs cgi with awms getmap request
On Fri, Nov 9, 2012 at 9:16 AM, Eichner, Andreas - SID-NLKM < andreas.eich...@sid.sachsen.de> wrote: > >> Once the request is done the the connection > >> will be closed. > > I thought that setting allows to open the db connection only > > once , keep it open until all layers data are read and will > > prevent closing and opening connections in between layers ? > > That's right. You can query more than one layer per GetMap request and > MapServer will open the database connection only once for all layers > involved. But once the request is done AFAIK the database connection > will be closed. > In CGI mode, a single connection will be reused across all layers of the request. In FastCGI mode, a connection will be kept open during the lifecycle of the fastcgi process, i.e. the connection will not be closed at the end of a request. > > I searched the list and the MapServer doc about the Apache ? Module > > mod_mapserver, however I could not find almost any reference > > to it other than it is on the wish list for v 6.2 ? Does it already > > exist in MapServer 6.0.3 > > The module is only available in the 6-2 branch and should be build when > supplying the --with-apache-module switch and configuration should be a > snippet in the apache config: > > > Mapfile /path/to/wms.map > > > But I'm sure it's not well tested and only supports WxS services. You > might ask Thomas Bonfort in what stage it is. Even if it's currently > not suitable for productive use you might give it a try and provide some > feedback. If it can solve your performance issues it might get more > attention by the developers. > It's there in 6.2 but we will not be advertising it as being ready for production. In practice the same mapfile is reused across requests, which makes for very good performance but has the following implications: - WFS requests with FILTERs set should not be used, as the FILTERITEM/FILTER will continue to be applied to the subsequent requests, even if FILTER was not supplied on the subsequent requests. - CGI substitutions and mapfile url overrides should not be used, as they would also be applied to subsequent requests - WMS SLD requests should not be used, for the same reason. Basically, the only safe usages are capabilities and plain GetMap or mode=map requests. Overcoming the previous limitations isn't planned for, so would need to be funded. It should be noted that these limitations would also apply to a homemade mapscript script that reuses a mapObj for multiple requests. regards, thomas > > > HTH > ___ > 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
Re: [mapserver-users] fast cgi MapServer (version 6.0.3) vs cgi with awms getmap request
On 11/09/2012 09:16 AM, Eichner, Andreas - SID-NLKM wrote: Once the request is done the the connection will be closed. I thought that setting allows to open the db connection only once , keep it open until all layers data are read and will prevent closing and opening connections in between layers ? That's right. You can query more than one layer per GetMap request and MapServer will open the database connection only once for all layers involved. But once the request is done AFAIK the database connection will be closed. If you think that the time needed to establish the connection to PostgreSQL is relevant in your case, you might consider to use of a connection pooler, like http://wiki.postgresql.org/wiki/PgBouncer. (...) HTH ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Peter -- Peter Hopfgartner R3 GIS Srl - GmbH web : http://www.r3-gis.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] fast cgi MapServer (version 6.0.3) vs cgi with awms getmap request
>> Once the request is done the the connection >> will be closed. > I thought that setting allows to open the db connection only > once , keep it open until all layers data are read and will > prevent closing and opening connections in between layers ? That's right. You can query more than one layer per GetMap request and MapServer will open the database connection only once for all layers involved. But once the request is done AFAIK the database connection will be closed. > I searched the list and the MapServer doc about the Apache ? Module > mod_mapserver, however I could not find almost any reference > to it other than it is on the wish list for v 6.2 ? Does it already > exist in MapServer 6.0.3 The module is only available in the 6-2 branch and should be build when supplying the --with-apache-module switch and configuration should be a snippet in the apache config: Mapfile /path/to/wms.map But I'm sure it's not well tested and only supports WxS services. You might ask Thomas Bonfort in what stage it is. Even if it's currently not suitable for productive use you might give it a try and provide some feedback. If it can solve your performance issues it might get more attention by the developers. HTH ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
