Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: mail shell
This sounds rather dangerous.
I certainly wouldn't try to get too fancy with the set of available commands executable via an inbound email.
A very simple crack at making this work might be this...
Create UNIX user remsupp on the box that will both receive the initial email and send the reply. In remsupp's $HOME create a .forward file containing something like this...
"| /usr/local/bin/systeminfo.ksh"
This will execute the script "/usr/local/bin/systeminfo.ksh". I don't think you can get the contents of your email into the script though. So, I guess the best you could do is just have a script that gets some general info then email the results to your phone or pager, which is better than nothing I suppose.
Depending on your flavour of UNIX, other options may be available.
Hth
-Kevin
"Chuck Hamilton" <chuck_hamilton_at_yahoo.com> wrote in message
news:9ospjg$euile$1_at_ID-85580.news.dfncis.de...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Does anyone know of a product that will let me email shell and/or
> oracle commands to an email address and reply with the results of the
> command? I'm looking for this so I can provide emergency support of
> Oracle databases via a 2-way pager or email enabled wireless phone.
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
>
> iQA/AwUBO7Hptmm5A4kkb4ZsEQIKOwCgpcGR2XogceQ4wjjyPrV17nbQs3oAoJ9d
> fSrlPRO8SJDYFfhn7Fdo68Bq
> =Br/4
> -----END PGP SIGNATURE-----
>
>
>
Received on Wed Sep 26 2001 - 15:32:00 CDT