Le 22/11/2012 12:22, Michael Friedrich a écrit :
On 2012-11-21 10:52, Serge Noiraud wrote:
Hi,
Does somebody already use postgresql with icinga-web ?
icinga works correctly with postgresql.
All works correctly with mysql, but I must use postgresql.
with icinga-web, I can't connect. I return automaticaly to the login
page.
How can I debug this ?
I configured icinga-web like this :
./configure --with-bin-user=icinga \
--with-bin-group=apache \
--prefix=/product/monitoring/icinga-web \
--sysconfdir=/product/monitoring/config/icinga-web \
--with-db-type=pgsql \
--with-db-host=localhost \
--with-db-name=icinga_web \
--with-db-user=icinga_web \
--with-db-pass=xxxx \
--with-db-port=52002 \
--with-api-type=pgsql \
--with-api-subtype=pgsql \
--with-api-host=localhost \
--with-api-port=52002 \
--with-api-db-prefix=icinga_ \
--with-api-db-name=icinga_web \
--with-api-db-user=icinga_web \
--with-api-db-pass=xxxx \
--with-web-apache-path=/etc/apache2/conf.d
Some remarks :
--syscondir doesn't work.
--sysconfdir does - where did you grab that string from?
./configure --help
icinga works correctly with this option but not icinga-web.
Do I miss something ?
check your configuration, especially the databases.xml - for the
details see the official documentation.
I 'll dig into this file
thanks. found nothing.
In the log files, I get the following If I choose the root user
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Starting authenticate
(username=root)
[Thu Nov 22 15:13:52 2012] [info] Auth.Dispatch: Converting username to
lowercase
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Userdata found in db
(uid=1)
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object (name=internal)
initialized
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Authoritative provider
found (provider=internal, authid=root)
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider.Database:
HASH(42bc5093863dce8c150387a5bb7e3061cf3ea67d2cf1779671e1b0f435e953a1)
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Successfull
authentication (provder=internal)
[Thu Nov 22 15:13:52 2012] [info] Auth.Dispatch: Delegate authentication
(not_authoritative=internal,user=root)
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object (name=auth_key)
initialized
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object
(name=http-basic-authentication) initialized
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Delegate
authentication, try http-basic-authentication
(not_authoritative=internal,user=root)
[Thu Nov 22 15:13:52 2012] [debug] Auth.Dispatch: Delegate
authentication, no providers found for root (not_authoritative=internal)
[Thu Nov 22 15:13:52 2012] [info] User root (Root, Enoch) logged in!
As you can see, I'm connected, but I return to the login window.
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object (name=internal)
initialized
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object (name=auth_key)
initialized
[Thu Nov 22 15:13:52 2012] [debug] Auth.Provider: Object
(name=http-basic-authentication) initialized
[Thu Nov 22 15:13:52 2012] [debug]
Auth.Provider.HTTPBasicAuthentification: Got data (auth_name=, auth_type=)
End of login here.
The following example is root with a bad password.
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: Starting authenticate
(username=root)
[Thu Nov 22 15:20:05 2012] [info] Auth.Dispatch: Converting username to
lowercase
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: Userdata found in db
(uid=1)
[Thu Nov 22 15:20:05 2012] [debug] Auth.Provider: Object (name=internal)
initialized
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: Authoritative provider
found (provider=internal, authid=root)
[Thu Nov 22 15:20:05 2012] [debug] Auth.Provider.Database:
HASH(8b37eac332f9e0cf8dedaf6463d0358422dc42d515233d70e987a43481bc477e)
[Thu Nov 22 15:20:05 2012] [info] Auth.Dispatch: Delegate authentication
(not_authoritative=internal,user=root)
[Thu Nov 22 15:20:05 2012] [debug] Auth.Provider: Object (name=auth_key)
initialized
[Thu Nov 22 15:20:05 2012] [debug] Auth.Provider: Object
(name=http-basic-authentication) initialized
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: Delegate
authentication, try http-basic-authentication
(not_authoritative=internal,user=root)
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: Delegate
authentication, no providers found for root (not_authoritative=internal)
[Thu Nov 22 15:20:05 2012] [debug] Auth.Dispatch: User cound not
authorized (username=root)
[Thu Nov 22 15:20:05 2012] [error] Userlogin by root failed!
The login window vibrates, so it's OK. So, I think the postgresql
connexion is OK.
I'm looking for right access in some directories
I tried to simplify the configure command to :
./configure --with-db-type=pgsql --with-db-port=5432
--with-api-type=pgsql --with-api-subtype=pgsql --with-api-port=5432
So, all path are set by default in /usr/local.
I now get one popup window : "Your login session has gone away, press ok
to login again!"
I click on the ok button and return to the login window.
My question : How can I debug that ?
--
Serge Noiraud
Les logiciels libre, c'est mieux : Debian, Firefox, LibreOffice, ...
Tout ce qui n'est pas gratuit est perdu.
Développeur projet gramps : http://www.gramps-project.org/
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
