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