In your startup script you need to call Apache::DBI->connect_on_init with the same parameters that you pass to DBI->connect.

Make sure things work without with vanilla DBI before adding the Apache::DBI layer.

Just look at netstat to see if there are open connections between your web servers and your database.

The answers to all your questions are here:

http://perl.apache.org/guide/databases.html