Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Rex::Group::Lookup::DBUser Contributed Perl DocumentRex::Group::Lookup::DBI(3)

NAME
       Rex::Group::Lookup::DBI - read hostnames	and groups from	a DBI source

DESCRIPTION
       With this module	you can	define hostgroups out of an DBI	source.

SYNOPSIS
	use Rex::Group::Lookup::DBI;
	groups_dbi "dsn", "user", "password", "SQL request";

EXPORTED FUNCTIONS
   groups_dbi($dsn, $user, $password, $sql)
	With this function you can read	groups from DBI	source.

   Example: groups_dbi(	'DBI:mysql:rex;host=db01', user		    =>
       'username', password	    => 'password', sql		    => "SELECT
       * FROM HOST",  create_all_group => TRUE);
   Database sample for MySQL
	CREATE TABLE IF	NOT EXISTS `HOST` (
	  `ID` int(11) NOT NULL,
	  `GROUP` varchar(255) DEFAULT NULL,
	  `HOST` varchar(255) NOT NULL,
	  PRIMARY KEY (`ID`)
	);

   Data	sample for MySQL
	INSERT INTO `HOST` (`ID`, `GROUP`, `HOST`) VALUES
	  (1, 'db', 'db01'),
	  (2, 'db', 'db02'),
	  (3, 'was', 'was01'),
	  (4, 'was', 'was02');

perl v5.24.1			  2016-07-16	    Rex::Group::Lookup::DBI(3)

NAME | DESCRIPTION | SYNOPSIS | EXPORTED FUNCTIONS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Rex::Group::Lookup::DBI&sektion=3&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help