can't login to centreon
IT Toonz
it.toonz at gmail.com
Fri Sep 3 11:50:55 CEST 2010
We reinstalled FAN 2.0 and these are the users available. Can’t find centreonadmin!!! Not sure if we are using a different FAN!!
Thanks for all your help, Sure Gerald will do so... I’m trying Nagios inbetween doing other tasks and client support calls, that why couldn’t concentrate more on it. J
Copying back the conf files now... will be back with any issues as soon as we face them....
centreon users.JPG
From: Ortner, Gerald [mailto:Gerald.Ortner at gespag.at]
Sent: 03 September 2010 14:31
To: Nagios Users List
Subject: Re: [Nagios-users] can't login to centreon
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... L
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 L
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.... L
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
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/8800fbb0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 55906 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20100903/8800fbb0/attachment.jpg>
-------------- 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
More information about the Users
mailing list