David Lynum wrote:
Joseph,
Thanks for getting back to me. Since I first submitted my question, I've been able to login. Now I'm having an
issue where once I login, I get "loading", and no further. Unfortunately the documentation for
icinga and icinga-web is complete. Meaning that I've had to look multiple places to get my answers. I ended up
going back to the icinga documentation and making sure that icinga-API and IDOUtils were all installed. The
documentation that I found for installing icinga and icinga-web doesn't have this step that you mentioned:
"mysql -u root -p icinga_web</usr/share/icinga-web/etc/schema/mysql.sql". So now I have the
"loading" issue, meaning that icinga web keeps loading data. This is mentioned in the icinga.org
documentation for installing icinga-web. Here is my icinga-web log file from today:
that's just the manual way of doing things, the preferred target is to
use make db-initialize for starters. look in the wiki for more advanced
howtos next to the official docs.
cat icinga-web-2011-07-25.log | more
[Mon Jul 25 15:47:57 2011] [fatal] Uncaught AppKitPHPError: PHP Error mkdir() [<a
href='function.mkdir'>function.mkdir</a>]: File exists
(/usr/local/icinga-web/app/cache/config/compile.xml_
development__033d402eaeb08f42e4e3d5f8474e444805e2c7c6.php:1327)
(/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Mon Jul 25 15:47:57 2011] [fatal] Uncaught AppKitPHPError: PHP Error mkdir() [<a
href='function.mkdir'>function.mkdir</a>]: File exists
(/usr/local/icinga-web/app/cache/config/compile.xml_
development__033d402eaeb08f42e4e3d5f8474e444805e2c7c6.php:1327)
(/usr/local/icinga-web/app/modules/AppKit/lib/logging/AppKitExceptionHandler.class.php:20)
[Mon Jul 25 16:00:29 2011] [error] Userlogin by nagios failed!
[Mon Jul 25 16:00:35 2011] [error] Userlogin by nagios failed!
[Mon Jul 25 16:00:44 2011] [error] Userlogin by icinga failed!
[Mon Jul 25 16:00:51 2011] [error] Userlogin by icinga failed!
[Mon Jul 25 16:00:56 2011] [error] Userlogin by icinga failed!
[Mon Jul 25 16:01:02 2011] [error] Auth.Dispatch: Delegate authentication, no
providers found for root (not_authoritative=internal)
[Mon Jul 25 16:01:02 2011] [error] Userlogin by root failed! (Please ignore the
userlogin by root failed. I mistyped the password.)
there's only one user (root) by default. the other users must be created
through icinga-web itsself (don't use htpasswd.user, the authentication
method is different).
Here's the tail of my icingaApi.log:
tail icingaApi.log
2011-07-25T16:32:34+00:00 - [EXCEPTION] Database connection failed:
SQLSTATE[28000] [1045] Access denied for user 'icinga'@'localhost' (using
password: YES)
2011-07-25T16:32:34+00:00 - [EXCEPTION] getConnection failed: Database
connection failed: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost' (using password: YES)
2011-07-25T16:33:35+00:00 - [EXCEPTION] Database connection failed:
SQLSTATE[28000] [1045] Access denied for user 'icinga'@'localhost' (using
password: YES)
2011-07-25T16:33:35+00:00 - [EXCEPTION] getConnection failed: Database
connection failed: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost' (using password: YES)
2011-07-25T16:33:35+00:00 - [EXCEPTION] Database connection failed:
SQLSTATE[28000] [1045] Access denied for user 'icinga'@'localhost' (using
password: YES)
2011-07-25T16:33:35+00:00 - [EXCEPTION] getConnection failed: Database
connection failed: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost' (using password: YES)
2011-07-25T16:34:36+00:00 - [EXCEPTION] Database connection failed:
SQLSTATE[28000] [1045] Access denied for user 'icinga'@'localhost' (using
password: YES)
2011-07-25T16:34:36+00:00 - [EXCEPTION] getConnection failed: Database
connection failed: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost' (using password: YES)
2011-07-25T16:34:36+00:00 - [EXCEPTION] Database connection failed:
SQLSTATE[28000] [1045] Access denied for user 'icinga'@'localhost' (using
password: YES)
2011-07-25T16:34:36+00:00 - [EXCEPTION] getConnection failed: Database
connection failed: SQLSTATE[28000] [1045] Access denied for user
'icinga'@'localhost' (using password: YES)
I can login to mysql with the user as icinga. But the icinga user doesn't have
a password. The documentation for creating the icinga user doesn't mention
giving the icinga account a password.
that's wrong. what do you expect 'identified by' to be in sql syntax?
GRANT USAGE ON *.* TO 'icinga'@'localhost'
IDENTIFIED BY 'icinga'
My ido2db.cfg has db_pass= set to nothing. I was trying to see if this would help resolve this error.
Originally it was set to db_pass=icinga. As to module.xml, I changed the config_password parameter to
"><" from">icinga<", to see if that would help, and it didn't.
as the documentation states,
*Database creation*
Icinga Web requires its own database e.g. icinga_web. You can use the
one from Icinga IDOUtils but it is recommended to keep this separated
for upgrading purposes.
so most likely you'll have the 2 of them, one for icinga_web one for
idoutils. to tell the icinga-api the correct credentials, you are
required to edit the icinga-web config calling the api properly.
icinga-io.xml as a pointer.
regarding the no password thingy - why in the world would someone set no
password onto a database? why didn't you just keep the icinga password
either way. then it would have worked. an no, i've got no idea how to
tell the icinga-api not to use any password when accessing the database ...
kind regards,
michael
Any ideas?
Thanks
David Lynum
IT Support Lead, Wholesale Applications Community (WAC)
Desk: +1 (925) 201-8520
Email: [email protected]
6210 Stoneridge Mall, Road Suite 400 Pleasanton, CA 94588
www.wacapps.net
-----Original Message-----
From: Joseph L. Casale [mailto:[email protected]]
Sent: Monday, July 25, 2011 3:28 AM
To: '[email protected]'
Subject: Re: [icinga-users] Can't login to icinga-web
I'm using the default username and password of root/password, but I get the
error that my login failed.
Did you start ido2db and whatever sql server you are using, is it configured
right?
There's also another error, the server encountered an error: Internal
Exception, check your logs. What logs should I be checking?
Look in /usr/share/icinga-web/app/data/log/
Any ideas on why I can't login? Icinga using the classic web interface works
just fine.
Classic doesn't have a dependency on the sql portion, recheck your db creation
and grant statements, then import the db scripts:
mysql -u root -p icinga</etc/icinga/idoutils/mysql/mysql.sql
mysql -u root -p icinga_web</usr/share/icinga-web/etc/schema/mysql.sql
if you are using mysql for example. (Paths might be different...)
Then make sure icinga.cfg is set to load and use ido2db.
jlc
------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that has
been used successfully in hundreds of IBM storage optimization engage- ments,
worldwide. Store less, Store more with what you own, Move data to the right
place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide. Store less, Store more with what you own, Move data to
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
--
DI (FH) Michael Friedrich
Vienna University Computer Center
Universitaetsstrasse 7 A-1010 Vienna, Austria
email: [email protected]
phone: +43 1 4277 14359
mobile: +43 664 60277 14359
fax: +43 1 4277 14338
web: http://www.univie.ac.at/zid
http://www.aco.net
Icinga Core& IDOUtils Developer
http://www.icinga.org
------------------------------------------------------------------------------
Storage Efficiency Calculator
This modeling tool is based on patent-pending intellectual property that
has been used successfully in hundreds of IBM storage optimization engage-
ments, worldwide. Store less, Store more with what you own, Move data to
the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
