[Mapbender-users] Load WMS issue

Wed Jan 23 23:18:59 PST 2013

Hi Armin,

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
a hint of an error as follows.

*file:
http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMSsql
error: ERROR: unnamed prepared statement does not exist ROLLBACK
performed....
*
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.

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* *of
*"mb_metadata" *relation. There is no such relation "mb_metadata"
created in postgres DB.
In both installations it created 77 relation.

*2013.01.24, 14:01:29,ERROR: Error while preparing statement in
C:\ms4w\apps\ait\http\php\mod_*
*loadwms.php: Sql: DELETE FROM
mb_metadata WHERE metadata_id IN (SELECT metadata_id FROM mb_metadata
INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id =
$1) as relation ON  mb_metadata.metadata_id =
relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'),
Error: ERROR:  relation "mb_metadata" does not exist
LINE 1: DELETE FROM mb_metadata WHERE metadata_id IN (SELECT metadat...
                    ^
2013.01.24, 14:01:29,ERROR: Error while executing prepared statement
in C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql: DELETE FROM
mb_metadata WHERE metadata_id IN (SELECT metadata_id FROM mb_metadata
INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id =
$1) as relation ON  mb_metadata.metadata_id =
relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'),
Error: ERROR:  unnamed prepared statement does not exist
2013.01.24, 14:01:29,ERROR: Error while preparing statement in
C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql: INSERT INTO gui_layer
(fkey_gui_id, fkey_layer_id, gui_layer_wms_id, gui_layer_status,
gui_layer_selectable, gui_layer_visible, gui_layer_queryable,
gui_layer_querylayer,gui_**layer_minscale,gui_layer_**maxscale,
gui_layer_priority, gui_layer_style, gui_layer_title)
VALUES($1,$2,$3,$4,$5,$6,$7,$**8,$9,$10,$11,$12,$13), Error: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
2013.01.24, 14:01:29,ERROR: Error while executing prepared statement
in C:\ms4w\apps\ait\http\php\mod_**loadwms.php: Sql: INSERT INTO
gui_layer (fkey_gui_id, fkey_layer_id, gui_layer_wms_id,
gui_layer_status, gui_layer_selectable, gui_layer_visible,
gui_layer_queryable,
gui_layer_querylayer,gui_**layer_minscale,gui_layer_**maxscale,
gui_layer_priority, gui_layer_style, gui_layer_title)
VALUES($1,$2,$3,$4,$5,$6,$7,$**8,$9,$10,$11,$12,$13), Error: ERROR:
unnamed prepared statement does not exist*

Thanks a lot.

Kind Regards
Ramesh

On Wed, Jan 23, 2013 at 3:39 PM, Armin Retterath <
armin.retterath at lvermgeo.rlp.de> wrote:

>  Hi Ramesh,
>
> 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.
> E.g.:
> file:///temp/capabilities1.xml
> and load it localy.
> If this is successful, you have a network problem.
> If not - maybe the capabilities parsing makes problems.
> Look in the mapbender log folder. In the current log file, there are more
> messages which may help to identify the problem.
> Do you use curl? Normaly this works well for localhost.
> Maybe you can send me your capabilities xml and I may test it with
> mapbender trunk.
>
> Regards
>
> Armin
>
>
>
> On 23.01.2013 09:00, Ramesh De Silva wrote:
>
> Hello Armin,
>
> Thanks a lot for the reply.
>
> 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.
> But my worry is; with the WMS running in localhost also I get this issue.
> I have set NOT_PROXY_HOSTS as follows
>
> *define("NOT_PROXY_HOSTS", "localhost");*
>
> By the way I am running everything on Windows 2003 Server.
>
> 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.
>
> Thank you.
>
> Best Regards
> Ramesh
>
>
>
> On Wed, Jan 23, 2013 at 2:01 PM, Armin Retterath <
> armin.retterath at lvermgeo.rlp.de> wrote:
>
>>  Hello Ramesh,
>>
>> 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.
>> I recommend to use the connection via curl library. It is very good in
>> most environments.
>> Do you use mapbender under windows or linux?
>> If you don't have a proxy test the following configuration:
>>
>> define("CONNECTION", "curl");
>> #define("CONNECTION", "http");
>> #define("CONNECTION", "socket");
>> #define("CONNECTION_PROXY", "xxxx"); // ip
>> #define("CONNECTION_PORT", "xxxx"); // port
>> define("CONNECTION_PROXY", ""); // ip
>> define("CONNECTION_PORT", ""); // port
>> define("CONNECTION_USER", ""); // user
>> define("CONNECTION_PASSWORD", ""); // password
>> define("CONNECTION_USERAGENT", "Mapbender");
>>
>> (libcurl and php5-curl is needed)
>>
>> Regards
>> Armin
>>
>>
>> On 23.01.2013 07:38, Ramesh De Silva wrote:
>>
>>  Hello,
>>
>> 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.
>>
>> The WMS Capabilities URLs I used as follows
>>
>> *From Localhost:*
>>
>>
>> http://localhost:8080/geoserver/GIC/wms?service=WMS&version=1.1.0&request=GetCapabilities
>>
>> *Then from other WMS sources
>> *
>>
>> *Cadastre of spain*
>>
>>
>> http://ovc.catastro.meh.es/Cartografia/WMS/ServidorWMS.aspx?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS
>>
>> *Bird Studies Canada*
>>
>>
>> http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS
>>
>>
>> <http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS>
>> I am running Geoserver version 2.2.1 and Mapbender 2.7.3 in my machine.
>> The default maps provided in Mapbender are working fine.
>>
>> Really appreciate any help to resolve this problem.
>>
>> Thank you.
>>
>> Best regards
>> Ramesh
>>
>>
>>  _______________________________________________
>> Mapbender_users mailing listMapbender_users at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/mapbender_users
>>
>>
>>
>> --
>> Zentrale Stelle Geodateninfrastruktur
>> Rheinland-Pfalz
>> LVermGeo-RP
>>
>> Ferdinand-Sauerbruch-Straße 15
>> 56073 Koblenz
>>
>> 0261/492-466armin.retterath at lvermgeo.rlp.dehttp://www.geoportal.rlp.de
>>
>>
>> _______________________________________________
>> Mapbender_users mailing list
>> Mapbender_users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>>
>>
>
>
> _______________________________________________
> Mapbender_users mailing listMapbender_users at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/mapbender_users
>
>
>
> --
> Zentrale Stelle Geodateninfrastruktur
> Rheinland-Pfalz
> LVermGeo-RP
>
> Ferdinand-Sauerbruch-Straße 15
> 56073 Koblenz
>
> 0261/492-466armin.retterath at lvermgeo.rlp.dehttp://www.geoportal.rlp.de
>
>
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapbender_users/attachments/20130124/20158e33/attachment.html>