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 2007/01/05 17:35:07 UTC
DO NOT REPLY [Bug 41302] New: - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
Summary: mod_dbd and mod_authn_dbd not work with posgresql (Error
looking up in database)
Product: Apache httpd-2
Version: 2.2.3
Platform: Other
OS/Version: Linux
Status: NEW
Severity: major
Priority: P2
Component: mod_dbd
AssignedTo: bugs@httpd.apache.org
ReportedBy: fontana@netw.it
Hi,
I installaed from source the 2.2.3 version for apache.
The configure was
./configure --enable-expires=shared --enable-headers=shared --enable-proxy=shared --enable-proxy-http=shared --enable-rewrite=shared --enable-so --enable-dbd=shared --enable-authn-dbd=shared
I'm trying to use dbd module a together with postgresql 8.1.x to authenticate
users.
I "discovered" that if I use the following configuration (using VirtualHosts)
the database is (seems) never queried
NameVirtualHost 192.168.1.5
ServerName elettra.local.effeci.info
<VirtualHost effeci.homelinux.net>
ServerName effeci.effeci.info
DBDriver pgsql
DBDParams "port=5432 host=localhost dbname=auth user=xxxx
password=xxxx"
DocumentRoot /home/http
DBDMin 1
DBDKeep 1
DBDMax 10
DBDExptime 0
<Directory /home/http>
Order Deny,Allow
AuthType basic
AuthName "Mio"
AuthBasicProvider dbd
AuthDBDUserPWQuery "select pass from users where login = %s"
require valid-user
</Directory>
</VirtualHost>
If I delete the VirtualHost configuration, the first ServerName and
NameVirtualHost directives everything work fine.
I found in bug 41141 that there is a "reference" to VirtualHost inheritance
problem, is the same bug?
Regards
Christian
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
------- Additional Comments From chrisd@pearsoncmg.com 2007-02-05 21:18 -------
If you get a chance, could you test your original problematic configuration
with the latest mod_dbd.c from trunk? I can't tell from your report if
my most recent changes will address your problem, but I think they might.
Please let me know what you find! Thanks.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
------- Additional Comments From christian.fontana@gmail.com 2007-01-06 05:34 -------
Thanks for your answers.
>
> http://marc.theaimsgroup.com/?l=apache-httpd-dev&m=116742014418304&w=2
>
I read more than once your post and I think I didn't understood it completely.
But the problem seems to be the one you describe.
> So, if you can wait a bit, I'm aiming to get both patches into trunk
> fairly soon.
Yes, I can wait. The system is not yet productive. I'm testing different
solutions an the one based on SQL seems to be the perfect one in order not to
duplicate credentials and use the alredy present corporate user repository.
> If you feel like trying to apply them to 2.2.3 yourself,
> go for it, and let me know if the "groups" change fixes your problem.
I tried simply with patch p0 < <patch name> but I receive some errors. I
suppose it's due to the fact that the patch is written for the trunk version
of mod_dbd, isn't it?
I don't know so well the apr utils library to try to adapt the code. I'm going
to try but I have before to understand how the module works and above all the
apr interface.
Thanks
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
chrisd@pearsoncmg.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bugs@ausics.net
------- Additional Comments From chrisd@pearsoncmg.com 2007-05-15 18:37 -------
*** Bug 42327 has been marked as a duplicate of this bug. ***
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
christian.fontana@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
------- Additional Comments From christian.fontana@gmail.com 2007-02-16 14:56 -------
Sorry for the delay, but I was busy.
I tested and it works fine: the database is correctly contacted.
thanks
christian
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
------- Additional Comments From christian.fontana@gmail.com 2007-02-07 04:57 -------
(In reply to comment #3)
> If you get a chance, could you test your original problematic configuration
> with the latest mod_dbd.c from trunk?
For sure I can test your code but I need some help. Is it enough to download
the apache 2.2.4 and the mod_dbd code from cvs and then compile as usual?
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
------- Additional Comments From chrisd@pearsoncmg.com 2007-02-07 09:28 -------
Yes, that should be fine; I've compiled the mod_dbd.c code from trunk
with 2.2.3 and there are no problems there. Any recent 2.2.x should be OK
for testing, so long as you're using the mod_dbd.c from trunk. Thanks.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org
DO NOT REPLY [Bug 41302] - mod_dbd and mod_authn_dbd not work with posgresql (Error looking up in database)
Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41302>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=41302
------- Additional Comments From chrisd@pearsoncmg.com 2007-01-05 10:02 -------
I think you're probably running into some problems in mod_dbd right now
that relate to virtual hosts and configuration inheritence. I described
them in more detail here, in the fourth section:
http://marc.theaimsgroup.com/?l=apache-httpd-dev&m=116742014418304&w=2
The part that deals with the inheritence issues is the fourth "groups"
patch here:
http://people.apache.org/~chrisd/patches/mod_dbd_pools_groups/
I've committed the first two patches from there to trunk, but I've had
to go back and do some more work on the third "pools" one to make sure it
works with single-process MPMs, and I'm still waiting to find some time
to test that; that relates to this bug report:
http://issues.apache.org/bugzilla/show_bug.cgi?id=39985
So, if you can wait a bit, I'm aiming to get both patches into trunk
fairly soon. If you feel like trying to apply them to 2.2.3 yourself,
go for it, and let me know if the "groups" change fixes your problem.
--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org