[hobbit] dbcheck.pl not working, Timeout connecting to DBI...

[Benjamin P. August]

In the end, I re-tried implementing bb-roracle (also on deadcat) with  
a full Oracle client install. After that, it was a matter of making  
sure that the hobbit user could run the Oracle client. Turns out  
Oracle client is pretty anal about its permissions.

I kept testing with sqlplus as root, and got mad because the scripts  
themselves wouldn't run as hobbit. Then I realized that basically the  
whole Oracle client install is owned and only executable by the oracle  
user (and root). It got a little more complicated than that, but the  
moral of the story is make sure that the Hobbit user can run everything.

-- 
--Ben
Benjamin P. August
System Administrator - VPUE
Stanford University


Quoting "Gore, David W (David)" <david.gore at verizonbusiness.com>:

>> -----Original Message-----
>> From: Benjamin P. August [mailto:baugust at stanford.edu]
>> Sent: Wednesday, January 23, 2008 19:16
>> To: hobbit at hswn.dk
>> Subject: [hobbit] Greetings and a question...
>>
>> First off, I love Hobbit. A lot. I've been running it as a
>> test in our department for almost 9 months now and I have
>> convinced the boss to not renew the contract for our
>> proprietary monitoring package (from a certain other
>> Scandinavian country) in favor of using Hobbit. I just need
>> to see if I can put donations on my corporate card. :)
>>
>> But I do have one last question after all of that effusion.
>> Is anyone out there running dbcheck.pl and had this error:
>>
>> "Wed Jan 23 10:21:40 2008:ERROR on sid_name: Timeout
>> connecting to DBI:Oracle:sid_name!"
>>
>> I know it isn't a network problem because the hobbit user can
>> connect using sqlplus just fine and the oratns check is OK.
>> The required Perl modules installed OK... I think.
>>
>> (no, sid_name is not our SID, name has been changed to
>> protect the innocent)
>>
>> Thanks!
>
> Ben, did you ever get this to work.  I am having the same problem.  I
> can connect fine with sqlplus from a Linux host(Redhat running the
> Hobbit server) to a Solaris host running Oracle 10.x.x.x, but I cannot
> get the dbcheck.pl script to run.  The script fails quickly with the
> same error message:
>
> Thu May 15 18:54:34 2008:ERROR: Timeout connecting to
> DBI:Oracle:host=MYHOST;port=5521;sid=MYSID!
>
> SID name and hostname changed in this email from what they really are.
> hostname, port, and sid in dbcheck.ini match what is used by sqlplus to
> connect correctly.
>
> Any help would be appreciated.
>
> ~David
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>
>