freetds

Install and Configure FreeTDS

tchmnkyz

tchmnkyz

13,541 downloads

12,842 latest version

2.3 quality score

Version information

  • 0.0.5 (latest)
  • 0.0.4
  • 0.0.3
  • 0.0.2
  • 0.0.1
released Oct 27th 2014

Start using this module

Tags: freetds

Documentation

tchmnkyz/freetds — version 0.0.5 Oct 27th 2014

tchmnkyz/freetds

####Table of Contents

  1. Overview
  2. Setup
  3. Usage
  4. Classes

##Overview

FreeTDS uses a configuration file called freetds.conf (the name of the file can be controlled by an environment variable). Its format is similar to Samba's modified "win.ini" format. Its foremost job is to relate dataserver names, as known to your programs[1] , to machine names, as known your network. That is, while your machines have names known to the network, the dataservers on your machines have names known only to your FreeTDS client programs. The configuration file can then further describe that dataserver in greater detail, as need be.

This module will install the packages required for this and maintain the freetds.conf file for you.

Setup

Usage

Basic Usage

Basic usage making sure freetds is always the latest version and a simple host definition.

class {"freetds": ensure => 'latest',}

::freetds::conf {"db01.example.org":
    version => '4.2',
    host => 'db01.example.org',
    port => '1433',
}

Advanced Usage

class {"freetds":
    ensure => 'latest',
    version => '4.2'
}

::freetds::conf {"db01.example.org":
 version => '7.0',
 host => 'db01.example.org',
  port => '1433',
  nt_domain => 'example.org',
  connection_timeout => '15',
}

Locales usage:

class {"freetds":
 ensure => 'latest',
 version => '4.2'
}

::freetds::locales {"default":
  date_format => "%b %e %Y %I:%M:%S:%z%p"
}

::freetds::locales {"en_US":
  date_format => "%b %e %Y %I:%M:%S:%z%p",
  language => "us_english",
  charset => "iso_1",
}

::freetds::conf {"db01.example.org":
  version => '7.0',
  host => 'db01.example.org',
  port => '1433',
  nt_domain => 'example.org',
  connection_timeout => '15',
}

Classes

  • freetds
    • Parameters:
      • version
      • port
      • install
      • ensure
  • freetds::package
    • Parameters:
      • install
      • ensure
  • freetds::conf
    • Parameters:
      • version
      • host
      • port
      • initial_block_size
      • try_server_login
      • try_domain_login
      • nt_domain
      • cross_domain_login
      • dump_file
      • dump_file_append
      • debug_level
      • timeout
      • connection_timeout
      • emulate_little_endian
      • client_charset
      • text_size
  • freetds::locales
    • Parameters:
      • date_format
      • language
      • charset