X-Git-Url: https://git.tokkee.org/?a=blobdiff_plain;f=gosa-si%2Fgosa-si-server;h=048089fbf0e3e28bda4d364b5494c04c3f525883;hb=ed91e18dc0bb59b019f2930b96bf47417a49289e;hp=9d48dc4ff217c3804045b8075108a3476f52f743;hpb=cb9af9baa8c60fbb85b9a09eb43838a89f5d3523;p=gosa.git

diff --git a/gosa-si/gosa-si-server b/gosa-si/gosa-si-server
index 9d48dc4ff..048089fbf 100755
--- a/gosa-si/gosa-si-server
+++ b/gosa-si/gosa-si-server
@@ -64,6 +64,7 @@ my (%cfg_defaults, $foreground, $verbose, $ping_timeout);
 my ($bus_activ, $bus, $msg_to_bus, $bus_cipher);
 my ($server);
 my ($gosa_server, $job_queue_timeout, $job_queue_loop_delay);
+my ($messaging_db_loop_delay);
 my ($known_modules);
 my ($pid_file, $procid, $pid, $log_file);
 my ($arp_activ, $arp_fifo);
@@ -123,6 +124,7 @@ my @job_queue_col_names = ("id INTEGER",
 		"targettag DEFAULT 'none'", 
 		"xmlmessage DEFAULT 'none'", 
 		"macaddress DEFAULT 'none'",
+		"plainname DEFAULT 'none'",
 		);
 
 # holds all other gosa-sd as well as the gosa-sd-bus
@@ -162,7 +164,7 @@ my $arch = "i386";
 # holds all messages which should be delivered to a user
 our $messaging_db;
 our $messaging_tn = "messaging"; 
-our @messaging_col_names = ('subject', 'from', 'to', 'flag', 'direction', 'delivery_time', 'message', 'timestamp', 'id INTEGER', );
+our @messaging_col_names = ('subject', 'message_from', 'message_to', 'flag', 'direction', 'delivery_time', 'message', 'timestamp', 'id INTEGER' );
 my $messaging_file_name;
 
 # path to directory to store client install log files
@@ -203,6 +205,7 @@ my $max_children = 2;
     "port" => [\$gosa_port, "20082"],
     "job-queue" => [\$job_queue_file_name, '/var/lib/gosa-si/jobs.db'],
     "job-queue-loop-delay" => [\$job_queue_loop_delay, 3],
+    "messaging-db-loop-delay" => [\$messaging_db_loop_delay, 3],
     "key" => [\$GosaPackages_key, "none"],
     },
 "SIPackages" => {
@@ -1235,6 +1238,8 @@ sub trigger_db_loop {
 	my ($kernel) = @_ ;
 	$kernel->delay_set('watch_for_new_jobs', $job_queue_loop_delay);
 	$kernel->delay_set('watch_for_done_jobs', $job_queue_loop_delay); 
+    $kernel->delay_set('watch_for_new_messages', $messaging_db_loop_delay);
+    $kernel->delay_set('watch_for_done_messages', $messaging_db_loop_delay);
 }
 
 sub watch_for_done_jobs {
@@ -1334,6 +1339,87 @@ sub watch_for_new_jobs {
 }
 
 
+sub watch_for_new_messages {
+    my ($kernel,$heap) = @_[KERNEL, HEAP];
+    my @coll_user_msg;   # collection list of outgoing messages
+    
+    # check messaging_db for new incoming messages with executable timestamp
+    my $timestamp = &get_time();
+    #my $sql_statement = "SELECT * FROM $messaging_tn WHERE (CAST (delivery_time AS INTEGER) + 120) < $timestamp";
+    my $sql_statement = "SELECT * FROM $messaging_tn WHERE ( (CAST(timestamp AS INTEGER))<$timestamp AND flag='n' AND direction='in' )";
+    my $res = $messaging_db->exec_statement( $sql_statement );
+
+ 	foreach my $hit (@{$res}) {
+
+        # create outgoing messages
+        my $message_to = @{$hit}[2];
+
+        # translate message_to to plain login name
+        my @reciever_l = ($message_to);  
+        my $message_id = @{$hit}[8];
+
+        #add each outgoing msg to messaging_db
+        my $reciever;
+        foreach $reciever (@reciever_l) {
+            my $sql_statement = "INSERT INTO $messaging_tn (subject, message_from, message_to, flag, direction, delivery_time, message, timestamp, id) ".
+                "VALUES ('".
+                @{$hit}[0]."', '".   # subject
+                @{$hit}[1]."', '".   # message_from
+                $reciever."', '".    # message_to
+                "none"."', '".       # flag
+                "out"."', '".        # direction
+                @{$hit}[5]."', '".   # delivery_time
+                @{$hit}[6]."', '".   # message
+                $timestamp."', '".   # timestamp
+                @{$hit}[8].          # id
+                "')";
+            &daemon_log("M DEBUG: $sql_statement", 1);
+            my $res = $messaging_db->exec_statement($sql_statement);
+            &daemon_log("M INFO: message '".@{$hit}[8]."' is prepared for delivery to reciever '$reciever'", 5);
+        }
+
+        # send outgoing messages
+        my $sql_statement = "SELECT * FROM $messaging_tn WHERE ( flag='p' AND direction='out' )";
+        my $res = $messaging_db->exec_statement( $sql_statement );
+        foreach my $hit (@{$res}) {
+            # add subject, from, to and message to list coll_user_msg
+            my @user_msg = [@{$hit}[0], @{$hit}[1], $reciever, @{$hit}[6]];
+            push( @coll_user_msg, \@user_msg);
+        }
+
+        # send outgoing list to myself (gosa-si-server) to deliver each message to user
+        # reason for this workaround: if to much messages have to be delivered, it can come to 
+        # denial of service problems of the server. so, the incoming message list can be processed
+        # by a forked child and gosa-si-server is always ready to work. 
+        my $collection_out_msg = &create_xml_hash("collection_user_messages", $server_address, $server_address);
+        # add to hash 'msg1' => [subject, from, to, message]
+        # hash to string
+        # send msg to myself
+# TODO
+
+        # set incoming message to flag d=deliverd
+        $sql_statement = "UPDATE $messaging_tn SET flag='p' WHERE id='$message_id'"; 
+        &daemon_log("M DEBUG: $sql_statement", 7);
+        $res = $messaging_db->update_dbentry($sql_statement);
+        &daemon_log("M INFO: message '".@{$hit}[8]."' is set to flag 'p' (processed)", 5);
+
+    }
+    
+    $kernel->delay_set('watch_for_new_messages', $messaging_db_loop_delay); 
+
+
+    return;
+}
+
+
+sub watch_for_done_messages {
+    my ($kernel,$heap) = @_[KERNEL, HEAP];
+
+    $kernel->delay_set('watch_for_done_messages', $messaging_db_loop_delay); 
+    return;
+}
+
+
 sub get_ldap_handle {
 	my ($session_id) = @_;
 	my $heap;
@@ -1512,7 +1598,7 @@ sub change_goto_state {
 
 
 sub create_fai_server_db {
-    my ($table_name, $kernel) = @_;
+    my ($table_name, $kernel, $dont_create_packages_list) = @_;
 	my $result;
     my $ldap_handle = &get_ldap_handle();
 	if(defined($ldap_handle)) {
@@ -1546,7 +1632,9 @@ sub create_fai_server_db {
 		daemon_log("INFO: create_fai_server_db: finished", 5);
 
 		# TODO: Find a way to post the 'create_packages_list_db' event
-		&create_packages_list_db($ldap_handle);
+		if(!defined($dont_create_packages_list)) {
+			&create_packages_list_db;
+		}
 	}	
     
     $ldap_handle->disconnect;
@@ -1568,12 +1656,15 @@ sub run_create_fai_server_db {
 
 
 sub create_fai_release_db {
-	my ($table_name) = @_;
+	my ($table_name, $session_id) = @_;
 	my $result;
 
+    # used for logging
+    if (not defined $session_id) { $session_id = "0"; }
+
     my $ldap_handle = &get_ldap_handle();
 	if(defined($ldap_handle)) {
-		daemon_log("INFO: create_fai_release_db: start",5);
+		daemon_log("$session_id INFO: create_fai_release_db: start",5);
 		my $mesg= $ldap_handle->search(
 			base   => $ldap_base,
 			scope  => 'sub',
@@ -1606,18 +1697,20 @@ sub create_fai_release_db {
 					}
 				}
 			}
-			daemon_log("DEBUG: Inserting ".scalar @sql_list." entries to DB",6);
+			daemon_log("$session_id DEBUG: Inserting ".scalar @sql_list." entries to DB",6);
 			if(@sql_list) {
 				unshift @sql_list, "DELETE FROM $table_name";
 				$fai_server_db->exec_statementlist(\@sql_list);
 			}
-			daemon_log("DEBUG: Done with inserting",6);
+			daemon_log("$session_id DEBUG: Done with inserting",6);
 		}
-		daemon_log("INFO: create_fai_release_db: finished",5);
+		daemon_log("$session_id INFO: create_fai_release_db: finished",5);
 	}
     $ldap_handle->disconnect;
 	return $result;
 }
+
+
 sub run_create_fai_release_db {
     my ($session, $heap, $table_name) = @_[SESSION, HEAP, ARG0];
     my $task = POE::Wheel::Run->new(
@@ -1870,7 +1963,7 @@ sub session_run_done {
 }
 
 sub create_sources_list {
-    my ($ldap_handle) = @_;
+    my $ldap_handle = &get_ldap_handle;
 	my $result="/tmp/gosa_si_tmp_sources_list";
 
 	# Remove old file
@@ -1889,11 +1982,13 @@ sub create_sources_list {
 				);
 		if($mesg->count) {
 			foreach my $entry(@{$mesg->{'entries'}}) {
-				my ($server, $tag, $release, $sections)= split /\|/, $entry->get_value('FAIrepository');
-				my $line = "deb $server $release";
-				$sections =~ s/,/ /g;
-				$line.= " $sections";
-				print $fh $line."\n";
+				foreach my $value(@{$entry->get_value('FAIrepository', asref => 1)}) {
+					my ($server, $tag, $release, $sections)= split /\|/, $value;
+					my $line = "deb $server $release";
+					$sections =~ s/,/ /g;
+					$line.= " $sections";
+					print $fh $line."\n";
+				}
 			}
 		}
 	}
@@ -1903,7 +1998,7 @@ sub create_sources_list {
 }
 
 sub create_packages_list_db {
-    my ($ldap_handle, $sources_file) = @_ ;
+    my ($ldap_handle, $sources_file);
 
 	if (not defined $ldap_handle) { 
 		$ldap_handle= &get_ldap_handle();
@@ -2189,6 +2284,7 @@ $login_users_db = GOSA::DBsqlite->new($login_users_file_name);
 $login_users_db->create_table($login_users_tn, \@login_users_col_names);
 
 # connect to fai_server_db and fai_release_db
+unlink($fai_server_file_name);
 $fai_server_db = GOSA::DBsqlite->new($fai_server_file_name);
 $fai_server_db->create_table($fai_server_tn, \@fai_server_col_names);
 $fai_server_db->create_table($fai_release_tn, \@fai_release_col_names);
@@ -2231,6 +2327,8 @@ POE::Session->create(
 	inline_states => {
 		_start => \&_start,
 		sig_handler => \&sig_handler,
+        watch_for_new_messages => \&watch_for_new_messages,
+        watch_for_done_messages => \&watch_for_done_messages,
 		watch_for_new_jobs => \&watch_for_new_jobs,
         watch_for_done_jobs => \&watch_for_done_jobs,
         create_packages_list_db => \&run_create_packages_list_db,