SIMPLE SOLUTIONS

REX::GROUP::LOOKUP::DBI(3PM) - Linux man page online | Library functions

Read hostnames and groups from a DBI source.

Chapter
2018-02-01
Rex::Group::Lookup::DBI(3pm) User Contributed Perl Documentation Rex::Group::Lookup::DBI(3pm)

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.26.1 2018-02-01 Rex::Group::Lookup::DBI(3pm)
Download raw manual
Index User Contributed Perl Documentation (+23303) perl v5.26.1 (+10548) № 3 (+68044)
Go top