Hi all,
I have put myself in a bit of a pickle, but hope someone here can help me.
In my handler I have two global vars ($dbh and $dbh_itemdb).
I set these in a <%once> clause like:
$dbh = DBI->connect("DBI:mysql:$base:localhost", "$user", "$pass");
$dbh_itemdb = DBI->connect("DBI:mysql:$item:localhost", "$user", "$pass");
If I comment out the 2nd line everything works (besides looking up
items). If I enable the 2nd line I get "Premature end of script
headers" for each request I make.
I then tried the same code base on a different server, and it works!
(as I would have thought would be the case on my primary server).
I have compared versions and found DBI in v1.56 on my primary box
which I then upgraded to v1.60.1 but on the secondary box I have v1.57
and didn't do anything subsequently. I also recompiled DBD-mysql after
upgrading DBI.
I also tried using connect_cached, but I read in docs that DBI already
does this for me, so I left things as they were in that area (but
tried both - naturally).
My system is FreeBSD 6.2-p10 with Mason v1.35, Apache 2.2.4_2,
mod_perl v2.0.3, and MySQL v5.0.41.
The background for even splitting my database in the first place for
this site is, that I want to make separate backup of the data. The 1st
database is the vital one which I'm backing up every hour. The 2nd
database is just an inventory list which I can generate from flat
files whenever I want - hence I don't really need a backup (that
often) - and it is HUGE in size compared to the dynamic content in the
1st DB.
Any hints are much appreciated
Thank you in advance
Regards
Nicolai Schlenzig,
Denmark
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Mason-users mailing list
Mason-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mason-users
