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.