Mailx recipient from mysql database Post: 302789723

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Mailx recipient from mysql database Post 302789723 by jazzyzha on Thursday 4th of April 2013 05:42:19 AM

Old

04-04-2013

Registered User

already checked it twice, already use double quote :

Code:

EMAIL_ADDRESS="$( mysql -uroot -pgurlia001 smsd -N -s -r -e "SELECT email FROM recipient" | tr '\n' ' ')"

and for mailx:

Code:

mysql -uroot -pgurlia001 smsd -e "SELECT ID, SenderName, Body FROM inbox" | mailx -s "$SUBJECT" -a From:sales@acme.com "$EMAIL_ADDRESS”

---------- Post updated at 04:39 AM ---------- Previous update was at 04:38 AM ----------

ups... do you mean:

Code:

mysql -uroot -pgurlia001 smsd -e "SELECT ID, SenderName, Body FROM inbox" | mailx -s "$SUBJECT" -a From:sales@acme.com $EMAIL_ADDRESS

?

---------- Post updated at 04:42 AM ---------- Previous update was at 04:39 AM ----------

YES IT WORKS! Thank You Brother! now it can send email to multiple email accounts using database. thank you very much

jazzyzha

View Public Profile for jazzyzha

Find all posts by jazzyzha

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

mailx recipient restriction

maybe a simple question, but i've looked around and not been able to find anything. is there a restriction on how many recipients can be used in a single mailx command? whether it's a numeric restriction or a size restriction (like 256k for the whole recipient parameter). thanks a lot.

2. Shell Programming and Scripting

Mailx Recipient and Name Script

Hi To All, I have a file with email addresses, most of which have names associated with them, it looks like this: http://img230.imageshack.us/img230/8255/94731317.th.jpg I am trying to come up with a script to use mailx (or anything else really) to send an email to...

3. UNIX for Dummies Questions & Answers

Connect MySQL database from Unix

How to connect a MySQL database from unix using unix shell scripting ( people are using perl scrpt to connect the same database). I want to access a MySQL database through a shell script

4. Shell Programming and Scripting

How to backup a particular Database in MYSQL?

Hi All, Thanks in Advance!! How to backup a particular Databases..through Bash script!! For example i have 6 databases; Anish linux Software Questions Rhce Google these are the databases i have from that i want to take "Anish" and "questions" database backup regularly....

5. Programming

Mailx recipient from mysql database

Dear All, Can I make Mailx to read recipient address from a mysql database? I already tried emailing with bash script: SUBJECT="TEST" export EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"` mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" |...

6. Web Development

Apache users from MySQL database

Hi team, How can I implement a users in MySQL database for Apache users, assuming that I'm using RHEL6. That is to say, how can I design this database and how let's Apache server know those user in this database. Thanks in advance..

LEARN ABOUT CENTOS

reporter-mailx

REPORTER-MAILX(1)						 LIBREPORT MANUAL						 REPORTER-MAILX(1)

NAME

       reporter-mailx - Sends contents of a problem directory via email.

SYNOPSIS

       reporter-mailx [-v] -d DIR [-c CONFFILE]

DESCRIPTION

       The tool reads a problem directory, composes an email message from the directory contents, and uses mailx to send the message to specified
       recipient.

       Properties of email messages can be specified in a configuration file, and via environment variables.

   Configuration file
       Configuration file contains entries in a format "Option = Value".

       The options are:

       Subject
	   The subject of the email message.

       EmailFrom
	   The sender of the email message.

       EmailTo
	   The recipient of the email message.

       SendBinaryData
	   Use yes/true/on/1 to attach all binary files from the problem directory to the email. This can cause the emails to be very large.

   Integration with ABRT events
       reporter-mailx can be used as a reporter, to allow users report problems via email when they decide to do it. This usage is pre-configured
       in /etc/libreport/events.d/mailx_event.conf:

	   EVENT=report_Mailx	   reporter-mailx

       It can also be used to notify administrator automatically when a problem happens. When this is desired, modify the event configuration file
       to run the tool on the post-create event:

	   EVENT=post-create	   reporter-mailx

OPTIONS

       -d DIR
	   Path to problem directory.

       -c CONFFILE
	   Path to configuration file. When used in ABRT event system, the file contains site-wide configuration. Users can change the values via
	   environment variables.

ENVIRONMENT VARIABLES

       Environment variables take precedence over values provided in the configuration file.

       Mailx_Subject
	   Subject of the email message.

       Mailx_EmailFrom
	   Sender of the email message.

       Mailx_EmailTo
	   Recipient of the email message. If nor the environment variable nor the corresponding option is defined, the message is send to
	   "root@localhost".

       Mailx_SendBinaryData
	   Use yes/true/on/1 to attach all binary files from the problem directory to the email.

AUTHORS

       o   ABRT team

LIBREPORT 2.1.11						    06/18/2014							 REPORTER-MAILX(1)