[horde] passwd does not substitute placeholder in backend.conf

[Kevin M. Myer]

Quoting Franz Georg Köhler <an7ilb$bk0f4 at openunix.de>:

> Hello averyone,
>
> I recently set up horde with passwd.
>
> Passwd is supposed to use a mySQL backend.
>
>
> Unfortunately, passwd does not replace the placeholder in backend.conf
> (%u):
>
> Dec 17 19:55:17 HORDE [debug] [passwd] SQL Query by 
> Passwd_Driver_sql::_lookup(): SELECT clearpw FROM testpop WHERE 
> domain_name = SUBSTRING_INDEX(?, @, -1) AND  local_part = 
> SUBSTRING_INDEX(?, @, 1) [on line 110 of 
> "horde/passwd/lib/Driver/sql.php"]
>
> Actually, passwd should replace %u with the user's name and %p with the
> user's password.
>
> Instead, we see just a ?.
>
> Could this be related to the fact that authentification is handled by
> IMP via IMAP?

The SQL statement doesn't have the actual values that are passed.  The 
'?' are just placeholders.  You would need to enable logging on your 
database and check the logs there for the actual values being passed.

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org