Heiko Schlittermann via Exim-users wrote on 04.05.2021 19:29: > Heiko Schlittermann via Exim-users <[email protected]> (Di 04 Mai 2021 > 17:44:23 CEST): >> Odhiambo Washington via Exim-users <[email protected]> (Di 04 Mai 2021 >> 17:00:36 CEST): >>> On Tue, May 4, 2021 at 4:52 PM Heiko Schlittermann via Exim-users < >>> temporarily rejected after DATA: failed to expand ACL string "${lookup >>> sqlite,file=/var/spool/exim/db/greylist.db {SELECT host from resenders >>> WHERE helo='${quote_sqlite:$sender_helo_name}' AND >>> host='$sender_host_address';} {1}}": absolute file name expected for >>> "sqlite" lookup >> >> I'm checking it. Give me a minute. >> -- >> Heiko > > Is there any chance setting the global sqlite_dbfile option? > > According to the spec file > > 9.26 More about SQLite > ---------------------- > > SQLite is different to the other SQL lookups because a filename is > required in > addition to the SQL query. An SQLite database is a single file, and there > is no > daemon as in the other SQL databases. > > The preferred way of specifying the file is by using the sqlite_dbfile > option, > set to an absolute path. > > A deprecated method is available, prefixing the query with the filename > separated by white space. This means that the path name cannot contain > white > space. It also means that the query cannot use any tainted values, as that > taints the entire query including the filename - resulting in a refusal > to open > the file. > > Here is a lookup expansion example: > > sqlite_dbfile = /some/thing/sqlitedb > ... > ${lookup sqlite {select name from aliases where id='userx';}} > > > I cannot find any reference to the syntax you're using. > Maybe I'm stupid.
https://lists.exim.org/lurker/message/20200606.183617.325a7016.en.html https://git.exim.org/exim.git/commitdiff/b8514d1960e259d49ab2c84c89eba52ab993da3f?hp=4a7dca52352d0976f200b89a50825433b7551554 +There are two ways of +specifying the file. +The first is is by using the &%sqlite_dbfile%& main option. +The second, which allows separate files for each query, +is to use an option appended, comma-separated, to the &"sqlite"& +lookup type word. The option is the word &"file"&, then an equals, +then the filename. +The filename in this case cannot contain whitespace or open-brace charachters. +.wen > ${lookup > sqlite,file=/var/spool/exim/db/greylist.db {SELECT host from resenders > WHERE helo='${quote_sqlite:$sender_helo_name}' AND > host='$sender_host_address';} {1}} > > > -- Best wishes Victor Ustugov mailto:[email protected] Skype ID: corvax_nb JID: [email protected] public GnuPG/PGP key: https://victor.corvax.kiev.ua/corvax.asc -- ## List details at https://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
