[Proftpd-user] UNKNOWN TAG in named query (%L and %V)

[Scott R. <ln...@us...>]

Greets.

I'm hoping this isn't another 'RTFM'. As a personal rule if I have two
RTFM hits in the same day I go home. :)

Having read the SQLNamedQuery docs I see that many of the
LogFormat/ExtendedLog meta-sequences apply with a few listed exceptions.

I need to log which ftp host (IP or HOSTNAME) a RETR command was
completed on. I have the following setup:

SQLNamedQuery updatefilelog INSERT "now(), '%u', '%a', '%b', '%F', '%L'"
xferstats

In the SQLLog I see:

query "INSERT INTO xferstats VALUES (now(), 'sco...@us...',
'9.65.235.53', '0', '/NDA_FILES_HERE', {UNKNOWN TAG})"

If I replace %L with %V I get the same results. Other tags, such as %v,
in place of %L.

Is there a reason %L and %V do not work with named queries?

-- 
Scott Russell <ln...@us...>
Linux Technology Center System Admin