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.32.1			  2020-12-05	    Rex::Group::Lookup::DBI(3)
NAME | DESCRIPTION | SYNOPSIS | EXPORTED FUNCTIONS

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

home | help