Re: [exim] INSERT statement in exim.conf

Pàgina inicial
Delete this message
Reply to this message
Autor: Raj
Data:  
A: Marilyn Davis
CC: exim-users
Assumpte: Re: [exim] INSERT statement in exim.conf
Marilyn Davis wrote:

>On Mon, 21 Mar 2005 raj-exim@??? wrote:
>
>
>
>>Hello frens,
>>I wonder why mysql INSERT statement won't work from exim.conf file.
>>SELECT is working very good.
>>I have exim 4.42 compiled with mysql support.
>>
>>
>
>Can we see your INSERT statement?
>
>And what is your mysql version?
>
>Marilyn Davis
>
>
>
>
>>Thanks a lot
>>Raj
>>
>>
>>
>>
>>
>
>
>

MYSQL_LOG=INSERT INTO LOGTABLE (local_part,arrivaltime,sender)
VALUES('${quote_mysql:local_part}',NOW(),'${quote_mysql:sender_address}')

savelog_director:
driver = manualroute
domains = ${lookup mysql {MYSQL_LOG}{$value}}
condition = 0
route_list = "* localhost byname"
transport = devnull_transport
verify = false

It trys to store in the LOGTABLE but eventually fails.
The mysql user has write permission in the dbase.

I think I should pipe it out to write in dbase. what do u say?
Raj