You are viewing a plain text version of this content. The canonical link for it is here.
Posted to bugs@httpd.apache.org by bu...@apache.org on 2021/03/06 21:00:04 UTC
[Bug 65172] New: authn_socache doesn't cache well with authn_dbd if
query contains additional columns
https://bz.apache.org/bugzilla/show_bug.cgi?id=65172
Bug ID: 65172
Summary: authn_socache doesn't cache well with authn_dbd if
query contains additional columns
Product: Apache httpd-2
Version: 2.4.46
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: mod_authn_socache
Assignee: bugs@httpd.apache.org
Reporter: avi@dbyt.es
Target Milestone: ---
Hi,
As recommended in the docs, I tried configuring authn_dbd with authn_socache.
This works well if AuthDBDUserPWQuery contains only the password column, but if
it contains additional columns then it doesn't cache them and their value
cannot be used.
e.g.
AuthDBDUserPWQuery "SELECT password, name, mail, ... FROM users"
in such case, the value of name, mail, etc.. will not be defined as
AUTHENTICATE_ variables as expected.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
[Bug 65172] authn_socache doesn't cache well with authn_dbd if query contains additional columns
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65172
y.guern@rock-hosting.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |y.guern@rock-hosting.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
[Bug 65172] authn_socache doesn't cache well with authn_dbd if query
contains additional columns
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65172
Dave Pearson <pe...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |pearsondave@hotmail.com
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
[Bug 65172] authn_socache doesn't cache well with authn_dbd if query
contains additional columns
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65172
Dave Pearson <pe...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Dave Pearson <pe...@hotmail.com> ---
I can confirm this behavior, and would like to add that the first time the
login is used, all will appear well, it is only subsequent accesses (i.e. via
cache) that do not show any of the AUTHENTICATE_ variables.
This can be quite easily shown by simply calling a phpinfo(); in a test php
file - upon refreshing the page using F5 in the browser, the AUTHENTICATE_
variables all clearly disappear after firstly being visible after login.
Changing the
AuthBasicProvider socache dbd
to
AuthBasicProvider dbd
"fixes" this issue, but it will no longer cache the credentials.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
[Bug 65172] authn_socache doesn't cache well with authn_dbd if query
contains additional columns
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65172
Dave Pearson <pe...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |major
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org