Ravada.pm 43.8 KB
Newer Older
1
2
3
4
5
package Ravada;

use warnings;
use strict;

6
our $VERSION = '0.2.9-alpha';
Francesc Guasch's avatar
Francesc Guasch committed
7

8
use Carp qw(carp croak);
9
use Data::Dumper;
10
use DBIx::Connector;
11
use Hash::Util qw(lock_hash);
12
use Moose;
Francesc Guasch's avatar
Francesc Guasch committed
13
use POSIX qw(WNOHANG);
14
15
use YAML;

16
17
use Socket qw( inet_aton inet_ntoa );

Francesc Guasch's avatar
Francesc Guasch committed
18
19
20
no warnings "experimental::signatures";
use feature qw(signatures);

Francesc Guasch's avatar
Francesc Guasch committed
21
use Ravada::Auth;
22
use Ravada::Request;
23
use Ravada::VM::Void;
24

Francesc Guasch's avatar
Francesc Guasch committed
25
26
27
28
29
30
31
32
33
our %VALID_VM;

eval {
    require Ravada::VM::KVM and do {
        Ravada::VM::KVM->import;
    };
    $VALID_VM{KVM} = 1;
};

34
35
36
no warnings "experimental::signatures";
use feature qw(signatures);

Francesc Guasch's avatar
Francesc Guasch committed
37
38
39
40
41
42
43
44
45
46
47
48
=head1 NAME

Ravada - Remove Virtual Desktop Manager

=head1 SYNOPSIS

  use Ravada;

  my $ravada = Ravada->new()

=cut

49
50
51
52
53
54
55

our $FILE_CONFIG = "/etc/ravada.conf";

###########################################################################

our $CONNECTOR;
our $CONFIG = {};
56
our $DEBUG;
57
our $CAN_FORK = 1;
58
our $CAN_LXC = 0;
59
60
61
62

# Seconds to wait for other long process
our $SECONDS_WAIT_CHILDREN = 2;
# Limit for long processes
63
our $LIMIT_PROCESS = 2;
64
65
our $LIMIT_HUGE_PROCESS = 1;

66
67
our $DIR_SQL = "sql/mysql";
$DIR_SQL = "/usr/share/doc/ravada/sql/mysql" if ! -e $DIR_SQL;
68

69
# LONG commands take long
70
71
our %HUGE_COMMAND = map { $_ => 1 } qw(download);
our %LONG_COMMAND =  map { $_ => 1 } (qw(prepare_base remove_base screenshot ), keys %HUGE_COMMAND);
72

73
74
75
our $USER_DAEMON;
our $USER_DAEMON_NAME = 'daemon';

76
77
78
79
80
81
82
83
has 'vm' => (
          is => 'ro'
        ,isa => 'ArrayRef'
       ,lazy => 1
     , builder => '_create_vm'
);

has 'connector' => (
84
85
86
87
88
89
        is => 'rw'
);

has 'config' => (
    is => 'ro'
    ,isa => 'Str'
90
91
);

92
93
94
95
96
97
has 'warn_error' => (
    is => 'rw'
    ,isa => 'Bool'
    ,default => sub { 1 }
);

Francesc Guasch's avatar
Francesc Guasch committed
98
99
100
101
102
103
104
=head2 BUILD

Internal constructor

=cut


105
106
sub BUILD {
    my $self = shift;
107
    if ($self->config()) {
108
        _init_config($self->config);
109
    } else {
Francesc Guasch's avatar
Francesc Guasch committed
110
        _init_config($FILE_CONFIG) if -e $FILE_CONFIG;
111
    }
112

Francesc Guasch's avatar
Francesc Guasch committed
113
    if ( $self->connector ) {
joansp's avatar
joansp committed
114
        $CONNECTOR = $self->connector
Francesc Guasch's avatar
Francesc Guasch committed
115
116
    } else {
        $CONNECTOR = $self->_connect_dbh();
117
        $self->connector($CONNECTOR);
Francesc Guasch's avatar
Francesc Guasch committed
118
    }
Francesc Guasch's avatar
Francesc Guasch committed
119
    Ravada::Auth::init($CONFIG);
120

121
    $self->_create_tables();
122
    $self->_upgrade_tables();
Francesc Guasch's avatar
Francesc Guasch committed
123
    $self->_init_user_daemon();
124
125
126
    $self->_update_data();
}

127
128
129
130
131
132
133
134
135
136
137
138
139
140
sub _init_user_daemon {
    my $self = shift;
    return if $USER_DAEMON;

    $USER_DAEMON = Ravada::Auth::SQL->new(name => $USER_DAEMON_NAME);
    if (!$USER_DAEMON->id) {
        $USER_DAEMON = Ravada::Auth::SQL::add_user(
            name => $USER_DAEMON_NAME,
            is_admin => 1
        );
        $USER_DAEMON = Ravada::Auth::SQL->new(name => $USER_DAEMON_NAME);
    }

}
141
142
sub _update_user_grants {
    my $self = shift;
Francesc Guasch's avatar
Francesc Guasch committed
143
    $self->_init_user_daemon();
144
145
146
    my $sth = $CONNECTOR->dbh->prepare("SELECT id FROM users");
    my $id;
    $sth->execute;
Francesc Guasch's avatar
Francesc Guasch committed
147
    $sth->bind_columns(\$id);
148
149
    while ($sth->fetch) {
        my $user = Ravada::Auth::SQL->search_by_id($id);
Francesc Guasch's avatar
Francesc Guasch committed
150
151
        next if $user->name() eq $USER_DAEMON_NAME;

152
153
        $USER_DAEMON->grant_user_permissions($user);
        $USER_DAEMON->grant_admin_permissions($user)    if $user->is_admin;
154
155
156
157
    }
    $sth->finish;
}

158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
sub _update_isos {
    my $self = shift;
    my $table = 'iso_images';
    my $field = 'name';
    my %data = (
        zesty => {
                    name => 'Ubuntu Zesty Zapus'
            ,description => 'Ubuntu 17.04 Zesty Zapus 64 bits'
                   ,arch => 'amd64'
                    ,xml => 'yakkety64-amd64.xml'
             ,xml_volume => 'yakkety64-volume.xml'
                    ,url => 'http://releases.ubuntu.com/17.04/'
                ,file_re => ,'ubuntu-17.04.*desktop-amd64.iso'
                ,md5_url => ,'http://releases.ubuntu.com/17.04/MD5SUMS'
        }
Francesc Guasch's avatar
Francesc Guasch committed
173
174
175
176
177
178
179
180
181
182
183
184
        ,serena64 => {
            name => 'Mint 18.1 Mate 64 bits'
    ,description => 'Mint Serena 18.1 with Mate Desktop based on Ubuntu Xenial 64 bits'
           ,arch => 'amd64'
            ,xml => 'xenial64-amd64.xml'
     ,xml_volume => 'xenial64-volume.xml'
            ,url => 'http://mirrors.evowise.com/linuxmint/stable/18.1/'
        ,file_re => 'linuxmint-18.1-mate-64bit.iso'
        ,md5_url => ''
            ,md5 => 'c5cf5c5d568e2dfeaf705cfa82996d93'

        }
Francesc Guasch's avatar
Francesc Guasch committed
185
186
187
        ,fedora => {
            name => 'Fedora 25'
            ,description => 'RedHat Fedora 25 Workstation 64 bits'
Francesc Guasch's avatar
Francesc Guasch committed
188
            ,url => 'http://ftp.halifax.rwth-aachen.de/fedora/linux/releases/25/Workstation/x86_64/iso/Fedora-Workstation-netinst-x86_64-25-.*\.iso'
Francesc Guasch's avatar
Francesc Guasch committed
189
190
191
192
193
            ,arch => 'amd64'
            ,xml => 'xenial64-amd64.xml'
            ,xml_volume => 'xenial64-volume.xml'
            ,sha256_url => 'http://fedora.mirrors.ovh.net/linux/releases/25/Workstation/x86_64/iso/Fedora-Workstation-25-.*-x86_64-CHECKSUM'
        }
Francesc Guasch's avatar
Francesc Guasch committed
194
195
196
197
198
199
200
201
202
203
204
        ,xubuntu_zesty => {
            name => 'Xubuntu Zesty Zapus'
            ,description => 'Xubuntu 17.04 Zesty Zapus 64 bits'
            ,arch => 'amd64'
            ,xml => 'yakkety64-amd64.xml'
            ,xml_volume => 'yakkety64-volume.xml'
            ,md5 => '6bd80e10bf223a04d3aafe0f997d046b'
            ,url => 'http://archive.ubuntu.com/ubuntu/dists/zesty/main/installer-amd64/current/images/netboot/mini.iso'
        }
        ,xubuntu_xenial => {
            name => 'Xubuntu Xenial Xerus'
205
            ,description => 'Xubuntu 16.04 Xenial Xerus 64 bits (LTS)'
Francesc Guasch's avatar
Francesc Guasch committed
206
207
208
209
210
            ,url => 'http://archive.ubuntu.com/ubuntu/dists/xenial/main/installer-amd64/current/images/netboot/mini.iso'
           ,xml => 'yakkety64-amd64.xml'
            ,xml_volume => 'yakkety64-volume.xml'
            ,md5 => 'fe495d34188a9568c8d166efc5898d22'
        }
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
        ,lubuntu_zesty => {
            name => 'Lubuntu Zesty Zapus'
            ,description => 'Lubuntu 17.04 Zesty Zapus 64 bits'
            ,url => 'http://cdimage.ubuntu.com/lubuntu/releases/17.04/release/lubuntu-17.04-desktop-amd64.iso'
            ,md5_url => 'http://cdimage.ubuntu.com/lubuntu/releases/17.04/release/MD5SUMS'
            ,xml => 'yakkety64-amd64.xml'
            ,xml_volume => 'yakkety64-volume.xml'
        }
        ,lubuntu_xenial => {
            name => 'Lubuntu Xenial Xerus'
            ,description => 'Xubuntu 16.04 Xenial Xerus 64 bits (LTS)'
            ,url => 'http://cdimage.ubuntu.com/lubuntu/releases/16.04.2/release/lubuntu-16.04.2-desktop-amd64.iso'
            ,md5_url => 'http://cdimage.ubuntu.com/lubuntu/releases/16.04.2/release/MD5SUMS'
            ,xml => 'yakkety64-amd64.xml'
            ,xml_volume => 'yakkety64-volume.xml'
        }
227
228
229
230
231
232
233
234
        ,debian_stretch => {
            name =>'Debian Stretch 64 bits XFCE'
            ,description => 'Debian 9.0 Stretch 64 bits'
            ,url => 'https://cdimage.debian.org/debian-cd/current/amd64/iso-cd/debian-9.0.0-amd64-xfce-CD-1.iso'
            ,md5 => '9346436c0cf1862af71cb0a03d9a703c'
            ,xml => 'jessie-amd64.xml'
            ,xml_volume => 'jessie-volume.xml'
        }
235
236
    );

237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
    $self->_update_table($table, $field, \%data);

}

sub _update_domain_drivers_types($self) {

    my $data = {
        image => {
            id => 4,
            ,name => 'image'
           ,description => 'Graphics Options'
           ,vm => 'qemu'
        },
        jpeg => {
            id => 5,
            ,name => 'jpeg'
           ,description => 'Graphics Options'
           ,vm => 'qemu'
        },
        zlib => {
            id => 6,
            ,name => 'zlib'
           ,description => 'Graphics Options'
           ,vm => 'qemu'
        },
        playback => {
            id => 7,
            ,name => 'playback'
           ,description => 'Graphics Options'
           ,vm => 'qemu'

        },
        streaming => {
            id => 8,
            ,name => 'streaming'
           ,description => 'Graphics Options'
           ,vm => 'qemu'

        }
    };
    $self->_update_table('domain_drivers_types','id',$data);
}

280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
sub _update_domain_drivers_options($self) {

    my $data = {
        qxl => {
            id => 1,
            ,id_driver_type => 1,
            ,name => 'QXL'
           ,value => 'type="qxl" ram="65536" vram="65536" vgamem="16384" heads="1" primary="yes"'
        },
        vmvga => {
            id => 2,
            ,id_driver_type => 1,
            ,name => 'VMVGA'
           ,value => 'type="vmvga" vram="16384" heads="1" primary="yes"'
        },
        cirrus => {
            id => 3,
            ,id_driver_type => 1,
            ,name => 'Cirrus'
           ,value => 'type="cirrus" vram="16384" heads="1" primary="yes"'
        },
        vga => {
            id => 4,
            ,id_driver_type => 1,
            ,name => 'VGA'
           ,value => 'type="vga" vram="16384" heads="1" primary="yes"'
        },
        ich6 => {
            id => 6,
            ,id_driver_type => 2,
            ,name => 'ich6'
           ,value => 'model="ich6"'
        },
        ac97 => {
            id => 7,
            ,id_driver_type => 2,
            ,name => 'ac97'
           ,value => 'model="ac97"'
        },
        virtio => {
            id => 8,
            ,id_driver_type => 3,
            ,name => 'virtio'
           ,value => 'type="virtio"'
        },
        e1000 => {
            id => 9,
            ,id_driver_type => 3,
            ,name => 'e1000'
           ,value => 'type="e1000"'
        },
        rtl8139 => {
            id => 10,
            ,id_driver_type => 3,
            ,name => 'rtl8139'
           ,value => 'type="rtl8139"'
        },
        auto_glz => {
            id => 11,
            ,id_driver_type => 4,
            ,name => 'auto_glz'
           ,value => 'compression="auto_glz"'
        },
        auto_lz => {
            id => 12,
            ,id_driver_type => 4,
            ,name => 'auto_lz'
           ,value => 'compression="auto_lz"'
        },
        quic => {
            id => 13,
            ,id_driver_type => 4,
            ,name => 'quic'
           ,value => 'compression="quic"'
        },
        glz => {
            id => 14,
            ,id_driver_type => 4,
            ,name => 'glz'
           ,value => 'compression="glz"'
        },
        lz => {
            id => 15,
            ,id_driver_type => 4,
            ,name => 'lz'
           ,value => 'compression="lz"'
        },
        off => {
            id => 16,
            ,id_driver_type => 4,
            ,name => 'off'
           ,value => 'compression="off"'
        },
        auto => {
            id => 17,
            ,id_driver_type => 5,
            ,name => 'auto'
           ,value => 'compression="auto"'
        },
        never => {
            id => 18,
            ,id_driver_type => 5,
            ,name => 'never'
           ,value => 'compression="never"'
        },
        always => {
            id => 19,
            ,id_driver_type => 5,
            ,name => 'always'
           ,value => 'compression="always"'
        },
        auto1 => {
            id => 20,
            ,id_driver_type => 6,
            ,name => 'auto'
           ,value => 'compression="auto"'
        },
        never1 => {
            id => 21,
            ,id_driver_type => 6,
            ,name => 'never'
           ,value => 'compression="never"'
        },
        always1 => {
            id => 22,
            ,id_driver_type => 6,
            ,name => 'always'
           ,value => 'compression="always"'
        },
        on => {
            id => 23,
            ,id_driver_type => 7,
            ,name => 'on'
           ,value => 'compression="on"'
        },
        off1 => {
            id => 24,
            ,id_driver_type => 7,
            ,name => 'off'
           ,value => 'compression="off"'
        },
        filter => {
            id => 25,
            ,id_driver_type => 8,
            ,name => 'filter'
           ,value => 'mode="filter"'
        },
        all => {
            id => 26,
            ,id_driver_type => 8,
            ,name => 'all'
           ,value => 'mode="all"'
        },
        off2 => {
            id => 27,
            ,id_driver_type => 8,
            ,name => 'off'
           ,value => 'mode="off"'
        }
    };
    $self->_update_table('domain_drivers_options','id',$data);
}

443
444
sub _update_table($self, $table, $field, $data) {

445
    my $sth_search = $CONNECTOR->dbh->prepare("SELECT id FROM $table WHERE $field = ?");
446
447
    for my $name (keys %$data) {
        my $row = $data->{$name};
448
449
450
        $sth_search->execute($row->{$field});
        my ($id) = $sth_search->fetchrow;
        next if $id;
Francesc Guasch's avatar
Francesc Guasch committed
451
        warn("INFO: updating $table : $row->{$field}\n")    if $0 !~ /\.t$/;
452
453

        my $sql =
454
            "INSERT INTO $table "
455
            ."("
456
            .join(" , ", sort keys %{$data->{$name}})
457
458
            .")"
            ." VALUES ( "
459
            .join(" , ", map { "?" } keys %{$data->{$name}})
460
461
462
            ." )"
        ;
        my $sth = $CONNECTOR->dbh->prepare($sql);
463
        $sth->execute(map { $data->{$name}->{$_} } sort keys %{$data->{$name}});
464
465
466
467
468
469
        $sth->finish;
    }
}

sub _update_data {
    my $self = shift;
470

471
    $self->_update_isos();
472
    $self->_update_user_grants();
473
    $self->_update_domain_drivers_types();
474
    $self->_update_domain_drivers_options();
475
476
}

477
478
479
480
481
482
483
484
485
486
sub _upgrade_table {
    my $self = shift;
    my ($table, $field, $definition) = @_;
    my $dbh = $CONNECTOR->dbh;

    my $sth = $dbh->column_info(undef,undef,$table,$field);
    my $row = $sth->fetchrow_hashref;
    $sth->finish;
    return if $row;

Francesc Guasch's avatar
Francesc Guasch committed
487
    warn "INFO: adding $field $definition to $table\n"  if $0 !~ /\.t$/;
488
    $dbh->do("alter table $table add $field $definition");
489
    return 1;
490
491
}

492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
sub _create_table {
    my $self = shift;
    my $table = shift;

    my $sth = $CONNECTOR->dbh->table_info('%',undef,$table,'TABLE');
    my $info = $sth->fetchrow_hashref();
    $sth->finish;
    return if keys %$info;

    warn "INFO: creating table $table\n";
    my $file_sql = "$DIR_SQL/$table.sql";
    open my $in,'<',$file_sql or die "$! $file_sql";
    my $sql = join " ",<$in>;
    close $in;

    $CONNECTOR->dbh->do($sql);
    return 1;
}

sub _insert_data {
    my $self = shift;
    my $table = shift;

    my $file_sql =  "$DIR_SQL/../data/insert_$table.sql";
    return if ! -e $file_sql;

    warn "INFO: inserting data for $table\n";
    open my $in,'<',$file_sql or die "$! $file_sql";
    my $sql = '';
    while (my $line = <$in>) {
        $sql .= $line;
        next if $sql !~ /\w/ || $sql !~ /;\s*$/;
        $CONNECTOR->dbh->do($sql);
        $sql = '';
    }
    close $in;

}

sub _create_tables {
    my $self = shift;
533
534
535
536
#    return if $CONNECTOR->dbh->{Driver}{Name} !~ /mysql/i;

    my $driver = lc($CONNECTOR->dbh->{Driver}{Name});
    $DIR_SQL =~ s{(.*)/.*}{$1/$driver};
537

538
539
540
541
    opendir my $ls,$DIR_SQL or die "$! $DIR_SQL";
    while (my $file = readdir $ls) {
        my ($table) = $file =~ m{(.*)\.sql$};
        next if !$table;
542
        next if $table =~ /^insert/;
543
544
545
546
547
        $self->_insert_data($table)     if $self->_create_table($table);
    }
    closedir $ls;
}

548
549
sub _upgrade_tables {
    my $self = shift;
Francesc Guasch's avatar
Francesc Guasch committed
550
#    return if $CONNECTOR->dbh->{Driver}{Name} !~ /mysql/i;
551

552
    $self->_upgrade_table('file_base_images','target','varchar(64) DEFAULT NULL');
553

554
    $self->_upgrade_table('vms','vm_type',"char(20) NOT NULL DEFAULT 'KVM'");
555
556
    $self->_upgrade_table('vms','connection_args',"text DEFAULT NULL");

557
    $self->_upgrade_table('requests','at_time','int(11) DEFAULT NULL');
Francesc Guasch's avatar
Francesc Guasch committed
558

559
    $self->_upgrade_table('iso_images','md5_url','varchar(255)');
Francesc Guasch's avatar
Francesc Guasch committed
560
561
    $self->_upgrade_table('iso_images','sha256','varchar(255)');
    $self->_upgrade_table('iso_images','sha256_url','varchar(255)');
562
    $self->_upgrade_table('iso_images','file_re','char(64)');
563
    $self->_upgrade_table('iso_images','device','varchar(255)');
564
565

    $self->_upgrade_table('users','language','char(3) DEFAULT NULL');
566
567
568
569
570
571
    if ( $self->_upgrade_table('users','is_external','int(11) DEFAULT 0')) {
        my $sth = $CONNECTOR->dbh->prepare(
            "UPDATE users set is_external=1 WHERE password='*LK* no pss'"
        );
        $sth->execute;
    }
Francesc Guasch's avatar
Francesc Guasch committed
572

573
    $self->_upgrade_table('networks','requires_password','int(11)');
574
575
    $self->_upgrade_table('networks','n_order','int(11) not null default 0');

576
    $self->_upgrade_table('domains','spice_password','varchar(20) DEFAULT NULL');
577
578
}

579

580
581
582
583
sub _connect_dbh {
    my $driver= ($CONFIG->{db}->{driver} or 'mysql');;
    my $db_user = ($CONFIG->{db}->{user} or getpwnam($>));;
    my $db_pass = ($CONFIG->{db}->{password} or undef);
Francesc Guasch's avatar
Francesc Guasch committed
584
    my $db = ( $CONFIG->{db}->{db} or 'ravada' );
585
586
587
588
589
590
591
    my $host = $CONFIG->{db}->{host};

    my $data_source = "DBI:$driver:$db";
    $data_source = "DBI:$driver:database=$db;host=$host"    
        if $host && $host ne 'localhost';

    return DBIx::Connector->new($data_source
592
593
594
595
596
                        ,$db_user,$db_pass,{RaiseError => 1
                        , PrintError=> 0 });

}

597
=head2 display_ip
598

599
Returns the default display IP read from the config file
600

601
=cut
602

603
sub display_ip {
604

605
    my $ip = $CONFIG->{display_ip};
joansp's avatar
joansp committed
606

607
    return $ip if $ip;
608
609
}

610
611
sub _init_config {
    my $file = shift;
612
613

    my $connector = shift;
614
    confess "Deprecated connector" if $connector;
615

616
    $CONFIG = YAML::LoadFile($file);
617
618
619

    $LIMIT_PROCESS = $CONFIG->{limit_process} 
        if $CONFIG->{limit_process} && $CONFIG->{limit_process}>1;
620
#    $CONNECTOR = ( $connector or _connect_dbh());
621
622
}

623
sub _create_vm_kvm {
624
    my $self = shift;
Francesc Guasch's avatar
Francesc Guasch committed
625
    return (undef, "KVM not installed") if !$VALID_VM{KVM};
626

627
628
629
630
    my $cmd_qemu_img = `which qemu-img`;
    chomp $cmd_qemu_img;

    return(undef,"ERROR: Missing qemu-img") if !$cmd_qemu_img;
631
632

    my $vm_kvm;
633

634
635
    eval { $vm_kvm = Ravada::VM::KVM->new( connector => ( $self->connector or $CONNECTOR )) };
    my $err_kvm = $@;
636
637
638
639

    my ($internal_vm , $storage);
    eval {
        $storage = $vm_kvm->dir_img();
640
        $internal_vm = $vm_kvm->vm;
641
642
    };
    $vm_kvm = undef if $@ || !$internal_vm || !$storage;
Francesc Guasch's avatar
Francesc Guasch committed
643
644
    $err_kvm .= ($@ or '');
    return ($vm_kvm,$err_kvm);
645
646
}

647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
=head2 disconnect_vm

Disconnect all the Virtual Managers connections.

=cut


sub disconnect_vm {
    my $self = shift;
    $self->_disconnect_vm();
}

sub _disconnect_vm{
    my $self = shift;
    return $self->_connect_vm(0);
}

sub _connect_vm {
665
    my $self = shift;
666
667
668
669

    my $connect = shift;
    $connect = 1 if !defined $connect;

670
671
    my @vms;
    eval { @vms = $self->vm };
672
    warn $@ if $@ && $self->warn_error;
673
674
675
676
    return if $@ && $@ =~ /No VMs found/i;
    die $@ if $@;

    return if !scalar @vms;
677
678
    for my $n ( 0 .. $#{$self->vm}) {
        my $vm = $self->vm->[$n];
679
680
681

        if (!$connect) {
            $vm->disconnect();
682
683
        } else {
            $vm->connect();
684
        }
685
686
687
    }
}

688
689
690
691
692
693
sub _create_vm {
    my $self = shift;

    my @vms = ();

    my ($vm_kvm, $err_kvm) = $self->_create_vm_kvm();
694
    warn $err_kvm if $err_kvm && $0 !~ /\.t$/;
695

696
697
    my $err = $err_kvm;

698
699
700
    push @vms,($vm_kvm) if $vm_kvm;

    my $vm_lxc;
701
702
703
704
705
706
    if ($CAN_LXC) {
        eval { $vm_lxc = Ravada::VM::LXC->new( connector => ( $self->connector or $CONNECTOR )) };
        push @vms,($vm_lxc) if $vm_lxc;
        my $err_lxc = $@;
        $err .= "\n$err_lxc" if $err_lxc;
    }
707
    if (!@vms) {
708
        warn "No VMs found: $err\n" if $self->warn_error;
709
710
711
    }
    return \@vms;

712
713
}

714
sub _check_vms {
715
716
    my $self = shift;

717
718
    my @vm;
    eval { @vm = @{$self->vm} };
719
720
721
722
723
724
725
726
727
728
    for my $n ( 0 .. $#vm ) {
        if ($vm[$n] && ref $vm[$n] =~ /KVM/i) {
            if (!$vm[$n]->is_alive) {
                warn "$vm[$n] dead" if $DEBUG;
                $vm[$n] = $self->_create_vm_kvm();
            }
        }
    }
}

Francesc Guasch's avatar
Francesc Guasch committed
729
730
731
732
=head2 create_domain

Creates a new domain based on an ISO image or another domain.

joansp's avatar
joansp committed
733
  my $domain = $ravada->create_domain(
Francesc Guasch's avatar
Francesc Guasch committed
734
735
736
737
738
         name => $name
    , id_iso => 1
  );


joansp's avatar
joansp committed
739
  my $domain = $ravada->create_domain(
Francesc Guasch's avatar
Francesc Guasch committed
740
741
742
743
744
745
746
747
         name => $name
    , id_base => 3
  );


=cut


748
sub create_domain {
749
750
    my $self = shift;

751
752
    my %args = @_;

753
754
755
    croak "Argument id_owner required "
        if !$args{id_owner};

756
757
    my $vm_name = $args{vm};
    delete $args{vm};
758

759
    my $request = ( $args{request} or undef);
Francesc Guasch's avatar
Francesc Guasch committed
760

761
    my $vm;
762
763
764
765
    if ($vm_name) {
        $vm = $self->search_vm($vm_name);
        confess "ERROR: vm $vm_name not found"  if !$vm;
    }
766
    $vm = $self->vm->[0]               if !$vm;
767

768
769
    confess "No vm found"   if !$vm;

770
771
    carp "WARNING: no VM defined, we will use ".$vm->name
        if !$vm_name;
Francesc Guasch's avatar
Francesc Guasch committed
772

773
    confess "I can't find any vm ".Dumper($self->vm) if !$vm;
Francesc Guasch's avatar
Francesc Guasch committed
774

775
    return $vm->create_domain(@_);
776
777
}

Francesc Guasch's avatar
Francesc Guasch committed
778
779
780
781
782
783
784
785
=head2 remove_domain

Removes a domain

  $ravada->remove_domain($name);

=cut

786
787
sub remove_domain {
    my $self = shift;
788
789
    my %arg = @_;

790
    confess "Argument name required "
791
792
        if !$arg{name};

793
794
    confess "Argument uid required "
        if !$arg{uid};
795
796
797
798

    lock_hash(%arg);

    my $domain = $self->search_domain($arg{name}, 1)
799
        or die "ERROR: I can't find domain '$arg{name}', maybe already removed.";
800

801
802
    my $user = Ravada::Auth::SQL->search_by_id( $arg{uid});
    $domain->remove( $user);
803
804
}

Francesc Guasch's avatar
Francesc Guasch committed
805
806
807
808
809
810
=head2 search_domain

  my $domain = $ravada->search_domain($name);

=cut

811
812
813
sub search_domain {
    my $self = shift;
    my $name = shift;
814
    my $import = shift;
815

816
817
818
819
820
821
822
823
824
825
826
827
    my $vm = $self->search_vm('Void');
    warn "No Void VM" if !$vm;
    return if !$vm;

    my $domain = $vm->search_domain($name, $import);
    return $domain if $domain;

    my @vms;
    eval { @vms = $self->vm };
    return if $@ && $@ =~ /No VMs found/i;
    die $@ if $@;

828
    for my $vm (@{$self->vm}) {
Francesc Guasch's avatar
Francesc Guasch committed
829
        my $domain = $vm->search_domain($name, $import);
830
        next if !$domain;
831
        next if !$domain->_select_domain_db && !$import;
832
833
834
        my $id;
        eval { $id = $domain->id };
        # TODO import the domain in the database with an _insert_db or something
Francesc Guasch's avatar
Francesc Guasch committed
835
        warn $@ if $@   && $DEBUG;
836
        return $domain if $id || $import;
837
    }
838
839


840
    return;
841
}
842

Francesc Guasch's avatar
Francesc Guasch committed
843
=head2 search_domain_by_id
Francesc Guasch's avatar
Francesc Guasch committed
844

Francesc Guasch's avatar
Francesc Guasch committed
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
  my $domain = $ravada->search_domain_by_id($id);

=cut

sub search_domain_by_id {
    my $self = shift;
    my $id = shift  or confess "ERROR: missing argument id";

    my $sth = $CONNECTOR->dbh->prepare("SELECT name FROM domains WHERE id=?");
    $sth->execute($id);
    my ($name) = $sth->fetchrow;
    confess "Unknown domain id=$id" if !$name;

    return $self->search_domain($name);
}
Francesc Guasch's avatar
Francesc Guasch committed
860

Francesc Guasch's avatar
Francesc Guasch committed
861
862
863
864
865
866
867
868
869
870
=head2 list_vms

List all the Virtual Machine Managers

=cut

sub list_vms($self) {
    return @{$self->vm};
}

871
872
=head2 list_domains

Francesc Guasch's avatar
Francesc Guasch committed
873
List all created domains
874
875
876
877
878
879
880
881

  my @list = $ravada->list_domains();

=cut

sub list_domains {
    my $self = shift;
    my @domains;
Francesc Guasch's avatar
Francesc Guasch committed
882
    for my $vm ($self->list_vms) {
883
884
885
886
887
888
889
        for my $domain ($vm->list_domains) {
            push @domains,($domain);
        }
    }
    return @domains;
}

890
891
892
893
894
895
896
897
898
899
900
901
902
=head2 list_domains_data

List all domains in raw format. Return a list of id => { name , id , is_active , is_base }

   my $list = $ravada->list_domains_data();

   $c->render(json => $list);

=cut

sub list_domains_data {
    my $self = shift;
    my @domains;
903
904
905
906
907
908
    my $sth = $CONNECTOR->dbh->prepare(
        "SELECT * FROM domains ORDER BY name"
    );
    $sth->execute;
    while (my $row = $sth->fetchrow_hashref) {
        push @domains,($row);
909
    }
910
    $sth->finish;
911
    return \@domains;
912
913
}

914
915
916
917
918
919
920
# sub list_domains_data {
#     my $self = shift;
#     my @domains;
#     for my $domain ($self->list_domains()) {
#         eval { $domain->id };
#         warn $@ if $@;
#         next if $@;
joansp's avatar
joansp committed
921
#         push @domains, {                id => $domain->id
922
923
924
#                                     , name => $domain->name
#                                   ,is_base => $domain->is_base
#                                 ,is_active => $domain->is_active
joansp's avatar
joansp committed
925

926
927
928
929
930
#                            }
#     }
#     return \@domains;
# }

931

Francesc Guasch's avatar
Francesc Guasch committed
932
933
934
935
936
937
938
939
940
941
942
943
944
945
=head2 list_bases

List all base domains

  my @list = $ravada->list_domains();


=cut

sub list_bases {
    my $self = shift;
    my @domains;
    for my $vm (@{$self->vm}) {
        for my $domain ($vm->list_domains) {
946
947
948
            eval { $domain->id };
            warn $@ if $@;
            next    if $@;
Francesc Guasch's avatar
Francesc Guasch committed
949
950
951
952
953
954
            push @domains,($domain) if $domain->is_base;
        }
    }
    return @domains;
}

955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
=head2 list_bases_data

List information about the bases

=cut

sub list_bases_data {
    my $self = shift;
    my @data;
    for ($self->list_bases ) {
        push @data,{ id => $_->id , name => $_->name };
    }
    return \@data;
}

Francesc Guasch's avatar
Francesc Guasch committed
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
=head2 list_images

List all ISO images

=cut

sub list_images {
    my $self = shift;
    my @domains;
    my $sth = $CONNECTOR->dbh->prepare(
        "SELECT * FROM iso_images ORDER BY name"
    );
    $sth->execute;
    while (my $row = $sth->fetchrow_hashref) {
        push @domains,($row);
    }
    $sth->finish;
    return @domains;
}

990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
=head2 list_images_data

List information about the images

=cut

sub list_images_data {
    my $self = shift;
    my @data;
    for ($self->list_images ) {
        push @data,{ id => $_->{id} , name => $_->{name} };
    }
    return \@data;
}

Francesc Guasch's avatar
Francesc Guasch committed
1005

1006
1007
1008
=pod

sub _list_images_lxc {
fv3rdugo's avatar
fv3rdugo committed
1009
1010
1011
    my $self = shift;
    my @domains;
    my $sth = $CONNECTOR->dbh->prepare(
1012
        "SELECT * FROM lxc_templates ORDER BY name"
fv3rdugo's avatar
fv3rdugo committed
1013
1014
1015
1016
1017
1018
1019
1020
1021
    );
    $sth->execute;
    while (my $row = $sth->fetchrow_hashref) {
        push @domains,($row);
    }
    $sth->finish;
    return @domains;
}

1022
sub _list_images_data_lxc {
fv3rdugo's avatar
fv3rdugo committed
1023
1024
1025
1026
1027
1028
1029
1030
    my $self = shift;
    my @data;
    for ($self->list_images_lxc ) {
        push @data,{ id => $_->{id} , name => $_->{name} };
    }
    return \@data;
}

1031
=cut
fv3rdugo's avatar
fv3rdugo committed
1032

Francesc Guasch's avatar
Francesc Guasch committed
1033
1034
1035
1036
=head2 remove_volume

  $ravada->remove_volume($file);

Francesc Guasch's avatar
Francesc Guasch committed
1037

Francesc Guasch's avatar
Francesc Guasch committed
1038
1039
=cut

1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
sub remove_volume {
    my $self = shift;

    my $file = shift;
    my ($name) = $file =~ m{.*/(.*)};

    my $removed = 0;
    for my $vm (@{$self->vm}) {
        my $vol = $vm->search_volume($name);
        next if !$vol;

        $vol->delete();
        $removed++;
    }
    if (!$removed && -e $file ) {
        warn "volume $file not found. removing file $file.\n";
        unlink $file or die "$! $file";
    }

}
1060

1061
1062
1063
1064
1065
1066
1067
1068
1069
=head2 clean_killed_requests

Before processing requests, old killed requests must be cleaned.

=cut

sub clean_killed_requests {
    my $self = shift;
    my $sth = $CONNECTOR->dbh->prepare("SELECT id FROM requests "
1070
        ." WHERE status <> 'done' AND STATUS <> 'requested'"
1071
1072
1073
1074
    );
    $sth->execute;
    while (my ($id) = $sth->fetchrow) {
        my $req = Ravada::Request->open($id);
1075
        $req->status("done","Killed ".$req->command." before completion");
1076
1077
1078
1079
    }

}

Francesc Guasch's avatar
Francesc Guasch committed
1080
1081
1082
1083
1084
1085
1086
1087
=head2 process_requests

This is run in the ravada backend. It processes the commands requested by the fronted

  $ravada->process_requests();

=cut

1088
1089
sub process_requests {
    my $self = shift;
1090
    my $debug = shift;
1091
    my $dont_fork = shift;
1092
1093
    my $long_commands = (shift or 0);
    my $short_commands = (shift or 0);
1094

1095
1096
    $self->_wait_pids_nohang();

1097
    my $sth = $CONNECTOR->dbh->prepare("SELECT id,id_domain FROM requests "
1098
1099
1100
        ." WHERE "
        ."    ( status='requested' OR status like 'retry %' OR status='waiting')"
        ."   AND ( at_time IS NULL  OR at_time = 0 OR at_time<=?) "
1101
1102
        ." ORDER BY date_req"
    );
1103
1104
1105
1106
1107
1108
1109
    $sth->execute(time);

    my $debug_type = '';
    $debug_type = 'long' if $long_commands;
    $debug_type = 'short' if $short_commands || !$long_commands;
    $debug_type = 'all' if $long_commands && $short_commands;

1110
1111
    while (my ($id_request,$id_domain)= $sth->fetchrow) {
        my $req = Ravada::Request->open($id_request);
1112
1113
1114
1115
1116
1117
1118
1119
1120

        if ( ($long_commands && 
                (!$short_commands && !$LONG_COMMAND{$req->command}))
            ||(!$long_commands && $LONG_COMMAND{$req->command})
        ) {
            warn "[$debug_type,$long_commands,$short_commands] $$ skipping request "
                .$req->command  if $DEBUG;
            next;
        }
1121
1122
        next if $req->command !~ /shutdown/i
            && $self->_domain_working($id_domain, $id_request);
1123

1124
1125
        warn "[$debug_type] $$ executing request ".$req->id." ".$req->status()." "
            .$req->command
1126
            ." ".Dumper($req->args) if $DEBUG || $debug;
Francesc Guasch's avatar
Francesc Guasch committed
1127
1128
1129

        my ($n_retry) = $req->status() =~ /retry (\d+)/;
        $n_retry = 0 if !$n_retry;
1130
1131
1132
        my $err = $self->_execute($req, $dont_fork);
        $req->error($err)   if $err;
        if ($err && $err =~ /libvirt error code: 38/) {
Francesc Guasch's avatar
Francesc Guasch committed
1133
            if ( $n_retry < 3) {
1134
                warn $req->id." ".$req->command." to retry" if $DEBUG;
joansp's avatar
joansp committed
1135
                $req->status("retry ".++$n_retry)
1136
            }
1137
        }
1138
1139
1140
        next if !$DEBUG && !$debug;

        sleep 1;
1141
        warn "req ".$req->id." , command: ".$req->command." , status: ".$req->status()
1142
            ." , error: '".($req->error or 'NONE')."'\n"  if $DEBUG;
Francesc Guasch's avatar
Francesc Guasch committed
1143

1144
1145
    }
    $sth->finish;
1146
1147
1148

}

Francesc Guasch's avatar
Francesc Guasch committed
1149
=head2 process_long_requests
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160

Process requests that take log time. It will fork on each one

=cut

sub process_long_requests {
    my $self = shift;
    my ($debug,$dont_fork) = @_;

    $self->_disconnect_vm();
    return $self->process_requests($debug, $dont_fork, 1);
1161
1162
}

1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
=head2 process_all_requests

Process all the requests, long and short

=cut

sub process_all_requests {

    my $self = shift;
    my ($debug,$dont_fork) = @_;

    $self->process_requests($debug, $dont_fork,1,1);

1176
1177
}

1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
sub _domain_working {
    my $self = shift;
    my ($id_domain, $id_request) = @_;

    confess "Missing id_request" if !defined$id_request;

    if (!$id_domain) {
        my $req = Ravada::Request->open($id_request);
        $id_domain = $req->defined_arg('id_base');
        if (!$id_domain) {
            my $domain_name = $req->defined_arg('name');
            return if !$domain_name;
            my $domain = $self->search_domain($domain_name) or return;
            $id_domain = $domain->id;
            if (!$id_domain) {
                warn Dumper($req);
                return;
            }
        }
    }
    my $sth = $CONNECTOR->dbh->prepare("SELECT id, status FROM requests "
        ." WHERE id <> ? AND id_domain=? AND (status <> 'requested' AND status <> 'done')");
    $sth->execute($id_request, $id_domain);
    my ($id, $status) = $sth->fetchrow;
#    warn "CHECKING DOMAIN WORKING "
#        ."[$id_request] id_domain $id_domain working in request ".($id or '<NULL>')
#            ." status: ".($status or '<UNDEF>');
    return $id;
}

1208
1209
1210
1211
1212
1213
1214
sub _process_all_requests_dont_fork {
    my $self = shift;
    my $debug = shift;

    return $self->process_requests($debug,1, 1, 1);
}

1215
1216
sub _process_requests_dont_fork {
    my $self = shift;
1217
    my $debug = shift;
1218
    return $self->process_requests($debug, 1);
1219
}
Francesc Guasch's avatar
Francesc Guasch committed
1220

1221
1222
1223
1224
1225
1226
1227
1228
=head2 list_vm_types

Returnsa list ofthe types of Virtual Machines available on this system

=cut

sub list_vm_types {
    my $self = shift;
joansp's avatar
joansp committed
1229

1230
1231
1232
1233
1234
    my %type;
    for my $vm (@{$self->vm}) {
            my ($name) = ref($vm) =~ /.*::(.*)/;
            $type{$name}++;
    }
1235
    return keys %type;
1236
1237
}

1238
1239
1240
sub _execute {
    my $self = shift;
    my $request = shift;
1241
    my $dont_fork = shift;
1242

Francesc Guasch's avatar
Francesc Guasch committed
1243
1244
    my $sub = $self->_req_method($request->command);

1245
1246
    confess "Unknown command ".$request->command
            if !$sub;
Francesc Guasch's avatar
Francesc Guasch committed
1247

1248
    if ($dont_fork || !$CAN_FORK || !$LONG_COMMAND{$request->command}) {
Francesc Guasch's avatar
Francesc Guasch committed
1249

1250
1251
1252
        eval { $sub->($self,$request) };
        my $err = ($@ or '');
        $request->error($err);
1253
        $request->status('done') if $request->status() ne 'done';
1254
1255
        return $err;
    }
Francesc Guasch's avatar
Francesc Guasch committed
1256

1257
1258
1259
    $self->_wait_pids_nohang();
    return if $self->_wait_children($request);

1260
    $request->status('working');
1261
1262
    my $pid = fork();
    die "I can't fork" if !defined $pid;
1263
1264
1265
1266
1267
    if ( $pid == 0 ) {
        $self->_do_execute_command($sub, $request) 
    } else {
        $self->_add_pid($pid, $request->id);
    }
1268
#    $self->_connect_vm_kvm();
1269
    return '';
Francesc Guasch's avatar
Francesc Guasch committed
1270
1271
}

1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
sub _do_execute_command {
    my $self = shift;
    my ($sub, $request) = @_;

#    if ($DEBUG ) {
#        mkdir 'log' if ! -e 'log';
#        open my $f_out ,'>', "log/fork_$$.out";
#        open my $f_err ,'>', "log/fork_$$.err";
#        $| = 1;
#        local *STDOUT = $f_out;
#        local *STDERR = $f_err;
#    }

    eval {
        $self->_connect_vm();
        $sub->($self,$request);
        $self->_disconnect_vm();
    };
    my $err = ( $@ or '');
    $request->error($err);
    $request->status('done') if $request->status() ne 'done';
    exit;

}

1297
1298
1299
1300
1301
1302
1303
sub _cmd_domdisplay {
    my $self = shift;
    my $request = shift;

    my $name = $request->args('name');
    confess "Unknown name for request ".Dumper($request)  if!$name;
    my $domain = $self->search_domain($request->args->{name});
1304
    my $user = Ravada::Auth::SQL->search_by_id( $request->args->{uid});
1305
    $request->error('');
1306
    my $display = $domain->display($user);
1307
1308
    $request->result({display => $display});

1309
1310
}

1311
1312
1313
1314
1315
1316
sub _cmd_screenshot {
    my $self = shift;
    my $request = shift;

    my $id_domain = $request->args('id_domain');
    my $domain = $self->search_domain_by_id($id_domain);
1317
    my $bytes = 0;
1318
    if (!$domain->can_screenshot) {
1319
        die "I can't take a screenshot of the domain ".$domain->name;
1320
    } else {
1321
1322
        $bytes = $domain->screenshot($request->args('filename'));
        $bytes = $domain->screenshot($request->args('filename'))    if !$bytes;
1323
    }