Page 1 of 1

Web users

Posted: Sun Jul 04, 2010 9:48 am
by nets
I wanted to know that when you create a nagios user for web access, where is the that user stored...I know one place is in the htpasswd.users file, but what databse stores the users that you create.

Re: Web users

Posted: Tue Jul 06, 2010 3:29 pm
by tonyyarusso
The xi_users table in the nagiosxi database (which is in PostgreSQL).

Re: Web users

Posted: Tue Jul 06, 2010 3:31 pm
by tonyyarusso
To demonstrate:

Code: Select all

[root@demo ~]# psql nagiosxi nagiosxi
Welcome to psql 8.1.21, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

nagiosxi=> select * from xi_users;
 user_id |  username   |             password             |         name         |     email      | backend_ticket | enabled
---------+-------------+----------------------------------+----------------------+----------------+----------------+---------
      18 | nagiosadmin | 40be4e59b9a2a2b5dffb918c0e86b3d7 | Nagios Administrator | root@localhost | 1234           |       1
(1 row)

nagiosxi=> \q
[root@demo ~]#

Re: Web users

Posted: Wed Jul 07, 2010 3:09 am
by nets
thanks alot, that solves that problem...now the only thing I need to know is that how do I replicate the nagiosxi database into a backup server....I am already replicating the nagios and the nagiosql database

Re: Web users

Posted: Wed Jul 07, 2010 12:53 pm
by tonyyarusso
http://wiki.postgresql.org/wiki/Replica ... on_Pooling might get you started, although I can't see I've dabbled in that at all.