<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 12 (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:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</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=EN-IN link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><i><span style='color:#31849B'>Hi Kyle,<o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'><o:p> </o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>Still not working </span></i><span
style='font-family:Wingdings;color:#31849B'>L</span><i><span style='color:#31849B'><o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'><o:p> </o:p></span></i></p>
<p class=MsoPlainText><i><span 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 style='color:#31849B'><o:p> </o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>From the prompt.<o:p></o:p></span></i></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>[root@nagios ~]# mysql<o:p></o:p></p>
<p class=MsoPlainText>Welcome to the MySQL monitor. Commands end with ; or \g.<o:p></o:p></p>
<p class=MsoPlainText>Your MySQL connection id is 42037<o:p></o:p></p>
<p class=MsoPlainText>Server version: 5.0.77 Source distribution<o:p></o:p></p>
<p class=MsoPlainText>Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.<o:p></o:p></p>
<p class=MsoPlainText>mysql> use centreon2<o:p></o:p></p>
<p class=MsoPlainText>Reading table information for completion of table and
column names<o:p></o:p></p>
<p class=MsoPlainText>You can turn off this feature to get a quicker startup
with -A<o:p></o:p></p>
<p class=MsoPlainText>Database changed<o:p></o:p></p>
<p class=MsoPlainText>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></p>
<p class=MsoPlainText>mysql><o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><i><span style='color:#31849B'>and like this....<o:p></o:p></span></i></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>[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></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><i><span style='color:#31849B'>Tried with centreonadmin
and root, with password centreon, can’t login.... </span></i><i><span
style='font-family:Wingdings;color:#31849B'>L</span><span style='color:#31849B'><o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'><o:p> </o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>We might have to reinstall
and configure everthing....<o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'><o:p> </o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>Please advice...<o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>Regards<o:p></o:p></span></i></p>
<p class=MsoPlainText><i><span style='color:#31849B'>Ananth.<o:p></o:p></span></i></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></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><o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>> Thanks for the continued support...<o:p></o:p></p>
<p class=MsoPlainText>><o:p> </o:p></p>
<p class=MsoPlainText>> Please look at the centreon.conf.php file... seems
user is “root” we tried<o:p></o:p></p>
<p class=MsoPlainText>> root and all passwords which we could think of...<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>You use this information combined with the command from
earlier to<o:p></o:p></p>
<p class=MsoPlainText>reset the password hash:<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>echo "update contact set contact_passwd =<o:p></o:p></p>
<p class=MsoPlainText>'2995cb0650c5f107230ed569a8c4d6e5' where contact_alias
like<o:p></o:p></p>
<p class=MsoPlainText>'%centreonadmin%'" | mysql -u root -p centreon2 -h
127.0.0.1<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>If you didn't censor the password and the value really is
"" then you<o:p></o:p></p>
<p class=MsoPlainText>probably only need to press enter when prompted for the
password (from<o:p></o:p></p>
<p class=MsoPlainText>the command above). This is terribly insecure and should
be changed<o:p></o:p></p>
<p class=MsoPlainText>at some point.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>-- <o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Kyle<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>------------------------------------------------------------------------------<o:p></o:p></p>
<p class=MsoPlainText>This SF.net Dev2Dev email is sponsored by:<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Show off your parallel programming skills.<o:p></o:p></p>
<p class=MsoPlainText>Enter the Intel(R) Threading Challenge 2010.<o:p></o:p></p>
<p class=MsoPlainText>http://p.sf.net/sfu/intel-thread-sfd<o:p></o:p></p>
<p class=MsoPlainText>_______________________________________________<o:p></o:p></p>
<p class=MsoPlainText>Nagios-users mailing list<o:p></o:p></p>
<p class=MsoPlainText>Nagios-users@lists.sourceforge.net<o:p></o:p></p>
<p class=MsoPlainText>https://lists.sourceforge.net/lists/listinfo/nagios-users<o:p></o:p></p>
<p class=MsoPlainText>::: Please include Nagios version, plugin version (-v)
and OS when reporting any issue. <o:p></o:p></p>
<p class=MsoPlainText>::: Messages without supporting info will risk being sent
to /dev/null<o:p></o:p></p>
</div>
</body>
</html>