Le 22/11/2012 00:39, Chris Curvey a écrit :
On Wed, Nov 21, 2012 at 5:52 PM, Serge Noiraud <serge.noir...@bull.net
<mailto:serge.noir...@bull.net>> 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.
Do I miss something ?
Can you connect to the postgres database locally using psql and those
credentials? (if not, check the configuration of "listen" and "port"
in postgresql.conf.)
Yes, It works. I tried with apache user :
bash-4.1$ id
uid=48(apache) gid=48(apache) groups=48(apache)
bash-4.1$psql -p 52002 -Uicinga_web icinga_web
psql (8.4.13)
Type "help" for help.
icinga_web=> \c
psql (8.4.13)
You are now connected to database "icinga_web".
icinga_web=> \d
List of relations
Schema | Name | Type | Owner
--------+----------------------------------+----------+------------
public | cronk | table | icinga_web
public | cronk_category | table | icinga_web
public | cronk_category_cc_id_seq | sequence | icinga_web
public | cronk_category_cronk | table | icinga_web
public | cronk_cronk_id_seq | sequence | icinga_web
public | cronk_principal_category | table | icinga_web
public | cronk_principal_cronk | table | icinga_web
...
--
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
