Unable to attach a .txt file or .log file to mail and mailx command

Question

I am trying to attach a .log file or .txt file to mail command to send an email once my ksh script executed. I am unable to use mutt command as it has been not installed in my machine and i am not supposed to install it. I have tried many ways by googling which has not been helped me to succeed.

Here is my requirement,I need to run some 10 sql queries and result need to send in the email via attachment. I have Check.ksh and i am running this by using nohup command.

nohup Check.ksh > Valid_Check.log 2>&1 &

In Check.ksh

typeset var TO="[email protected]";
typeset var SUB="Report";
typeset var BODY="Check Completed";
typeset var ATTACHMENT=${FILE_PATH}/Valid_Check.log

if [ -f "${ATTACHMENT}" ]; then 
echo "Log file exist";
else
echo "No Log File";
fi

uuencode Valid_Check.log Valid_Check.log | mail -s "${SUB}" "${BODY}" ${TO}

and tried the below as well

#mailx -s "${SUB}" "${TO}" "${BODY}" < ${FILE_PATH}/Valid_Check.log

#cat ${FILE_PATH}/Valid_Check.log | mailx -s "${SUBJECT}" "${TO}" "${BODY}";

Above code throwing an error like "Valid... User unknown"

Any inputs would be helpful or any other simple/easy approach?

Thanks,

Answer 1

If you have a recent enough mailx, use the -a option to add an attachment.

mailx -s "$SUB" -a "Valid_Check.log" "$TO" <<<"$BODY"

See also https://access.redhat.com/solutions/104833

If you are hopelessly stuck in a previous millennium and don't have any software which can handle proper attachments, the uuencode data should simply be appended to the body.

( echo "$BODY"; echo; uuencode Valid_check.log Valid_check.log ) |
mailx -s "$SUB" "$TO"

The basic approach suffers from a race condition, though - the existence of the output file indicates that the cron job has started, not finished. Putting the mail command at the end of the cron job would fix this; then, the email will only be sent when the previous step finishes.