[Mapbender-users] RE: problem with wms after importing gui on server

Tue Jan 15 06:08:11 EST 2008

Again, I am having a problem with importing a gui exported from my local
windows machine to my linux server (both mapbender 2.4.3). 
The gui imported ok, however when I try to upload the wms belonging to itI
get a message 
" duplicate key violates unique constraint "pk_gui_layer" error."

How can I get rid of the duplicate entry ? How can that be there in the
first place ?

Even though I couldn't really succeed to upload the WMS capabilities on the
server I can access the wms located on the server from my localmachine if I
upload it there.
Weird stuff. 

Any ideas why that is and how I can find out a way to fix it? Main problem
is that I can't get it to work on the server.

Karsten 

-----Original Message-----
From: karsten vennemann [mailto:karsten at terragis.net] 
Sent: Thursday, January 03, 2008 00:54
To: 'mapbender_users at lists.osgeo.org'
Subject: Re: problem with wms after importing gui on server

Happy new year all,

Ok - my mistake I fiddled around with the wms in the meantime (trying to fix
it) and added a second layer on the wms on the server that broke the whole
thing.
Now the wms seems to be working again at
http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projects/a
lliance/ok_server.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1
gives me an xml output file. 

I can use this wms successfully on my local machine but not on the server
(which serves the wms !) ???
I could now import the gui on the server without any errors (that showed
before - see below), but the wms data doesn't show up nor does the wms on
the administration interface (same as before).

I also tried to figure out if I had some junk in the db, thus renamed the
wms on the localhost, copied gui to new name , deleted the old wms , added
new one, exported as sql and imported on server - still the same problem
(works on localhost but not on server).

When I load the mapbender app from the server  get the following error in
firebug:

wms[0] has no properties
mb_mapObj_const("mapframe1", "maps", "625", "400", null)map.php (line 19)
mb_registerMapObj("mapframe1", "maps", null, "625", "400")map.php (line 7)
init_mod_map1()mod_map1.php (line 17)
onload(load )mod_map1.php (line 1)
[Break on this error]
this.epsg=wms[0].gui_wms_epsg;this.extent=setExtent(this.width,this.height,t
his....

Anybody any hints what I can try to fix this ?

Karsten

Date: Tue, 1 Jan 2008 16:15:30 +0100 (CET)
From: "Ulrich Rothstein" <uli.rothstein at wheregroup.com>
Subject: Re: [Mapbender-users] problem with wms after importing gui on
	server
To: "Mapbender User List" <mapbender_users at lists.osgeo.org>
Message-ID: <33245.212.79.172.164.1199200530.squirrel at vogon.ccgis.de>
Content-Type: text/plain;charset=iso-8859-1

Hey Karsten,

I just get an error-message if I try to load the capabilities document:

msLoadMap(): General error message. Undefined overlay symbol "POINT" in
class 0, style 1 of layer Active Attorneys. msAddImageSymbol(): Unable to
access file. Error opening image file
/var/www/mapdata/projects/alliance/POINT.

regards
Uli

On Sat, December 29, 2007 9:04 am, karsten vennemann wrote:
> Hi list,
>
>
>
>
> I'm working with mapbender 2.4.3 and created a gui including one wms
> (http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/project
> s/ alliance/ok_server.map
> <http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projec
> ts/ alliance/ok_server.map&> &) on my local windows machine. There all is
> working fine. I then exported the gui as sql and imported into the
> mapbender database (postgis) on my linux server. The gui shows up on the
> admin pages after I ran Insert into gui_mb_user Values
('ocla1',1,'owner');
>
>
>
>
> However, the wms does not show up when I load the gui, also I can't find
> my wms in the table "wms" nor does it show up when I try to edit the wms
> under Configue WMS access> WMS GUI settings in the WMS_TiTle list box.
> I don't know whether a wms belonging to a gui usually is exported with the
>  gui  - or whether I have to recreate that resource on the server again?
>
>
>
> Thus, I tried to recreate the wms with "load capabilities", however
> trying to load
>
> http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/project
> s/a lliance/ok_server.map
> <http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projec
> ts/
> alliance/ok_server.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0>
>  &REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0
>
>
> gives me a violation of a constraint :-(:
>
> Warning: pg_exec() [function.pg-exec
> <http://alliance.terragis.net/php/function.pg-exec> ]: Query failed:
> ERROR:
> duplicate key violates unique constraint "pk_gui_layer" in
> /var/www/sites/mapbender/http/php/database-pgsql.php on line 133
> sql error: ERROR: duplicate key violates unique constraint "pk_gui_layer"
> ROLLBACK performed....
>
>
>
>
> Now I'm stuck and don't know how to port gui and wms to the server. Any
> ideas what went wrong, or how I can fix this?
>
> Karsten
>
>
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>
>

-- 
---------------------------------------
Ulrich Rothstein
WhereGroup GmbH & Co. KG
Siemensstra_e 8
53121 Bonn
Germany

Fon: +49 (0)228 / 90 90 38 - 17
Fax: +49 (0)228 / 90 90 38 - 11

mailto:uli.rothstein at wheregroup.com
http://www.wheregroup.com
Amtsgericht Bonn, HRA 6788
-------------------------------
Komplementdrin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
---------------------------------------

------------------------------

_______________________________________________
Mapbender_users mailing list
Mapbender_users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapbender_users

End of Mapbender_users Digest, Vol 14, Issue 1
**********************************************