<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Ramesh,<br>
<br>
as an alternativ, you can use the development version of mapbender
(trunk) : <a class="moz-txt-link-freetext" href="http://www.mapbender.org/SVN">http://www.mapbender.org/SVN</a> .<br>
We use it in our production environment ;-) .<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.geoportal.rlp.de">http://www.geoportal.rlp.de</a><br>
<br>
<br>
Cheers from Germany<br>
<br>
Armin<br>
<br>
<br>
On 25.01.2013 03:12, Ramesh De Silva wrote:<br>
</div>
<blockquote
cite="mid:CACVncoJm4=yym_XEt1gD5hgwpvAhayyghMSBcp0U7BjvuWcMWg@mail.gmail.com"
type="cite">Dear Armin,
<div><br>
</div>
<div>Thank you for all the support so far. I will try to create
these missing relations explicitly using the scripts in patch
files. If fail, I will move to Linux platform. I believe things
would work smoother in Linux.</div>
<div><br>
</div>
<div>By the way, I am using PostgreSQL 9.1.</div>
<div><br>
</div>
<div>Cheers from Thailand</div>
<div><br>
</div>
<div>Ramesh</div>
<div>Master Student</div>
<div>Asian Institute of Technology</div>
<div>Bangkok, Thailand</div>
<div><br>
</div>
<div><br>
<br>
<div class="gmail_quote">
On Thu, Jan 24, 2013 at 7:37 PM, Armin Retterath <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:armin.retterath@vermkv.rlp.de"
target="_blank">armin.retterath@vermkv.rlp.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
forwarded because new email<br>
---------- Weitergeleitete Nachricht ----------<br>
<br>
Betreff: Re: [Mapbender-users] Load WMS issue<br>
Datum: Donnerstag, 24. Januar 2013<br>
Von: Armin Retterath <<a moz-do-not-send="true"
href="mailto:armin.retterath@vermkv.rlp.de"
target="_blank">armin.retterath@vermkv.rlp.de</a>><br>
An: Mapbender User List <<a moz-do-not-send="true"
href="mailto:mapbender_users@lists.osgeo.org"
target="_blank">mapbender_users@lists.osgeo.org</a>><br>
<br>
Hello Ramesh,<br>
<br>
it will be a problem of the installation process. Please
check your error file<br>
for the database creation. The mb_metadata table is part of
the sql update<br>
script<br>
<a moz-do-not-send="true"
href="http://trac.osgeo.org/mapbender/browser/tags/2.7.3/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql"
target="_blank">http://trac.osgeo.org/mapbender/browser/tags/2.7.3/resources/db/pgsql/UTF-8/update/update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql</a><br>
line 1781<br>
Maybe the installation script don't call this update sql or
there is another<br>
database problem.<br>
The db error_log from the install.bat script may help you. I
think, some time<br>
ago, there was a similar question on the list.<br>
I only work on linux and don't have such a problem before.<br>
<br>
Maybe some other guy which use mb-2.7.3 under windows can
help ;-).<br>
(The metadata table is used by mapbender to be act as a
metadata catalogue -<br>
similar to geonetworks ows harvest mechanism.)<br>
<br>
What version of Postgres/Postgis do you use?<br>
<br>
Kind regards from Germany<br>
Armin<br>
<br>
<br>
<br>
Am Donnerstag, 24. Januar 2013 08:18:59 schrieb Ramesh De
Silva:<br>
<div>> Hi Armin,<br>
><br>
> Today I installed Mapbender in some other computer
and tried to load my<br>
> Geoserver WMS as well as external WMS to that. This
time I got<br>
> a hint of an error as follows.<br>
><br>
</div>
> *file:<br>
> <a moz-do-not-send="true"
href="http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&R"
target="_blank">http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&R</a><br>
> EQUEST=GetCapabilities&SERVICE=WMSsql error: ERROR:
unnamed prepared<br>
<div>> statement does not exist ROLLBACK<br>
> performed....<br>
> *<br>
> When I try to add these WMSs temporary using the
AddWMS feature in default<br>
> GUIs (such as ait_gui2); the maps can be loaded
seamlessly. It seems there<br>
> 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<br>
> can give me a tip to fix this issue by looking in to
the following log file<br>
</div>
> output. One possible problem looks like unavailability*
*of<br>
> *"mb_metadata" *relation. There is no such relation
"mb_metadata"<br>
<div>> created in postgres DB.<br>
> In both installations it created 77 relation.<br>
><br>
</div>
> *2013.01.24, 14:01:29,ERROR: Error while preparing
statement in<br>
> C:\ms4w\apps\ait\http\php\mod_*<br>
> *loadwms.php: Sql: DELETE FROM<br>
<div>> 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>
</div>
> in C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql:
DELETE FROM<br>
<div>> 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>
</div>
> C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql:
INSERT INTO gui_layer<br>
<div>> (fkey_gui_id, fkey_layer_id, gui_layer_wms_id,
gui_layer_status,<br>
> gui_layer_selectable, gui_layer_visible,
gui_layer_queryable,<br>
</div>
>
gui_layer_querylayer,gui_**layer_minscale,gui_layer_**maxscale,<br>
> gui_layer_priority, gui_layer_style, gui_layer_title)<br>
> VALUES($1,$2,$3,$4,$5,$6,$7,$**8,$9,$10,$11,$12,$13),
Error: ERROR:<br>
<div>> 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>
</div>
> in C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql:
INSERT INTO<br>
<div>> 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>
</div>
>
gui_layer_querylayer,gui_**layer_minscale,gui_layer_**maxscale,<br>
> gui_layer_priority, gui_layer_style, gui_layer_title)<br>
> VALUES($1,$2,$3,$4,$5,$6,$7,$**8,$9,$10,$11,$12,$13),
Error: ERROR:<br>
> unnamed prepared statement does not exist*<br>
<div>
<div>><br>
><br>
> Thanks a lot.<br>
><br>
> Kind Regards<br>
> Ramesh<br>
><br>
><br>
> On Wed, Jan 23, 2013 at 3:39 PM, Armin Retterath
<<br>
><br>
> <a moz-do-not-send="true"
href="mailto:armin.retterath@lvermgeo.rlp.de"
target="_blank">armin.retterath@lvermgeo.rlp.de</a>>
wrote:<br>
> > Hi Ramesh,<br>
> ><br>
> > first: please use Version 1.1.1 for the WMS
Capabilities REQUEST, second:<br>
> > you can try to load the Capabilities Document
from file system. Store the<br>
> > XML which is shown to in the browser window to
a location where the<br>
> > apache can read it - maybe temp folder. Then
give simple the path to the<br>
> > local document in the loadWMS window.<br>
> > E.g.:<br>
> > <a class="moz-txt-link-freetext" href="file:///temp/capabilities1.xml">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<br>
> > 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<br>
> > mapbender trunk.<br>
> ><br>
> > Regards<br>
> ><br>
> > Armin<br>
> ><br>
> ><br>
> ><br>
> > On 23.01.2013 09:00, Ramesh De Silva wrote:<br>
> ><br>
> > 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<br>
> > users. We set "automatically detect Proxy" in
browser settings. May be I<br>
> > can request proxy information from university
network administration and<br>
> > try to provide values in the mapbender.conf.<br>
> > But my worry is; with the WMS running in
localhost also I get this issue.<br>
> > I have set NOT_PROXY_HOSTS as follows<br>
> ><br>
</div>
</div>
<div>> > *define("NOT_PROXY_HOSTS", "localhost");*<br>
> ><br>
</div>
<div>
<div>> > 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<br>
> > impact for this? Actually I disabled it as I
couldn't start Apache after<br>
> > enabling this extension.<br>
> ><br>
> > Thank you.<br>
> ><br>
> > Best Regards<br>
> > Ramesh<br>
> ><br>
> ><br>
> ><br>
> > On Wed, Jan 23, 2013 at 2:01 PM, Armin
Retterath <<br>
> ><br>
> > <a moz-do-not-send="true"
href="mailto:armin.retterath@lvermgeo.rlp.de"
target="_blank">armin.retterath@lvermgeo.rlp.de</a>>
wrote:<br>
> >> Hello Ramesh,<br>
> >><br>
> >> it seems to be a http connection problem.
Do you work behind a proxy?<br>
> >> 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<br>
> >> 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<br>
> >><br>
> >><br>
> >> On 23.01.2013 07:38, Ramesh De Silva
wrote:<br>
> >><br>
> >> Hello,<br>
> >><br>
> >> I have a problem in loading any WMS to
Mapbender. When I try to load a<br>
> >> WMS using a WMS Capabilities URL; nothing
happens. It shows me the WMS<br>
> >> Capabilities URL itself in the resulting
screen.<br>
> >><br>
> >> The WMS Capabilities URLs I used as
follows<br>
> >><br>
</div>
</div>
<div>> >> *From Localhost:*<br>
> >><br>
> >><br>
> >> <a moz-do-not-send="true"
href="http://localhost:8080/geoserver/GIC/wms?service=WMS&version=1.1.0&reques"
target="_blank">http://localhost:8080/geoserver/GIC/wms?service=WMS&version=1.1.0&reques</a><br>
> >>t=GetCapabilities<br>
> >><br>
> >> *Then from other WMS sources<br>
> >> *<br>
> >><br>
> >> *Cadastre of spain*<br>
> >><br>
> >><br>
> >> <a moz-do-not-send="true"
href="http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1"
target="_blank">http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1</a>.<br>
> >>1&REQUEST=GetCapabilities&SERVICE=WMS<br>
> >><br>
> >> *Bird Studies Canada*<br>
> >><br>
> >><br>
> >> <a moz-do-not-send="true"
href="http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapa"
target="_blank">http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapa</a><br>
> >>bilities&SERVICE=WMS<br>
> >><br>
> >><br>
> >> <<a moz-do-not-send="true"
href="http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCap"
target="_blank">http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCap</a><br>
</div>
> >>abilities&SERVICE=WMS> I am running
Geoserver version 2.2.1 and Mapbender<br>
<div>> >> 2.7.3 in my machine. The default maps
provided in Mapbender are working<br>
> >> fine.<br>
> >><br>
> >> Really appreciate any help to resolve this
problem.<br>
> >><br>
> >> Thank you.<br>
> >><br>
> >> Best regards<br>
> >> Ramesh<br>
> >><br>
> >><br>
> >>
_______________________________________________<br>
> >> Mapbender_users mailing<br>
> >> <a class="moz-txt-link-abbreviated" href="mailto:listMapbender_users@lists.osgeo.orghttp://">listMapbender_users@lists.osgeo.orghttp://</a><a
moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listin"
target="_blank">lists.osgeo.org/mailman/listin</a><br>
> >>fo/mapbender_users<br>
> >><br>
> >><br>
> >><br>
> >> --<br>
> >> Zentrale Stelle Geodateninfrastruktur<br>
> >> Rheinland-Pfalz<br>
> >> LVermGeo-RP<br>
> >><br>
> >> Ferdinand-Sauerbruch-Straße 15<br>
> >> 56073 Koblenz<br>
> >><br>
</div>
> >>
<a class="moz-txt-link-abbreviated" href="mailto:0261/492-466armin.retterath@lvermgeo.rlp.dehttp://">0261/492-466armin.retterath@lvermgeo.rlp.dehttp://</a><a
moz-do-not-send="true" href="http://www.geoportal.rlp.de"
target="_blank">www.geoportal.rlp.de</a><br>
<div>> >><br>
> >><br>
> >>
_______________________________________________<br>
> >> Mapbender_users mailing list<br>
> >> <a moz-do-not-send="true"
href="mailto:Mapbender_users@lists.osgeo.org"
target="_blank">Mapbender_users@lists.osgeo.org</a><br>
> >> <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/mapbender_users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
> ><br>
> > _______________________________________________<br>
> > Mapbender_users mailing<br>
> > <a class="moz-txt-link-abbreviated" href="mailto:listMapbender_users@lists.osgeo.orghttp://">listMapbender_users@lists.osgeo.orghttp://</a><a
moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinf"
target="_blank">lists.osgeo.org/mailman/listinf</a><br>
> >o/mapbender_users<br>
> ><br>
> ><br>
> ><br>
> > --<br>
> > Zentrale Stelle Geodateninfrastruktur<br>
> > Rheinland-Pfalz<br>
> > LVermGeo-RP<br>
> ><br>
> > Ferdinand-Sauerbruch-Straße 15<br>
> > 56073 Koblenz<br>
> ><br>
</div>
> > <a class="moz-txt-link-abbreviated" href="mailto:0261/492-466armin.retterath@lvermgeo.rlp.dehttp://">0261/492-466armin.retterath@lvermgeo.rlp.dehttp://</a><a
moz-do-not-send="true" href="http://www.geoportal.rlp.de"
target="_blank">www.geoportal.rlp.de</a><br>
<div>
<div>> ><br>
> ><br>
> >
_______________________________________________<br>
> > Mapbender_users mailing list<br>
> > <a moz-do-not-send="true"
href="mailto:Mapbender_users@lists.osgeo.org"
target="_blank">Mapbender_users@lists.osgeo.org</a><br>
> > <a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/mapbender_users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
><br>
_______________________________________________<br>
Mapbender_users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Mapbender_users@lists.osgeo.org"
target="_blank">Mapbender_users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/mapbender_users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Mapbender_users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapbender_users">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Zentrale Stelle Geodateninfrastruktur
Rheinland-Pfalz
LVermGeo-RP
Ferdinand-Sauerbruch-Straße 15
56073 Koblenz
0261/492-466
<a class="moz-txt-link-abbreviated" href="mailto:armin.retterath@lvermgeo.rlp.de">armin.retterath@lvermgeo.rlp.de</a>
<a class="moz-txt-link-freetext" href="http://www.geoportal.rlp.de">http://www.geoportal.rlp.de</a></pre>
</body>
</html>