16 |
my $debug = 0; |
my $debug = 0; |
17 |
$|=1; |
$|=1; |
18 |
|
|
19 |
my $cdr_opts = 'dev=/dev/hdc blank=fast -v -eject'; |
# don't check for user |
20 |
|
my $bpc = BackupPC::Lib->new(undef, undef, 1) || die; |
21 |
|
my %Conf = $bpc->Conf(); |
22 |
|
%BackupPC::SearchLib::Conf = %Conf; |
23 |
|
|
24 |
|
my $cdrecord = $Conf{CDRecordBin} || die "Need CDRecordBin in config.pl\n"; |
25 |
|
my $cdr_opts = $Conf{CDRecordOpts} || die "Need CDRecordOpts in config.pl\n"; |
26 |
|
|
27 |
|
|
28 |
my $bin; |
my $bin; |
29 |
foreach my $c (qw/mkisofs cdrecord eject/) { |
foreach my $c (qw/mkisofs eject/, $cdrecord) { |
30 |
$bin->{$c} = which($c) || die "$0 needs $c, install it\n"; |
$bin->{$c} = which($c) || die "$0 needs $c, install it\n"; |
31 |
} |
} |
32 |
|
|
34 |
|
|
35 |
my $t_fmt = '%Y-%m-%d %H:%M:%S'; |
my $t_fmt = '%Y-%m-%d %H:%M:%S'; |
36 |
|
|
|
# don't check for user |
|
|
my $bpc = BackupPC::Lib->new(undef, undef, 1) || die; |
|
|
my %Conf = $bpc->Conf(); |
|
|
%BackupPC::SearchLib::Conf = %Conf; |
|
37 |
|
|
38 |
my $dsn = $Conf{SearchDSN} || die "Need SearchDSN in config.pl\n"; |
my $dsn = $Conf{SearchDSN} || die "Need SearchDSN in config.pl\n"; |
39 |
my $user = $Conf{SearchUser} || ''; |
my $user = $Conf{SearchUser} || ''; |
94 |
backups.date AS date, |
backups.date AS date, |
95 |
shares.name AS share, |
shares.name AS share, |
96 |
backups.size AS backup_size, |
backups.size AS backup_size, |
97 |
backups.inc_size AS compress_size, |
backups.inc_size AS compress_size |
|
backups.parts AS parts |
|
98 |
FROM backups, archive_backup, hosts, shares |
FROM backups, archive_backup, hosts, shares |
99 |
WHERE archive_backup.backup_id = backups.id |
WHERE archive_backup.backup_id = backups.id |
100 |
AND hosts.id=backups.hostid |
AND hosts.id=backups.hostid |
173 |
$row->{'copies'} =~ s/^\s*0+\s*$/no/; |
$row->{'copies'} =~ s/^\s*0+\s*$/no/; |
174 |
$row->{'total_size'} /= (1024*1024); |
$row->{'total_size'} /= (1024*1024); |
175 |
|
|
176 |
my $copies = $row->{'copies'}; |
my $copies = 'copies'; |
177 |
if ($row->{'parts'} > 1) { |
$copies = 'copy' if ($row->{'copies'} == 1); |
|
$copies .= '/' . $row->{'parts'}; |
|
|
} |
|
|
|
|
|
my $copies_dest = 'copies'; |
|
|
$copies_dest = 'copy' if ($row->{'copies'} == 1); |
|
178 |
|
|
179 |
return |
return |
180 |
sprintf("%d by %s on %s, %s %s [%.2f Mb]", |
sprintf("%d by %s on %s, %s %s [%.2f Mb]", |
181 |
$row->{'dvd_nr'}, |
$row->{'dvd_nr'}, |
182 |
$row->{'username'}, |
$row->{'username'}, |
183 |
$row->{'date'}, |
$row->{'date'}, |
184 |
$copies, $copies_dest, |
$row->{'copies'}, $copies, |
185 |
$row->{'total_size'}, |
$row->{'total_size'}, |
186 |
); |
); |
187 |
} |
} |
243 |
|
|
244 |
my $sth_archive_burned = $dbh->prepare( qq{ |
my $sth_archive_burned = $dbh->prepare( qq{ |
245 |
insert into archive_burned |
insert into archive_burned |
246 |
(archive_id, iso_size, part) |
(archive_id, iso_size, part, copy) |
247 |
values ( (select id from archive where dvd_nr =?), ?, ?) |
values ( (select id from archive where dvd_nr =?), ?, ?, ?) |
248 |
}); |
}); |
249 |
|
|
250 |
foreach my $arc (@archives_to_burn) { |
foreach my $arc (@archives_to_burn) { |
343 |
print "ISO $iso_file allready exists\n"; |
print "ISO $iso_file allready exists\n"; |
344 |
} |
} |
345 |
|
|
346 |
print "\nREADY TO BURN MEDIA $disk_name please insert blank media and press ENTER\n\n"; |
my $copies = $Conf{BurnMultipleCopies} || 1; |
347 |
|
|
348 |
system($bin->{'eject'}) == 0 or skip "can't run eject: $?"; |
foreach my $copy_nr ( 1 .. $copies ) { |
349 |
|
|
350 |
my $wait = <STDIN>; |
print "\nREADY TO BURN MEDIA $disk_name copy $copy_nr\n\nPlease insert blank media and press ENTER\n\n"; |
351 |
|
|
352 |
my $cmd = $bin->{'cdrecord'} . ' ' . $cdr_opts . ' ' . $iso_file; |
system($bin->{'eject'}) == 0 or skip "can't run eject: $?"; |
353 |
|
|
354 |
# system($cmd) == 0 or skip "can't run $cmd: $?"; |
my $wait = <STDIN>; |
|
print "## $cmd\n"; |
|
355 |
|
|
356 |
print "\n\nPLEASE REMOVE DVD MEDIA AND LABEL IT WITH $disk_name\n\n"; |
my $cmd = $bin->{$cdrecord} . ' ' . $cdr_opts . ' ' . $iso_file; |
357 |
|
|
358 |
$sth_archive_burned->execute($dvd_nr, $iso_size, $part_nr); |
# FIXME |
359 |
|
print "## $cmd\n"; |
360 |
|
system($cmd) == 0 or skip "can't run $cmd: $?"; |
361 |
|
|
362 |
|
print "\n\nPLEASE REMOVE DVD MEDIA AND LABEL IT WITH $disk_name\n\n"; |
363 |
|
|
364 |
print "Media burn for $disk_name recorded\n"; |
$sth_archive_burned->execute($dvd_nr, $iso_size, $part_nr, $copy_nr); |
365 |
|
|
366 |
|
print "Media burn for $disk_name copy $copy_nr recorded\n"; |
367 |
|
} |
368 |
|
|
369 |
$part_nr++; |
$part_nr++; |
370 |
} until ($part_nr > $parts); |
} until ($part_nr > $parts); |