[Tickets #6997] Re: My Address Books missing shared address books

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/6997
------------------------------------------------------------------------------
  Ticket             | 6997
  Updated By         | Jan Schneider <jan at horde.org>
  Summary            | My Address Books missing shared address books
  Queue              | Turba
  Version            | 2.2.1
  Type               | Bug
  State              | Resolved
  Priority           | 2. Medium
  Milestone          | 2.2.2
  Patch              |
  Owners             | Jan Schneider
------------------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2008-10-24 06:28) wrote:

My IRC discussion with Lukas about that issue and the solution:

(18:58:53) yunosh: is it possible that mdb2 and db collide if using  
both in a script, but with different database names?
(18:59:28) lsmith: well .. most db ext reuse connections to the same host
(18:59:42) lsmith: some provide a way to force the creation of a new  
connection
(18:59:54) lsmith: but without it .. you might run into some issues
(19:00:14) lsmith: thats the only point that comes to my head at least
(19:00:27) lsmith: mdb2 does a fair bit of changing in the db sessions
(19:00:32) lsmith: db does much less of that
(19:00:40) lsmith: so if at all .. db could see some "breakage"
(19:02:12) yunosh: well, last time i checked the mysql driver of db  
(which i am using) it performs a select db before each query
(19:02:45) yunosh: and indeed it's a mdb2 query that fails because it  
runs onthe wrong db, not a DB query
(19:06:43) lsmith: ah
(19:06:58) yunosh: got it
(19:07:00) lsmith: yunosh: mdb2 doesnt do the select db
(19:07:10) yunosh: yes, because it tracks the current db internally
(19:07:11) lsmith: so set the new link dsn option
(19:07:30) yunosh: that won't help
(19:07:45) yunosh: oh, it would
(19:07:59) yunosh: but i rather don't want to have two connections open
(19:08:17) yunosh: db selects the db unconditionally
(19:08:30) yunosh: mdb2 only if the internal tracked database name changes
(19:08:36) lsmith: right
(19:08:43) yunosh: and of course it doesn't notice if it's changed outside
(19:08:50) lsmith: you can fix this with a debug handler
(19:09:00) yunosh: like how?
(19:09:15) lsmith: there is a hook that allows you to execute stuff  
before and after a query
(19:09:30) yunosh: ah
(19:10:24) lsmith: http://pooteeweet.org/blog/429
(19:11:39) yunosh: thanks, i guess we'll have to go that route
(19:13:15) lsmith: in the debug handler .. just change the dsn
(19:13:29) lsmith: then it should automatically do the select db if necessary
(19:13:37) lsmith: and skip it if its not needed
(19:14:04) yunosh: well, i could select the db directly in the debug  
handler, no?
(19:14:12) lsmith: you could
(19:14:19) lsmith: but if you execute two mdb2 queries in a row
(19:14:29) lsmith: you would end up with to select db calls (a round  
trip each)
(19:14:45) lsmith: with just updating the dsn you would have to fairly  
cheap php calls and one select db call
(19:15:10) yunosh: well, updating the dsn doesn't help, because it is correct
(19:15:27) yunosh: it just doesn't match the current db link
(19:15:28) lsmith: err .. right