1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| #!/usr/bin/perl -w
## info Mysql ##
use strict;
use Net::Telnet;
use Net::Ping;
use Net::MySQL;
my $hostname = '10.129.4.60';
my $database = 'ness3';
my $user = 'netcool';
my $password = 'ncool';
my $timeout = 1 ;
my $query;
my $result;
my $mysql;
my $debug;
# ----------------------------Mes Fonctions----------------------
sub f_open_mysql {
$mysql = Net::MySQL->new(
hostname => $hostname, # Default use UNIX socket
database => $database,
user => $user,
password => $password,
timeout => $timeout,
debug => $debug
);
}# fin sub
sub f_Query_mysql {
my $query = "SELECT s.subnet_name ,ip.ip_addr, ip.name FROM subnet s , ip , block b
WHERE
s.block_id = b.oid
and ip.subnet_id = s.oid
and ip.row_enabled = 1
and b.block_name = 'Loopback local Redback'
and ip.name regexp '^[0-9][0-9][A-Z0-9][A-Z][A-Z0-9][A-Z]{0,2}\-SE[0-9][0-9]0'
order by ip.ip_addr" ;
## execution de la request ##
$result = $mysql->query( $query );
#---- je voudrais aficher le résultat-----------------
if ($mysql->is_error) { die ("SQL Request Error !!!\nEnd script\n");}
}# fin sub
print "test2\n";
sub f_close_mysql {
$mysql->close;
}# fin sub |
Partager