laurent faillie wrote:
While trying to use Apache 2.2 database authentication, I discovered that I
wasn't able to retrieve users. After some investigation, I found that
PREPARE/EXECUTE are faulty. It can be reproduced in psql as bellow :
www=> PREPARE authn_dbd_1 (varchar) AS select mdp from mariage.comptes where
nom = '$1';
That $1 should be without the quotes, like this:
PREPARE authn_dbd_1 (varchar) AS select mdp from mariage.comptes where
nom = $1
Otherwise the query looks for a user named '$1'.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
