[op5-users] Ninja views

[Hienz, Michael]

Pier,

if the ninja_user_authentication table is empty and you would like to have admin access you need you insert in to this table one record, with the user_id from your nagios admin user, that should be found in the user table. If you do not have your Nagiosadmin in this table as well, you need to create it. All other values should be set to one in the ninja_user_authentication table record, well except the id field as it is auto_incrementing. You also need to look into the roles table to see which id the admin role has. Remember this ID and check the roles_user table. If the ID of your nagiosadmin can't be found in there, create a record and insert the ID of your nagiosadmin, plus the admin id for the role_id, which you could look up in the roles table.

I hope that I am right with this one, at least that is my understanding to setup the user rights fully manually. It may sound confusing, because there are quite some cross references to other tables.

Michael



-----Ursprüngliche Nachricht-----
Von: op5-users-bounces at lists.op5.com [mailto:op5-users-bounces at lists.op5.com] Im Auftrag von Pier
Gesendet: Freitag, 23. Oktober 2009 16:10
An: Mailinglist for op5's products
Betreff: Re: [op5-users] Ninja views

> > I tried to restart merlin and checked in the logs, but
> i get always 3 hosts.
> 
> Have you checked the content of the database?
> There is no way for us to tell what the problem might be if
> we don't know if 
> the content of the merlin database differs from the output
> in Ninja.
 mysql> select * from hosts;
[...]

82 rows in set (0.00 sec)



> You should also check the content of the
> merlin.ninja_user_authorization 
> table. If it is empty (or if all_hosts or all_services is
> 0), you will only be 
> able to see the objects where you are an authorized
> contact.
mysql> select * from ninja_user_authorization;
Empty set (0.00 sec)

It's actually empty.

Pier


      
_______________________________________________
op5-users mailing list
op5-users at lists.op5.com
http://lists.op5.com/mailman/listinfo/op5-users

**********************
** LEGAL DISCLAIMER **
**********************

This E-mail message and any attachments may contain 
legally privileged, confidential or proprietary 
information. If you are not the intended recipient(s),
or the employee or agent responsible for delivery of 
this message to the intended recipient(s), you are 
hereby notified that any dissemination, distribution 
or copying of this E-mail message is strictly 
prohibited. If you have received this message in 
error, please immediately notify the sender and 
delete this E-mail message from your computer.