Hi,

My question is related to bug 231. I'm having the same problem as described but using the latest 3.0.2 version of NagiosQL.

www.nagiosql.org/_mantis/view.php?id=231

Basically, when you have more then one domain, services are exported cross-domain. Example:

I have Domain1 with Service1 and Service2
I have Domain2 with Service1 and Service2

When I export Domain1 configuration I get the following services in the files: Service1, Service1, Service2 and Service2. Shouldn't I only have one Service1 and one Service2?

Same thing for Domain2, I get all 4 services...

This cause the following error in Nagios, as you can see with the "CPU usage" service.

[1240882148] Warning: Duplicate definition found for service 'CPU usage' on host 'nagios' (config file '/opt/nagios/etc/services/NRPE.cfg', starting on line 30)
[1240882148] Warning: Duplicate definition found for service 'CPU usage' on host 'nagios' (config file '/opt/nagios/etc/services/NRPE.cfg', starting on line 14)

Can someone let me know if it is normal behavior? If not, is there plan to fix this in 3.0.3 or can you provide a patch?

I am using:

NagiosQL 3.0.2
Nagios 3.0.6 (compiled for i386)
CentOS 5.3 x86_64
PHP 5.1.6 (standard RPM from CentOS)
Apache 2.2.3 (standard RPM from CentOS)
MySQL 5.0.45 (standard RPM from CentOS)

Thank you very much,

Jean-Philippe

I will attach the actual class file to this thread this evening - so you can check if this is solvend in 3.0.3 or not

Thanks, that would be really appreciated as it is the only thing that cause us problem at the moment.

Jean-Philippe

Here is the file - I hope that's all
This attachment is hidden for guests. Please login or register to see it.

Hi Martin,

Sorry but I think it didn't solve the problem. I will make sure by cleaning the VM and testing again.

Using diff I saw the changes you made, but I see nothing about tbl_service. But don't worry about that, maybe it's me which doesn't understand it well

I'll let you know about the 2nd test soon.

Thanks,

Jean-Philippe

Hi,

I tested again and unfortunately the bug was still there. However, I was able to figure out what was the problem.

It is located on line 983 of config_class.php:


Original (3.0.3):
$strSQLData = "SELECT * FROM `".$strTableName."` WHERE `config_name`='$strConfigName' ORDER BY `service_description`";


Modified:
$strSQLData = "SELECT * FROM `".$strTableName."` WHERE `config_name`='$strConfigName' AND `config_id`=".$this->intDomainId." ORDER BY `service_description`";


So as I said in the bugport (#231), there was a missing "WHERE config_id = x".

Thank you very much Martin for helping me on that one, maybe you can apply that patch to 3.0.3

Thanks,

J-P