12-23-2011
Send email from shell to users in Mysql
Hi, I need help about sending mail in linux. I have a ubuntu server with working web site, users are uploading files in one main directory (to folder inbox). With samba I shared that directory and on other mashine is Windows server and application that is reading that files and writting content to database. Based of the result is creating new file with content: package name that is recieved, size, date and time and does the package contained erros or it was OK. That newly created files are again sent over samba to the same directory in ubuntu server (to folder outbox). That all is working!
Now, i need to listen are there new files in folder outbox. If there are new files, I need to send their content to specific email address. I have users in Mysql database. The name of files that are coming to outbox is with mask like this ddmmyyyy.x where x is user id in Mysql. So if "extension" of file is 1, I need to send mail to mail address of user in mysql with user id 1. If its 2 I am sending to user with user id... and after that move file from outbox to archive.
So, it's going like this: new file arrived in outbox, based on the extension of that file, select email address of user from database with user id = extension of file. On that email address send content of that file and move file to archive.
Does anyone can help me to solve this. Thank you!
P.S I have a mail working and I can send email from shell.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am using the mailx command to send email to multple users. The command works fine when i am sending mail to a single user but when i insert multiple email ids inside the quote it does not work. All the email ids are coming from a property file.Please have a lookt at the property file and... (4 Replies)
Discussion started by: priyaksingh
4 Replies
2. UNIX for Dummies Questions & Answers
Hi,
If I want to send an email to serveral users, what is the correct way to do it?
I know a little bit mail command. If I want to send email to John and Scott after UNIX shell scripts have completed the job. I type:
mail -s 'Job has been completed successfully' john@yahoo.com < log.txt
... (4 Replies)
Discussion started by: duke0001
4 Replies
3. Shell Programming and Scripting
Hi all,
I want to know how to send an email using shell script .....
I tried a command call mail but it did not work..
Please any one reply.. With example if you know thanks..
Madhu (4 Replies)
Discussion started by: madhumathikv
4 Replies
4. UNIX for Dummies Questions & Answers
hi,
i'm pretty new to this unix. i've been asked to create a shell script which will pick up the email id from a text file(stored in same machine, same directory) searches for that id in another file in which a product name( a one line text) is mentioned against it. then it should send a mail... (0 Replies)
Discussion started by: vishwas.shenoy
0 Replies
5. Shell Programming and Scripting
I know how to send an email with sendmail in a shell script.
I know how to send an email with an attachment in a script.
But im trying to send an email and need to set Content-Type to text/html and insert a file as the body and not attachment.
Send email with file as attachment:
... (4 Replies)
Discussion started by: Ikon
4 Replies
6. Shell Programming and Scripting
Hi,
Someone Knows how to obtein a chain from a unix file, but not all the line, for exemple, for this file ,obtein only 902111111 and to keep the value, this value will be used to make a mailx.
NF=ALL,
SUBJ=
FROM: SN=CD, SE=TOPCALL, NA=, N=902111111, N=TCLFI
TO: SE=FAX, NA=, C1=... (0 Replies)
Discussion started by: peybol
0 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT ULTRIX
refile
refile(1mh) refile(1mh)
Name
refile - file message in other folders
Syntax
refile [ msgs ] [ +folder ] [ options ]
Description
Use the command to move the specified message from the current folder to another folder. You can refile messages in more than one folder
by giving multiple folder names as arguments.
If you do not specify a message, the current message is refiled. You can refile a message other than the current message by giving its
number as a msgs argument. You can also refile more than one message at a time by specifying more than one message number, or a range of
message numbers, or a message sequence. See for more information on sequences.
The current folder remains the same unless the -src option is specified; in that case, the source folder becomes current. Normally, the
last message specified becomes the current message. However, if the -link option is used, the current message is not changed.
If the Previous-Sequence: entry is set in the file, in addition to defining the named sequences from the source folder, will also define
those sequences for the destination folders. See for information concerning the previous sequence.
Options
-draft Refiles the draft message, or the current message in your folder, if you have one set up. You cannot give a msgs argument when
you use this option.
-file filename
Moves a file into a folder. This option takes a file from its directory and places it in the named folder, as the next message
in the folder. The file must be formatted as a legal mail message. This means that the message must have the minimum header
fields separated from the body of the message by a blank line or a line of dashes.
-help Prints a list of the valid options to this command.
-link
-nolink Keeps a copy of the message in the source folder. Normally, removes the messages from the original folder when it refiles them.
The -link option keeps a copy in the original folder, as well as filing a copy in the new folder.
-preserve
-nopreserve
Preserves the number of a message in the new folder. Normally, when a message is refiled in to another folder, it is set to the
next available number in that folder. The -preserve option keeps the number of the message the same in the new folder as it had
been in the old.
You cannot have two messages with the same number in one folder, so you should use this option with care.
-src +folder
Specifies the source folder to take messages from. Normally, messages are refiled from the current folder into another folder.
However, you can take messages from a different folder by using the -src +folder option to specify the alternative source folder.
Examples
The following example refiles messages 3 and 5 in the folder
% refile 3 5 +records
The next example files the current message into two folders:
% refile +jones +map
The next example takes message 13 in the current folder and refiles it in the folder. The message remains in the current folder as well as
appearing in the folder.
% refile -link 13 +test
The next example takes a message from the folder when it is not the current folder, and places it in the folder
% refile 3 -src +test +outbox
Profile Components
Path: To determine your Mail directory
Folder-Protect: To set protections when creating a new folder
rmmproc: Program to delete the message
Files
The user profile.
See Also
folder(1mh), mark(1mh), mh_profile(5mh)
refile(1mh)