can't login to centreon

[Ortner, Gerald]

Hi Gerald,

Try the command I’ve provided!
No need for the pipe command nor double quotes!
Just execute :

update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '% centreonadmin %;

at the mysql command prompt!!


Every SQL statement ends with a semicolon (;)

At least try to read carefully the advices people give you. Maybe your problem would have been solved days ago…

Gerald

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

Hi Gerald,


[root at nagios ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 45494
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> "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u centreonadmin -p centreon2 -h 192.168.3.241
    -> "update contact set contact_passwd = '2995cb0650c5f107230ed569a8c4d6e5' where contact_alias like '%centreonadmin%'" | mysql -u centreonadmin -p centreon2
    ->

Nothing happens...we just get the prompt... ☹

Even verification also, it just returns the command.

Please advice.

Regards
Ananth.



From: Ortner, Gerald [mailto:Gerald.Ortner at gespag.at]
Sent: 03 September 2010 11:14
To: Nagios Users List
Subject: Re: [Nagios-users] can't login to centreon

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

________________________________
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/c28537e2/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