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

[Jonathan M. Hollin]

Oh the connect is definitely where it's failing.  If I comment that out then
everything works fine...

I'll try your code though - watch this space.

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


:: >:: how bout adding a 'or die DBI->errstr' to the above line to find
:: >:: out whats
:: >:: happening.
:: >
:: >Hmm...  Tried that, it returns nothing!!! :-(
::
:: This is suspicious.  The connect() is definitely where the error is
:: happening given what you wrote earlier.  Try making sure, change it to:
::
::         use DBI();
::         $driver = "mysql";
::         $dsn = "DBI:$driver:database=shapeshifter;host=localhost";
::         $dbh = DBI->connect($dsn, dbusrname, dbpassword)
::           or die "Error: $DBI::errstr";
::
:: (include the whole string there)