Re: Apache2/Modperl2 fails to preload Win32::OLE at server startup
I definitely agree with that.
A daemon would solve all the authentication and connection persistence issues.
But the problem is that all accesses to the database that I'm using *must* go
through a vendor specific API which is only available as a COM library.
This explains the choice of Apache/win32 and Win32::OLE.
In face of the potential problems, I will reconsider writing a RPC::PlServer
daemon that uses Win32::OLE to access the database.
Thanks for the suggestion.
Stas Bekman wrote:
> Thierry Valentin wrote:--
>> 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.
earth decision sciences SA
/(formerly known as T-Surf)/
22, allée de la Foret de la Reine
54500 Vandoeuvre-lès-Nancy, France
Phone: +33 (0)3-83-67-66-29
Fax: +33 (0)3-83-67-66-34
Please visit our website at: www.earthdecision.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