Hi Mike,
the config section
<ClientListSQL>
DBSource dbi:Oracle:NAC
DBUsername foo
DBAuth bar
ConnectionHook sub { \
$_[1]->do("ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD
HH24:MI:SS'"); \
$_[1]->do("ALTER SESSION SET CURRENT_SCHEMA = nacadm"); \
}
# store the supportgroup from the CMDB in the OSC-Group-Identifier attribute
GetClientQuery SELECT device.ipaddr, 'key', NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, device.hostid, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 'OSC-Group-Identifier=' || tblhost.hsup FROM device
JOIN core.tblh...@pcmsat01 ON (device.hostid = tblhost.hostid) WHERE
device.fk_collector = 5
# Reread the client list every hour
RefreshPeriod 3600
</ClientListSQL>
the error from the level 3 logfile:
Thu Oct 14 12:57:42 2010: ERR: Execute failed for 'SELECT device.ipaddr, 'key',
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
device.hostid, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
'OSC-Group-Identifier=' || tblhost.hsup FROM device JOIN core.tblh...@pcmsat01
ON (device.hostid = tblhost.hostid) WHERE device.fk_collector = 5': SQL Timeout
--
Best regards, Alex
Am Montag, den 11.10.2010, 23:27 +0200 schrieb Mike McCauley:
Hello Alexander,
On Tuesday 12 October 2010 03:07:16 am Alexander Hartmaier wrote:
> Hi Mike,
>
> 4.7 rpm, without patches.
OK, so we will need to see the config file and the log file showing the error
and what happens before.
Cheers.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be
privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
