Hi,
I set up Nagiosql 3.0.1 on FreeBSD 7.2 with Apache 2.2, MYSQL 5.0.51 and PHP 5.2.5.

I imported a timeperiods.cfg file successfully. After that I have duplicate entries in the Time periods section. When I tried to delete some of them, I got this message:

SELECT * FROM `tbl_timedefinition` WHERE `idMaster`=9Error[3]: Unknown column 'idMaster' in 'where clause'

and the other I got this message:
No data deleted. The dataset probably does not exist, is protected from deletion or has relations to other configurations which cannot be deleted. Use the "info" function for detailed information about relations!

I was going to manually delete it from the database, but when I went into the database to see, there is no idMaster field in tbl_timedefinition table or the tbl_timedefinistion table.

Any suggestion as how I can get out of this? Thanks.

Jean

Well, I am managed to delete the extra ones in the tlb_timeperiod table by login to the database. I hope I didn't break any links that I don't see. But still not sure where the

"SELECT * FROM `tbl_timedefinition` WHERE `idMaster`=9Error[3]: Unknown column 'idMaster' in 'where clause'"

came from.

Since this is fixed, then the next question is that I am not sure why Nagios is not sending out alerts -- either email nor call to a phone number. First I thought it might be related to the time period setup. But now that the time period setup is ok. I compared my host.cfg and service.cfg to the ones posted here and said to be ok. They are more or less the same as mine. So I am not sure where else to trouble shoot. Anyone any ideas? Thanks.

Jean

First, you should update to 3.0.3 before importing your data - there were some fixed issues since 3.0.1 inside the importer.