NagiosQL and tbl_service

[emi65]

Hi expert

I'm using nagiosQL 3.2 and in tbl_service there is a field called
import_hash

Do you know what is ?

thanks
Emilio

[abrist]

From: https://svn.nagiosql.org/nagiosql/tags/ ... 04_310.sql

-- Add new import_hash field for all tables without key

A few of the nagios objects do not have a unique key: escalations/dependencies. I think import_hash was added to give these a unique key, and I think they just extended the behavior to all objects (as they should).

[emi65]

... but I create a bash/mysql script in order to add massive services in the tbl_service

I am able to add all and I don't get any error but from the nagios interface I cannot see the service
(I see just the host)

If I check the tbl_service I see the record but the import_hash field is empty.

Is there a way to set a right value for this field ?

I did also this test
from nagiosql interface , I duplicate one oh this inserted service and I save it, so
I'm able to see this service in the nagios interface and also the original .
Why ?
When I check the tbl_service of this duplicate service I can see a value in the hash field .

So the question is : what is the right way to create a valid hash value ?

thanks
Emilio

[Box293]

This question is better suited in the NagosQL forums:

http://www.nagiosql.org/forum8/