[support] Dynamic remote database access

[Ms. Nancy Wichmann]

No, I didn't, but will try it later.


Nancy E. Wichmann, PMP
(781) 697-6344
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

From: "Metzler, David" <metzlerd at evergreen.edu>
>To: Ms. Nancy Wichmann <nan_wich at bellsouth.net>
>Sent: Monday, July 11, 2011 4:14 PM
>Subject: RE: [support] Dynamic remote database access
>
>
>I tried your test, but I did not get the same behavior as you did.  Just adding the url did not make it try and connect. 
>Did you remember to change your base connection to $db_url[‘default’] prior to adding the secondary connection string? 
> 
>Dave
> 
>From:Ms. Nancy Wichmann [mailto:nan_wich at bellsouth.net] 
>Sent: Monday, July 11, 2011 12:09 PM
>To: Metzler, David
>Subject: Re: [support] Dynamic remote database access
> 
>I haven't even gotten as far as to use db_set_active. I was just checking that the settings.php worked as intended, which it does not. Try it on your local site: enter another db connection, but with an incorrect password. At the very least, authentication is happening whether you are physically accessing the DB or not. And when I tried accessing a truly remote DB with correct userid and password, it failed because MySql was trying to add my local IP address to the userid. In this case, I am not an admin in any way, shape, or form on the remote DB and cannot even try adding a user id containing the IP address (whatever it may be today).
> If this were not under Drupal, I would just try a straight mysql_connect, but i don't think that is very Drupally.
> 
>Nancy E. Wichmann, PMP
>(781) 697-6344
> 
>Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
>
>
>
>From:"Metzler, David"
> 
>Not sure how you are accessing your remote db, but it seems odd that it should open a connection before one is required. The settings.php shouldn’t cause a connection to the db, it just defines the connection stirng. 
> 
>It seems that when set_active is called then the conection gets opened.   If that only happens in  a cron hook then that should only happen then.  Where are your set_active calls coming into play here? 
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110711/a6ce6d19/attachment.html