RE: Connection to MySQL DB fails when mod_perl enabled...

[Jonathan M. Hollin]

:: JH> Yes I also have PHP4 installed and running properly (and am able
:: JH> to connect to the MySQL server fine with PHP).
::
:: Good, that establishes that your DB is working.

Yes the database is working fine.  Let me reiterate:  DB is accessible via
mysqladmin; DB is accessible via PHP; DB is accessible via CGI; DB is NOT
accessible via mod_perl.

:: JH> Removed PHP from Apache, that didn't help.
:: JH> Nothing else is connecting to the MySQL server.
::
:: I've never used a non-*NIX Apache. Do you need to restart you
:: machine to get
:: something(s) out of memory? Compile a new binary (I doubt it)?

I don't think I have to restart the machine.  I thought I only had to kill
the Apache process, then restart it.  However, I'll try a reboot...

:: JH> Interestingly, the MySQL server error log contains nothing.
:: No failed
:: JH> access attempts, no other error codes.  I presume this is
:: significant?
::
:: My thought would be that this indicates a driver problem. I would suggest
:: creating a terribly minimized configuration that only includes
:: the requisits
:: and mod_perl stuff. Then see if that works.

Yes, I think I should try this.  I'll reboot now, then test.  Then I'll
build minimal script and test that.  Will advise list of results.

I would just like to say thank you to everyone for their help thus far.  I
am completely new to mod_perl, but an old hand with Perl and CGI.  I
appreciate your efforts.

Kindest regards,
Jonathan M. Hollin
Digital-Word.com