Shell to run query, encrypt and send email


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Shell to run query, encrypt and send email
# 8  
Old 07-17-2002
MySQL resolved

I used one of the script posted here for email attachement.

Thank you all.Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run remote command and send email

I am currently try to write a simple script with the following condition, but so far not having luck as the exit code would always be 0. Run remote command to read a file and grep for test word. if test word is in the file, send email. if not, do nothing also possible to ssh to multiple... (3 Replies)
Discussion started by: jaapar
3 Replies

2. Shell Programming and Scripting

Script that will send an email if the cron job did not run.

Team, Would like to know what is the best script that will send you an email if cronjob did not run. Thanks (4 Replies)
Discussion started by: kenshinhimura
4 Replies

3. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies

4. Shell Programming and Scripting

SQL query output convert to HTML & send as email body

Hi , I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body. p_id src_system amount 1 A 100 2 B 200 3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies

5. Shell Programming and Scripting

Help with shell script to send email once

Hi Guys, I have this script which will monitor oracle db process if up or down.And I want it to send email if it's down and the time it's back to online. However my script just keep on sending "Email Up" if the db is up or "Email Down" if the db is down.Is there any way to trap it so that it... (5 Replies)
Discussion started by: d3xt3r
5 Replies

6. Shell Programming and Scripting

Script to send email after comparing the folder permissions to a certain permission & send email

Hello , I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them . I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies

7. Shell Programming and Scripting

How to send email through shell script

Hi All, I am new to the unix , i have to deliver one script very urgently I have to write a shell script where i have i want to send email to specific email id in this script i want FROM to be parameterized and stored in a variable TO to be parameterized and stored in a variable... (3 Replies)
Discussion started by: nileshbhawsar
3 Replies

8. Shell Programming and Scripting

Send Email using Korn Shell

Hi All, I need assistance is sending email out using korn shell Steps, 1- Count number of records in database. 2- if count is more than 2000 3- send email to user else if less then 1999 exit out. Here is my script and is not exiting out and need to press .DOT and Enter command to... (2 Replies)
Discussion started by: atlurip
2 Replies

9. Shell Programming and Scripting

We need a script that invokes the sql query every 14 days ans send email

HI, We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies

10. Shell Programming and Scripting

We need a script that invokes the sql query every 14 days ans send email

Hi, We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies
Login or Register to Ask a Question
comsat(8)						      System Manager's Manual							 comsat(8)

NAME
comsat - The biff server SYNOPSIS
comsat DESCRIPTION
The comsat server receives reports of incoming mail and notifies users who request this service. comsat is invoked by the inetd(8) daemon when it receives messages on a datagram port associated with the biff(1) service specification in /etc/services(4). The datagram contains a 1-line message of the form: user@mailbox-offset If the user specified is logged in and the associated terminal has the owner execute bit turned on (with biff y), offset is used as a seek offset into the file named in mailbox. The first 7 lines or 560 characters of the mes- sage are printed on the user's system. The message excludes mail header lines other than the From or Subject lines. The comsat command always tries to convert incoming mail messages from the mail interchange codeset to the user's application codeset. It determines the mail interchange code first by checking the mail message itself to see if it contains the required information. Otherwise, the system-wide default mail interchange code in the file /usr/lib/mail-codesets will be used. If no such system file exists, no codeset conversion will be performed. The determination of the user's application code in each terminal session is by one of the following methods. The application codeset defined in the user's Asian tty driver. The codeset name stored in the ~/.codesetdevname file, where devname is the name of the terminal device for the current terminal session. You can obtain the value of devname by issuing the tty command. For example, if the tty command returns /dev/ttys8, use ttys8 as the value for devname. The lang valued option defined in $HOME/.mailrc or /usr/share/lib/Mail.rc. FILES
Specifies the command path. Includes information about logged-in users and their associated ttys. File containing mailx subcommands to customize mailx for a specific user. File containing mailx subcommands to change mailx for all users on the system. RELATED INFORMATION
Commands: biff(1), inetd(8), mailx(1), mh(1) Files: services(4), inetd.conf(4), tty(7) delim off comsat(8)