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

use warnings;
use strict;

6
our $VERSION = '0.2.3';
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
use Ravada::Auth;
19
use Ravada::Request;
20
use Ravada::VM::KVM;
21
use Ravada::VM::Void;
22

Francesc Guasch's avatar
Francesc Guasch committed
23
24
25
26
27
28
29
30
31
32
33
34
=head1 NAME

Ravada - Remove Virtual Desktop Manager

=head1 SYNOPSIS

  use Ravada;

  my $ravada = Ravada->new()

=cut

35
36
37
38
39
40
41

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

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

our $CONNECTOR;
our $CONFIG = {};
42
our $DEBUG;
43
our $CAN_FORK = 1;
44
our $CAN_LXC = 0;
45
our $LIMIT_PROCESS = 2;
46
47
our $DIR_SQL = "sql/mysql";
$DIR_SQL = "/usr/share/doc/ravada/sql/mysql" if ! -e $DIR_SQL;
48

49
# LONG commands take long
Francesc Guasch's avatar
Francesc Guasch committed
50
our %LONG_COMMAND =  map { $_ => 1 } qw(prepare_base remove_base screenshot);
51
52
53
54
55
56
57
58
59

has 'vm' => (
          is => 'ro'
        ,isa => 'ArrayRef'
       ,lazy => 1
     , builder => '_create_vm'
);

has 'connector' => (
60
61
62
63
64
65
        is => 'rw'
);

has 'config' => (
    is => 'ro'
    ,isa => 'Str'
66
67
);

Francesc Guasch's avatar
Francesc Guasch committed
68
69
70
71
72
73
74
=head2 BUILD

Internal constructor

=cut


75
76
sub BUILD {
    my $self = shift;
77
    if ($self->config()) {
78
        _init_config($self->config);
79
    } else {
Francesc Guasch's avatar
Francesc Guasch committed
80
        _init_config($FILE_CONFIG) if -e $FILE_CONFIG;
81
    }
82

Francesc Guasch's avatar
Francesc Guasch committed
83
    if ( $self->connector ) {
joansp's avatar
joansp committed
84
        $CONNECTOR = $self->connector
Francesc Guasch's avatar
Francesc Guasch committed
85
86
    } else {
        $CONNECTOR = $self->_connect_dbh();
87
        $self->connector($CONNECTOR);
Francesc Guasch's avatar
Francesc Guasch committed
88
    }
Francesc Guasch's avatar
Francesc Guasch committed
89
    Ravada::Auth::init($CONFIG);
90
    $self->_create_tables();
91
    $self->_upgrade_tables();
92
93
}

94
95
96
97
98
99
100
101
102
103
104
105
106
107
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;

    warn "INFO: adding $field $definition to $table\n";
    $dbh->do("alter table $table add $field $definition");
}

108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
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;
149
150
    return if $CONNECTOR->dbh->{Driver}{Name} !~ /mysql/i;

151
152
153
154
155
156
157
158
159
    opendir my $ls,$DIR_SQL or die "$! $DIR_SQL";
    while (my $file = readdir $ls) {
        my ($table) = $file =~ m{(.*)\.sql$};
        next if !$table;
        $self->_insert_data($table)     if $self->_create_table($table);
    }
    closedir $ls;
}

160
161
sub _upgrade_tables {
    my $self = shift;
162
163
    return if $CONNECTOR->dbh->{Driver}{Name} !~ /mysql/i;

164
    $self->_upgrade_table('file_base_images','target','varchar(64) DEFAULT NULL');
165
166
    $self->_upgrade_table('vms','vm_type',"char(20) NOT NULL DEFAULT 'KVM'");
    $self->_upgrade_table('requests','at_time','int(11) DEFAULT NULL');
167
168
    $self->_upgrade_table('iso_images','md5_url','varchar(255)');
    $self->_upgrade_table('iso_images','file_re','char(64)');
169
170
171
}


172
173
174
175
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
176
177
    my $db = ( $CONFIG->{db}->{db} or 'ravada' );
    return DBIx::Connector->new("DBI:$driver:$db"
178
179
180
181
182
                        ,$db_user,$db_pass,{RaiseError => 1
                        , PrintError=> 0 });

}

183
=head2 display_ip
184

185
Returns the default display IP read from the config file
186

187
=cut
188

189
sub display_ip {
190

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

193
    return $ip if $ip;
194
195
}

196
197
sub _init_config {
    my $file = shift;
198
199

    my $connector = shift;
200
    confess "Deprecated connector" if $connector;
201

202
    $CONFIG = YAML::LoadFile($file);
203
204
205

    $LIMIT_PROCESS = $CONFIG->{limit_process} 
        if $CONFIG->{limit_process} && $CONFIG->{limit_process}>1;
206
#    $CONNECTOR = ( $connector or _connect_dbh());
207
208
}

209
sub _create_vm_kvm {
210
    my $self = shift;
211

212
213
214
215
    my $cmd_qemu_img = `which qemu-img`;
    chomp $cmd_qemu_img;

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

    my $vm_kvm;
218

219
220
    eval { $vm_kvm = Ravada::VM::KVM->new( connector => ( $self->connector or $CONNECTOR )) };
    my $err_kvm = $@;
221
222
223
224

    my ($internal_vm , $storage);
    eval {
        $storage = $vm_kvm->dir_img();
225
        $internal_vm = $vm_kvm->vm;
226
227
    };
    $vm_kvm = undef if $@ || !$internal_vm || !$storage;
Francesc Guasch's avatar
Francesc Guasch committed
228
229
    $err_kvm .= ($@ or '');
    return ($vm_kvm,$err_kvm);
230
231
}

232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
=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 {
250
    my $self = shift;
251
252
253
254

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

255
256
    my @vms;
    eval { @vms = $self->vm };
257
    warn $@ if $@;
258
259
260
261
    return if $@ && $@ =~ /No VMs found/i;
    die $@ if $@;

    return if !scalar @vms;
262
263
    for my $n ( 0 .. $#{$self->vm}) {
        my $vm = $self->vm->[$n];
264
265
266

        if (!$connect) {
            $vm->disconnect();
267
268
        } else {
            $vm->connect();
269
        }
270
271
272
    }
}

273
274
275
276
277
278
sub _create_vm {
    my $self = shift;

    my @vms = ();

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

281
282
    my $err = $err_kvm;

283
284
285
    push @vms,($vm_kvm) if $vm_kvm;

    my $vm_lxc;
286
287
288
289
290
291
    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;
    }
292
    if (!@vms) {
293
        warn "No VMs found: $err\n";
294
295
296
    }
    return \@vms;

297
298
}

299
sub _check_vms {
300
301
    my $self = shift;

302
303
    my @vm;
    eval { @vm = @{$self->vm} };
304
305
306
307
308
309
310
311
312
313
    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
314
315
316
317
=head2 create_domain

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

joansp's avatar
joansp committed
318
  my $domain = $ravada->create_domain(
Francesc Guasch's avatar
Francesc Guasch committed
319
320
321
322
323
         name => $name
    , id_iso => 1
  );


joansp's avatar
joansp committed
324
  my $domain = $ravada->create_domain(
Francesc Guasch's avatar
Francesc Guasch committed
325
326
327
328
329
330
331
332
         name => $name
    , id_base => 3
  );


=cut


333
sub create_domain {
334
335
    my $self = shift;

336
337
    my %args = @_;

338
339
340
    croak "Argument id_owner required "
        if !$args{id_owner};

341
342
    my $vm_name = $args{vm};
    delete $args{vm};
343

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

346
    my $vm;
347
348
349
350
    if ($vm_name) {
        $vm = $self->search_vm($vm_name);
        confess "ERROR: vm $vm_name not found"  if !$vm;
    }
351
    $vm = $self->vm->[0]               if !$vm;
352

353
354
    confess "No vm found"   if !$vm;

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

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

360
    return $vm->create_domain(@_);
361
362
}

Francesc Guasch's avatar
Francesc Guasch committed
363
364
365
366
367
368
369
370
=head2 remove_domain

Removes a domain

  $ravada->remove_domain($name);

=cut

371
372
sub remove_domain {
    my $self = shift;
373
374
    my %arg = @_;

375
    confess "Argument name required "
376
377
        if !$arg{name};

378
379
    confess "Argument uid required "
        if !$arg{uid};
380
381
382
383

    lock_hash(%arg);

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

386
387
    my $user = Ravada::Auth::SQL->search_by_id( $arg{uid});
    $domain->remove( $user);
388
389
}

Francesc Guasch's avatar
Francesc Guasch committed
390
391
392
393
394
395
=head2 search_domain

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

=cut

396
397
398
sub search_domain {
    my $self = shift;
    my $name = shift;
399
    my $import = shift;
400

401
402
403
404
405
406
407
408
409
410
411
412
    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 $@;

413
    for my $vm (@{$self->vm}) {
Francesc Guasch's avatar
Francesc Guasch committed
414
        my $domain = $vm->search_domain($name, $import);
415
        next if !$domain;
416
        next if !$domain->_select_domain_db && !$import;
417
418
419
        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
420
        warn $@ if $@   && $DEBUG;
421
        return $domain if $id || $import;
422
    }
423
424


425
    return;
426
}
427

Francesc Guasch's avatar
Francesc Guasch committed
428
=head2 search_domain_by_id
Francesc Guasch's avatar
Francesc Guasch committed
429

Francesc Guasch's avatar
Francesc Guasch committed
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
  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
445

446
447
=head2 list_domains

Francesc Guasch's avatar
Francesc Guasch committed
448
List all created domains
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464

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

=cut

sub list_domains {
    my $self = shift;
    my @domains;
    for my $vm (@{$self->vm}) {
        for my $domain ($vm->list_domains) {
            push @domains,($domain);
        }
    }
    return @domains;
}

465
466
467
468
469
470
471
472
473
474
475
476
477
=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;
478
479
480
481
482
483
    my $sth = $CONNECTOR->dbh->prepare(
        "SELECT * FROM domains ORDER BY name"
    );
    $sth->execute;
    while (my $row = $sth->fetchrow_hashref) {
        push @domains,($row);
484
    }
485
    $sth->finish;
486
    return \@domains;
487
488
}

489
490
491
492
493
494
495
# 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
496
#         push @domains, {                id => $domain->id
497
498
499
#                                     , name => $domain->name
#                                   ,is_base => $domain->is_base
#                                 ,is_active => $domain->is_active
joansp's avatar
joansp committed
500

501
502
503
504
505
#                            }
#     }
#     return \@domains;
# }

506

Francesc Guasch's avatar
Francesc Guasch committed
507
508
509
510
511
512
513
514
515
516
517
518
519
520
=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) {
521
522
523
            eval { $domain->id };
            warn $@ if $@;
            next    if $@;
Francesc Guasch's avatar
Francesc Guasch committed
524
525
526
527
528
529
            push @domains,($domain) if $domain->is_base;
        }
    }
    return @domains;
}

530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
=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
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
=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;
}

565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
=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
580

581
582
583
=pod

sub _list_images_lxc {
fv3rdugo's avatar
fv3rdugo committed
584
585
586
    my $self = shift;
    my @domains;
    my $sth = $CONNECTOR->dbh->prepare(
587
        "SELECT * FROM lxc_templates ORDER BY name"
fv3rdugo's avatar
fv3rdugo committed
588
589
590
591
592
593
594
595
596
    );
    $sth->execute;
    while (my $row = $sth->fetchrow_hashref) {
        push @domains,($row);
    }
    $sth->finish;
    return @domains;
}

597
sub _list_images_data_lxc {
fv3rdugo's avatar
fv3rdugo committed
598
599
600
601
602
603
604
605
    my $self = shift;
    my @data;
    for ($self->list_images_lxc ) {
        push @data,{ id => $_->{id} , name => $_->{name} };
    }
    return \@data;
}

606
=cut
fv3rdugo's avatar
fv3rdugo committed
607

Francesc Guasch's avatar
Francesc Guasch committed
608
609
610
611
=head2 remove_volume

  $ravada->remove_volume($file);

Francesc Guasch's avatar
Francesc Guasch committed
612

Francesc Guasch's avatar
Francesc Guasch committed
613
614
=cut

615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
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";
    }

}
635

636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
=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 "
        ." WHERE status='working' "
    );
    $sth->execute;
    while (my ($id) = $sth->fetchrow) {
        my $req = Ravada::Request->open($id);
        $req->status("done","Killed before completion");
    }

}

Francesc Guasch's avatar
Francesc Guasch committed
655
656
657
658
659
660
661
662
=head2 process_requests

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

  $ravada->process_requests();

=cut

663
664
sub process_requests {
    my $self = shift;
665
    my $debug = shift;
666
    my $dont_fork = shift;
667
668
    my $long_commands = (shift or 0);
    my $short_commands = (shift or 0);
669

670
671
    $self->_wait_pids_nohang();

672
    my $sth = $CONNECTOR->dbh->prepare("SELECT id,id_domain FROM requests "
673
674
675
        ." WHERE "
        ."    ( status='requested' OR status like 'retry %' OR status='waiting')"
        ."   AND ( at_time IS NULL  OR at_time = 0 OR at_time<=?) "
676
677
        ." ORDER BY date_req"
    );
678
679
680
681
682
683
684
    $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;

685
686
    while (my ($id_request,$id_domain)= $sth->fetchrow) {
        my $req = Ravada::Request->open($id_request);
687
688
689
690
691
692
693
694
695

        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;
        }
696
697
        next if $req->command !~ /shutdown/i
            && $self->_domain_working($id_domain, $id_request);
698

699
700
        warn "[$debug_type] $$ executing request ".$req->id." ".$req->status()." "
            .$req->command
701
            ." ".Dumper($req->args) if $DEBUG || $debug;
Francesc Guasch's avatar
Francesc Guasch committed
702
703
704

        my ($n_retry) = $req->status() =~ /retry (\d+)/;
        $n_retry = 0 if !$n_retry;
705
706
707
        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
708
            if ( $n_retry < 3) {
709
                warn $req->id." ".$req->command." to retry" if $DEBUG;
joansp's avatar
joansp committed
710
                $req->status("retry ".++$n_retry)
711
            }
712
        }
713
714
715
        next if !$DEBUG && !$debug;

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

719
720
    }
    $sth->finish;
721
722
723

}

Francesc Guasch's avatar
Francesc Guasch committed
724
=head2 process_long_requests
725
726
727
728
729
730
731
732
733
734
735

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);
736
737
}

738
739
740
741
742
743
744
745
746
747
748
749
750
=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);

751
752
}

753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
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;
}

783
784
785
786
787
788
789
sub _process_all_requests_dont_fork {
    my $self = shift;
    my $debug = shift;

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

790
791
sub _process_requests_dont_fork {
    my $self = shift;
792
    my $debug = shift;
793
    return $self->process_requests($debug, 1);
794
}
Francesc Guasch's avatar
Francesc Guasch committed
795

796
797
798
799
800
801
802
803
=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
804

805
806
807
808
809
    my %type;
    for my $vm (@{$self->vm}) {
            my ($name) = ref($vm) =~ /.*::(.*)/;
            $type{$name}++;
    }
810
    return keys %type;
811
812
}

813
814
815
sub _execute {
    my $self = shift;
    my $request = shift;
816
    my $dont_fork = shift;
817

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

820
821
    confess "Unknown command ".$request->command
            if !$sub;
Francesc Guasch's avatar
Francesc Guasch committed
822

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

825
826
827
        eval { $sub->($self,$request) };
        my $err = ($@ or '');
        $request->error($err);
828
        $request->status('done') if $request->status() ne 'done';
829
830
        return $err;
    }
Francesc Guasch's avatar
Francesc Guasch committed
831

832
833
834
    $self->_wait_pids_nohang();
    return if $self->_wait_children($request);

835
    $request->status('working');
836
837
    my $pid = fork();
    die "I can't fork" if !defined $pid;
838
    $self->_do_execute_command($sub, $request) if $pid == 0;
839
    $self->_add_pid($pid, $request->id);
840
#    $self->_connect_vm_kvm();
841
    return '';
Francesc Guasch's avatar
Francesc Guasch committed
842
843
}

844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
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;

}

869
870
871
872
873
874
875
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});
876
    my $user = Ravada::Auth::SQL->search_by_id( $request->args->{uid});
877
    $request->error('');
878
    my $display = $domain->display($user);
879
880
    $request->result({display => $display});

881
882
}

883
884
885
886
887
888
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);
889
    my $bytes = 0;
890
    if (!$domain->can_screenshot) {
891
        die "I can't take a screenshot of the domain ".$domain->name;
892
    } else {
893
894
        $bytes = $domain->screenshot($request->args('filename'));
        $bytes = $domain->screenshot($request->args('filename'))    if !$bytes;
895
    }
896
    $request->error("No data received") if !$bytes;
897
898
899
}


900
sub _cmd_create{
Francesc Guasch's avatar
Francesc Guasch committed
901
902
903
    my $self = shift;
    my $request = shift;

904
    $request->status('creating domain');
905
    warn "$$ creating domain"   if $DEBUG;
906
    my $domain;
907

908
    $domain = $self->create_domain(%{$request->args},request => $request);
909

910
    my $msg = '';
911

912
    if ($domain) {
913
       $msg = 'Domain '
914
915
            ."<a href=\"/machine/view/".$domain->id.".html\">"
            .$request->args('name')."</a>"
Francesc Guasch's avatar
Francesc Guasch committed
916
            ." created."
917
918
919
920
        ;
    }

    $request->status('done',$msg);
Francesc Guasch's avatar
Francesc Guasch committed
921
922
923

}

924
925
926
927
928
sub _wait_children {
    my $self = shift;
    my $req = shift or confess "Missing request";

    my $try = 0;
929
    for ( 1 .. 10 ) {
930
931
932
933
        my $n_pids = scalar keys %{$self->{pids}};
        my $msg = $req->id." ".$req->command." waiting for processes to finish $n_pids of $LIMIT_PROCESS running";
        warn $msg if $DEBUG;

934
        return if $n_pids < $LIMIT_PROCESS;
935
936
937
938

        $self->_wait_pids_nohang();
        sleep 1;

939
940
941
        next if $try++;

        $req->error($msg);
942
        $req->status('waiting') if $req->status() !~ 'waiting';
943
    }
944
    return scalar keys %{$self->{pids}};
945
946
}

947
948
949
950
sub _wait_pids_nohang {
    my $self = shift;
    return if !keys %{$self->{pids}};

Francesc Guasch's avatar
Francesc Guasch committed
951
952
953
954
955
956
    for my $pid ( keys %{$self->{pids}}) {
        my $kid = waitpid($pid , WNOHANG);
        next if !$kid || $kid == -1;
        $self->_set_req_done($kid);
        delete $self->{pids}->{$kid};
    }
957
958
959
960
961
962
963
964
965
966
967
968

}

sub _set_req_done {
    my $self = shift;
    my $pid = shift;

    my $id_request = $self->{pids}->{$pid};
    return if !$id_request;

    my $req = Ravada::Request->open($id_request);
    $req->status('done')    if $req->status =~ /working/i;
969
970
}

Francesc Guasch's avatar
Francesc Guasch committed
971
972
973
974
sub _wait_pids {
    my $self = shift;
    my $request = shift;

975
976
    $request->status('waiting for other tasks')
        if $request && $request->status !~ /waiting/i;
Francesc Guasch's avatar
Francesc Guasch committed
977

Francesc Guasch's avatar
Francesc Guasch committed
978
    for my $pid ( keys %{$self->{pids}}) {
979
980
        $request->status("waiting for pid $pid")
            if $request && $request->status !~ /waiting/i;
981
982

#        warn "Checking for pid '$pid' created at ".localtime($self->{pids}->{$pid});
Francesc Guasch's avatar
Francesc Guasch committed
983
        my $kid = waitpid($pid,0);
984
#        warn "Found $kid";
985
986
987
        $self->_set_req_done($pid);

        delete $self->{pids}->{$kid};
Francesc Guasch's avatar
Francesc Guasch committed
988
989
990
991
992
993
994
        return if $kid  == $pid;
    }
}

sub _add_pid {
    my $self = shift;
    my $pid = shift;
995
    my $id_req = shift;
Francesc Guasch's avatar
Francesc Guasch committed
996

997
    $self->{pids}->{$pid} = $id_req;
Francesc Guasch's avatar
Francesc Guasch committed
998
999
}

1000
sub _cmd_remove {
Francesc Guasch's avatar
Francesc Guasch committed
1001
1002
1003
    my $self = shift;
    my $request = shift;

1004
1005
1006
1007
    confess "Unknown user id ".$request->args->{uid}
        if !defined $request->args->{uid};

    $self->remove_domain(name => $request->args('name'), uid => $request->args('uid'));
Francesc Guasch's avatar
Francesc Guasch committed
1008

1009
}
Francesc Guasch's avatar
Francesc Guasch committed
1010

1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
sub _cmd_pause {
    my $self = shift;
    my $request = shift;

    my $name = $request->args('name');
    my $domain = $self->search_domain($name);
    die "Unknown domain '$name'" if !$domain;

    my $uid = $request->args('uid');
    my $user = Ravada::Auth::SQL->search_by_id($uid);

    $domain->pause($user);

    $request->status('done');

}

sub _cmd_resume {
    my $self = shift;
    my $request = shift;

    my $name = $request->args('name');
    my $domain = $self->search_domain($name);
    die "Unknown domain '$name'" if !$domain;

    my $uid = $request->args('uid');
    my $user = Ravada::Auth::SQL->search_by_id($uid);

1039
1040
    $domain->resume(
        remote_ip => $request->args('remote_ip')
1041
        ,user => $user
1042
    );
1043
1044
1045
1046
1047
1048

    $request->status('done');

}


1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
sub _cmd_open_iptables {
    my $self = shift;
    my $request = shift;

    my $uid = $request->args('uid');
    my $user = Ravada::Auth::SQL->search_by_id($uid);

    my $domain = $self->search_domain_by_id($request->args('id_domain'));
    die "Unknown domain" if !$domain;

    $domain->open_iptables(
        remote_ip => $request->args('remote_ip')
        ,uid => $user->id
    );
}

Francesc Guasch's avatar
Francesc Guasch committed
1065
1066
1067
1068
1069
sub _cmd_start {
    my $self = shift;
    my $request = shift;

    my $name = $request->args('name');
1070

1071
1072
    my $domain = $self->search_domain($name);
    die "Unknown domain '$name'" if !$domain;
1073
1074
1075
1076

    my $uid = $request->args('uid');
    my $user = Ravada::Auth::SQL->search_by_id($uid);

1077
    $domain->start(user => $user, remote_ip => $request->args('remote_ip'));
1078
1079
1080
    my $msg = 'Domain '
            ."<a href=\"/machine/view/".$domain->id.".html\">"
            .$request->args('name')."</a>"
Francesc Guasch's avatar
Francesc Guasch committed
1081
            ." started"
1082
1083
        ;
    $request->status('done', $msg);
Francesc Guasch's avatar
Francesc Guasch committed
1084
1085
1086

}

Francesc Guasch's avatar
Francesc Guasch committed
1087
1088
1089
1090
sub _cmd_prepare_base {
    my $self = shift;
    my $request = shift;

Francesc Guasch's avatar
Francesc Guasch committed
1091
    my $id_domain = $request->id_domain   or confess "Missing request id_domain";
1092
1093
1094
1095
    my $uid = $request->args('uid')     or confess "Missing argument uid";

    my $user = Ravada::Auth::SQL->search_by_id( $uid);

Francesc Guasch's avatar
Francesc Guasch committed
1096
    my $domain = $self->search_domain_by_id($id_domain);
1097

Francesc Guasch's avatar
Francesc Guasch committed
1098
    die "Unknown domain id '$id_domain'\n" if !$domain;
1099
1100

    $domain->prepare_base($user);
Francesc Guasch's avatar
Francesc Guasch committed
1101
1102
1103

}

1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
sub _cmd_remove_base {
    my $self = shift;
    my $request = shift;

    my $id_domain = $request->id_domain or confess "Missing request id_domain";
    my $uid = $request->args('uid')     or confess "Missing argument uid";

    my $user = Ravada::Auth::SQL->search_by_id( $uid);

    my $domain = $self->search_domain_by_id($id_domain);

    die "Unknown domain id '$id_domain'\n" if !$domain;

1117
1118
    $domain->_vm->disconnect();
    $self->_disconnect_vm();
1119
1120
1121
1122
1123
    $domain->remove_base($user);

}


1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
sub _cmd_hybernate {
    my $self = shift;
    my $request = shift;

    my $uid = $request->args('uid') or confess "Missing argument uid";
    my $id_domain = $request->id_domain or confess "Missing request id_domain";

    my $user = Ravada::Auth::SQL->search_by_id( $uid);
    my $domain = $self->search_domain_by_id($id_domain);

    die "Unknown domain id '$id_domain'\n" if !$domain;

    $domain->hybernate($user);

}

1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
sub _cmd_download {
    my $self = shift;
    my $request = shift;

    my $id_iso = $request->args('uid') or confess "Missing argument uid";

    # Ravada::KVM_search_iso

}

Francesc Guasch's avatar
Francesc Guasch committed
1150
1151
1152
1153
sub _cmd_shutdown {
    my $self = shift;
    my $request = shift;

1154
    my $uid = $request->args('uid');
Francesc Guasch's avatar
Francesc Guasch committed
1155
    my $name = $request->args('name');
1156
    my $timeout = ($request->args('timeout') or 60);
1157

1158
    my $domain;
1159
1160
1161
    $domain = $self->search_domain($name);
    die "Unknown domain '$name'\n" if !$domain;

1162
1163
    my $user = Ravada::Auth::SQL->search_by_id( $uid);

1164
1165
    $domain->shutdown(timeout => $timeout, name => $name, user => $user
                    , request => $request);
Francesc Guasch's avatar
Francesc Guasch committed
1166
1167
1168

}

1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
sub _cmd_force_shutdown {
    my $self = shift;
    my $request = shift;

    my $uid = $request->args('uid');
    my $name = $request->args('name');

    my $domain;
    $domain = $self->search_domain($name);
    die "Unknown domain '$name'\n" if !$domain;

    my $user = Ravada::Auth::SQL->search_by_id( $uid);

    $domain->force_shutdown($user,$request);

}

1186
1187
1188
1189
sub _cmd_list_vm_types {
    my $self = shift;
    my $request = shift;
    my @list_types = $self->list_vm_types();
Francesc Guasch's avatar
Francesc Guasch committed
1190
    $request->result(\@list_types);
1191
1192
    $request->status('done');
}
Francesc Guasch's avatar
Francesc Guasch committed
1193

1194
1195
1196
1197
1198
1199
1200
sub _cmd_ping_backend {
    my $self = shift;
    my $request = shift;

    $request->status('done');
    return 1;
}
Francesc Guasch's avatar
Francesc Guasch committed
1201

1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
sub _cmd_rename_domain {
    my $self = shift;
    my $request = shift;

    my $uid = $request->args('uid');
    my $name = $request->args('name');
    my $id_domain = $request->args('id_domain') or die "ERROR: Missing id_domain";

    my $user = Ravada::Auth::SQL->search_by_id($uid);
    my $domain = $self->search_domain_by_id($id_domain);

    confess "Unkown domain ".Dumper($request)   if !$domain;

    $domain->rename(user => $user, name => $name);

}

Francesc Guasch's avatar
Francesc Guasch committed
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
sub _cmd_set_driver {
    my $self = shift;
    my $request = shift;

    my $uid = $request->args('uid');
    my $id_domain = $request->args('id_domain') or die "ERROR: Missing id_domain";

    my $user = Ravada::Auth::SQL->search_by_id($uid);
    my $domain = $self->search_domain_by_id($id_domain);

    confess "Unkown domain ".Dumper($request)   if !$domain;

    die "USER $uid not authorized to set driver for domain ".$domain->name
        if $domain->id_owner != $user->id && !$user->is_admin;

    $domain->set_driver_id($request->args('id_option'));
}

Francesc Guasch's avatar
Francesc Guasch committed
1237
1238
1239
1240
1241
sub _req_method {
    my $self = shift;
    my  $cmd = shift;

    my %methods = (
Francesc Guasch's avatar
Francesc Guasch committed
1242

Francesc Guasch's avatar