8 messages in net.sourceforge.lists.courier-maildropRe: [maildropl] How to get extra info...
FromSent OnAttachments
Dan HorneSep 28, 2005 2:28 pm 
Jay LeeSep 28, 2005 2:47 pm 
Jay LeeSep 28, 2005 2:49 pm 
Dan HorneSep 29, 2005 6:44 am 
Dan HorneSep 29, 2005 6:45 am 
Jay LeeSep 29, 2005 7:10 am 
Dan HorneSep 29, 2005 7:14 am 
Jay LeeSep 29, 2005 7:17 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [maildropl] How to get extra info from MySQL db into filtersActions...
From:Jay Lee (jl@pbu.edu)
Date:Sep 29, 2005 7:10:06 am
List:net.sourceforge.lists.courier-maildrop

Dan Horne wrote:

RUN_SA=`echo "SELECT value FROM userpref where username = '$USER' and preference = 'use_sa'" | mysql -s -u dbuser -pdbpass spamassassin`

Thanks, I will give that one a try. Just to be clear the "spamassassin" at the end of the mysql command is the db name, right?

Yes, that last spamassassin is the name of the db for mysql to use. For more help on the mysql command try:

man mysql

It will give you further details like what the -s (silent) command does and such.

Jay

-- Jay Lee Network / Systems Administrator Information Technology Dept. Philadelphia Biblical University

--