Hi Chris, thanks for your reply.
Chris Darroch wrote:
Phil Endecott wrote:
http://marc.info/?l=apache-httpd-users&m=118765132424174&w=2
My guess is that I'm encountering the known issues with DBD described here:
http://marc.info/?l=apache-httpd-dev&m=116742014418304&w=2
Am I right in thinking that this is fixed in the trunk but not in
2.2.4? What about 2.2.5/6 - I don't see anything in the 2.2.5 changelog.
I think you're right about the problem you're encountering;
the patches for 2.2.x await a third vote and so they're not in
expected in 2.2.5/6, as it stands at the moment.
OK; my experience seems to be that in this respect 2.2.4 has regressed
compared to 2.2.3 (though I may have been lucky in some way with my
2.2.3 setup) and certainly compared to 2.0.x + the 3rd-party
mod_auth_pgsql. I don't know if this affects how the issue is
prioritised for inclusion in future versions. I would love to see
working authn_dbd ASAP.
- authn_dbd_password() uses the error message "Error looking up %s in
database" for 3 different errors. It would be really great to have
different messages in each case.
I'd suggest opening a Bugzilla report and, if possible, attaching
a patch file with the revised messages you'd like to see (and please add
the keyword PatchAvailable in this case).
done; http://issues.apache.org/bugzilla/show_bug.cgi?id=43210
- The mod_authn_dbd docs
(http://httpd.apache.org/docs/2.2/mod/mod_authn_dbd.html) claim "DBD
drivers recognise both stdio-like %s and native syntax". Is this
accurate? It seems that the postgresql DBD driver does some type magic
based on the character after the %, which wouldn't be possible with the
postgresql $1 syntax. Maybe $1 only works for strings (which would be
OK for usernames, of course). (Does it correctly count the number of
parameters if I use $1?)
I seem to recall some type magic in this driver, but I'm not
particularly familiar with it. If you encounter problems, I'd again
suggest opening a Bugzilla report.
I haven't actually got as far as encountering any problems with this
since dbd is not working at all :-(
However, see the documentation for apr_dbd_prepare() at
http://apr.apache.org/docs/apr-util/trunk/group___a_p_r___util___d_b_d.html#gcf21412447c4357c64d1e9200a0f5eec
"To specify parameters of the prepared query, use %s, %d etc. (see
below for full list) in place of database specific parameter syntax"
Looking at the source it's pretty clear that it understands only
%letter synatx, not $n or even MySQL % syntax. So I've filed a bug on
the mod_authn_dbd documentation:
http://issues.apache.org/bugzilla/show_bug.cgi?id=43211
Regards,
Phil.
