<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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:blue;
text-decoration:underline;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=DE link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>after setting up a new Mapbender
2.4 and loading PostgreSQL from SQL-Scripts from <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="Courier New"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Courier New";color:navy'> …\resources\db\postgresql\pgsql_**.sql<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>… I had the same
Trouble: ‘root/root’ was <b><span style='font-weight:bold'>not</span></b>
accepted to log in.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>This may be a problem how
the encrypted Value is transported and loaded into PostgreSQL.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>(I unzipped mapbender on
Windows, export with WinSCP to Linux, where the Database and Mapbender is
running)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>I fixed it by <u>writing
a new Password for User “root” into the Database</u> “mapbender”:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face="Courier New"><span lang=EN-GB
style='font-size:10.0pt;font-family:"Courier New";color:navy'>update mb_user
set mb_user_password = md5('<i><span style='font-style:italic'>MyNewPassword</span></i>')
where mb_user_name = 'root';<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>(from pgAdmin III Database
Client)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>The function md5 does
the encryption. It must be defined as a function in PG.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Inserting a new user “admin1”
wouldn’t help you. He has no guis.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>User “root” is
owner off all guis. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>He has to create other users.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>He has do give the rights
to other users.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Greetings<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>F. Jaeger<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-GB
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>Von:</span></font></b><font
size=2 face=Tahoma><span lang=EN-GB style='font-size:10.0pt;font-family:Tahoma'>
smithveg [mailto:smithveg@gmail.com] <br>
<b><span style='font-weight:bold'>Gesendet:</span></b> Donnerstag, 10. August
2006 13:37<br>
<b><span style='font-weight:bold'>An:</span></b> <st1:PersonName w:st="on">users@mapb<span
lang=DE>ender.osgeo.org</span></st1:PersonName><br>
</span></font><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>Betreff:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Re:
[Mapbender-users] the mapbender installation stuck on half way</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>ya, is that, but the
password has already encrypted. How can i get the password? otherwise i just
add in a new user. But i do not know how to add the password. I try to use the
function as below.. it cannot go though..<br>
case 1:<br>
---------------------------------<br>
postgres=# INSERT INTO mb_user
VALUES(1,'admin1',password(admin),1,'admin',100);<br>
<br>
ERROR: column "admin" does not exist<br>
---------------------------------- <br>
case 2:<br>
----------------------------------<br>
postgres=# INSERT INTO mb_user VALUES(1,'admin1',password('admin'),1,'admin',100<br>
);<br>
ERROR: function password("unknown") does not exist<br>
HINT: No function matches the given name and argument types. You may need
to ad <br>
d explicit type casts.<br>
-----------------------------------<br>
<br>
This are the 2 possible error i get, when i insert new record.<br>
<br>
<br>
<br>
<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><span class=gmailquote><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 8/10/06, <b><span style='font-weight:bold'>Manfred
Meier</span></b> <<a href="mailto:m.meier@spiekermann.de">m.meier@spiekermann.de</a>>
wrote:</span></font></span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Hi,<br>
<br>
is in the mapbender database in table mb_user (at least in my mysql<br>
installation) a user root and a password? fields are "mb_user_name"
and<br>
"mb_user_password".<br>
<br>
Manfred<br>
<br>
<br>
<br>
smithveg schrieb:<br>
<br>
> I'm using windows xp SP2, PostgreSQL (postgreSQL could support<br>
> mapbender), PHP 5.0.3<br>
> I did check for <a href="http://www.mapbender.org">www.mapbender.org</a>
<<a href="http://www.mapbender.org"> http://www.mapbender.org</a>> site,
no<br>
> solution was found. I think i stuck at admin username and password. I<br>
> think it cannot get the default username and pasword from the<br>
> instalation guide. In addition, i never set any password. It may be the <br>
> default password.<br>
><br>
> Thansk<br>
><br>
> On 8/10/06, Lars-Hendrik Schneider <<a
href="mailto:schneider@terrestris.de">schneider@terrestris.de</a><br>
> <mailto:<a href="mailto:schneider@terrestris.de">
schneider@terrestris.de</a>>> wrote:<br>
><br>
> Hi <realname?>,<br>
><br>
> smithveg schrieb:<br>
> > Dear, I can't get the mapbender
working. I stuck on half way, anyone<br>
> > helps me. Thanks. <br>
><br>
> I think these are to less information. Please provide
what you have<br>
> done<br>
> so far, which system you use (OS, database, PHP +
version, which<br>
> Mapbender ...) and describe in detail where you
stuck. Have a look at <br>
> the mapbender WIKI also to get some background
information. Otherwise<br>
> (like with this mail) it is impossible to help
you!<br>
><br>
> Regards,<br>
> Lars-Hendrik<br>
><br>
>
--------------------------------------------------------------------- <br>
> To unsubscribe, e-mail: <a
href="mailto:users-unsubscribe@mapbender.osgeo.org">users-unsubscribe@mapbender.osgeo.org</a><br>
> <mailto:<a
href="mailto:users-unsubscribe@mapbender.osgeo.org">users-unsubscribe@mapbender.osgeo.org
</a>><br>
> For additional commands, e-mail: <a
href="mailto:users-help@mapbender.osgeo.org">users-help@mapbender.osgeo.org</a><br>
> <mailto:<a
href="mailto:users-help@mapbender.osgeo.org">users-help@mapbender.osgeo.org </a>><br>
><br>
><br>
><br>
><br>
> --<br>
> smithveg<br>
<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: <a href="mailto:users-unsubscribe@mapbender.osgeo.org">users-unsubscribe@mapbender.osgeo.org</a><br>
For additional commands, e-mail: <a href="mailto:users-help@mapbender.osgeo.org">users-help@mapbender.osgeo.org</a><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
smithveg <o:p></o:p></span></font></p>
</div>
</body>
</html>