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 2008/07/22 13:25:36 UTC

DO NOT REPLY [Bug 45456] New: mod_dbd don' t allow more then one database pool

https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

           Summary: mod_dbd don't allow more then one database pool
           Product: Apache httpd-2
           Version: 2.3-HEAD
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: mod_dbd
        AssignedTo: bugs@httpd.apache.org
        ReportedBy: mkevac@gmail.com


With mod_dbd one can use only one database pool.

It will be great, if some kind of <DBDPool pool_name> container will be
introduced and all mod_dbd APIs should accept pool_name as parameter.

Patch follows...


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #10 from RobertPattinson <go...@https.webasyst.net> 2012-04-11 05:49:59 UTC ---
With mod_dbd one can use only one database pool.

It will be great, if some kind of <DBDPool pool_name> container will be
introduced and all mod_dbd APIs should accept pool_name as parameter.
http://bitly.com/bundles/cyberworldukltd/1

--- Comment #11 from RobertPattinson <go...@https.webasyst.net> 2012-04-11 05:49:59 UTC ---
http://bitly.com/bundles/cyberworldukltd/1

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #5 from Marko Kevac <mk...@gmail.com> 2010-05-17 03:46:03 EDT ---
Created an attachment (id=25447)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25447)
test module

Here is test module, which acquires and cacquires connection and execute 'SHOW
DATABASES' on pool named ?pool_name=... or on default pool if pool_name is not
set.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #13 from Marko Kevac <mk...@gmail.com> 2012-04-11 13:26:37 UTC ---
It is the question who will do it faster. But I will try to find some time.
Thanks for your work!

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

RobertPattinson <go...@https.webasyst.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                URL|                            |http://snip.it/collections/
                   |                            |16604-iPhone-4-cases--iPhon
                   |                            |e-4S-cases--iPad-2-Cases-Co
                   |                            |llections

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #17 from RobertPattinson <go...@https.webasyst.net> 2012-04-16 06:52:48 UTC ---
Here is test module, which acquires and cacquires connection and execute 'SHOW
DATABASES' on pool named ?pool_name=... or on default pool if pool_name is not
set.

http://mobileaccessoriesuk.wordpress.com/

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Gianni <gi...@bitforge.com.br> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gianni.rossi@bitforge.com.b
                   |                            |r

-- 
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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #9 from Igor Galić <i....@brainsware.org> 2012-04-06 13:16:27 UTC ---
We did a quick code-review in #httpd-dev today, and there's a couple of
questions

The thing that I noticed was:
https://issues.apache.org/bugzilla/attachment.cgi?id=25450&action=diff#a/modules/database/mod_dbd.c_sec19
on line line 1084 there's this mysterious declaration:

  dbd_pool_t *dbdpool = NULL;

We have no idea what that's doing there..

Furthermore you're modifying, or rather, breaking, the existing API of
ap_dbd_acquire_pool().
I'd rather we find a way to be backward compatible.

More comments this evening.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456


Marko Kevac <mk...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #22299|0                           |1
        is obsolete|                            |




--- Comment #3 from Marko Kevac <mk...@gmail.com>  2009-01-30 11:57:26 PST ---
Created an attachment (id=23207)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23207)
New version of patch

New version of patch with pool bug fixed and added new DBDInitSQL configuration


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Peter Poeml <po...@cmdline.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |poeml@cmdline.net

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Marko Kevac <mk...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #25446|0                           |1
        is obsolete|                            |

--- Comment #6 from Marko Kevac <mk...@gmail.com> 2010-05-17 04:06:39 EDT ---
Created an attachment (id=25450)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25450)
Forgot about .h file diff. New version.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Stefan Fritsch <sf...@sfritsch.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                URL|http://snip.it/collections/ |
                   |16604-iPhone-4-cases--iPhon |
                   |e-4S-cases--iPad-2-Cases-Co |
                   |llections                   |

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #12 from Igor Galić <i....@brainsware.org> 2012-04-11 13:09:21 UTC ---
Okay, trying to integrate this on current trunk, it fails. Of course.
I'll try to make sense of it.

Marko, If I'm not done earlier, as the author, could you try to update the
patch yourself against trunk, please?

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Marko Kevac <mk...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #23207|0                           |1
        is obsolete|                            |

--- Comment #4 from Marko Kevac <mk...@gmail.com> 2010-05-17 03:41:09 EDT ---
Created an attachment (id=25446)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25446)
new version

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #8 from Marko Kevac <mk...@gmail.com> 2012-04-06 07:05:14 UTC ---
It's ok :-)

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #16 from RobertPattinson <go...@https.webasyst.net> 2012-04-12 11:08:53 UTC ---
vthank you very much for your work, I hope you don't feel too neglected.
I only noticed it now that I'm working on a PHP extension which should use
mod_dbd as database back-end.

http://www.myspecies.info

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Matthew Kent <mk...@magoazul.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mkent@magoazul.com

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #16 from Jackie Rosen <ja...@hushmail.com> ---
*** Bug 260998 has been marked as a duplicate of this bug. ***
Seen from the domain http://volichat.com
Page where seen: http://volichat.com/adult-chat-rooms
Marked for reference. Resolved as fixed @bugzilla.

-- 
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 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #15 from Daniel Gruno <hu...@apache.org> ---
This should be marked as an enhancement request, not a bug :)

-- 
You are receiving this mail because:
You are the assignee for the bug.

DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #7 from Igor Galić <i....@brainsware.org> 2012-04-05 20:26:40 UTC ---
Marko,

thank you very much for your work, I hope you don't feel too neglected.
I only noticed it now that I'm working on a PHP extension which should use
mod_dbd as database back-end.

I'll look into integrating this ASAP.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

--- Comment #15 from Igor Galić <i....@brainsware.org> 2012-04-11 18:15:15 UTC ---
well, I was really afraid I'd break tests when applying this patch.

Then I found out we don't have any for this module -_-

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Daniel Gruno <hu...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--- Comment #14 from Daniel Gruno <hu...@apache.org> ---
This should be marked as an enhancement request, not a bug :)

-- 
You are receiving this mail because:
You are the assignee for the bug.

DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Peter Poeml <pe...@poeml.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|poeml@cmdline.net           |peter@poeml.de

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456

Igor Galić <i....@brainsware.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #25450|0                           |1
        is obsolete|                            |

--- Comment #14 from Igor Galić <i....@brainsware.org> 2012-04-11 14:03:07 UTC ---
Created attachment 28585
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=28585
adapt for new changes on trunk

I've left APLOGNO() empty for when we actually commit it the numbers might turn
out to be very different.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456





--- Comment #1 from Marko Kevac <mk...@gmail.com>  2008-07-22 04:26:46 PST ---
Created an attachment (id=22299)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=22299)
more then one pool for mod_dbd


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456





--- Comment #2 from Marko Kevac <mk...@gmail.com>  2008-07-22 04:28:47 PST ---
Configuration example:

    <DBDPool "dbdtest">
        DBDriver mysql
        DBDParams "host=172.20.30.65, port=..."
        DBDPersist On
    </DBDPool>

    <DBDPool "dbdtest2">
        DBDriver mysql
        DBDParams "host=172.20.30.65, port=..."
        DBDPersist On
    </DBDPool>

    <DBDPool "dbdtest3">
        DBDriver mysql
        DBDParams "host=172.20.30.65, port=..."
        DBDPersist On
    </DBDPool>

    <DBDPool "dbdtest4">
        DBDriver mysql
        DBDParams "host=172.20.30.65, port=..."
        DBDPersist On
    </DBDPool>


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 45456] mod_dbd don't allow more then one database pool

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45456


Marko Kevac <mk...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |PatchAvailable




-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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