Code

b2dff82b4bb49d06a5e8171260ef6cd6aef5e527
[gosa.git] / gosa-si / gosa-si-server
1 #!/usr/bin/perl
2 #===============================================================================
3 #
4 #         FILE:  gosa-sd
5 #
6 #        USAGE:  ./gosa-sd
7 #
8 #  DESCRIPTION:
9 #
10 #      OPTIONS:  ---
11 # REQUIREMENTS:  libconfig-inifiles-perl libcrypt-rijndael-perl libxml-simple-perl 
12 #                libdata-dumper-simple-perl libdbd-sqlite3-perl libnet-ldap-perl
13 #                libpoe-perl
14 #         BUGS:  ---
15 #        NOTES:
16 #       AUTHOR:   (Andreas Rettenberger), <rettenberger@gonicus.de>
17 #      COMPANY:
18 #      VERSION:  1.0
19 #      CREATED:  12.09.2007 08:54:41 CEST
20 #     REVISION:  ---
21 #===============================================================================
24 use strict;
25 use warnings;
26 use Getopt::Long;
27 use Config::IniFiles;
28 use POSIX;
30 use Fcntl;
31 use IO::Socket::INET;
32 use IO::Handle;
33 use IO::Select;
34 use Symbol qw(qualify_to_ref);
35 use Crypt::Rijndael;
36 use MIME::Base64;
37 use Digest::MD5  qw(md5 md5_hex md5_base64);
38 use XML::Simple;
39 use Data::Dumper;
40 use Sys::Syslog qw( :DEFAULT setlogsock);
41 use Cwd;
42 use File::Spec;
43 use File::Basename;
44 use File::Find;
45 use File::Copy;
46 use File::Path;
47 use GOSA::DBsqlite;
48 use GOSA::GosaSupportDaemon;
49 use POE qw(Component::Server::TCP Wheel::Run Filter::Reference);
50 use Net::LDAP;
51 use Net::LDAP::Util qw(:escape);
53 my $modules_path = "/usr/lib/gosa-si/modules";
54 use lib "/usr/lib/gosa-si/modules";
56 # TODO es gibt eine globale funktion get_ldap_handle
57 # - ist in einer session dieses ldap handle schon vorhanden, wird es zurückgegeben
58 # - ist es nicht vorhanden, wird es erzeugt, im heap für spätere ldap anfragen gespeichert und zurückgegeben
59 # - sessions die kein ldap handle brauchen, sollen auch keins haben
60 # - wird eine session geschlossen, muss das ldap verbindung vorher beendet werden
61 our $global_kernel;
63 my (%cfg_defaults, $foreground, $verbose, $ping_timeout);
64 my ($bus_activ, $bus, $msg_to_bus, $bus_cipher);
65 my ($server);
66 my ($gosa_server, $job_queue_timeout, $job_queue_loop_delay);
67 my ($messaging_db_loop_delay);
68 my ($known_modules);
69 my ($pid_file, $procid, $pid, $log_file);
70 my ($arp_activ, $arp_fifo);
71 my ($xml);
72 my $sources_list;
73 my $max_clients;
74 my %repo_files=();
75 my $repo_path;
76 my %repo_dirs=();
77 # variables declared in config file are always set to 'our'
78 our (%cfg_defaults, $log_file, $pid_file, 
79     $server_ip, $server_port, $SIPackages_key, 
80     $arp_activ, $gosa_unit_tag,
81     $GosaPackages_key, $gosa_ip, $gosa_port, $gosa_timeout,
82 );
84 # additional variable which should be globaly accessable
85 our $server_address;
86 our $server_mac_address;
87 our $bus_address;
88 our $gosa_address;
89 our $no_bus;
90 our $no_arp;
91 our $verbose;
92 our $forground;
93 our $cfg_file;
94 #our ($ldap_handle, $ldap_uri, $ldap_base, $ldap_admin_dn, $ldap_admin_password, $ldap_server_dn);
95 our ($ldap_uri, $ldap_base, $ldap_admin_dn, $ldap_admin_password, $ldap_server_dn);
98 # specifies the verbosity of the daemon_log
99 $verbose = 0 ;
101 # if foreground is not null, script will be not forked to background
102 $foreground = 0 ;
104 # specifies the timeout seconds while checking the online status of a registrating client
105 $ping_timeout = 5;
107 $no_bus = 0;
108 $bus_activ = "true";
109 $no_arp = 0;
110 my $packages_list_under_construction = "/tmp/packages_list_creation_in_progress";
111 my @packages_list_statements;
112 my $watch_for_new_jobs_in_progress = 0;
114 our $prg= basename($0);
116 # holds all gosa jobs
117 our $job_db;
118 our $job_queue_tn = 'jobs';
119 my $job_queue_file_name;
120 my @job_queue_col_names = ("id INTEGER PRIMARY KEY", 
121                 "timestamp DEFAULT 'none'", 
122                 "status DEFAULT 'none'", 
123                 "result DEFAULT 'none'", 
124                 "progress DEFAULT 'none'", 
125         "headertag DEFAULT 'none'", 
126                 "targettag DEFAULT 'none'", 
127                 "xmlmessage DEFAULT 'none'", 
128                 "macaddress DEFAULT 'none'",
129                 "plainname DEFAULT 'none'",
130                 );
132 # holds all other gosa-sd as well as the gosa-sd-bus
133 our $known_server_db;
134 our $known_server_tn = "known_server";
135 my $known_server_file_name;
136 my @known_server_col_names = ("hostname", "status", "hostkey", "timestamp");
138 # holds all registrated clients
139 our $known_clients_db;
140 our $known_clients_tn = "known_clients";
141 my $known_clients_file_name;
142 my @known_clients_col_names = ("hostname", "status", "hostkey", "timestamp", "macaddress", "events");
144 # holds all logged in user at each client 
145 our $login_users_db;
146 our $login_users_tn = "login_users";
147 my $login_users_file_name;
148 my @login_users_col_names = ("client", "user", "timestamp");
150 # holds all fai server, the debian release and tag
151 our $fai_server_db;
152 our $fai_server_tn = "fai_server"; 
153 my $fai_server_file_name;
154 our @fai_server_col_names = ("timestamp", "server", "release", "sections", "tag"); 
156 our $fai_release_db;
157 our $fai_release_tn = "fai_release"; 
158 my $fai_release_file_name;
159 our @fai_release_col_names = ("timestamp", "release", "class", "type", "state"); 
161 # holds all packages available from different repositories
162 our $packages_list_db;
163 our $packages_list_tn = "packages_list";
164 my $packages_list_file_name;
165 our @packages_list_col_names = ("distribution", "package", "version", "section", "description", "template", "timestamp");
166 my $outdir = "/tmp/packages_list_db";
167 my $arch = "i386"; 
169 # holds all messages which should be delivered to a user
170 our $messaging_db;
171 our $messaging_tn = "messaging"; 
172 our @messaging_col_names = ("id INTEGER", "subject", "message_from", "message_to", 
173         "flag", "direction", "delivery_time", "message", "timestamp" );
174 my $messaging_file_name;
176 # path to directory to store client install log files
177 our $client_fai_log_dir = "/var/log/fai"; 
179 # queue which stores taskes until one of the $max_children children are ready to process the task
180 my @tasks = qw();
181 my $max_children = 2;
184 %cfg_defaults = (
185 "general" => {
186     "log-file" => [\$log_file, "/var/run/".$prg.".log"],
187     "pid-file" => [\$pid_file, "/var/run/".$prg.".pid"],
188     },
189 "bus" => {
190     "activ" => [\$bus_activ, "true"],
191     },
192 "server" => {
193     "port" => [\$server_port, "20081"],
194     "known-clients" => [\$known_clients_file_name, '/var/lib/gosa-si/clients.db' ],
195     "known-servers" => [\$known_server_file_name, '/var/lib/gosa-si/servers.db'],
196     "login-users" => [\$login_users_file_name, '/var/lib/gosa-si/users.db'],
197     "fai-server" => [\$fai_server_file_name, '/var/lib/gosa-si/fai_server.db'],
198     "fai-release" => [\$fai_release_file_name, '/var/lib/gosa-si/fai_release.db'],
199     "packages-list" => [\$packages_list_file_name, '/var/lib/gosa-si/packages.db'],
200     "messaging" => [\$messaging_file_name, '/var/lib/gosa-si/messaging.db'],
201     "source-list" => [\$sources_list, '/etc/apt/sources.list'],
202     "repo-path" => [\$repo_path, '/srv/www/repository'],
203     "ldap-uri" => [\$ldap_uri, ""],
204     "ldap-base" => [\$ldap_base, ""],
205     "ldap-admin-dn" => [\$ldap_admin_dn, ""],
206     "ldap-admin-password" => [\$ldap_admin_password, ""],
207     "gosa-unit-tag" => [\$gosa_unit_tag, ""],
208     "max-clients" => [\$max_clients, 10],
209     },
210 "GOsaPackages" => {
211     "ip" => [\$gosa_ip, "0.0.0.0"],
212     "port" => [\$gosa_port, "20082"],
213     "job-queue" => [\$job_queue_file_name, '/var/lib/gosa-si/jobs.db'],
214     "job-queue-loop-delay" => [\$job_queue_loop_delay, 3],
215     "messaging-db-loop-delay" => [\$messaging_db_loop_delay, 3],
216     "key" => [\$GosaPackages_key, "none"],
217     },
218 "SIPackages" => {
219     "key" => [\$SIPackages_key, "none"],
220     },
221 );
224 #===  FUNCTION  ================================================================
225 #         NAME:  usage
226 #   PARAMETERS:  nothing
227 #      RETURNS:  nothing
228 #  DESCRIPTION:  print out usage text to STDERR
229 #===============================================================================
230 sub usage {
231     print STDERR << "EOF" ;
232 usage: $prg [-hvf] [-c config]
234            -h        : this (help) message
235            -c <file> : config file
236            -f        : foreground, process will not be forked to background
237            -v        : be verbose (multiple to increase verbosity)
238            -no-bus   : starts $prg without connection to bus
239            -no-arp   : starts $prg without connection to arp module
240  
241 EOF
242     print "\n" ;
246 #===  FUNCTION  ================================================================
247 #         NAME:  read_configfile
248 #   PARAMETERS:  cfg_file - string -
249 #      RETURNS:  nothing
250 #  DESCRIPTION:  read cfg_file and set variables
251 #===============================================================================
252 sub read_configfile {
253     my $cfg;
254     if( defined( $cfg_file) && ( (-s $cfg_file) > 0 )) {
255         if( -r $cfg_file ) {
256             $cfg = Config::IniFiles->new( -file => $cfg_file );
257         } else {
258             print STDERR "Couldn't read config file!\n";
259         }
260     } else {
261         $cfg = Config::IniFiles->new() ;
262     }
263     foreach my $section (keys %cfg_defaults) {
264         foreach my $param (keys %{$cfg_defaults{ $section }}) {
265             my $pinfo = $cfg_defaults{ $section }{ $param };
266             ${@$pinfo[ 0 ]} = $cfg->val( $section, $param, @$pinfo[ 1 ] );
267         }
268     }
272 #===  FUNCTION  ================================================================
273 #         NAME:  logging
274 #   PARAMETERS:  level - string - default 'info'
275 #                msg - string -
276 #                facility - string - default 'LOG_DAEMON'
277 #      RETURNS:  nothing
278 #  DESCRIPTION:  function for logging
279 #===============================================================================
280 sub daemon_log {
281     # log into log_file
282     my( $msg, $level ) = @_;
283     if(not defined $msg) { return }
284     if(not defined $level) { $level = 1 }
285     if(defined $log_file){
286         open(LOG_HANDLE, ">>$log_file");
287         if(not defined open( LOG_HANDLE, ">>$log_file" )) {
288             print STDERR "cannot open $log_file: $!";
289             return }
290             chomp($msg);
291                         $msg =~s/\n//g;   # no newlines are allowed in log messages, this is important for later log parsing
292             if($level <= $verbose){
293                 my ($seconds, $minutes, $hours, $monthday, $month,
294                         $year, $weekday, $yearday, $sommertime) = localtime(time);
295                 $hours = $hours < 10 ? $hours = "0".$hours : $hours;
296                 $minutes = $minutes < 10 ? $minutes = "0".$minutes : $minutes;
297                 $seconds = $seconds < 10 ? $seconds = "0".$seconds : $seconds;
298                 my @monthnames = ("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec");
299                 $month = $monthnames[$month];
300                 $monthday = $monthday < 10 ? $monthday = "0".$monthday : $monthday;
301                 $year+=1900;
302                 my $name = $prg;
304                 my $log_msg = "$month $monthday $hours:$minutes:$seconds $name $msg\n";
305                 print LOG_HANDLE $log_msg;
306                 if( $foreground ) { 
307                     print STDERR $log_msg;
308                 }
309             }
310         close( LOG_HANDLE );
311     }
315 #===  FUNCTION  ================================================================
316 #         NAME:  check_cmdline_param
317 #   PARAMETERS:  nothing
318 #      RETURNS:  nothing
319 #  DESCRIPTION:  validates commandline parameter
320 #===============================================================================
321 sub check_cmdline_param () {
322     my $err_config;
323     my $err_counter = 0;
324         if(not defined($cfg_file)) {
325                 $cfg_file = "/etc/gosa-si/server.conf";
326                 if(! -r $cfg_file) {
327                         $err_config = "please specify a config file";
328                         $err_counter += 1;
329                 }
330     }
331     if( $err_counter > 0 ) {
332         &usage( "", 1 );
333         if( defined( $err_config)) { print STDERR "$err_config\n"}
334         print STDERR "\n";
335         exit( -1 );
336     }
340 #===  FUNCTION  ================================================================
341 #         NAME:  check_pid
342 #   PARAMETERS:  nothing
343 #      RETURNS:  nothing
344 #  DESCRIPTION:  handels pid processing
345 #===============================================================================
346 sub check_pid {
347     $pid = -1;
348     # Check, if we are already running
349     if( open(LOCK_FILE, "<$pid_file") ) {
350         $pid = <LOCK_FILE>;
351         if( defined $pid ) {
352             chomp( $pid );
353             if( -f "/proc/$pid/stat" ) {
354                 my($stat) = `cat /proc/$pid/stat` =~ m/$pid \((.+)\).*/;
355                 if( $stat ) {
356                                         daemon_log("ERROR: Already running",1);
357                     close( LOCK_FILE );
358                     exit -1;
359                 }
360             }
361         }
362         close( LOCK_FILE );
363         unlink( $pid_file );
364     }
366     # create a syslog msg if it is not to possible to open PID file
367     if (not sysopen(LOCK_FILE, $pid_file, O_WRONLY|O_CREAT|O_EXCL, 0644)) {
368         my($msg) = "Couldn't obtain lockfile '$pid_file' ";
369         if (open(LOCK_FILE, '<', $pid_file)
370                 && ($pid = <LOCK_FILE>))
371         {
372             chomp($pid);
373             $msg .= "(PID $pid)\n";
374         } else {
375             $msg .= "(unable to read PID)\n";
376         }
377         if( ! ($foreground) ) {
378             openlog( $0, "cons,pid", "daemon" );
379             syslog( "warning", $msg );
380             closelog();
381         }
382         else {
383             print( STDERR " $msg " );
384         }
385         exit( -1 );
386     }
389 #===  FUNCTION  ================================================================
390 #         NAME:  import_modules
391 #   PARAMETERS:  module_path - string - abs. path to the directory the modules 
392 #                are stored
393 #      RETURNS:  nothing
394 #  DESCRIPTION:  each file in module_path which ends with '.pm' and activation 
395 #                state is on is imported by "require 'file';"
396 #===============================================================================
397 sub import_modules {
398     daemon_log(" ", 1);
400     if (not -e $modules_path) {
401         daemon_log("ERROR: cannot find directory or directory is not readable: $modules_path", 1);   
402     }
404     opendir (DIR, $modules_path) or die "ERROR while loading modules from directory $modules_path : $!\n";
405     while (defined (my $file = readdir (DIR))) {
406         if (not $file =~ /(\S*?).pm$/) {
407             next;
408         }
409                 my $mod_name = $1;
411         if( $file =~ /ArpHandler.pm/ ) {
412             if( $no_arp > 0 ) {
413                 next;
414             }
415         }
416         
417         eval { require $file; };
418         if ($@) {
419             daemon_log("ERROR: gosa-si-server could not load module $file", 1);
420             daemon_log("$@", 5);
421                 } else {
422                         my $info = eval($mod_name.'::get_module_info()');
423                         # Only load module if get_module_info() returns a non-null object
424                         if( $info ) {
425                                 my ($input_address, $input_key, $input, $input_active, $input_type) = @{$info};
426                                 $known_modules->{$mod_name} = $info;
427                                 daemon_log("INFO: module $mod_name loaded", 5);
428                         }
429                 }
430     }   
431     close (DIR);
435 #===  FUNCTION  ================================================================
436 #         NAME:  sig_int_handler
437 #   PARAMETERS:  signal - string - signal arose from system
438 #      RETURNS:  noting
439 #  DESCRIPTION:  handels tasks to be done befor signal becomes active
440 #===============================================================================
441 sub sig_int_handler {
442     my ($signal) = @_;
444 #       if (defined($ldap_handle)) {
445 #               $ldap_handle->disconnect;
446 #       }
447     # TODO alle verbliebenden ldap verbindungen aus allen heaps beenden
448     
450     daemon_log("shutting down gosa-si-server", 1);
451     system("kill `ps -C gosa-si-server -o pid=`");
453 $SIG{INT} = \&sig_int_handler;
456 sub check_key_and_xml_validity {
457     my ($crypted_msg, $module_key, $session_id) = @_;
458     my $msg;
459     my $msg_hash;
460     my $error_string;
461     eval{
462         $msg = &decrypt_msg($crypted_msg, $module_key);
464         if ($msg =~ /<xml>/i){
465             $msg =~ s/\s+/ /g;  # just for better daemon_log
466             daemon_log("$session_id DEBUG: decrypted_msg: \n$msg", 8);
467             $msg_hash = $xml->XMLin($msg, ForceArray=>1);
469             ##############
470             # check header
471             if( not exists $msg_hash->{'header'} ) { die "no header specified"; }
472             my $header_l = $msg_hash->{'header'};
473             if( 1 > @{$header_l} ) { die 'empty header tag'; }
474             if( 1 < @{$header_l} ) { die 'more than one header specified'; }
475             my $header = @{$header_l}[0];
476             if( 0 == length $header) { die 'empty string in header tag'; }
478             ##############
479             # check source
480             if( not exists $msg_hash->{'source'} ) { die "no source specified"; }
481             my $source_l = $msg_hash->{'source'};
482             if( 1 > @{$source_l} ) { die 'empty source tag'; }
483             if( 1 < @{$source_l} ) { die 'more than one source specified'; }
484             my $source = @{$source_l}[0];
485             if( 0 == length $source) { die 'source error'; }
487             ##############
488             # check target
489             if( not exists $msg_hash->{'target'} ) { die "no target specified"; }
490             my $target_l = $msg_hash->{'target'};
491             if( 1 > @{$target_l} ) { die 'empty target tag'; }
492         }
493     };
494     if($@) {
495         daemon_log("$session_id DEBUG: do not understand the message: $@", 7);
496         $msg = undef;
497         $msg_hash = undef;
498     }
500     return ($msg, $msg_hash);
504 sub check_outgoing_xml_validity {
505     my ($msg) = @_;
507     my $msg_hash;
508     eval{
509         $msg_hash = $xml->XMLin($msg, ForceArray=>1);
511         ##############
512         # check header
513         my $header_l = $msg_hash->{'header'};
514         if( 1 != @{$header_l} ) {
515             die 'no or more than one headers specified';
516         }
517         my $header = @{$header_l}[0];
518         if( 0 == length $header) {
519             die 'header has length 0';
520         }
522         ##############
523         # check source
524         my $source_l = $msg_hash->{'source'};
525         if( 1 != @{$source_l} ) {
526             die 'no or more than 1 sources specified';
527         }
528         my $source = @{$source_l}[0];
529         if( 0 == length $source) {
530             die 'source has length 0';
531         }
532         unless( $source =~ /^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}:\d+$/ ||
533                 $source =~ /^GOSA$/i ) {
534             die "source '$source' is neither a complete ip-address with port nor 'GOSA'";
535         }
536         
537         ##############
538         # check target  
539         my $target_l = $msg_hash->{'target'};
540         if( 0 == @{$target_l} ) {
541             die "no targets specified";
542         }
543         foreach my $target (@$target_l) {
544             if( 0 == length $target) {
545                 die "target has length 0";
546             }
547             unless( $target =~ /^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}:\d+$/ ||
548                     $target =~ /^GOSA$/i ||
549                     $target =~ /^\*$/ ||
550                     $target =~ /KNOWN_SERVER/i ||
551                     $target =~ /JOBDB/i ||
552                     $target =~ /^([0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2})$/i ){
553                 die "target '$target' is not a complete ip-address with port or a valid target name or a mac-address";
554             }
555         }
556     };
557     if($@) {
558         daemon_log("WARNING: outgoing msg is not gosa-si envelope conform", 5);
559         daemon_log("$@ ".(defined($msg) && length($msg)>0)?$msg:"Empty Message", 8);
560         $msg_hash = undef;
561     }
563     return ($msg_hash);
567 sub input_from_known_server {
568     my ($input, $remote_ip, $session_id) = @_ ;  
569     my ($msg, $msg_hash, $module);
571     my $sql_statement= "SELECT * FROM known_server";
572     my $query_res = $known_server_db->select_dbentry( $sql_statement ); 
574     while( my ($hit_num, $hit) = each %{ $query_res } ) {    
575         my $host_name = $hit->{hostname};
576         if( not $host_name =~ "^$remote_ip") {
577             next;
578         }
579         my $host_key = $hit->{hostkey};
580         daemon_log("$session_id DEBUG: input_from_known_server: host_name: $host_name", 7);
581         daemon_log("DEBUG: input_from_known_server: host_key: $host_key", 7);
583         # check if module can open msg envelope with module key
584         my ($tmp_msg, $tmp_msg_hash) = &check_key_and_xml_validity($input, $host_key, $session_id);
585         if( (!$tmp_msg) || (!$tmp_msg_hash) ) {
586             daemon_log("$session_id DEBUG: input_from_known_server: deciphering raise error", 7);
587             daemon_log("$@", 8);
588             next;
589         }
590         else {
591             $msg = $tmp_msg;
592             $msg_hash = $tmp_msg_hash;
593             $module = "SIPackages";
594             last;
595         }
596     }
598     if( (!$msg) || (!$msg_hash) || (!$module) ) {
599         daemon_log("$session_id DEBUG: Incoming message is not from a known server", 7);
600     }
601   
602     return ($msg, $msg_hash, $module);
606 sub input_from_known_client {
607     my ($input, $remote_ip, $session_id) = @_ ;  
608     my ($msg, $msg_hash, $module);
610     my $sql_statement= "SELECT * FROM known_clients";
611     my $query_res = $known_clients_db->select_dbentry( $sql_statement ); 
612     while( my ($hit_num, $hit) = each %{ $query_res } ) {    
613         my $host_name = $hit->{hostname};
614         if( not $host_name =~ /^$remote_ip:\d*$/) {
615                 next;
616                 }
617         my $host_key = $hit->{hostkey};
618         &daemon_log("$session_id DEBUG: input_from_known_client: host_name: $host_name", 7);
619         &daemon_log("$session_id DEBUG: input_from_known_client: host_key: $host_key", 7);
621         # check if module can open msg envelope with module key
622         ($msg, $msg_hash) = &check_key_and_xml_validity($input, $host_key, $session_id);
624         if( (!$msg) || (!$msg_hash) ) {
625             &daemon_log("$session_id DEGUG: input_from_known_client: deciphering raise error", 7);
626             &daemon_log("$@", 8);
627             next;
628         }
629         else {
630             $module = "SIPackages";
631             last;
632         }
633     }
635     if( (!$msg) || (!$msg_hash) || (!$module) ) {
636         &daemon_log("$session_id DEBUG: Incoming message is not from a known client", 7);
637     }
639     return ($msg, $msg_hash, $module);
643 sub input_from_unknown_host {
644     no strict "refs";
645     my ($input, $session_id) = @_ ;
646     my ($msg, $msg_hash, $module);
647     my $error_string;
648     
649         my %act_modules = %$known_modules;
651         while( my ($mod, $info) = each(%act_modules)) {
653         # check a key exists for this module
654         my $module_key = ${$mod."_key"};
655         if( not defined $module_key ) {
656             if( $mod eq 'ArpHandler' ) {
657                 next;
658             }
659             daemon_log("$session_id ERROR: no key specified in config file for $mod", 1);
660             next;
661         }
662         daemon_log("$session_id DEBUG: $mod: $module_key", 7);
664         # check if module can open msg envelope with module key
665         ($msg, $msg_hash) = &check_key_and_xml_validity($input, $module_key, $session_id);
666         if( (not defined $msg) || (not defined $msg_hash) ) {
667             next;
668         }
669         else {
670             $module = $mod;
671             last;
672         }
673     }
675     if( (!$msg) || (!$msg_hash) || (!$module)) {
676         daemon_log("$session_id DEBUG: Incoming message is not from an unknown host", 7);
677     }
679     return ($msg, $msg_hash, $module);
683 sub create_ciphering {
684     my ($passwd) = @_;
685         if((!defined($passwd)) || length($passwd)==0) {
686                 $passwd = "";
687         }
688     $passwd = substr(md5_hex("$passwd") x 32, 0, 32);
689     my $iv = substr(md5_hex('GONICUS GmbH'),0, 16);
690     my $my_cipher = Crypt::Rijndael->new($passwd , Crypt::Rijndael::MODE_CBC());
691     $my_cipher->set_iv($iv);
692     return $my_cipher;
696 sub encrypt_msg {
697     my ($msg, $key) = @_;
698     my $my_cipher = &create_ciphering($key);
699     my $len;
700     {
701             use bytes;
702             $len= 16-length($msg)%16;
703     }
704     $msg = "\0"x($len).$msg;
705     $msg = $my_cipher->encrypt($msg);
706     chomp($msg = &encode_base64($msg));
707     # there are no newlines allowed inside msg
708     $msg=~ s/\n//g;
709     return $msg;
713 sub decrypt_msg {
715     my ($msg, $key) = @_ ;
716     $msg = &decode_base64($msg);
717     my $my_cipher = &create_ciphering($key);
718     $msg = $my_cipher->decrypt($msg); 
719     $msg =~ s/\0*//g;
720     return $msg;
724 sub get_encrypt_key {
725     my ($target) = @_ ;
726     my $encrypt_key;
727     my $error = 0;
729     # target can be in known_server
730     if( not defined $encrypt_key ) {
731         my $sql_statement= "SELECT * FROM known_server WHERE hostname='$target'";
732         my $query_res = $known_server_db->select_dbentry( $sql_statement ); 
733         while( my ($hit_num, $hit) = each %{ $query_res } ) {    
734             my $host_name = $hit->{hostname};
735             if( $host_name ne $target ) {
736                 next;
737             }
738             $encrypt_key = $hit->{hostkey};
739             last;
740         }
741     }
743     # target can be in known_client
744     if( not defined $encrypt_key ) {
745         my $sql_statement= "SELECT * FROM known_clients WHERE hostname='$target'";
746         my $query_res = $known_clients_db->select_dbentry( $sql_statement ); 
747         while( my ($hit_num, $hit) = each %{ $query_res } ) {    
748             my $host_name = $hit->{hostname};
749             if( $host_name ne $target ) {
750                 next;
751             }
752             $encrypt_key = $hit->{hostkey};
753             last;
754         }
755     }
757     return $encrypt_key;
761 #===  FUNCTION  ================================================================
762 #         NAME:  open_socket
763 #   PARAMETERS:  PeerAddr string something like 192.168.1.1 or 192.168.1.1:10000
764 #                [PeerPort] string necessary if port not appended by PeerAddr
765 #      RETURNS:  socket IO::Socket::INET
766 #  DESCRIPTION:  open a socket to PeerAddr
767 #===============================================================================
768 sub open_socket {
769     my ($PeerAddr, $PeerPort) = @_ ;
770     if(defined($PeerPort)){
771         $PeerAddr = $PeerAddr.":".$PeerPort;
772     }
773     my $socket;
774     $socket = new IO::Socket::INET(PeerAddr => $PeerAddr,
775             Porto => "tcp",
776             Type => SOCK_STREAM,
777             Timeout => 5,
778             );
779     if(not defined $socket) {
780         return;
781     }
782 #    &daemon_log("DEBUG: open_socket: $PeerAddr", 7);
783     return $socket;
787 #===  FUNCTION  ================================================================
788 #         NAME:  get_ip 
789 #   PARAMETERS:  interface name (i.e. eth0)
790 #      RETURNS:  (ip address) 
791 #  DESCRIPTION:  Uses ioctl to get ip address directly from system.
792 #===============================================================================
793 sub get_ip {
794         my $ifreq= shift;
795         my $result= "";
796         my $SIOCGIFADDR= 0x8915;       # man 2 ioctl_list
797         my $proto= getprotobyname('ip');
799         socket SOCKET, PF_INET, SOCK_DGRAM, $proto
800                 or die "socket: $!";
802         if(ioctl SOCKET, $SIOCGIFADDR, $ifreq) {
803                 my ($if, $sin)    = unpack 'a16 a16', $ifreq;
804                 my ($port, $addr) = sockaddr_in $sin;
805                 my $ip            = inet_ntoa $addr;
807                 if ($ip && length($ip) > 0) {
808                         $result = $ip;
809                 }
810         }
812         return $result;
816 sub get_local_ip_for_remote_ip {
817         my $remote_ip= shift;
818         my $result="0.0.0.0";
820         if($remote_ip =~ /^(\d\d?\d?\.){3}\d\d?\d?$/) {
821                 if($remote_ip eq "127.0.0.1") {
822                         $result = "127.0.0.1";
823                 } else {
824                         my $PROC_NET_ROUTE= ('/proc/net/route');
826                         open(PROC_NET_ROUTE, "<$PROC_NET_ROUTE")
827                                 or die "Could not open $PROC_NET_ROUTE";
829                         my @ifs = <PROC_NET_ROUTE>;
831                         close(PROC_NET_ROUTE);
833                         # Eat header line
834                         shift @ifs;
835                         chomp @ifs;
836                         foreach my $line(@ifs) {
837                                 my ($Iface,$Destination,$Gateway,$Flags,$RefCnt,$Use,$Metric,$Mask,$MTU,$Window,$IRTT)=split(/\s/, $line);
838                                 my $destination;
839                                 my $mask;
840                                 my ($d,$c,$b,$a)=unpack('a2 a2 a2 a2', $Destination);
841                                 $destination= sprintf("%d.%d.%d.%d", hex($a), hex($b), hex($c), hex($d));
842                                 ($d,$c,$b,$a)=unpack('a2 a2 a2 a2', $Mask);
843                                 $mask= sprintf("%d.%d.%d.%d", hex($a), hex($b), hex($c), hex($d));
844                                 if(new NetAddr::IP($remote_ip)->within(new NetAddr::IP($destination, $mask))) {
845                                         # destination matches route, save mac and exit
846                                         $result= &get_ip($Iface);
847                                         last;
848                                 }
849                         }
850                 }
851         } else {
852                 daemon_log("get_local_ip_for_remote_ip was called with a non-ip parameter: $remote_ip", 1);
853         }
854         return $result;
858 sub send_msg_to_target {
859     my ($msg, $address, $encrypt_key, $msg_header, $session_id) = @_ ;
860     my $error = 0;
861     my $header;
862     my $new_status;
863     my $act_status;
864     my ($sql_statement, $res);
865   
866     if( $msg_header ) {
867         $header = "'$msg_header'-";
868     } else {
869         $header = "";
870     }
872         # Patch the source ip
873         if($msg =~ /<source>0\.0\.0\.0:\d*?<\/source>/) {
874                 my $remote_ip = &get_local_ip_for_remote_ip(sprintf("%s", $address =~ /^([0-9\.]*?):.*$/));
875                 $msg =~ s/<source>(0\.0\.0\.0):(\d*?)<\/source>/<source>$remote_ip:$2<\/source>/s;
876         }
878     # encrypt xml msg
879     my $crypted_msg = &encrypt_msg($msg, $encrypt_key);
881     # opensocket
882     my $socket = &open_socket($address);
883     if( !$socket ) {
884         daemon_log("$session_id ERROR: cannot send ".$header."msg to $address , host not reachable", 1);
885         $error++;
886     }
887     
888     if( $error == 0 ) {
889         # send xml msg
890         print $socket $crypted_msg."\n";
892         daemon_log("$session_id INFO: send ".$header."msg to $address", 5);
893         #daemon_log("DEBUG: message:\n$msg", 9);
894         
895     }
897     # close socket in any case
898     if( $socket ) {
899         close $socket;
900     }
902     if( $error > 0 ) { $new_status = "down"; }
903     else { $new_status = $msg_header; }
906     # known_clients
907     $sql_statement = "SELECT * FROM known_clients WHERE hostname='$address'";
908     $res = $known_clients_db->select_dbentry($sql_statement);
909     if( keys(%$res) > 0) {
910         $act_status = $res->{1}->{'status'};
911         if( $act_status eq "down" ) {
912             $sql_statement = "DELETE FROM known_clients WHERE hostname='$address'";
913             $res = $known_clients_db->del_dbentry($sql_statement);
914             daemon_log("$session_id WARNING: failed 2x to send msg to host '$address', delete host from known_clients", 3);
915         } else { 
916             $sql_statement = "UPDATE known_clients SET status='$new_status' WHERE hostname='$address'";
917             $res = $known_clients_db->update_dbentry($sql_statement);
918             if($new_status eq "down"){
919                 daemon_log("$session_id WARNING: set '$address' from status '$act_status' to '$new_status'", 3);
920             } else {
921                 daemon_log("$session_id INFO: set '$address' from status '$act_status' to '$new_status'", 5);
922             }
923         }
924     }
926     # known_server
927     $sql_statement = "SELECT * FROM known_server WHERE hostname='$address'";
928     $res = $known_server_db->select_dbentry($sql_statement);
929     if( keys(%$res) > 0 ) {
930         $act_status = $res->{1}->{'status'};
931         if( $act_status eq "down" ) {
932             $sql_statement = "DELETE FROM known_server WHERE hostname='$address'";
933             $res = $known_server_db->del_dbentry($sql_statement);
934             daemon_log("$session_id WARNING: failed 2x to a send msg to host '$address', delete host from known_server", 3);
935         } 
936         else { 
937             $sql_statement = "UPDATE known_server SET status='$new_status' WHERE hostname='$address'";
938             $res = $known_server_db->update_dbentry($sql_statement);
939             if($new_status eq "down"){
940                 daemon_log("$session_id WARNING: set '$address' from status '$act_status' to '$new_status'", 3);
941             }
942             else {
943                 daemon_log("$session_id INFO: set '$address' from status '$act_status' to '$new_status'", 5);
944             }
945         }
946     }
947     return $error; 
951 sub update_jobdb_status_for_send_msgs {
952     my ($answer, $error) = @_;
953     if( $answer =~ /<jobdb_id>(\d+)<\/jobdb_id>/ ) {
954         my $jobdb_id = $1;
955             
956         # sending msg faild
957         if( $error ) {
958             if (not $answer =~ /<header>trigger_action_reinstall<\/header>/) {
959                 my $sql_statement = "UPDATE $job_queue_tn ".
960                     "SET status='error', result='can not deliver msg, please consult log file' ".
961                     "WHERE id='$jobdb_id'";
962                 my $res = $job_db->update_dbentry($sql_statement);
963             }
965         # sending msg was successful
966         } else {
967             my $sql_statement = "UPDATE $job_queue_tn ".
968                 "SET status='done' ".
969                 "WHERE id='$jobdb_id' AND status='processed'";
970             my $res = $job_db->update_dbentry($sql_statement);
971         }
972     }
975 sub _start {
976     my ($kernel) = $_[KERNEL];
977     &trigger_db_loop($kernel);
978     $global_kernel = $kernel;
979         $kernel->yield('create_fai_server_db', $fai_server_tn );
980         $kernel->yield('create_fai_release_db', $fai_release_tn );
981         $kernel->sig(USR1 => "sig_handler");
982         $kernel->sig(USR2 => "create_packages_list_db");
985 sub sig_handler {
986         my ($kernel, $signal) = @_[KERNEL, ARG0] ;
987         daemon_log("0 INFO got signal '$signal'", 1); 
988         $kernel->sig_handled();
989         return;
992 sub next_task {
993     my ($session, $heap) = @_[SESSION, HEAP];
995     while ( keys( %{ $heap->{task} } ) < $max_children ) {
996         my $next_task = shift @tasks;
997         last unless defined $next_task;
999         my $task = POE::Wheel::Run->new(
1000                 Program => sub { process_task($session, $heap, $next_task) },
1001                 StdioFilter => POE::Filter::Reference->new(),
1002                 StdoutEvent  => "task_result",
1003                 StderrEvent  => "task_debug",
1004                 CloseEvent   => "task_done",
1005                );
1007         $heap->{task}->{ $task->ID } = $task;
1008     }
1011 sub handle_task_result {
1012     my ($kernel, $heap, $result) = @_[KERNEL, HEAP, ARG0];
1013     my $client_answer = $result->{'answer'};
1014     if( $client_answer =~ s/session_id=(\d+)$// ) {
1015         my $session_id = $1;
1016         if( defined $session_id ) {
1017             my $session_reference = $kernel->ID_id_to_session($session_id);
1018             if( defined $session_reference ) {
1019                 $heap = $session_reference->get_heap();
1020             }
1021         }
1023         if(exists $heap->{'client'}) {
1024             $heap->{'client'}->put($client_answer);
1025         }
1026     }
1027     $kernel->sig(CHLD => "child_reap");
1030 sub handle_task_debug {
1031     my $result = $_[ARG0];
1032     print STDERR "$result\n";
1035 sub handle_task_done {
1036     my ( $kernel, $heap, $task_id ) = @_[ KERNEL, HEAP, ARG0 ];
1037     delete $heap->{task}->{$task_id};
1038     $kernel->yield("next_task");
1041 sub process_task {
1042     no strict "refs";
1043     my ($session, $heap, $input) = @_;
1044     my $session_id = $session->ID;
1045     my ($msg, $msg_hash, $module);
1046     my $error = 0;
1047     my $answer_l;
1048     my ($answer_header, @answer_target_l, $answer_source);
1049     my $client_answer = "";
1051     daemon_log("", 5); 
1052     daemon_log("$session_id INFO: Incoming msg with session ID $session_id from '".$heap->{'remote_ip'}."'", 5);
1053     #daemon_log("$session_id DEBUG: Incoming msg:\n$input", 9);
1055     ####################
1056     # check incoming msg
1057     # msg is from a new client or gosa
1058     ($msg, $msg_hash, $module) = &input_from_unknown_host($input, $session_id);
1059     # msg is from a gosa-si-server or gosa-si-bus
1060     if(( !$msg ) || ( !$msg_hash ) || ( !$module )){
1061         ($msg, $msg_hash, $module) = &input_from_known_server($input, $heap->{'remote_ip'}, $session_id);
1062     }
1063     # msg is from a gosa-si-client
1064     if(( !$msg ) || ( !$msg_hash ) || ( !$module )){
1065         ($msg, $msg_hash, $module) = &input_from_known_client($input, $heap->{'remote_ip'}, $session_id);
1066     }
1067     # an error occurred
1068     if(( !$msg ) || ( !$msg_hash ) || ( !$module )){
1069         # if an incoming msg could not be decrypted (maybe a wrong key), send client a ping. If the client
1070         # could not understand a msg from its server the client cause a re-registering process
1071         daemon_log("$session_id INFO cannot understand incoming msg, send 'ping'-msg to all host with ip '".$heap->{remote_ip}."' to cause a re-registering of the client if necessary", 5);
1072         my $sql_statement = "SELECT * FROM $main::known_clients_tn WHERE (hostname LIKE '".$heap->{'remote_ip'}."%')";
1073         my $query_res = $known_clients_db->select_dbentry( $sql_statement ); 
1074         while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1075             my $host_name = $hit->{'hostname'};
1076             my $host_key = $hit->{'hostkey'};
1077             my $ping_msg = "<xml> <header>gosa_ping</header> <source>$server_address</source> <target>$host_name</target></xml>";
1078             my $error = &send_msg_to_target($ping_msg, $host_name, $host_key, "gosa_ping", $session_id);
1079             &update_jobdb_status_for_send_msgs($ping_msg, $error);
1080         }
1081         $error++;
1082     }
1084     ######################
1085     # process incoming msg
1086     if( $error == 0) {
1087         daemon_log("$session_id INFO: Incoming msg with header '".@{$msg_hash->{'header'}}[0].
1088                                 "' from '".$heap->{'remote_ip'}."'", 5); 
1089         daemon_log("$session_id DEBUG: Processing module ".$module, 7);
1090         $answer_l = &{ $module."::process_incoming_msg" }($msg, $msg_hash, $session_id);
1092         if ( 0 < @{$answer_l} ) {
1093             my $answer_str = join("\n", @{$answer_l});
1094             daemon_log("$session_id DEBUG: $module: Got answer from module: \n".$answer_str,8);
1095         } else {
1096             daemon_log("$session_id DEBUG: $module: Got no answer from module!" ,8);
1097         }
1099     }
1100     if( !$answer_l ) { $error++ };
1102     ########
1103     # answer
1104     if( $error == 0 ) {
1106         foreach my $answer ( @{$answer_l} ) {
1107             # for each answer in answer list
1108             
1109             # check outgoing msg to xml validity
1110             my $answer_hash = &check_outgoing_xml_validity($answer);
1111             if( not defined $answer_hash ) {
1112                 next;
1113             }
1114             
1115             $answer_header = @{$answer_hash->{'header'}}[0];
1116             @answer_target_l = @{$answer_hash->{'target'}};
1117             $answer_source = @{$answer_hash->{'source'}}[0];
1119             # deliver msg to all targets 
1120             foreach my $answer_target ( @answer_target_l ) {
1122                 # targets of msg are all gosa-si-clients in known_clients_db
1123                 if( $answer_target eq "*" ) {
1124                     # answer is for all clients
1125                     my $sql_statement= "SELECT * FROM known_clients";
1126                     my $query_res = $known_clients_db->select_dbentry( $sql_statement ); 
1127                     while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1128                         my $host_name = $hit->{hostname};
1129                         my $host_key = $hit->{hostkey};
1130                         my $error = &send_msg_to_target($answer, $host_name, $host_key, $answer_header, $session_id);
1131                         &update_jobdb_status_for_send_msgs($answer, $error);
1132                     }
1133                 }
1135                 # targets of msg are all gosa-si-server in known_server_db
1136                 elsif( $answer_target eq "KNOWN_SERVER" ) {
1137                     # answer is for all server in known_server
1138                     my $sql_statement= "SELECT * FROM known_server";
1139                     my $query_res = $known_server_db->select_dbentry( $sql_statement ); 
1140                     while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1141                         my $host_name = $hit->{hostname};
1142                         my $host_key = $hit->{hostkey};
1143                         $answer =~ s/KNOWN_SERVER/$host_name/g;
1144                         my $error = &send_msg_to_target($answer, $host_name, $host_key, $answer_header, $session_id);
1145                         &update_jobdb_status_for_send_msgs($answer, $error);
1146                     }
1147                 }
1149                 # target of msg is GOsa
1150                                 elsif( $answer_target eq "GOSA" ) {
1151                                         my $session_id = ($1) if $answer =~ /<session_id>(\d+?)<\/session_id>/;
1152                                         my $add_on = "";
1153                     if( defined $session_id ) {
1154                         $add_on = ".session_id=$session_id";
1155                     }
1156                     # answer is for GOSA and has to returned to connected client
1157                     my $gosa_answer = &encrypt_msg($answer, $GosaPackages_key);
1158                     $client_answer = $gosa_answer.$add_on;
1159                 }
1161                 # target of msg is job queue at this host
1162                 elsif( $answer_target eq "JOBDB") {
1163                     $answer =~ /<header>(\S+)<\/header>/;   
1164                     my $header;
1165                     if( defined $1 ) { $header = $1; }
1166                     my $error = &send_msg_to_target($answer, $server_address, $GosaPackages_key, $header, $session_id);
1167                     &update_jobdb_status_for_send_msgs($answer, $error);
1168                 }
1170                 # target of msg is a mac address
1171                 elsif( $answer_target =~ /^([0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2}:[0-9a-f]{2})$/i ) {
1172                     daemon_log("$session_id INFO: target is mac address '$answer_target', looking for host in known_clients", 5);
1173                     my $sql_statement = "SELECT * FROM known_clients WHERE macaddress LIKE '$answer_target'";
1174                     my $query_res = $known_clients_db->select_dbentry( $sql_statement );
1175                     my $found_ip_flag = 0;
1176                     while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1177                         my $host_name = $hit->{hostname};
1178                         my $host_key = $hit->{hostkey};
1179                         $answer =~ s/$answer_target/$host_name/g;
1180                         daemon_log("$session_id INFO: found host '$host_name', associated to '$answer_target'", 5);
1181                         my $error = &send_msg_to_target($answer, $host_name, $host_key, $answer_header, $session_id);
1182                         &update_jobdb_status_for_send_msgs($answer, $error);
1183                         $found_ip_flag++ ;
1184                     }   
1185                     if( $found_ip_flag == 0) {
1186                         daemon_log("$session_id WARNING: no host found in known_clients with mac address '$answer_target'", 3);
1187                         if( $bus_activ eq "true" ) { 
1188                             daemon_log("$session_id INFO: try to forward msg '$answer_header' to bus '$bus_address'", 5);
1189                             my $sql_statement = "SELECT * FROM known_server WHERE hostname='$bus_address'";
1190                             my $query_res = $known_server_db->select_dbentry( $sql_statement );
1191                             while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1192                                 my $bus_address = $hit->{hostname};
1193                                 my $bus_key = $hit->{hostkey};
1194                                 my $error = &send_msg_to_target($answer, $bus_address, $bus_key, $answer_header, $session_id);
1195                                 &update_jobdb_status_for_send_msgs($answer, $error);
1196                                 last;
1197                             }
1198                         }
1200                     }
1202                 #  answer is for one specific host   
1203                 } else {
1204                     # get encrypt_key
1205                     my $encrypt_key = &get_encrypt_key($answer_target);
1206                     if( not defined $encrypt_key ) {
1207                         # unknown target, forward msg to bus
1208                         daemon_log("$session_id WARNING: unknown target '$answer_target'", 3);
1209                         if( $bus_activ eq "true" ) { 
1210                             daemon_log("$session_id INFO: try to forward msg '$answer_header' to bus '$bus_address'", 5);
1211                             my $sql_statement = "SELECT * FROM known_server WHERE hostname='$bus_address'";
1212                             my $query_res = $known_server_db->select_dbentry( $sql_statement );
1213                             my $res_length = keys( %{$query_res} );
1214                             if( $res_length == 0 ){
1215                                 daemon_log("$session_id WARNING: send '$answer_header' to '$bus_address' failed, ".
1216                                         "no bus found in known_server", 3);
1217                             }
1218                             else {
1219                                 while( my ($hit_num, $hit) = each %{ $query_res } ) {    
1220                                     my $bus_key = $hit->{hostkey};
1221                                     my $error = &send_msg_to_target($answer, $bus_address, $bus_key, $answer_header,$session_id );
1222                                     &update_jobdb_status_for_send_msgs($answer, $error);
1223                                 }
1224                             }
1225                         }
1226                         next;
1227                     }
1228                     my $error = &send_msg_to_target($answer, $answer_target, $encrypt_key, $answer_header,$session_id);
1229                     &update_jobdb_status_for_send_msgs($answer, $error);
1230                 }
1231             }
1232         }
1233     }
1235     my $filter = POE::Filter::Reference->new();
1236     my %result = ( 
1237             status => "seems ok to me",
1238             answer => $client_answer,
1239             );
1241     my $output = $filter->put( [ \%result ] );
1242     print @$output;
1248 sub trigger_db_loop {
1249         my ($kernel) = @_ ;
1250         $kernel->delay_set('watch_for_new_jobs', $job_queue_loop_delay);
1251         $kernel->delay_set('watch_for_done_jobs', $job_queue_loop_delay); 
1252         $kernel->delay_set('watch_for_new_messages', $messaging_db_loop_delay);
1253         $kernel->delay_set('watch_for_done_messages', $messaging_db_loop_delay);
1257 sub watch_for_done_jobs {
1258     my ($kernel,$heap) = @_[KERNEL, HEAP];
1260     my $sql_statement = "SELECT * FROM ".$job_queue_tn.
1261         " WHERE status='done'";
1262         my $res = $job_db->select_dbentry( $sql_statement );
1264     while( my ($id, $hit) = each %{$res} ) {
1265         my $jobdb_id = $hit->{id};
1266         my $sql_statement = "DELETE FROM $job_queue_tn WHERE id='$jobdb_id'"; 
1267         my $res = $job_db->del_dbentry($sql_statement);
1268     }
1270     $kernel->delay_set('watch_for_done_jobs',$job_queue_loop_delay);
1274 sub watch_for_new_jobs {
1275         if($watch_for_new_jobs_in_progress == 0) {
1276                 $watch_for_new_jobs_in_progress = 1;
1277                 my ($kernel,$heap) = @_[KERNEL, HEAP];
1279                 # check gosa job queue for jobs with executable timestamp
1280                 my $timestamp = &get_time();
1281                 my $sql_statement = "SELECT * FROM $job_queue_tn WHERE status='waiting' AND (CAST (timestamp AS INTEGER)) < $timestamp ORDER BY timestamp";
1282                 my $res = $job_db->exec_statement( $sql_statement );
1284                 # Merge all new jobs that would do the same actions
1285                 my @drops;
1286                 my $hits;
1287                 foreach my $hit (reverse @{$res} ) {
1288                         my $macaddress= lc @{$hit}[8];
1289                         my $headertag= @{$hit}[5];
1290                         if(
1291                                 defined($hits->{$macaddress}) &&
1292                                 defined($hits->{$macaddress}->{$headertag}) &&
1293                                 defined($hits->{$macaddress}->{$headertag}[0])
1294                         ) {
1295                                 push @drops, "DELETE FROM $job_queue_tn WHERE id = '$hits->{$macaddress}->{$headertag}[0]'";
1296                         }
1297                         $hits->{$macaddress}->{$headertag}= $hit;
1298                 }
1300                 # Delete new jobs with a matching job in state 'processing'
1301                 foreach my $macaddress (keys %{$hits}) {
1302                         foreach my $jobdb_headertag (keys %{$hits->{$macaddress}}) {
1303                                 my $jobdb_id = @{$hits->{$macaddress}->{$jobdb_headertag}}[0];
1304                                 if(defined($jobdb_id)) {
1305                                         my $sql_statement = "SELECT * FROM $job_queue_tn WHERE macaddress LIKE '$macaddress' AND headertag='$jobdb_headertag' AND status='processing'";
1306                                         my $res = $job_db->exec_statement( $sql_statement );
1307                                         foreach my $hit (@{$res}) {
1308                                                 push @drops, "DELETE FROM $job_queue_tn WHERE id = '$jobdb_id'";
1309                                         }
1310                                 } else {
1311                                         daemon_log("J ERROR: Job without id exists for macaddress $macaddress!", 1);
1312                                 }
1313                         }
1314                 }
1316                 # Commit deletion
1317                 $job_db->exec_statementlist(\@drops);
1319                 # Look for new jobs that could be executed
1320                 foreach my $macaddress (keys %{$hits}) {
1322                         # Look if there is an executing job
1323                         my $sql_statement = "SELECT * FROM $job_queue_tn WHERE macaddress LIKE '$macaddress' AND status='processing'";
1324                         my $res = $job_db->exec_statement( $sql_statement );
1326                         # Skip new jobs for host if there is a processing job
1327                         if(defined($res) and defined @{$res}[0]) {
1328                                 next;
1329                         }
1331                         foreach my $jobdb_headertag (keys %{$hits->{$macaddress}}) {
1332                                 my $jobdb_id = @{$hits->{$macaddress}->{$jobdb_headertag}}[0];
1333                                 if(defined($jobdb_id)) {
1334                                         my $job_msg = @{$hits->{$macaddress}->{$jobdb_headertag}}[7];
1336                                         daemon_log("J DEBUG: its time to execute $job_msg", 7);
1337                                         my $sql_statement = "SELECT * FROM known_clients WHERE macaddress LIKE '$macaddress'";
1338                                         my $res_hash = $known_clients_db->select_dbentry( $sql_statement );
1340                                         # expect macaddress is unique!!!!!!
1341                                         my $target = $res_hash->{1}->{hostname};
1343                                         # change header
1344                                         $job_msg =~ s/<header>job_/<header>gosa_/;
1346                                         # add sqlite_id
1347                                         $job_msg =~ s/<\/xml>$/<jobdb_id>$jobdb_id<\/jobdb_id><\/xml>/;
1349                                         $job_msg =~ /<header>(\S+)<\/header>/;
1350                                         my $header = $1 ;
1351                                         my $func_error = &send_msg_to_target($job_msg, $server_address, $GosaPackages_key, $header, "J");
1353                                         # update status in job queue to 'processing'
1354                                         $sql_statement = "UPDATE $job_queue_tn SET status='processing' WHERE id='$jobdb_id'";
1355                                         my $res = $job_db->update_dbentry($sql_statement);
1357                                         # We don't want parallel processing
1358                                         last;
1359                                 }
1360                         }
1361                 }
1363                 $watch_for_new_jobs_in_progress = 0;
1364                 $kernel->delay_set('watch_for_new_jobs', $job_queue_loop_delay);
1365         }
1369 sub watch_for_new_messages {
1370     my ($kernel,$heap) = @_[KERNEL, HEAP];
1371     my @coll_user_msg;   # collection list of outgoing messages
1372     
1373     # check messaging_db for new incoming messages with executable timestamp
1374     my $timestamp = &get_time();
1375     my $sql_statement = "SELECT * FROM $messaging_tn WHERE ( (CAST(timestamp AS INTEGER))<$timestamp AND flag='n' AND direction='in' )";
1376     my $res = $messaging_db->exec_statement( $sql_statement );
1377         foreach my $hit (@{$res}) {
1379         # create outgoing messages
1380         my $message_to = @{$hit}[3];
1382         # translate message_to to plain login name
1383 # TODO implement reciever translation
1384         my @reciever_l = ($message_to);  
1385         my $message_id = @{$hit}[0];
1387         #add each outgoing msg to messaging_db
1388         my $reciever;
1389         foreach $reciever (@reciever_l) {
1390             my $sql_statement = "INSERT INTO $messaging_tn (id, subject, message_from, message_to, flag, direction, delivery_time, message, timestamp) ".
1391                 "VALUES ('".
1392                 $message_id."', '".    # id
1393                 @{$hit}[1]."', '".     # subject
1394                 @{$hit}[2]."', '".     # message_from
1395                 $reciever."', '".      # message_to
1396                 "none"."', '".         # flag
1397                 "out"."', '".          # direction
1398                 @{$hit}[6]."', '".     # delivery_time
1399                 @{$hit}[7]."', '".     # message
1400                 $timestamp."'".     # timestamp
1401                 ")";
1402             &daemon_log("M DEBUG: $sql_statement", 1);
1403             my $res = $messaging_db->exec_statement($sql_statement);
1404             &daemon_log("M INFO: message '".@{$hit}[0]."' is prepared for delivery to reciever '$reciever'", 5);
1405         }
1407         # send outgoing messages
1408         my $sql_statement = "SELECT * FROM $messaging_tn WHERE ( flag='p' AND direction='out' )";
1409         my $res = $messaging_db->exec_statement( $sql_statement );
1410         foreach my $hit (@{$res}) {
1411             # add subject, from, to and message to list coll_user_msg
1412             my @user_msg = [@{$hit}[1], @{$hit}[2], $reciever, @{$hit}[7]];
1413             push( @coll_user_msg, \@user_msg);
1414         }
1416         # send outgoing list to myself (gosa-si-server) to deliver each message to user
1417         # reason for this workaround: if to much messages have to be delivered, it can come to 
1418         # denial of service problems of the server. so, the incoming message list can be processed
1419         # by a forked child and gosa-si-server is always ready to work. 
1420         my $collection_out_msg = &create_xml_hash("collection_user_messages", $server_address, $server_address);
1421         # add to hash 'msg1' => [subject, from, to, message]
1422         # hash to string
1423         # send msg to myself
1424 # TODO
1426         # set incoming message to flag d=deliverd
1427         $sql_statement = "UPDATE $messaging_tn SET flag='p' WHERE id='$message_id'"; 
1428         &daemon_log("M DEBUG: $sql_statement", 7);
1429         $res = $messaging_db->update_dbentry($sql_statement);
1430         &daemon_log("M INFO: message '$message_id' is set to flag 'p' (processed)", 5);
1432     }
1433     
1434     $kernel->delay_set('watch_for_new_messages', $messaging_db_loop_delay); 
1437     return;
1441 sub watch_for_done_messages {
1442     my ($kernel,$heap) = @_[KERNEL, HEAP];
1444     $kernel->delay_set('watch_for_done_messages', $messaging_db_loop_delay); 
1445     return;
1449 sub get_ldap_handle {
1450         my ($session_id) = @_;
1451         my $heap;
1452         my $ldap_handle;
1454         if (not defined $session_id ) { $session_id = 0 };
1455         if ($session_id =~ /[^0-9]*/) { $session_id = 0 };
1457         if ($session_id == 0) {
1458                 daemon_log("$session_id DEBUG: get_ldap_handle invoked without a session_id, create a new ldap_handle", 7); 
1459                 $ldap_handle = Net::LDAP->new( $ldap_uri );
1460                 $ldap_handle->bind($ldap_admin_dn, password => $ldap_admin_password); 
1462         } else {
1463                 my $session_reference = $global_kernel->ID_id_to_session($session_id);
1464                 if( defined $session_reference ) {
1465                         $heap = $session_reference->get_heap();
1466                 }
1468                 if (not defined $heap) {
1469                         daemon_log("$session_id DEBUG: cannot get heap for session_id '$session_id'", 7); 
1470                         return;
1471                 }
1473                 # TODO: This "if" is nonsense, because it doesn't prove that the
1474                 #       used handle is still valid - or if we've to reconnect...
1475                 #if (not exists $heap->{ldap_handle}) {
1476                         $ldap_handle = Net::LDAP->new( $ldap_uri );
1477                         $ldap_handle->bind($ldap_admin_dn, password => $ldap_admin_password); 
1478                         $heap->{ldap_handle} = $ldap_handle;
1479                 #}
1480         }
1481         return $ldap_handle;
1485 sub change_fai_state {
1486     my ($st, $targets, $session_id) = @_;
1487     $session_id = 0 if not defined $session_id;
1488     # Set FAI state to localboot
1489     my %mapActions= (
1490         reboot    => '',
1491         update    => 'softupdate',
1492         localboot => 'localboot',
1493         reinstall => 'install',
1494         rescan    => '',
1495         wake      => '',
1496         memcheck  => 'memcheck',
1497         sysinfo   => 'sysinfo',
1498         install   => 'install',
1499     );
1501     # Return if this is unknown
1502     if (!exists $mapActions{ $st }){
1503         daemon_log("$session_id ERROR: unknown action '$st', can not translate ot FAIstate", 1); 
1504       return;
1505     }
1507     my $state= $mapActions{ $st };
1509     my $ldap_handle = &get_ldap_handle($session_id);
1510     if( defined($ldap_handle) ) {
1512       # Build search filter for hosts
1513         my $search= "(&(objectClass=GOhard)";
1514         foreach (@{$targets}){
1515             $search.= "(macAddress=$_)";
1516         }
1517         $search.= ")";
1519       # If there's any host inside of the search string, procress them
1520         if (!($search =~ /macAddress/)){
1521             daemon_log("$session_id ERROR: no macAddress found in filter statement for LDAP search: '$search'", 1);    
1522             return;
1523         }
1525       # Perform search for Unit Tag
1526       my $mesg = $ldap_handle->search(
1527           base   => $ldap_base,
1528           scope  => 'sub',
1529           attrs  => ['dn', 'FAIstate', 'objectClass'],
1530           filter => "$search"
1531           );
1533           if ($mesg->count) {
1534                   my @entries = $mesg->entries;
1535                   foreach my $entry (@entries) {
1536                           # Only modify entry if it is not set to '$state'
1537                           if ($entry->get_value("FAIstate") ne "$state"){
1538                                   daemon_log("$session_id INFO: Setting FAIstate to '$state' for ".$entry->dn, 5);
1539                                   my $result;
1540                                   my %tmp = map { $_ => 1 } $entry->get_value("objectClass");
1541                                   if (exists $tmp{'FAIobject'}){
1542                                           if ($state eq ''){
1543                                                   $result= $ldap_handle->modify($entry->dn, changes => [
1544                                                           delete => [ FAIstate => [] ] ]);
1545                                           } else {
1546                                                   $result= $ldap_handle->modify($entry->dn, changes => [
1547                                                           replace => [ FAIstate => $state ] ]);
1548                                           }
1549                                   } elsif ($state ne ''){
1550                                           $result= $ldap_handle->modify($entry->dn, changes => [
1551                                                   add     => [ objectClass => 'FAIobject' ],
1552                                                   add     => [ FAIstate => $state ] ]);
1553                                   }
1555                                   # Errors?
1556                                   if ($result->code){
1557                                           daemon_log("$session_id Error: Setting FAIstate to '$state' for ".$entry->dn. "failed: ".$result->error, 1);
1558                                   }
1559                           } else {
1560                                   daemon_log("$session_id DEBUG FAIstate at host '".$entry->dn."' already at state '$st'", 7); 
1561                           }  
1562                   }
1563           }
1564     # if no ldap handle defined
1565     } else {
1566         daemon_log("$session_id ERROR: no LDAP handle defined for update FAIstate", 1); 
1567     }
1572 sub change_goto_state {
1573     my ($st, $targets, $session_id) = @_;
1574     $session_id = 0  if not defined $session_id;
1576     # Switch on or off?
1577     my $state= $st eq 'active' ? 'active': 'locked';
1579     my $ldap_handle = &get_ldap_handle($session_id);
1580     if( defined($ldap_handle) ) {
1582       # Build search filter for hosts
1583       my $search= "(&(objectClass=GOhard)";
1584       foreach (@{$targets}){
1585         $search.= "(macAddress=$_)";
1586       }
1587       $search.= ")";
1589       # If there's any host inside of the search string, procress them
1590       if (!($search =~ /macAddress/)){
1591         return;
1592       }
1594       # Perform search for Unit Tag
1595       my $mesg = $ldap_handle->search(
1596           base   => $ldap_base,
1597           scope  => 'sub',
1598           attrs  => ['dn', 'gotoMode'],
1599           filter => "$search"
1600           );
1602       if ($mesg->count) {
1603         my @entries = $mesg->entries;
1604         foreach my $entry (@entries) {
1606           # Only modify entry if it is not set to '$state'
1607           if ($entry->get_value("gotoMode") ne $state){
1609             daemon_log("$session_id INFO: Setting gotoMode to '$state' for ".$entry->dn, 5);
1610             my $result;
1611             $result= $ldap_handle->modify($entry->dn, changes => [
1612                                                 replace => [ gotoMode => $state ] ]);
1614             # Errors?
1615             if ($result->code){
1616               &daemon_log("$session_id Error: Setting gotoMode to '$state' for ".$entry->dn. "failed: ".$result->error, 1);
1617             }
1619           }
1620         }
1621       }
1623     }
1627 sub run_create_fai_server_db {
1628     my ($kernel, $session, $heap, $table_name) = @_[KERNEL, SESSION, HEAP, ARG0];
1629     my $session_id = $session->ID;
1630     my $task = POE::Wheel::Run->new(
1631             Program => sub { &create_fai_server_db($table_name,$kernel, undef, $session_id) },
1632             StdoutEvent  => "session_run_result",
1633             StderrEvent  => "session_run_debug",
1634             CloseEvent   => "session_run_done",
1635             );
1637     $heap->{task}->{ $task->ID } = $task;
1638     return;
1642 sub create_fai_server_db {
1643     my ($table_name, $kernel, $dont_create_packages_list, $session_id) = @_;
1644         my $result;
1646         if (not defined $session_id) { $session_id = 0; }
1647     my $ldap_handle = &get_ldap_handle();
1648         if(defined($ldap_handle)) {
1649                 daemon_log("$session_id INFO: create_fai_server_db: start", 5);
1650                 my $mesg= $ldap_handle->search(
1651                         base   => $ldap_base,
1652                         scope  => 'sub',
1653                         attrs  => ['FAIrepository', 'gosaUnitTag'],
1654                         filter => "(&(FAIrepository=*)(objectClass=FAIrepositoryServer))",
1655                 );
1656                 if($mesg->{'resultCode'} == 0 &&
1657                    $mesg->count != 0) {
1658                    foreach my $entry (@{$mesg->{entries}}) {
1659                            if($entry->exists('FAIrepository')) {
1660                                    # Add an entry for each Repository configured for server
1661                                    foreach my $repo(@{$entry->get_value('FAIrepository', asref => 1)}) {
1662                                                    my($tmp_url,$tmp_server,$tmp_release,$tmp_sections) = split(/\|/, $repo);
1663                                                    my $tmp_tag= $entry->get_value('gosaUnitTag') || "";
1664                                                    $result= $fai_server_db->add_dbentry( { 
1665                                                                    table => $table_name,
1666                                                                    primkey => ['server', 'release', 'tag'],
1667                                                                    server => $tmp_url,
1668                                                                    release => $tmp_release,
1669                                                                    sections => $tmp_sections,
1670                                                                    tag => (length($tmp_tag)>0)?$tmp_tag:"",
1671                                                            } );
1672                                            }
1673                                    }
1674                            }
1675                    }
1676                 daemon_log("$session_id INFO: create_fai_server_db: finished", 5);
1678                 # TODO: Find a way to post the 'create_packages_list_db' event
1679                 if(not defined($dont_create_packages_list)) {
1680                         &create_packages_list_db(undef, undef, $session_id);
1681                 }
1682         }       
1683     
1684     $ldap_handle->disconnect;
1685         return $result;
1689 sub run_create_fai_release_db {
1690     my ($session, $heap, $table_name) = @_[SESSION, HEAP, ARG0];
1691         my $session_id = $session->ID;
1692     my $task = POE::Wheel::Run->new(
1693             Program => sub { &create_fai_release_db($table_name, $session_id) },
1694             StdoutEvent  => "session_run_result",
1695             StderrEvent  => "session_run_debug",
1696             CloseEvent   => "session_run_done",
1697             );
1699     $heap->{task}->{ $task->ID } = $task;
1700     return;
1704 sub create_fai_release_db {
1705         my ($table_name, $session_id) = @_;
1706         my $result;
1708     # used for logging
1709     if (not defined $session_id) { $session_id = 0; }
1711     my $ldap_handle = &get_ldap_handle();
1712         if(defined($ldap_handle)) {
1713                 daemon_log("$session_id INFO: create_fai_release_db: start",5);
1714                 my $mesg= $ldap_handle->search(
1715                         base   => $ldap_base,
1716                         scope  => 'sub',
1717                         attrs  => [],
1718                         filter => "(&(objectClass=organizationalUnit)(ou=fai))",
1719                 );
1720                 if($mesg->{'resultCode'} == 0 &&
1721                         $mesg->count != 0) {
1722                         # Walk through all possible FAI container ou's
1723                         my @sql_list;
1724                         my $timestamp= &get_time();
1725                         foreach my $ou (@{$mesg->{entries}}) {
1726                                 my $tmp_classes= resolve_fai_classes($ou->dn, $ldap_handle, $session_id);
1727                                 if(defined($tmp_classes) && ref($tmp_classes) eq 'HASH') {
1728                                         my @tmp_array=get_fai_release_entries($tmp_classes);
1729                                         if(@tmp_array) {
1730                                                 foreach my $entry (@tmp_array) {
1731                                                         if(defined($entry) && ref($entry) eq 'HASH') {
1732                                                                 my $sql= 
1733                                                                 "INSERT INTO $table_name "
1734                                                                 ."(timestamp, release, class, type, state) VALUES ("
1735                                                                 .$timestamp.","
1736                                                                 ."'".$entry->{'release'}."',"
1737                                                                 ."'".$entry->{'class'}."',"
1738                                                                 ."'".$entry->{'type'}."',"
1739                                                                 ."'".$entry->{'state'}."')";
1740                                                                 push @sql_list, $sql;
1741                                                         }
1742                                                 }
1743                                         }
1744                                 }
1745                         }
1747                         daemon_log("$session_id DEBUG: Inserting ".scalar @sql_list." entries to DB",8);
1748                         if(@sql_list) {
1749                                 unshift @sql_list, "DELETE FROM $table_name";   # at first, clear db
1750                                 $fai_release_db->exec_statementlist(\@sql_list);
1751                         }
1752                         daemon_log("$session_id DEBUG: Done with inserting",7);
1753                 }
1754                 daemon_log("$session_id INFO: create_fai_release_db: finished",5);
1755         }
1756     $ldap_handle->disconnect;
1757         return $result;
1760 sub get_fai_types {
1761         my $tmp_classes = shift || return undef;
1762         my @result;
1764         foreach my $type(keys %{$tmp_classes}) {
1765                 if(defined($tmp_classes->{$type}[0]) && (!($tmp_classes->{$type}[0] =~ /^.*?removed.*?$/))) {
1766                         my $entry = {
1767                                 type => $type,
1768                                 state => $tmp_classes->{$type}[0],
1769                         };
1770                         push @result, $entry;
1771                 }
1772         }
1774         return @result;
1777 sub get_fai_state {
1778         my $result = "";
1779         my $tmp_classes = shift || return $result;
1781         foreach my $type(keys %{$tmp_classes}) {
1782                 if(defined($tmp_classes->{$type}[0])) {
1783                         $result = $tmp_classes->{$type}[0];
1784                         
1785                 # State is equal for all types in class
1786                         last;
1787                 }
1788         }
1790         return $result;
1793 sub resolve_fai_classes {
1794         my ($fai_base, $ldap_handle, $session_id) = @_;
1795         if (not defined $session_id) { $session_id = 0; }
1796         my $result;
1797         my @possible_fai_classes= ("FAIscript", "FAIhook", "FAIpartitionTable", "FAItemplate", "FAIvariable", "FAIprofile", "FAIpackageList");
1798         my $fai_filter= "(|(&(objectClass=FAIclass)(|(objectClass=".join(")(objectClass=", @possible_fai_classes).")))(objectClass=FAIbranch))";
1799         my $fai_classes;
1801         daemon_log("$session_id DEBUG: Searching for FAI entries in base $fai_base",7);
1802         my $mesg= $ldap_handle->search(
1803                 base   => $fai_base,
1804                 scope  => 'sub',
1805                 attrs  => ['cn','objectClass','FAIstate'],
1806                 filter => $fai_filter,
1807         );
1808         daemon_log("$session_id DEBUG: Found ".$mesg->count()." FAI entries",7);
1810         if($mesg->{'resultCode'} == 0 &&
1811                 $mesg->count != 0) {
1812                 foreach my $entry (@{$mesg->{entries}}) {
1813                         if($entry->exists('cn')) {
1814                                 my $tmp_dn= $entry->dn();
1816                                 # Skip classname and ou dn parts for class
1817                                 my $tmp_release = ($1) if $tmp_dn =~ /^[^,]+,[^,]+,(.*?),$fai_base$/;
1819                                 # Skip classes without releases
1820                                 if((!defined($tmp_release)) || length($tmp_release)==0) {
1821                                         next;
1822                                 }
1824                                 my $tmp_cn= $entry->get_value('cn');
1825                                 my $tmp_state= $entry->get_value('FAIstate');
1827                                 my $tmp_type;
1828                                 # Get FAI type
1829                                 for my $oclass(@{$entry->get_value('objectClass', asref => 1)}) {
1830                                         if(grep $_ eq $oclass, @possible_fai_classes) {
1831                                                 $tmp_type= $oclass;
1832                                                 last;
1833                                         }
1834                                 }
1836                                 if($tmp_release =~ /^.*?,.*?$/ && (!($tmp_release =~ /^.*?\\,.*?$/))) {
1837                                         # A Subrelease
1838                                         my @sub_releases = split(/,/, $tmp_release);
1840                                         # Walk through subreleases and build hash tree
1841                                         my $hash;
1842                                         while(my $tmp_sub_release = pop @sub_releases) {
1843                                                 $hash .= "\{'$tmp_sub_release'\}->";                                            
1844                                         }
1845                                         eval('push @{$fai_classes->'.$hash.'{$tmp_cn}->{$tmp_type}}, (defined($tmp_state) && length($tmp_state)>0)?$tmp_state:"";');
1846                                 } else {
1847                                         # A branch, no subrelease
1848                                         push @{$fai_classes->{$tmp_release}->{$tmp_cn}->{$tmp_type}}, (defined($tmp_state) && length($tmp_state)>0)?$tmp_state:"";
1849                                 }
1850                         } elsif (!$entry->exists('cn')) {
1851                                 my $tmp_dn= $entry->dn();
1852                                 my $tmp_release = ($1) if $tmp_dn =~ /^(.*?),$fai_base$/;
1854                                 # Skip classes without releases
1855                                 if((!defined($tmp_release)) || length($tmp_release)==0) {
1856                                         next;
1857                                 }
1859                                 if($tmp_release =~ /^.*?,.*?$/ && (!($tmp_release =~ /^.*?\\,.*?$/))) {
1860                                         # A Subrelease
1861                                         my @sub_releases= split(/,/, $tmp_release);
1863                                         # Walk through subreleases and build hash tree
1864                                         my $hash;
1865                                         while(my $tmp_sub_release = pop @sub_releases) {
1866                                                 $hash .= "\{'$tmp_sub_release'\}->";                                            
1867                                         }
1868                                         # Remove the last two characters
1869                                         chop($hash);
1870                                         chop($hash);
1872                                         eval('$fai_classes->'.$hash.'= {}');
1873                                 } else {
1874                                         # A branch, no subrelease
1875                                         if(!exists($fai_classes->{$tmp_release})) {
1876                                                 $fai_classes->{$tmp_release} = {};
1877                                         }
1878                                 }
1879                         }
1880                 }
1882                 # The hash is complete, now we can honor the copy-on-write based missing entries
1883                 foreach my $release (keys %$fai_classes) {
1884                         $result->{$release}= deep_copy(apply_fai_inheritance($fai_classes->{$release}));
1885                 }
1886         }
1887         return $result;
1890 sub apply_fai_inheritance {
1891        my $fai_classes = shift || return {};
1892        my $tmp_classes;
1894        # Get the classes from the branch
1895        foreach my $class (keys %{$fai_classes}) {
1896                # Skip subreleases
1897                if($class =~ /^ou=.*$/) {
1898                        next;
1899                } else {
1900                        $tmp_classes->{$class}= deep_copy($fai_classes->{$class});
1901                }
1902        }
1904        # Apply to each subrelease
1905        foreach my $subrelease (keys %{$fai_classes}) {
1906                if($subrelease =~ /ou=/) {
1907                        foreach my $tmp_class (keys %{$tmp_classes}) {
1908                                if(!exists($fai_classes->{$subrelease}->{$tmp_class})) {
1909                                        $fai_classes->{$subrelease}->{$tmp_class} =
1910                                        deep_copy($tmp_classes->{$tmp_class});
1911                                } else {
1912                                        foreach my $type (keys %{$tmp_classes->{$tmp_class}}) {
1913                                                if(!exists($fai_classes->{$subrelease}->{$tmp_class}->{$type})) {
1914                                                        $fai_classes->{$subrelease}->{$tmp_class}->{$type}=
1915                                                        deep_copy($tmp_classes->{$tmp_class}->{$type});
1916                                                }
1917                                        }
1918                                }
1919                        }
1920                }
1921        }
1923        # Find subreleases in deeper levels
1924        foreach my $subrelease (keys %{$fai_classes}) {
1925                if($subrelease =~ /ou=/) {
1926                        foreach my $subsubrelease (keys %{$fai_classes->{$subrelease}}) {
1927                                if($subsubrelease =~ /ou=/) {
1928                                        apply_fai_inheritance($fai_classes->{$subrelease});
1929                                }
1930                        }
1931                }
1932        }
1934        return $fai_classes;
1937 sub get_fai_release_entries {
1938         my $tmp_classes = shift || return;
1939         my $parent = shift || "";
1940         my @result = shift || ();
1942         foreach my $entry (keys %{$tmp_classes}) {
1943                 if(defined($entry)) {
1944                         if($entry =~ /^ou=.*$/) {
1945                                 my $release_name = $entry;
1946                                 $release_name =~ s/ou=//g;
1947                                 if(length($parent)>0) {
1948                                         $release_name = $parent."/".$release_name;
1949                                 }
1950                                 my @bufentries = get_fai_release_entries($tmp_classes->{$entry}, $release_name, @result);
1951                                 foreach my $bufentry(@bufentries) {
1952                                         push @result, $bufentry;
1953                                 }
1954                         } else {
1955                                 my @types = get_fai_types($tmp_classes->{$entry});
1956                                 foreach my $type (@types) {
1957                                         push @result, 
1958                                         {
1959                                                 'class' => $entry,
1960                                                 'type' => $type->{'type'},
1961                                                 'release' => $parent,
1962                                                 'state' => $type->{'state'},
1963                                         };
1964                                 }
1965                         }
1966                 }
1967         }
1969         return @result;
1972 sub deep_copy {
1973         my $this = shift;
1974         if (not ref $this) {
1975                 $this;
1976         } elsif (ref $this eq "ARRAY") {
1977                 [map deep_copy($_), @$this];
1978         } elsif (ref $this eq "HASH") {
1979                 +{map { $_ => deep_copy($this->{$_}) } keys %$this};
1980         } else { die "what type is $_?" }
1984 sub session_run_result {
1985     my ($kernel, $heap, $client_answer) = @_[KERNEL, HEAP, ARG0];    
1986     $kernel->sig(CHLD => "child_reap");
1989 sub session_run_debug {
1990     my $result = $_[ARG0];
1991     print STDERR "$result\n";
1994 sub session_run_done {
1995     my ( $kernel, $heap, $task_id ) = @_[ KERNEL, HEAP, ARG0 ];
1996     delete $heap->{task}->{$task_id};
2000 sub create_sources_list {
2001         my $session_id = shift;
2002         my $ldap_handle = &main::get_ldap_handle;
2003         my $result="/tmp/gosa_si_tmp_sources_list";
2005         # Remove old file
2006         if(stat($result)) {
2007                 unlink($result);
2008                 &main::daemon_log("$session_id DEBUG: remove an old version of '$result'", 7); 
2009         }
2011         my $fh;
2012         open($fh, ">$result");
2013         if (not defined $fh) {
2014                 &main::daemon_log("$session_id DEBUG: cannot open '$result' for writing", 7); 
2015                 return undef;
2016         }
2017         if(defined($main::ldap_server_dn) and length($main::ldap_server_dn) > 0) {
2018                 my $mesg=$ldap_handle->search(
2019                         base    => $main::ldap_server_dn,
2020                         scope   => 'base',
2021                         attrs   => 'FAIrepository',
2022                         filter  => 'objectClass=FAIrepositoryServer'
2023                 );
2024                 if($mesg->count) {
2025                         foreach my $entry(@{$mesg->{'entries'}}) {
2026                                 foreach my $value(@{$entry->get_value('FAIrepository', asref => 1)}) {
2027                                         my ($server, $tag, $release, $sections)= split /\|/, $value;
2028                                         my $line = "deb $server $release";
2029                                         $sections =~ s/,/ /g;
2030                                         $line.= " $sections";
2031                                         print $fh $line."\n";
2032                                 }
2033                         }
2034                 }
2035         } else {
2036                 &main::daemon_log("$session_id ERROR: something wrong with ldap_server_dn '$main::ldap_server_dn', abort create_sources_list", 1); 
2037         }
2038         close($fh);
2040         return $result;
2044 sub run_create_packages_list_db {
2045     my ($session, $heap) = @_[SESSION, HEAP];
2046         my $session_id = $session->ID;
2048         my $task = POE::Wheel::Run->new(
2049                                         Program => sub {&create_packages_list_db(undef, undef, $session_id)},
2050                                         StdoutEvent  => "session_run_result",
2051                                         StderrEvent  => "session_run_debug",
2052                                         CloseEvent   => "session_run_done",
2053                                         );
2054         $heap->{task}->{ $task->ID } = $task;
2058 sub create_packages_list_db {
2059         my ($ldap_handle, $sources_file, $session_id) = @_;
2060         
2061         # it should not be possible to trigger a recreation of packages_list_db
2062         # while packages_list_db is under construction, so set flag packages_list_under_construction
2063         # which is tested befor recreation can be started
2064         if (-r $packages_list_under_construction) {
2065                 daemon_log("$session_id WARNING: packages_list_db is right now under construction, please wait until this process is finished", 3);
2066                 return;
2067         } else {
2068                 daemon_log("$session_id INFO: create_packages_list_db: start", 5); 
2069                 # set packages_list_under_construction to true
2070                 system("touch $packages_list_under_construction");
2071                 @packages_list_statements=undef;
2072         }
2074         if (not defined $session_id) { $session_id = 0; }
2075         if (not defined $ldap_handle) { 
2076                 $ldap_handle= &get_ldap_handle();
2078                 if (not defined $ldap_handle) {
2079                         daemon_log("$session_id ERROR: no ldap_handle available to create_packages_list_db", 1);
2080                         unlink($packages_list_under_construction);
2081                         return;
2082                 }
2083         }
2084         if (not defined $sources_file) { 
2085                 &main::daemon_log("$session_id INFO: no sources_file given for creating packages list so trigger creation of it", 5); 
2086                 $sources_file = &create_sources_list($session_id);
2087         }
2089         if (not defined $sources_file) {
2090                 &main::daemon_log("$session_id ERROR: no sources_file given under '$sources_file', skip create_packages_list_db", 1); 
2091                 unlink($packages_list_under_construction);
2092                 return;
2093         }
2095         my $line;
2097         open(CONFIG, "<$sources_file") or do {
2098                 daemon_log( "$session_id ERROR: create_packages_list_db: Failed to open '$sources_file'", 1);
2099                 unlink($packages_list_under_construction);
2100                 return;
2101         };
2103         # Read lines
2104         while ($line = <CONFIG>){
2105                 # Unify
2106                 chop($line);
2107                 $line =~ s/^\s+//;
2108                 $line =~ s/^\s+/ /;
2110                 # Strip comments
2111                 $line =~ s/#.*$//g;
2113                 # Skip empty lines
2114                 if ($line =~ /^\s*$/){
2115                         next;
2116                 }
2118                 # Interpret deb line
2119                 if ($line =~ /^deb [^\s]+\s[^\s]+\s[^\s]+/){
2120                         my( $baseurl, $dist, $sections ) = ($line =~ /^deb\s([^\s]+)\s+([^\s]+)\s+(.*)$/);
2121                         my $section;
2122                         foreach $section (split(' ', $sections)){
2123                                 &parse_package_info( $baseurl, $dist, $section, $session_id );
2124                         }
2125                 }
2126         }
2128         close (CONFIG);
2130         find(\&cleanup_and_extract, keys( %repo_dirs ));
2131         $packages_list_db->exec_statementlist(\@packages_list_statements);
2132         unlink($packages_list_under_construction);
2133         daemon_log("$session_id INFO: create_packages_list_db: finished", 5); 
2134         return;
2138 sub parse_package_info {
2139     my ($baseurl, $dist, $section, $session_id)= @_;
2140     my ($package);
2141     if (not defined $session_id) { $session_id = 0; }
2142     my ($path) = ($baseurl =~ m%://[^/]*(.*)$%);
2143     $repo_dirs{ "${repo_path}/pool" } = 1;
2145     foreach $package ("Packages.gz"){
2146         daemon_log("$session_id DEBUG: create_packages_list: fetch $baseurl, $dist, $section", 7);
2147         get_package( "$baseurl/dists/$dist/$section/binary-$arch/$package", "$outdir/$dist/$section", $session_id );
2148         parse_package( "$outdir/$dist/$section", $dist, $path, $session_id );
2149     }
2150     
2154 sub get_package {
2155     my ($url, $dest, $session_id)= @_;
2156     if (not defined $session_id) { $session_id = 0; }
2158     my $tpath = dirname($dest);
2159     -d "$tpath" || mkpath "$tpath";
2161     # This is ugly, but I've no time to take a look at "how it works in perl"
2162     if(0 == system("wget '$url' -O '$dest' 2>/dev/null") ) {
2163         system("gunzip -cd '$dest' > '$dest.in'");
2164         daemon_log("$session_id DEBUG: run command: gunzip -cd '$dest' > '$dest.in'", 5);
2165         unlink($dest);
2166         daemon_log("$session_id DEBUG: delete file '$dest'", 5); 
2167     } else {
2168         daemon_log("$session_id ERROR: create_packages_list_db: get_packages: fetching '$url' failed!", 1);
2169     }
2170     return 0;
2174 sub parse_package {
2175     my ($path, $dist, $srv_path, $session_id)= @_;
2176     if (not defined $session_id) { $session_id = 0;}
2177     my ($package, $version, $section, $description);
2178     my $PACKAGES;
2179     my $timestamp = &get_time();
2181     if(not stat("$path.in")) {
2182         daemon_log("$session_id ERROR: create_packages_list: parse_package: file '$path.in' is not readable",1);
2183         return;
2184     }
2186     open($PACKAGES, "<$path.in");
2187     if(not defined($PACKAGES)) {
2188         daemon_log("$session_id ERROR: create_packages_list_db: parse_package: cannot open '$path.in'",1); 
2189         return;
2190     }
2192     # Read lines
2193     while (<$PACKAGES>){
2194         my $line = $_;
2195         # Unify
2196         chop($line);
2198         # Use empty lines as a trigger
2199         if ($line =~ /^\s*$/){
2200             my $sql = "INSERT INTO packages_list VALUES ('$dist', '$package', '$version', '$section', '', 'none', '$timestamp')";
2201             push(@packages_list_statements, $sql);
2202             $package = "none";
2203             $version = "none";
2204             $section = "none";
2205             $description = "none"; 
2206             next;
2207         }
2209         # Trigger for package name
2210         if ($line =~ /^Package:\s/){
2211             ($package)= ($line =~ /^Package: (.*)$/);
2212             next;
2213         }
2215         # Trigger for version
2216         if ($line =~ /^Version:\s/){
2217             ($version)= ($line =~ /^Version: (.*)$/);
2218             next;
2219         }
2221         # Trigger for description
2222         if ($line =~ /^Description:\s/){
2223             ($description)= ($line =~ /^Description: (.*)$/);
2224             next;
2225         }
2227         # Trigger for section
2228         if ($line =~ /^Section:\s/){
2229             ($section)= ($line =~ /^Section: (.*)$/);
2230             next;
2231         }
2233         # Trigger for filename
2234         if ($line =~ /^Filename:\s/){
2235             my ($filename) = ($line =~ /^Filename: (.*)$/);
2236             store_fileinfo( $package, $filename, $dist, $srv_path, $version, $repo_path );
2237             next;
2238         }
2239     }
2241     close( $PACKAGES );
2242     unlink( "$path.in" );
2243     &main::daemon_log("$session_id DEBUG: unlink '$path.in'", 1); 
2247 sub store_fileinfo {
2248     my( $package, $file, $dist, $path, $vers, $srvdir) = @_;
2250     my %fileinfo = (
2251         'package' => $package,
2252         'dist' => $dist,
2253         'version' => $vers,
2254     );
2256     $repo_files{ "${srvdir}/$file" } = \%fileinfo;
2260 sub cleanup_and_extract {
2261     my $fileinfo = $repo_files{ $File::Find::name };
2263     if( defined $fileinfo ) {
2265         my $dir = "$outdir/$fileinfo->{ 'dist' }/debconf.d";
2266         my $sql;
2267         my $package = $fileinfo->{ 'package' };
2268         my $newver = $fileinfo->{ 'version' };
2270         mkpath($dir);
2271         system( "dpkg -e '$File::Find::name' '$dir/DEBIAN'" );
2273         if( -f "$dir/DEBIAN/templates" ) {
2275             daemon_log("DEBUG: Found debconf templates in '$package' - $newver", 5);
2277             my $tmpl= "";
2278             {
2279                 local $/=undef;
2280                 open FILE, "$dir/DEBIAN/templates";
2281                 $tmpl = &encode_base64(<FILE>);
2282                 close FILE;
2283             }
2284             rmtree("$dir/DEBIAN/templates");
2286             $sql= "update $main::packages_list_tn set template = '$tmpl' where package = '$package' and version = '$newver';";
2288         } else {
2289             $sql= "update $main::packages_list_tn set template = '' where package = '$package' and version = '$newver';";
2290         }
2292         push @packages_list_statements, $sql;
2293     }
2295     return;
2299 #==== MAIN = main ==============================================================
2300 #  parse commandline options
2301 Getopt::Long::Configure( "bundling" );
2302 GetOptions("h|help" => \&usage,
2303         "c|config=s" => \$cfg_file,
2304         "f|foreground" => \$foreground,
2305         "v|verbose+" => \$verbose,
2306         "no-bus+" => \$no_bus,
2307         "no-arp+" => \$no_arp,
2308            );
2310 #  read and set config parameters
2311 &check_cmdline_param ;
2312 &read_configfile;
2313 &check_pid;
2315 $SIG{CHLD} = 'IGNORE';
2317 # forward error messages to logfile
2318 if( ! $foreground ) {
2319   open( STDIN,  '+>/dev/null' );
2320   open( STDOUT, '+>&STDIN'    );
2321   open( STDERR, '+>&STDIN'    );
2324 # Just fork, if we are not in foreground mode
2325 if( ! $foreground ) { 
2326     chdir '/'                 or die "Can't chdir to /: $!";
2327     $pid = fork;
2328     setsid                    or die "Can't start a new session: $!";
2329     umask 0;
2330 } else { 
2331     $pid = $$; 
2334 # Do something useful - put our PID into the pid_file
2335 if( 0 != $pid ) {
2336     open( LOCK_FILE, ">$pid_file" );
2337     print LOCK_FILE "$pid\n";
2338     close( LOCK_FILE );
2339     if( !$foreground ) { 
2340         exit( 0 ) 
2341     };
2344 daemon_log(" ", 1);
2345 daemon_log("$0 started!", 1);
2347 if ($no_bus > 0) {
2348     $bus_activ = "false"
2351 # connect to gosa-si job queue
2352 $job_db = GOSA::DBsqlite->new($job_queue_file_name);
2353 $job_db->create_table($job_queue_tn, \@job_queue_col_names);
2355 # connect to known_clients_db
2356 $known_clients_db = GOSA::DBsqlite->new($known_clients_file_name);
2357 $known_clients_db->create_table($known_clients_tn, \@known_clients_col_names);
2359 # connect to known_server_db
2360 $known_server_db = GOSA::DBsqlite->new($known_server_file_name);
2361 $known_server_db->create_table($known_server_tn, \@known_server_col_names);
2363 # connect to login_usr_db
2364 $login_users_db = GOSA::DBsqlite->new($login_users_file_name);
2365 $login_users_db->create_table($login_users_tn, \@login_users_col_names);
2367 # connect to fai_server_db and fai_release_db
2368 unlink($fai_server_file_name);
2369 $fai_server_db = GOSA::DBsqlite->new($fai_server_file_name);
2370 $fai_server_db->create_table($fai_server_tn, \@fai_server_col_names);
2372 unlink($fai_release_file_name);
2373 $fai_release_db = GOSA::DBsqlite->new($fai_release_file_name);
2374 $fai_release_db->create_table($fai_release_tn, \@fai_release_col_names);
2376 # connect to packages_list_db
2377 unlink($packages_list_file_name);
2378 unlink($packages_list_under_construction);
2379 $packages_list_db = GOSA::DBsqlite->new($packages_list_file_name);
2380 $packages_list_db->create_table($packages_list_tn, \@packages_list_col_names);
2382 # connect to messaging_db
2383 $messaging_db = GOSA::DBsqlite->new($messaging_file_name);
2384 $messaging_db->create_table($messaging_tn, \@messaging_col_names);
2387 # create xml object used for en/decrypting
2388 $xml = new XML::Simple();
2390 # create socket for incoming xml messages
2392 POE::Component::Server::TCP->new(
2393         Port => $server_port,
2394         ClientInput => sub {
2395         my ($kernel, $input) = @_[KERNEL, ARG0];
2396         push(@tasks, $input);
2397         $kernel->yield("next_task");
2398         },
2399     InlineStates => {
2400         next_task => \&next_task,
2401         task_result => \&handle_task_result,
2402         task_done   => \&handle_task_done,
2403         task_debug  => \&handle_task_debug,
2404         child_reap => sub { "Do nothing special. I'm just a comment, but i'm necessary!"  },
2405     }
2406 );
2408 daemon_log("start socket for incoming xml messages at port '$server_port' ", 1);
2410 # create session for repeatedly checking the job queue for jobs
2411 POE::Session->create(
2412         inline_states => {
2413                 _start => \&_start,
2414                 sig_handler => \&sig_handler,
2415         watch_for_new_messages => \&watch_for_new_messages,
2416         watch_for_done_messages => \&watch_for_done_messages,
2417                 watch_for_new_jobs => \&watch_for_new_jobs,
2418         watch_for_done_jobs => \&watch_for_done_jobs,
2419         create_packages_list_db => \&run_create_packages_list_db,
2420         create_fai_server_db => \&run_create_fai_server_db,
2421         create_fai_release_db => \&run_create_fai_release_db,
2422         session_run_result => \&session_run_result,
2423         session_run_debug => \&session_run_debug,
2424         session_run_done => \&session_run_done,
2425         child_reap => sub { "Do nothing special. I'm just a comment, but i'm necessary!"  },
2426         }
2427 );
2430 # import all modules
2431 &import_modules;
2433 # check wether all modules are gosa-si valid passwd check
2435 POE::Kernel->run();
2436 exit;