<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="urn:schemas-microsoft-com:office:smarttags">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.terra, li.terra, div.terra
{margin:0in;
margin-bottom:.0001pt;
line-height:15.0pt;
font-size:11.0pt;
font-family:Arial;}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi list,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m working with mapbender 2.4.3 and created a gui
including one wms (<a
href="http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projects/alliance/ok_server.map&">http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projects/alliance/ok_server.map&</a>)
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<br>
Insert into gui_mb_user Values (‘ocla1’,1,’owner’);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>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. <br>
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?<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Thus, I tried to recreate the wms with
“load capabilities”, however trying to load <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><a
href="http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projects/alliance/ok_server.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0">http://alliance.terragis.net/cgi-bin/mapserv?map=/var/www/mapdata/projects/alliance/ok_server.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0</a><o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>gives me a violation of a constraint
</span></font><font size=2 face=Wingdings><span style='font-size:10.0pt;
font-family:Wingdings'>L</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>:<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;font-weight:bold'>Warning</span></font></b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>: pg_exec()
[<a href="http://alliance.terragis.net/php/function.pg-exec">function.pg-exec</a>]:
Query failed: ERROR: duplicate key violates unique constraint
"pk_gui_layer" in <b><span style='font-weight:bold'>/var/www/sites/mapbender/http/php/database-pgsql.php</span></b>
on line <b><span style='font-weight:bold'>133</span></b><br>
sql error: ERROR: duplicate key violates unique constraint
"pk_gui_layer" ROLLBACK performed....<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>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?<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>Karsten<o:p></o:p></span></font></p>
</div>
</body>
</html>