Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Mailx recipient from mysql database

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Mailx recipient from mysql database
# 1  
Old 04-04-2013
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:

Code:
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" | mailx -s "$SUBJECT" -a From:sales@acme.com "$EMAIL_ADDRESS”

It return this error:


Code:
export: 13: supervisor@gmail.com: bad variable name

the table has 2 row with two email address each.

but no luck. Any help would be very appriciated. Thanks
# 2  
Old 04-04-2013
Not sure why you are getting that error. But why do you need export here? Just assign the email address to that variable and use it. Execute the script using -x option i.e. bash -x yours_script, this might give us something to look into.

--ahamed
# 3  
Old 04-04-2013
i need export because i need it to send email to multiple email accounts (using mysql database) that being registered with a software that I developed. is there any better way?

thanks
# 4  
Old 04-04-2013
Yes I get it, but here you dont need export, just a variable should do it.
Did you try without export? how about the requested output with -x option?

--ahamed
# 5  
Old 04-04-2013
thanks Ahamed,

using the same script like before with -x option, it stil gives me this error:

Code:
export: 13: supervisor@gmail.com: bad variable name

I dont know how to change it with variable, please help me with the code, im new with bash script.
# 6  
Old 04-04-2013
Just remove the keyword export from your code and try.

--ahamed
# 7  
Old 04-04-2013
Do you mean like this:

Code:
SUBJECT="TEST"
EMAIL_ADDRESS=`mysql -uroot -pabcde smsd -e "SELECT email FROM recipient"`
mysql -uroot -pabcde smsd -e "SELECT ID, SenderName, Body FROM inbox" | mailx -s "$SUBJECT" -a From:sales@acme.com "$EMAIL_ADDRESS”


output:

Code:
root@testapp:/etc# sh -x daemon_emailer.sh
+ SUBJECT=TEST
+ mysql -uroot -pabcde smsd -e SELECT email FROM recipient
+ EMAIL_ADDRESS=email
supervisor@gmail.com
marketing@gmail.com
daemon_emailer.sh: 14: Syntax error: Unterminated quoted string

Last edited by jazzyzha; 04-04-2013 at 05:42 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. 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.. (3 Replies)
Discussion started by: leo_ultra_leo
3 Replies

2. 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" |... (2 Replies)
Discussion started by: jazzyzha
2 Replies

3. 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.... (4 Replies)
Discussion started by: anishkumarv
4 Replies

4. 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 Replies)
Discussion started by: apsprabhu
4 Replies

5. 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... (4 Replies)
Discussion started by: slicker
4 Replies

6. 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. (6 Replies)
Discussion started by: chris32680
6 Replies
Login or Register to Ask a Question