Mysql error when cacti could not resolve the Domain

[farhan]

Hi guys,

I am experiencing mysql errors if your host is not resolvabe. Today my

DNS server was down. And cacti could not resolve these domains and

giving following erros.

The logfile is

01/23/2006 12:52:22 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:22 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:22 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:22 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:22 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:22 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1'


01/23/2006 12:52:51 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:51 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:51 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:51 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:51 PM - CACTID: Poller[0] WARNING: Unknown host MGR0-T1.test.comindico.com.au
01/23/2006 12:52:51 PM - CACTID: Poller[0] Host[2] ERROR: HOST EVENT: Host is DOWN Message: SNMP not performed due to setting or ping result, ICMP: Destination hostname invalid
01/23/2006 12:52:51 PM - CACTID: Poller[0] ERROR: Problem with MySQL: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1'.

I think cacti should give proper error in log instead of mysql errors.

Sorry this message should have been poster under Linux/Unix help.