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(a)evergreen.edu>
>To: Ms. Nancy Wichmann <nan_wich(a)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@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?
>
>