You would have oracle's cron to execute something like this regularly:<br><br> #!/bin/sh<br> md5sum /some/secure/oracle/path/filename > /var/tmp/filename.md5<br><br>Then have hobbit's cron run something like:<br>
<br> #!/bin/sh<br> $HOME/server/bin/bbcmd $HOME/server/ext/oracle-md5-checker.sh<br><br>You could use Hobbit's launcher, but I always found it easier to use cron to spread scheduled jobs over time.<br><br>The oracle-md5-checker.sh script would start up with all the Hobbit environment, grab the md5 checksum from the file, check it against the proper value, then report red/green. I think I would then have it delete the md5 file - that might require parking the file somewhere other than /var/tmp, which would be a good idea anyway... Deleting the file means that next time the hobbit script runs, it can validate that the oracle cron job ran, rather than just blindly re-reading the same file. That's probably simpler than comparing the file-last-changed timestamp to realtime.<br>
<br>Ralph Mitchell<br><br><br><div class="gmail_quote">On Tue, Jan 13, 2009 at 1:45 PM, chris <span dir="ltr"><<a href="mailto:chris@spw.info">chris@spw.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Thanks for your suggestions.</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">Adding the hobbit user to the oracle group
is unfortunately not an option, as the permissions do not even give the group
permission to the directory, but only the owner itself.</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;">When you suggest running a script as
oracle from cron, I presume that we are talking outside of the hobbit
environment, or is there still a way to keep server side configuration, etc?</span></font></p>
<p><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="2" width="100%" align="center">
</span></font></div>
<p><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma;"> Ralph Mitchell
[mailto:<a href="mailto:ralphmitchell@gmail.com" target="_blank">ralphmitchell@gmail.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> Sonntag, 11. Jänner 2009
20:27<br>
<b><span style="font-weight: bold;">To:</span></b> <a href="mailto:hobbit@hswn.dk" target="_blank">hobbit@hswn.dk</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [hobbit] file
monitoring permission problems</span></font></p>
</div><div><div></div><div class="Wj3C7c">
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;"> </span></font></p>
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">On Sun, Jan 11, 2009 at 1:05 PM, L.M.J <<a href="mailto:linuxmasterjedi@free.fr" target="_blank">linuxmasterjedi@free.fr</a>> wrote:</span></font></p>
<div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); border-width: medium medium medium 1pt; padding: 0cm 0cm 0cm 6pt; margin-left: 4.8pt; margin-right: 0cm;">
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">Le Sun, 11 Jan 2009 13:12:20 +0100,<br>
"Chris" <<a href="mailto:chris@spw.info" target="_blank">chris@spw.info</a>> a
écrit :</span></font></p>
<div>
<p style="margin-bottom: 12pt;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"><br>
> This is confirmed when looking into the client data sent to the server:<br>
><br>
> [file:/opt/oracle/product/j2ee/applications/appl.ear]<br>
> ERROR: Permission denied<br>
><br>
> Is there an easy workaround without having to change file permissions, eg.<br>
> running the file tests with sudo?</span></font></p>
</div>
<p><font size="3" face="Times New Roman"><span style="font-size: 12pt;">You can add the user "hobbit" to the oracle unix group. I
think it's the fastest and simplest way<br>
to fix your issue.</span></font></p>
</blockquote>
</div>
<p style="margin-bottom: 12pt;"><font size="3" face="Times New Roman"><span style="font-size: 12pt;"><br>
That also reduces your database security, and I'll bet your DBAs wouldn't allow
it. Better to have the oracle account run the script from cron and pick
up the output from a neutral location.<br>
<br>
Ralph Mitchell</span></font></p>
</div></div></div>
</div>
</blockquote></div><br>