[Mapbender-users] Fwd: Re: Load WMS issue

Thu Jan 24 04:37:21 PST 2013

forwarded because new email
----------  Weitergeleitete Nachricht  ----------

Betreff: Re: [Mapbender-users] Load WMS issue
Datum: Donnerstag, 24. Januar 2013
Von: Armin Retterath <armin.retterath at vermkv.rlp.de>
An: Mapbender User List <mapbender_users at lists.osgeo.org>

Hello Ramesh,

it will be a problem of the installation process. Please check your error file 
for the database creation. The mb_metadata table is part of the sql update 
script 
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
line 1781
Maybe the installation script don't call this update sql or there is another 
database problem. 
The db error_log from the install.bat script may help you. I think, some time 
ago, there was a similar question on the list. 
I only work on linux and don't have such a problem before. 

Maybe some other guy which use mb-2.7.3 under windows can help ;-).
(The metadata table is used by mapbender to be act as a metadata catalogue - 
similar to geonetworks ows harvest mechanism.) 

What version of Postgres/Postgis do you use?

Kind regards from Germany 
Armin

Am Donnerstag, 24. Januar 2013 08:18:59 schrieb Ramesh De Silva:
> 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&R
> EQUEST=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&reques
> >>t=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=GetCapa
> >>bilities&SERVICE=WMS
> >>
> >>
> >> <http://www.bsc-eoc.org/cgi-bin/bsc_ows.asp?VERSION=1.1.1&REQUEST=GetCap
> >>abilities&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/listin
> >>fo/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/listinf
> >o/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
> 