[SOLVED] uuncode doesn't work

sysmicuser · 08-28-2013, 09:55 AM

Guys

Why this should not work?

simple stuff

(uunecode file1.csv file1.csv ; uunecode file 2.csv file2.csv) | mailx -s "test" testme.com??

What's the problem?

I tried with debug on and I see mail

I tried to change the shell from sh to ksh but still no luck. Fundamentally I don't think there is any issue with my script...

Jenni · 08-28-2013, 09:59 AM

Maybe because the command is "uuencode" or "uudecode", not uuncode, or uunecode?

sysmicuser · 08-29-2013, 07:24 AM

@Jenni

I have typed in correctly in my script. It is uuencode

druuna · 08-29-2013, 07:31 AM

@sysmicuser: You need to provide details.

- What doesn't work?
- What did you expect the outcome to be?
- Post the script.

Jenni · 08-29-2013, 08:48 AM

Assuming you have mailx set up properly and working, then the line you gave should work, but both files would end up sending as one, which can confuse uudecode if you don't split them up before decoding.
Usually, if you want to send multiple files via uuencode, it is best to make a tarball first ( tar -cvzf file.tar.gz file1 file2 .. fileN ) then encode and send that. then the recipient can use uudecode then tar -xvzf file.tar.gz to extract them.

so:
tar -cvzf file.tar.gz file1 file2 file3 ; uuencode file.tar.gz file.tar.gz

druuna · 08-29-2013, 09:09 AM

Quote:

Originally Posted by Jenni

Assuming you have mailx set up properly and working, then the line you gave should work, but both files would end up sending as one, which can confuse uudecode if you don't split them up before decoding.
Usually, if you want to send multiple files via uuencode, it is best to make a tarball first ( tar -cvzf file.tar.gz file1 file2 .. fileN ) then encode and send that. then the recipient can use uudecode then tar -xvzf file.tar.gz to extract them.

so:
tar -cvzf file.tar.gz file1 file2 file3 ; uuencode file.tar.gz file.tar.gz

I agree, that is the solution I would choose, but:

Code:

(uunencode file1.csv file1.csv ; uunencode file2.csv file2.csv) | mailx -s "test" testme.com

Will work. I do assume that mail is set up properly and testme.com is a valid e-mail address.

A test shows this:

Code:

$ ( uuencode foobar foobar ; uuencode fubar fubar ) | mailx -s test druuna
$ mail
Mail version 8.1.2 01/15/2001.  Type ? for help.
"/var/mail/druuna": 1 message 1 new
>N  1 druuna@plains.wil  Thu Aug 29 16:04   23/649   test
& 
Message 1:
From druuna@plains.wildfire.nl Thu Aug 29 16:04:55 2013
Envelope-to: druuna@plains.wildfire.nl
Delivery-date: Thu, 29 Aug 2013 16:04:55 +0200
Date: Thu, 29 Aug 2013 16:04:55 +0200
To: druuna@plains.wildfire.nl
Subject: test
From: druuna <druuna@plains.wildfire.nl>

begin 640 foobar
.,0HR"C,*-`HU"C8*-PH`
`
end
begin 640 fubar
080IB"F,*9`IE"F8*9PIH"@``
`
end

&

sysmicuser · 08-30-2013, 08:39 AM

@drunna.

I don't think there is any wrong in my script. I just ran the same command online on unix console and seems to be working fine but I have no idea why it doesn't work within my shell script

druuna · 08-30-2013, 08:41 AM

Quote:

Originally Posted by sysmicuser

I don't think there is any wrong in my script. I just ran the same command online on unix console and seems to be working fine but I have no idea why it doesn't work within my shell script

If you don't post the script here, we cannot help you.

You mention Unix; On what platform are you trying to do this?

sysmicuser · 08-30-2013, 08:48 AM

@drunna

Yes I am posting code mate, night time here so that is why brain is working slow

Code:

[oracle@rhel53 temp]$ cat script1.sh 
#!/bin/bash

set -x

day=$(date +%A)
date_format=$(date +%d-%b-%Y)
password=$(/app/oracle/decrypt.sh <encrypted-password>)
report_1=script1-part-1_${date_format}.csv
report_2=script1-part-2_${date_format}.csv
export TNS_ADMIN=<path to tns names .ora>
if [ "$day" == "Monday" ] 
then
        echo -e "Do whatever you want"
else
sqlplus -s user/$password@database << EOF >> $report_1
@script1-part1-mon.sql
EOF

sqlplus -s user/$password@database << EOF >> $report_2
@script1-part-2-mon.sql
EOF
fi

(uuencode $report_1 $report_1 ; uuencode $report_2 $report_2) | mailx -s "Test Report" user@test.com
#rm -vf ${report_1}
#rm -vf ${report_2}

echo "I have done all my work"
[oracle@rhel53 temp]$

I have tried in all different shell but don't know why it doesn't works !

I tried the same on command line and it indeed works beautifully

---------- Post added 08-30-13 at 11:49 PM ----------

@Jenni

No need to tar. We can attach multiple files in a single email.

druuna · 08-30-2013, 09:04 AM

@sysmicuser: The script doesn't generate any output at all when you execute it?

When using set -x there should be output generated, please post this.

On first glance I don't see anything wrong (I'm not a DB man and I assume the sql parts are correct). Only thing that I would call suspicious is the old redhat version (5.3), this should be 5.9 as of 2013.

sysmicuser · 08-30-2013, 09:08 AM

@druna

Script generates output. It generates two csv files but they are not sent as an attachment !!

Yep, the sql parts are fine. I have no idea why it is not sent as an attachment.

Yep posting output.

druuna · 08-30-2013, 09:12 AM

Quote:

Originally Posted by sysmicuser

Script generates output. It generates two csv files but they are not sent as an attachment !!

Yep, the sql parts are fine. I have no idea why it is not sent as an attachment.

I'm not talking about the files that are generated by the script. I'm talking about the output generated by set -x, which would look something like this:

Code:

$ ./script1.sh
++ date +%A
+ day=vrijdag
++ date +%d-%b-%Y
+ date_format=30-aug-2013
.
.
.

Post that, please.

sysmicuser · 08-30-2013, 09:20 AM

Code:

[oracle@script1 temp]$ ./script1.sh 
++ date +%A
+ day=Saturday
++ date +%d-%b-%Y
+ date_format=31-Aug-2013
++ /app/oracle/decrypt.sh <encrypted password>
+ password=<password>
+ report_1=script1-part-1_31-Aug-2013.csv
+ report_2=script1-part-2_31-Aug-2013.csv
+ export TNS_ADMIN=<path to tnsnames.ora>
+ TNS_ADMIN=<path to tnsnames.ora>
+ '[' Saturday == Monday ']'
+ sqlplus -s user/user99@database
+ sqlplus -s user/user99@database
+ uuencode script1-part-1_31-Aug-2013.csv script1-part-1_31-Aug-2013.csv
+ mailx -s 'Test Report' user@test.com
+ uuencode script1-part-2_31-Aug-2013.csv script1-part-2_31-Aug-2013.csv
+ echo 'I have done all my work'
I have done all my work
[oracle@script1 temp]$

druuna · 08-30-2013, 09:28 AM

The above looks fine.

I'm starting to wonder what you mean by attachment.

- Did you look inside the mail send to user@test.com?
- Do you see anything that resembles the following inside:

Code:

begin 640 script1-part-1_31-Aug-2013.csv
<unreadable stuff>
end
begin 640 script1-part-2_31-Aug-2013.csv
<unreadable stuff>
end

sysmicuser · 08-31-2013, 08:45 PM

@druna

Apologies for the delay in response.
I say attachment means I say that I am not getting email with those two files.
Yes I looked in the email there is nothing in that.

Quote:

begin 640 script1-part-1_31-Aug-2013.csv
<unreadable stuff>
end
begin 640 script1-part-2_31-Aug-2013.csv
<unreadable stuff>
end

Instead of 640 I see 700 because I have explicitly changed the permissions. yes I could see like that, why you ask? Is that the reason it is unable to send an attachment?

Further investigation reveals that even if I do something like this

uuencode file1.csv file1.csv|mailx -s "test" user@test.com

I am not getting email at all? However same email can be sent "outside" the shell script. I did echo $? just after this command and get return code as 0 ! all confusing