can't login to centreon

[Ortner, Gerald]

Hi,
AFAIK the first one wont’ work because every string after the hash (#) symbol is treated as comment. Correct me if I’m wrong
For mysql prompt use:
update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '% centreonadmin %;

If the update was successful the output should look like this:
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

The latter one won’t work if there is no contact with an alias like root…

For command line use:
echo “update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u root -p centreon2”


To verify if the update was successful, you can issue following command:
Mysql prompt:
select contact_passwd, contact_alias from contact where contact_alias like '%centreonadmin%'

CLI:
echo “select contact_passwd, contact_alias from contact where contact_alias like '%centreonadmin%'” | mysql -u root -p centreon2”

You don’t need the –h option if you are working on locally on the server

Gerald


Von: IT Toonz [mailto:it.toonz at gmail.com]
Gesendet: Freitag, 03. September 2010 06:00
An: 'Nagios Users List'
Betreff: Re: [Nagios-users] can't login to centreon


Hi Kyle,



Still not working ☹



This is how we tried, please let us know if we made any mistakes.



From the prompt.



[root at nagios ~]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 42037

Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use centreon2

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> #echo "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u root -p centreon2 -h 192.168.3.241

mysql>



and like this....



[root at nagios ~]# #echo "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%root%'" | mysql -u root -p centreon2 -h 192.168.3.241



Tried with centreonadmin and root, with password centreon, can’t login.... ☹



We might have to reinstall and configure everthing....



Please advice...

Regards

Ananth.





-----Original Message-----
From: Kyle Bader [mailto:kyle.bader at gmail.com]
Sent: 02 September 2010 21:22
To: Nagios Users List
Subject: Re: [Nagios-users] can't login to centreon



> Thanks for the continued support...

>

> Please look at the centreon.conf.php file... seems user is “root” we tried

> root and all passwords which we could think of...



You use this information combined with the command from earlier to

reset the password hash:



echo "update contact set contact_passwd =

'2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like

'%centreonadmin%'" | mysql -u root -p centreon2 -h 127.0.0.1



If you didn't censor the password and the value really is "" then you

probably only need to press enter when prompted for the password (from

the command above).  This is terribly insecure and should be changed

at some point.



--



Kyle



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

This SF.net Dev2Dev email is sponsored by:



Show off your parallel programming skills.

Enter the Intel(R) Threading Challenge 2010.

http://p.sf.net/sfu/intel-thread-sfd

_______________________________________________

Nagios-users mailing list

Nagios-users at lists.sourceforge.net<mailto:Nagios-users at lists.sourceforge.net>

https://lists.sourceforge.net/lists/listinfo/nagios-users

::: Please include Nagios version, plugin version (-v) and OS when reporting any issue.

::: Messages without supporting info will risk being sent to /dev/null

________________________________
OOe. Gesundheits- und Spitals-AG
Techcenter, Hafenstrasse 47-51, 4020 Linz DVR 2107870, ATU 51928204, Firmenbuchgericht: Landesgericht Linz, FN 210146 p
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100903/f869d1d6/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null