Exim 4 pipe select command/script from mysql db

Posted by axel.klein on Server Fault See other posts from Server Fault or by axel.klein
Published on 2010-04-01T14:55:01Z Indexed on 2010/04/01 15:03 UTC
Read the original article Hit count: 569

Filed under:

exim4

|

pipe

|

mysql

|

error-message

|

error

Is there an option to run a mysql lookup in the pipe driver of exim?

MYSQL_Q_SCRIPT=SELECT script FROM MYSQL_EMAILTABLE WHERE domain='${quote_mysql:$domain}' AND local_part='${quote_mysql:$local_part}'
command = "${lookup mysql {MYSQL_Q_SCRIPT}{$value}

I am always getting an error like this:

"Expansion of "${lookup" from command "${lookup mysql {SELECT script FROM emails WHERE domain='${quote_mysql:$domain}' AND local_part='${quote_mysql:$local_part}'}{$value}}" in run_script transport failed: missing lookup type" The problem is that exactly the same query works fine in the appenddriver. So I do not see the mistake.

© Server Fault or respective owner

Related posts about exim4

Linux : Forward users mail using exim4 server (newbiw warning)

as seen on Server Fault - Search for 'Server Fault'
Hello, I have a network of linux server, one of them is running exim4 that server could send [email protected]. At exim4 server, I had setup an alias for the users accounts ...for example root : [email protected] But I have other server, if I put the alias email is marked as spam...since they… >>> More
Override the bounce recipient address in exim4

as seen on Server Fault - Search for 'Server Fault'
I have a small app that allows a user to share an item by generating an email to a supplied email address. We set the "from" and "reply to" values to be the sender's address, so that when the email reaches the recipient, it appears to have come from the sender. This works wonderfully except when… >>> More
exim4 - disable autoreplies about "SMTP error from remote mail server after RCPT"

as seen on Server Fault - Search for 'Server Fault'
Hello I have a setup of exim4 on domain1 in front of other server, domain2 (with sendmail). Second server have no direct access to internet, so domain1 is MX for domain2. And domain2 is set as hubbed_host in the exim4 on domain1. When spammer sends message for no_such_user@domain2, its sendmail… >>> More
Exim4 delivery to parent domain.

as seen on Server Fault - Search for 'Server Fault'
I've set up an ubuntu server 9.1 system with exim4 as a relay for e-mail on my network. I've told exim that it is part of a subdomain: sub.domain.com I can test and deliver messages fine to my gmail accounts. I cannot get exim4 to sent messages to [email protected] though. The error received… >>> More
Awstats messaging non existant user causing exim4 to go nuts

as seen on Server Fault - Search for 'Server Fault'
I've taken over managing a server set up by someone else now uncontactable, while managing to work out most faults / changes needed this one is stumping me. Awstats is running on the machine and sending messages via exim4 to a user every time it runs an update. The user account has been deleted and… >>> More

Related posts about pipe

Using SAS Macro to pipe a list of filenames from a Windows directory

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to amend the macro below to accept a macro parameter as the 'location' argument for a dir command. However I cannot get it to resolve correctly due to the nested quotes issue. Using %str(%') does not work, neither do quoting functions for some reason. The macro will work fine when the… >>> More
How to rate-limit a pipe under linux ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a filter which I could use to rate-limit a pipe on linux? If this exists, let call it rate-limit, I want to be able to type in a terminal something like cat /dev/urandom | rate-limit 3 -k | foo in order to send a a stream of random bytes to foo's standard input at a rate (lower than) 3… >>> More
Behavior of a pipe after a fork()

as seen on Stack Overflow - Search for 'Stack Overflow'
When reading about pipes in Advanced Programming in the UNIX Environment, I noticed that after a fork that the parent can close() the read end of a pipe and it doesn't close the read end for the child. When a process forks, does its file descriptors get retained? What I mean by this is that before… >>> More
How do I pipe terminal standard output (stdout) to the clipboard?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
For example, Say I want to list the contents of a folder and directly paste them into a chat window for a friend to see. I realize I could do ls > filename.txt to create a file (filename.txt) with those contents; I'd then have to open or print the file and manually select and copy the text… >>> More
I can't upgrade 13.10 because of broken pipe

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I try upgrading and this is what I get: christopher@chris-computer:~$ sudo apt-get upgrade [sudo] password for christopher: Reading package lists... Done Building dependency tree Reading state information... Done The following packages will be upgraded: librhythmbox-core7 1 upgraded, 0… >>> More