Users and Contacts Directory Service

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Users and Contacts Directory Service

Post by ssax »

Really, hmm, were there any errors or anything? Please PM me the output of this command:

Code: Select all

echo "select * from xi_usermeta;" | psql nagiosxi nagiosxi
Thank you
jkinning
Posts: 747
Joined: Wed Oct 09, 2013 2:54 pm

Re: Users and Contacts Directory Service

Post by jkinning »

I ran the above command and it just scrolls and I then see flashes of data from time to time. I attempted to run the command and output it to a file but the file turned out to be over 2GB.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Users and Contacts Directory Service

Post by ssax »

That's huge, please run this command to limit it:

Code: Select all

echo "select * from xi_usermeta where keyname like '%auth_%' OR keyname like '%ldap%' OR keyname like '%allow_local%';" | psql nagiosxi nagiosxi
jkinning
Posts: 747
Joined: Wed Oct 09, 2013 2:54 pm

Re: Users and Contacts Directory Service

Post by jkinning »

Sent PM with output from new select statement.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Users and Contacts Directory Service

Post by ssax »

Received, please send in an email to [email protected] with a descriptive subject and detailed body with a link back to this thread so that we can get a remote session setup. I will keep an eye out for it, I will need to dig through the DB.

Thank you
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Users and Contacts Directory Service

Post by rkennedy »

Closing this out as I see a ticket has arrived.
Former Nagios Employee
Locked