NAME

DBIx::DSN::Resolver - Resolve hostname within dsn string

SYNOPSIS

  use DBIx::DSN::Resolver;

  my $dsn = 'dbi:mysql:database=mytbl;host=myserver.example'

  my $resolver = DBIx::DSN::Resolver->new();
  $dsn = $resolver->resolv($dsn);

  is $dsn, 'dbi:mysql:database=mytbl;host=10.0.9.41';

DESCRIPTION

DBIx::DSN::Resolver parses dsn string and resolves hostname within dsn. This module allows customize the resolver function.

CUSTOMIZE RESOLVER

use the resolver argument. This sample code makes resolver cache with Cache::Memory::Simple.

  use Cache::Memory::Simple;
  use Socket;
    
  my $DNS_CACHE = Cache::Memory::Simple->new();
      
  my $r = DBIx::DSN::Resolver->new(
     resolver => sub {
         my $host = shift;
         my $ipr = $DNS_CACHE->get($host);
         my $ip = $ipr ? $$ipr : undef;
         if ( !$ipr ) {
              $ip = Socket::inet_aton($host);
              $DNS_CACHE->set($host,\$ip,5);
          }
          return unless $ip;
          Socket::inet_ntoa($ip);
      }
  );
  $dsn = $resolver->resolv($dsn);

Default:

  resolver => sub { Socket::inet_ntoa(Socket::inet_aton(@_)) }

Also DBIx::DSN::Resolver::Cached is useful for cache resolver response.

AUTHOR

Masahiro Nagano <kazeburo {at} gmail.com>

NOTES

DBIx::DSN::Resolver uses Socket::inet_aton for hostname resolution. If you use Solaris and fail hostname resolution, please recompile Socket with "LIBS=-lresolve"

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.