[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

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