Hello all the discussion has become a little bit technical for me...
What I understand is that I've been lucky to make this work so far and that sooner or later I will end up with some problems.
I'm not familiar with win32-perl internals, but based on what Jan explained so far I suspect that you may have the problem. I could be wrong though. Jan will probably know better to answer this question.
Is there some not-too-complicated way to workaround the problems in the perl scripts or at least prevent the most severe problems to happen?
NOTE: Actually what I'm currently doing is a authentication handler derived from Apache::AuthCookie. My handler is connecting to a database through Win32::OLE to authenticate users. Active connections are kept in a cache until users logout.
From what I understand of Jan's answer: should I keep an active connection per thread-id?
I don't think this will work. You could try to run a daemon which will do the auth (i.e. taking win32::OLE out of picture) and have your modperl scripts talk to that daemon when they need auth.
I think your best solution is to get linux or another unix flavor and then you will be on the safe ground (at least with prefork mpm). I think 99.9% of modperl users use some Unix flavor, so things are much more solid on this side of the world.
-- __________________________________________________________________ Stas Bekman JAm_pH ------> Just Another mod_perl Hacker http://stason.org/ mod_perl Guide ---> http://perl.apache.org mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com http://modperlbook.org http://apache.org http://ticketmaster.com
-- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html