[Exim] Slight MySql problem upgrading from 3.35 to 4.04

トップ ページ
このメッセージを削除
このメッセージに返信
著者: boutilpj
日付:  
To: exim-users
題目: [Exim] Slight MySql problem upgrading from 3.35 to 4.04
I just starting upgrading to 4.04 from 3.35 and ran into a MySql problem
during testing. I ran the convert script to convert my version 3 config
file into a version 4 one. The script did a pretty good job but I kept
getting this error:

boutilpj@??? R=mysql_system_aliases defer (-1): failed to
expand "${lookup mysql {"select userid from user where
aliasid='$local_part'"}}": lookup of ""select userid from user where
aliasid='boutilpj'"" gave DEFER: MYSQL: query failed: You have an error
in your SQL syntax near '"select userid from user where
aliasid='boutilpj'"' at line 1\n


Changing the following line (remove double-quotes):

data = ${lookup mysql {"select userid from user where
aliasid='$local_part'"}}

to:

data = ${lookup mysql {select userid from user where aliasid='$local_part'}}


solved the problem.



This is the original line that was converted from the version 3
configure file.

query = "select userid from user where aliasid='$local_part'"