[Mapbender-users] Fwd: Re: Load WMS issue
Ramesh De Silva
desilvarami at gmail.com
Thu Jan 24 18:12:10 PST 2013
Dear Armin,
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.
By the way, I am using PostgreSQL 9.1.
Cheers from Thailand
Ramesh
Master Student
Asian Institute of Technology
Bangkok, Thailand
On Thu, Jan 24, 2013 at 7:37 PM, Armin Retterath <
armin.retterath at vermkv.rlp.de> wrote:
> 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
> >
> _______________________________________________
> 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/20130125/a7b9cd9b/attachment.html>
More information about the Mapbender_users
mailing list