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@evergreen.edu

To: Ms. Nancy Wichmann nan_wich@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?