#!/usr/bin/env perl

use strict;
use CGI;
use DBI;
use JSON qw( encode_json );
use Socket;
use YAML qw( LoadFile );
my $cgi = new CGI;
print $cgi->header('text/html');
my %var = $cgi->Vars;
exit unless( $var{hostname} );
chomp $var{hostname};

my $real = $cgi->remote_host();
my $packed = gethostbyname($var{hostname}) or die "Can't resolve $var{hostname}\n";
my $remote = inet_ntoa($packed);
chomp $remote;
if ( $real ne $remote ) {
    print "Invalid Source IP\n";
    die "Invalid Source IP $real claimed to be $remote\n";
}
my $config_settings = LoadFile("/var/www/conf/backup_master_config.yaml") || die "Failed to load config: $!\n";
my $dbh = DBI->connect("DBI:mysql:database=".$config_settings->{backup_db}.";host=localhost",$config_settings->{backup_user}, $config_settings->{backup_pass}) or die("couldnt connect to db $!"); 

my %data;
my $query = "SELECT server.hostname,newbacknetip.backnetip,pubkeys.pubkey FROM `pubkeys` LEFT JOIN `server` on pubkeys.serverid = server.serverid LEFT JOIN `newbacknetip` on pubkeys.serverid = newbacknetip.serverid WHERE server.hostname IN (SELECT chostname FROM iscsiview WHERE chostname = ? or bhostname = ?)";
my $sth = $dbh->prepare($query);
$sth->execute($var{hostname}, $var{hostname});
if ($sth->errstr) {
    print "Error occured: $sth->errstr\n";
} else {
    my $backnetip;
    while(my $ref = $sth->fetchrow_hashref()){
        next if ( !$ref->{backnetip} );
        $backnetip = join '.', unpack 'C4', pack 'N', $ref->{backnetip};
        print "from=\"$backnetip\",no-X11-forwarding,no-port-forwarding $ref->{pubkey}\n"; 
    }
    $sth->finish;
}
