Thread ROUTER Configuration: Config-daten in der Tabelle speichern (13 answers)
Opened by nour at 2007-01-29 12:35

renee
 2007-01-29 12:50
#73749 #73749
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
ungetestet:
Code: (dl )
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
use strict;
use warnings;
use DBI;
use Net::Telnet::Cisco;
use Digest::MD5;

our $dbh = DBI->connect(...) or die $DBI::errstr;

my $session = Net::Telnet::Cisco-> new (Host => '10.200.2.100');
my $raw_data;

sub Login{
my @output = $session->cmd('show run');
my $List = join '',@output;
my @array = split /interface ATM/,$List;
shift @array;
my %hash;
for my $interface(@array){
my ($bez) = $interface =~ /^([^\n]+)/;
my @data = $interface =~ /(data.*?cbr 128)/sg;
for my $data(@data){
my ($id,$ip) = $data =~ /(data\s*[\d\/]+).*?protocol ip ((?:\d{1,3}\.){3}\d{1,3})/s;
push @{$hash{'ATM'.$bez}}, [$id,$ip];
}
}

my $query = "INSERT INTO RC_CISCO_NB(NEID,TS,VPI,VCI,PCR,data,IP) VALUES(?,NOW(),'','','',?,?)";
my $sth = $dbh->prepare($query) or die $dbh->errstr();
for my $atm(keys %hash){
print sprintf("%10s | %10s | %15s\n",$atm,'data','IP');
print sprintf("%10s | %10s | %15s\n",' ',@$_) for @{$hash{$atm}};
$sth->execute($neid,$_,$atm) or die $dbh->errstr() for(@{$hash{$atm}});
}
}


Hier wird allerdings vorausgesetzt, dass Die Spalte ID automatisch incrementiert wird.
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread ROUTER Configuration: Config-daten in der Tabelle speichern