[RADIATOR] refresh time on clientlistsql

[Alexander Hartmaier]

Hi Mike,

I must have mistaken this server with another.
It runs 4.6 with some patches.
I've upgraded it now to 4.7 with the current patch set and will report
if this fixed the error message in the log.

-- 
Best regards, Alex


On Thu, 2010-10-14 at 13:21 +0200, Mike McCauley wrote:
> Hello Alex,
> 
> Thanks for the log.
> Can we pls see a bit more of the log, maybe a few hundred lines before the 
> error.
> Are you quite sure you dant have a 4.7 patch set installed?
> 
> Cheers.
> 
> On Thursday 14 October 2010 09:01:09 pm Alexander Hartmaier wrote:
> > 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.tblhost at 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.tblhost at 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.
> > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
> >"*
> 
> 
>