<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:Consolas;}
p.PlainText, li.PlainText, div.PlainText
{mso-style-name:"Plain Text";
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.E-MailFormatvorlage21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE-AT" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-IN">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">AFAIK the first one wont’ work because every string after the hash (#) symbol is treated as comment. Correct me if I’m wrong<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">For mysql prompt use:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '% centreonadmin %;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">If the update was successful the output should look like this:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">Query OK, 1 row affected (0.02 sec)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">Rows matched: 1 Changed: 1 Warnings: 0<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">The latter one won’t work if there is no contact with an alias like root…<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">For command line use:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">echo “update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u root -p centreon2”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">To verify if the update was successful, you can issue following command:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">Mysql prompt:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">select contact_passwd, contact_alias from contact where contact_alias like '%centreonadmin%'<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">CLI:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">echo “select contact_passwd, contact_alias from contact where contact_alias like '%centreonadmin%'” | mysql -u root -p centreon2”<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">You don’t need the –h option if you are working on locally on the server<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN">Gerald<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-IN"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> IT Toonz [mailto:it.toonz@gmail.com]
<br>
<b>Gesendet:</b> Freitag, 03. September 2010 06:00<br>
<b>An:</b> 'Nagios Users List'<br>
<b>Betreff:</b> Re: [Nagios-users] can't login to centreon<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Hi Kyle,<o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B"><o:p> </o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Still not working
</span></i><span lang="EN-IN" style="font-family:Wingdings;color:#31849B">L</span><i><span lang="EN-IN" style="color:#31849B"><o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B"><o:p> </o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">This is how we tried, please let us know if we made any mistakes.<o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B"><o:p> </o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">From the prompt.<o:p></o:p></span></i></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">[root@nagios ~]# mysql<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Welcome to the MySQL monitor. Commands end with ; or \g.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Your MySQL connection id is 42037<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Server version: 5.0.77 Source distribution<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">mysql> use centreon2<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Reading table information for completion of table and column names<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">You can turn off this feature to get a quicker startup with -A<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Database changed<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">mysql> #echo "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u root -p centreon2 -h 192.168.3.241<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">mysql><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">and like this....<o:p></o:p></span></i></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">[root@nagios ~]# #echo "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%root%'" | mysql -u root -p centreon2 -h 192.168.3.241<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Tried with centreonadmin and root, with password centreon, can’t login....
</span></i><i><span lang="EN-IN" style="font-family:Wingdings;color:#31849B">L</span></i><i><span lang="EN-IN" style="color:#31849B"><o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B"><o:p> </o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">We might have to reinstall and configure everthing....<o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B"><o:p> </o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Please advice...<o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Regards<o:p></o:p></span></i></p>
<p class="MsoPlainText"><i><span lang="EN-IN" style="color:#31849B">Ananth.<o:p></o:p></span></i></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">-----Original Message-----<br>
From: Kyle Bader [mailto:kyle.bader@gmail.com] <br>
Sent: 02 September 2010 21:22<br>
To: Nagios Users List<br>
Subject: Re: [Nagios-users] can't login to centreon</span><span lang="EN-IN"><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">> Thanks for the continued support...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">> Please look at the centreon.conf.php file... seems user is “root” we tried<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">> root and all passwords which we could think of...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">You use this information combined with the command from earlier to<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">reset the password hash:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">echo "update contact set contact_passwd =<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">'2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">'%centreonadmin%'" | mysql -u root -p centreon2 -h 127.0.0.1<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">If you didn't censor the password and the value really is "" then you<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">probably only need to press enter when prompted for the password (from<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">the command above). This is terribly insecure and should be changed<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">at some point.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">-- <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Kyle<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">------------------------------------------------------------------------------<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">This SF.net Dev2Dev email is sponsored by:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><o:p> </o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Show off your parallel programming skills.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Enter the Intel(R) Threading Challenge 2010.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><a href="http://p.sf.net/sfu/intel-thread-sfd">http://p.sf.net/sfu/intel-thread-sfd</a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">_______________________________________________<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">Nagios-users mailing list<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><a href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN"><a href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a><o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-IN">::: Messages without supporting info will risk being sent to /dev/null<o:p></o:p></span></p>
</div>
<br>
<hr>
<font face="Arial" color="Black" size="1">OOe. Gesundheits- und Spitals-AG<br>
Techcenter, Hafenstrasse 47-51, 4020 Linz DVR 2107870, ATU 51928204, Firmenbuchgericht: Landesgericht Linz, FN 210146 p<br>
</font>
</body>
</html>