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
