So if I have a global variable set in my httpd.conf for both sites with the same name, will that do it? I just copied most of the code from the old virtualhost to the new one and I don't think I changed the name of my database handle variable.
Perrin Harkins wrote: > On 1/23/07, Matt Grommes <[EMAIL PROTECTED]> wrote: >> I've recently added a new site to my server, both now running Mason. The >> problem is that I'll get errors on the first site and when I look at the >> log, it'll say it's trying to use the second site's database. The issue >> as I see it (if I'm wrong please correct me) is that since both sites >> use Apache::DBI, it's sharing the database connections between the two >> sites. > > No, Apache::DBI doesn't do that. Every time you call connect(), it > checks your connection parameters and returns you a handle cached for > that connection. It could only get confused if you were using the > exact same connection parameters for both and then switching databases > after that with something like "USE other_database;" (in MySQL > syntax). > > More likely, you are putting the database handle into a global > variable in some autohandler code somewhere, and sometimes putting in > the wrong one. > > - Perrin > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Mason-users mailing list Mason-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mason-users
