Hi Armin,<br>
<br>
Today I installed Mapbender in some other computer and tried to
load my Geoserver WMS as well as external WMS to that. This time I got<br>
a hint of an error as follows.<br>
<br>
<span style="color:rgb(255,0,0)"><i><u>file: <a href="http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMSsql" target="_blank">http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMSsql</a><br>
error: ERROR: unnamed prepared statement does not exist ROLLBACK
performed....<br>
</u></i></span><br>
When I try to add these WMSs temporary using the AddWMS feature in
default GUIs (such as ait_gui2); the maps can be loaded seamlessly. It seems there is a problem in adding these WMS to the database.<br>
<br>
In the log file I found the following error repeatedly. Appreciate if you can give me a tip to fix this issue by looking in to the following log file output. One possible problem looks like unavailability<i> </i>of <span style="color:rgb(51,0,0)"><i>"mb_metadata" </i></span> relation. There is no such relation "mb_metadata" created in postgres DB. In both installations it created 77 relation.<br>
<br>
<span style="color:rgb(51,0,0)"><i>2013.01.24, 14:01:29,ERROR: Error while preparing statement in<br>
C:\ms4w\apps\ait\http\php\mod_</i></span><div id=":70"><span style="color:rgb(51,0,0)"><i>loadwms.php: Sql: DELETE FROM<br>
mb_metadata WHERE metadata_id IN (SELECT metadata_id FROM mb_metadata<br>
INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id =<br>
$1) as relation ON mb_metadata.metadata_id =<br>
relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'),<br>
Error: ERROR: relation "mb_metadata" does not exist<br>
LINE 1: DELETE FROM mb_metadata WHERE metadata_id IN (SELECT metadat...<br>
^<br>
2013.01.24, 14:01:29,ERROR: Error while executing prepared statement<br>
in C:\ms4w\apps\ait\http\php\mod_</i></span><span style="color:rgb(51,0,0)"><i>loadwms.php: Sql: DELETE FROM<br>
mb_metadata WHERE metadata_id IN (SELECT metadata_id FROM mb_metadata<br>
INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id =<br>
$1) as relation ON mb_metadata.metadata_id =<br>
relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'),<br>
Error: ERROR: unnamed prepared statement does not exist<br>
2013.01.24, 14:01:29,ERROR: Error while preparing statement in<br>
C:\ms4w\apps\ait\http\php\mod_</i></span><span style="color:rgb(51,0,0)"><i>loadwms.php: Sql: INSERT INTO gui_layer<br>
(fkey_gui_id, fkey_layer_id, gui_layer_wms_id, gui_layer_status,<br>
gui_layer_selectable, gui_layer_visible, gui_layer_queryable,<br>
gui_layer_querylayer,gui_</i></span><span style="color:rgb(51,0,0)"><i>layer_minscale,gui_layer_</i></span><span style="color:rgb(51,0,0)"><i>maxscale,<br>
gui_layer_priority, gui_layer_style, gui_layer_title)<br>
VALUES($1,$2,$3,$4,$5,$6,$7,$</i></span><span style="color:rgb(51,0,0)"><i>8,$9,$10,$11,$12,$13), Error: ERROR:<br>
current transaction is aborted, commands ignored until end of<br>
transaction block<br>
2013.01.24, 14:01:29,ERROR: Error while executing prepared statement<br>
in C:\ms4w\apps\ait\http\php\mod_</i></span><span style="color:rgb(51,0,0)"><i>loadwms.php: Sql: INSERT INTO<br>
gui_layer (fkey_gui_id, fkey_layer_id, gui_layer_wms_id,<br>
gui_layer_status, gui_layer_selectable, gui_layer_visible,<br>
gui_layer_queryable,<br>
gui_layer_querylayer,gui_</i></span><span style="color:rgb(51,0,0)"><i>layer_minscale,gui_layer_</i></span><span style="color:rgb(51,0,0)"><i>maxscale,<br>
gui_layer_priority, gui_layer_style, gui_layer_title)<br>
VALUES($1,$2,$3,$4,$5,$6,$7,$</i></span><span style="color:rgb(51,0,0)"><i>8,$9,$10,$11,$12,$13), Error: ERROR:<br>
unnamed prepared statement does not exist</i></span><br>
<br>
<br>
Thanks a lot.<br>
<br>
Kind Regards<br>
Ramesh</div><br><br><div class="gmail_quote">On Wed, Jan 23, 2013 at 3:39 PM, Armin Retterath <span dir="ltr"><<a href="mailto:armin.retterath@lvermgeo.rlp.de" target="_blank">armin.retterath@lvermgeo.rlp.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Ramesh,<br>
<br>
first: please use Version 1.1.1 for the WMS Capabilities REQUEST,
second: you can try to load the Capabilities Document from file
system. Store the XML which is shown to in the browser window to a
location where the apache can read it - maybe temp folder. Then
give simple the path to the local document in the loadWMS window.<br>
E.g.:<br>
<a>file:///temp/capabilities1.xml</a><br>
and load it localy.<br>
If this is successful, you have a network problem.<br>
If not - maybe the capabilities parsing makes problems.<br>
Look in the mapbender log folder. In the current log file, there
are more messages which may help to identify the problem.<br>
Do you use curl? Normaly this works well for localhost. <br>
Maybe you can send me your capabilities xml and I may test it with
mapbender trunk.<br>
<br>
Regards<span class="HOEnZb"><font color="#888888"><br>
<br>
Armin</font></span><div><div class="h5"><br>
<br>
<br>
On 23.01.2013 09:00, Ramesh De Silva wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">Hello Armin,<br>
<br>
Thanks a lot for the reply.<br>
<br>
I am inside a university network but proxy settings are unknown to
the users. We set "automatically detect Proxy" in browser
settings. May be I can request proxy information from university
network administration and try to provide values in the
mapbender.conf.<br>
But my worry is; with the WMS running in localhost also I get this
issue. I have set NOT_PROXY_HOSTS as follows<br>
<br>
<b>define("NOT_PROXY_HOSTS", "localhost");</b><br>
<br>
By the way I am running everything on Windows 2003 Server.<br>
<br>
The imagick extension is not enabled in php.ini yet. Does it have
any impact for this? Actually I disabled it as I couldn't start
Apache after enabling this extension.<br>
<br>
Thank you.<br>
<br>
Best Regards<br>
Ramesh<br>
<br>
<br>
<br>
<div class="gmail_quote">On Wed, Jan 23, 2013 at 2:01 PM, Armin
Retterath <span dir="ltr"><<a href="mailto:armin.retterath@lvermgeo.rlp.de" target="_blank">armin.retterath@lvermgeo.rlp.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hello Ramesh,<br>
<br>
it seems to be a http connection problem. Do you work
behind a proxy? You have to define the proxy variables in
the conf/mapbender.conf file. <br>
I recommend to use the connection via curl library. It is
very good in most environments.<br>
Do you use mapbender under windows or linux?<br>
If you don't have a proxy test the following
configuration:<br>
<br>
define("CONNECTION", "curl");
<br>
#define("CONNECTION", "http");
<br>
#define("CONNECTION", "socket");
<br>
#define("CONNECTION_PROXY", "xxxx"); // ip
<br>
#define("CONNECTION_PORT", "xxxx"); // port
<br>
define("CONNECTION_PROXY", ""); // ip
<br>
define("CONNECTION_PORT", ""); // port
<br>
define("CONNECTION_USER", ""); // user
<br>
define("CONNECTION_PASSWORD", ""); // password
<br>
define("CONNECTION_USERAGENT", "Mapbender");<br>
<br>
(libcurl and php5-curl is needed)<br>
<br>
Regards <br>
Armin
<div>
<div><br>
<br>
On 23.01.2013 07:38, Ramesh De Silva wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>Hello,<br>
<br>
I have a problem in loading any WMS to Mapbender. When
I try to load a WMS using a WMS Capabilities URL;
nothing happens. It shows me the WMS Capabilities URL
itself in the resulting screen.<br>
<br>
The WMS Capabilities URLs I used as follows<br>
<br>
<b>From Localhost:</b><br>
<br>
<a href="http://localhost:8080/geoserver/GIC/wms?service=WMS&version=1.1.0&request=GetCapabilities" target="_blank">http://localhost:8080/geoserver/GIC/wms?service=WMS&version=1.1.0&request=GetCapabilities</a><br>
<br>
<b>Then from other WMS sources<br>
</b>
<p><b>Cadastre of spain</b></p>
<p><a href="http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS" target="_blank">http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS</a></p>
<p><b>Bird Studies Canada</b></p>
<p><a href="http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS" target="_blank">http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS</a></p>
<p><a href="http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS" target="_blank"><br>
</a></p>
I am running Geoserver version <span>2.2.1 and
Mapbender 2.7.3 in my machine. The default maps
provided in Mapbender are working fine.<br>
<br>
</span><font color="#FF0000"><font color="#000000">Really
appreciate any help to resolve this problem.<br>
<br>
Thank you.<br>
<br>
Best regards<br>
Ramesh <br>
</font></font> <br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Mapbender_users mailing list
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><span><font color="#888888">
</font></span></pre>
<span><font color="#888888"> </font></span></blockquote>
<span><font color="#888888"> <br>
<br>
<pre cols="72">--
Zentrale Stelle Geodateninfrastruktur
Rheinland-Pfalz
LVermGeo-RP
Ferdinand-Sauerbruch-Straße 15
56073 Koblenz
0261/492-466
<a href="mailto:armin.retterath@lvermgeo.rlp.de" target="_blank">armin.retterath@lvermgeo.rlp.de</a>
<a href="http://www.geoportal.rlp.de" target="_blank">http://www.geoportal.rlp.de</a></pre>
</font></span></div>
<br>
_______________________________________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br>
</blockquote>
</div>
<br>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Mapbender_users mailing list
<a href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a>
</pre>
</blockquote>
<br>
<br>
<pre cols="72">--
Zentrale Stelle Geodateninfrastruktur
Rheinland-Pfalz
LVermGeo-RP
Ferdinand-Sauerbruch-Straße 15
56073 Koblenz
0261/492-466
<a href="mailto:armin.retterath@lvermgeo.rlp.de" target="_blank">armin.retterath@lvermgeo.rlp.de</a>
<a href="http://www.geoportal.rlp.de" target="_blank">http://www.geoportal.rlp.de</a></pre>
</div></div></div>
<br>_______________________________________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br></blockquote></div><br>