Re: handling mysql errors

[Bill Karwin]

It's in an infinite loop here:

while( !$dbh ) {
  if( $dbh = DBI->connect(...) ) {
    ... return( $dbh );
  } else {
    warn( $DBI::errstr );
    sleep(2);
  }
}

If connect fails, your else block runs, and then loops to try again. Does this ever break out? Do you want to keep count of retries and return an error if ++$retries exceeds a certain maximum?

If the connection succeeds with a FQDN but not with a simple hostname, I would assume your router is configured fine, but your client host is not resolving the simple hostname.