![[tokkee]](http://tokkee.org/images/avatar.png){kind=avatar}
diff --git a/trunk/gosa-plugins/log/addons/logview/class_gosa_logview.inc b/trunk/gosa-plugins/log/addons/logview/class_gosa_logview.inc
--- /dev/null
@@ -0,0 +1,427 @@
+<?php
+
+class gosa_logview extends plugin
+{
+ /* Definitions */
+ var $plHeadline= "System logs";
+ var $plDescription= "This does something";
+
+ /* attribute list for save action */
+ var $attributes = array();
+ var $objectclasses = array();
+
+ var $server = "";
+ var $action = "modify";
+ var $time = 2;
+ var $regex = "*";
+
+ var $start = 0;
+ var $sort = 1;
+
+ var $sort_direction = "down";
+ var $fields = array("action","timestamp","user","objecttype","object","result","repeated");
+ var $range = 25;
+ var $view_logged = FALSE;
+ var $location = "";
+ var $location_id = -1;
+ var $timezone_offset = 0;
+
+ var $uid_map = array();
+
+
+ function gosa_logview (&$config, $dn= NULL)
+ {
+ /* Include config object */
+ $this->config= &$config;
+ $this->ui = get_userinfo();
+ $this->location = $this->config->current['BASE'];
+
+ /* Restore last filter settings */
+ $logview = session::get('logview');
+ foreach(array("action","server","time","regex") as $attr){
+ if(isset($logview['gosa_log'][$attr])){
+ $this->$attr = $logview['gosa_log'][$attr];
+ }
+ }
+
+ $tz = timezone::get_default_timezone();
+ $this->timezone_offset = $tz['value'] * 60 * 60 ;
+
+ $ldap = $this->config->get_ldap_link();
+ $ldap->search("(&(objectClass=person)(uid=*))",array("uid","dn"));
+ while($attrs = $ldap->fetch()){
+ $this->uid_map[$attrs['dn']] = $attrs['uid'][0];
+ }
+ }
+
+
+ function execute()
+ {
+ /* Call parent execute */
+ plugin::execute();
+
+ /* Log view */
+ if(!$this->view_logged){
+ $this->view_logged = TRUE;
+ new log("view","gosa_logging/".get_class($this),$this->dn);
+ }
+
+ /* Time interval */
+ $date_select = array(
+ "0" => _("one hour"), "1" => _("6 hours"),
+ "2" => _("12 hours"), "3" => _("24 hours"),
+ "4" => _("2 days"), "5" => _("one week"),
+ "6" => _("2 weeks"), "7" => _("one month"));
+
+
+ $time = time();
+ $date_select_ = array(
+ "0" => $time - 3600,
+ "1" => $time - 21600,
+ "2" => $time - 43200,
+ "3" => $time - 86400,
+ "4" => $time - 172800,
+ "5" => $time - 604800,
+ "6" => $time - 1209600,
+ "7" => $time - 2419200);
+
+ $smarty= get_smarty();
+ $smarty->assign("search_result", "");
+ $smarty->assign("plug", "?plug=".validate($_GET['plug']));
+ $smarty->assign("search_image", get_template_path('images/lists/search.png'));
+ $smarty->assign("time_image", get_template_path('plugins/log/images/time.png'));
+ $smarty->assign("server_image", get_template_path('plugins/systems/images/server.png'));
+ $smarty->assign("log_image", get_template_path('plugins/logview/images/log_warning.png'));
+ $smarty->assign("ruleset_image", get_template_path('images/lists/edit.png'));
+ $smarty->assign("launchimage", get_template_path('images/launch.png'));
+ $smarty->assign("date_select", $date_select);
+ $smarty->assign("actions", array());
+ $smarty->assign("direction", "up");
+ $smarty->assign("mode0", "");
+ $smarty->assign("mode1", "");
+ $smarty->assign("mode2", "");
+ $smarty->assign("mode3", "");
+ $smarty->assign("mode4", "");
+ $smarty->assign("mode5", "");
+ $smarty->assign("mode6", "");
+
+ /* Assign select option content */
+ foreach( array("server", "action", "time", "regex") as $type){
+ $smarty->assign("$type", $this->$type);
+ }
+
+ /****
+ * Check if defined servers
+ * and mysql extension
+ ****/
+ if (!isset($this->config->data['SERVERS']['LOGGING']) || !count($this->config->data['SERVERS']['LOGGING'])){
+ msg_dialog::display(_("Warning"), msgPool::noserver("GOsa log"), WARNING_DIALOG);
+ $smarty->assign("servers", array());
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+ if(!is_callable("mysql_connect")){
+ msg_dialog::display(_("Configuration error"), sprintf(_("Missing %s PHP extension!"), "mysql"), WARNING_DIALOG);
+ $smarty->assign("servers", array());
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+ /****
+ * Get Configurations
+ ****/
+ $list_of_servers = $this->config->data['SERVERS']['LOGGING'];
+ $servers = array();
+ foreach($list_of_servers as $servername => $data){
+ $servers[$servername] = $servername;
+ }
+ $smarty->assign("servers", $servers);
+
+ /* Set a default server, if there is currently no valid server selected */
+ if(empty($this->server) || !in_array($this->server,$servers)){
+ $this->server = key($servers);
+ }
+
+ /****
+ * Connect to currently selected server
+ ****/
+ $cfg = $list_of_servers[$this->server];
+
+ $link = @mysql_pconnect($this->server, $cfg['USER'], $cfg['PWD']);
+ if ($link === FALSE){
+ msg_dialog::display(_("Error"), msgPool::dbconnect($this->server,@mysql_error(),"GOsa LOG"), ERROR_DIALOG);
+ new log("debug","gosa_logging","dbconnect",array(),@mysql_error());
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+ /* check if log database is available */
+ if (! @mysql_select_db($cfg['DB'])){
+ msg_dialog::display(_("Error"), msgPool::dbselect($cfg['DB'],@mysql_error(), "GOsa LOG"), ERROR_DIALOG);
+ new log("debug","gosa_logging","selectdb",array(),@mysql_error());
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+
+ /****
+ * Get location_id.
+ ****/
+
+ if($this->location_id == -1){
+ $actions = array("!ALL" => _("All"));
+ $query = "SELECT id FROM gosa_locations WHERE location='".mysql_escape_string($this->location)."';";
+ $res = @mysql_query($query);
+ if($res){
+ $attrs = @mysql_fetch_assoc($res);
+ if(isset($attrs['id'])){
+ $this->location_id = $attrs['id'];
+ }
+ }
+ }
+
+ /****
+ * Get all action types
+ ****/
+
+ $actions = array("!ALL" => _("All"));
+ $query = "SELECT distinct(action) FROM gosa_log WHERE location_id='".$this->location_id."'; ";
+ $res = @mysql_query($query);
+ while($attrs = @mysql_fetch_assoc($res)){
+ $actions[$attrs['action']] = $attrs['action'];
+ }
+
+
+ /****
+ * Check Acls
+ ****/
+
+ $ui = get_userinfo();
+ $dn = $list_of_servers[$this->server]['DN'];
+ $acls = $ui->get_permissions($dn,"server/gosaLogServer","viewEntries");
+
+ if(!preg_match("/r/",$acls)){
+ $res = "<tr>
+ <td colspan=".count($this->fields).">
+ "._("You have insufficient permissions to view syslog entries.")."
+ </td>
+ </tr>";
+
+ /* Show main page */
+ $smarty->assign("range_selector", "");
+ $smarty->assign("search_result", $res);
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+ /* Prepare order setting */
+ if ($this->sort_direction == "down"){
+ $desc= "DESC";
+ $sort_sign = "<img src='images/lists/sort-down.png' alt='\/' class='center' title='down' border=0>";
+ } else {
+ $desc= "";
+ $sort_sign = "<img src='images/lists/sort-up.png' alt='/\' class='center' title='up' border=0>";
+ }
+
+ /****
+ * Query stuff
+ ****/
+
+ /* Check for required tables
+ */
+ $query = "SHOW TABLES;";
+ $res = @mysql_query($query,$link);
+ $tables = array();
+ while($attrs = @mysql_fetch_row($res)){
+ $tables[] = $attrs[0];
+ }
+ $error = FALSE;
+ foreach(array("gosa_log","gosa_locations") as $required){
+ if(!in_array($required,$tables)){
+ msg_dialog::display(_("Error"),
+ sprintf(_("Missing logging table (%s.%s) update your GOsa logging database schema."),
+ $cfg['DB'],$required), ERROR_DIALOG);
+ $error = TRUE;
+ }
+ }
+ if(!$error){
+
+ /* Get start time */
+ $start = $date_select_[$this->time];
+
+ /* Prepare search filter */
+ $sql_regex =trim(preg_replace("/\*/","%",$this->regex));
+ $sql_regex = "%".trim($sql_regex,"%")."%";
+
+ /* Create search filter */
+ $query_base= "FROM gosa_log WHERE timestamp >= $start ";
+
+ /* Append action filter */
+ if($this->action != "!ALL"){
+ $query_base .=" AND action like '".$this->action."' ";
+ }
+
+ /* Append search filter */
+ if($sql_regex != "%%"){
+ $query_base .=" AND ( result like '".$sql_regex."' OR user like '".$sql_regex."') ";
+ }
+
+ /* Appen location */
+ $query_base .= " AND location_id='".$this->location_id."' ";
+
+ /* Get number of entries */
+ $query= "SELECT COUNT(`user`) ".$query_base.";";
+ $result = mysql_query($query);
+ if(!$result){
+ new log("debug","gosa_logging","",array(),@mysql_error());
+ }
+ $line= mysql_fetch_array($result, MYSQL_ASSOC);
+ $count= $line['COUNT(`user`)'];
+ if ($count > 25){
+ $smarty->assign("range_selector", range_selector($count, $this->start, $this->range,"EntriesPerPage"));
+ } else {
+ $smarty->assign("range_selector", "");
+ }
+
+ /* Query results that will be displayed */
+ $query= "SELECT * ".$query_base." ORDER BY ".$this->fields[$this->sort]." ".$desc." LIMIT ".$this->start.",".$this->range.";";
+ @DEBUG (DEBUG_MYSQL, __LINE__, __FUNCTION__, __FILE__, $query, "Database query");
+ $result = @mysql_query($query);
+
+ if(!$result){
+ msg_dialog::display(_("Error"), msgPool::dbquery("gosa_log",@mysql_error(), "GOsa LOG"), ERROR_DIALOG);
+ new log("debug","gosa_logging","querydb",array(),@mysql_error());
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+ /* Display results */
+ $mod= 0;
+
+ /* Add entries to result str */
+ $res = "";
+ while ($line = mysql_fetch_array($result, MYSQL_ASSOC)){
+
+ /* Toggle background color */
+ if ( ($mod++) & 1){
+ $col= "background-color: #ECECEC;";
+ } else {
+ $col= "background-color: #F5F5F5;";
+ }
+
+ $base = ", ".substr($this->config->current['BASE'],0,5)."...";
+
+ if(isset($this->uid_map[$line['user']])){
+ $user = $this->uid_map[$line['user']];
+ }else{
+ $user = preg_replace("/,".preg_quote($this->config->current['BASE'], '/')."/",$base,$line['user']);
+ }
+ $object = preg_replace("/,".preg_quote($this->config->current['BASE'], '/')."/",$base,$line['object']);
+
+ $res.=" <tr style=\"$col\">\n";
+ $res.=" <td title='".$line['objecttype']."'>".$line['action']."</td>";
+ $res.=" <td>".date("H:i:s d.m.Y",($line['timestamp'] + $this->timezone_offset))."</td>";
+ $res.=" <td title='".$line['user']."'>".preg_replace("/,/",", ",$user)."</td>";
+ $res.=" <td title='".$line['objecttype']."'>".$line['objecttype']."</td>";
+ $res.=" <td title='".$line['object']."'>".preg_replace("/,/",", ",LDAP::fix($object))."</td>";
+ $res.=" <td>".$line['result']."</td>";
+ $res.=" </tr>\n";
+ }
+ }
+ @mysql_close($link);
+ $smarty->assign("mode".$this->sort, $sort_sign);
+ $smarty->assign("search_result", $res);
+
+ $smarty->assign("regex", $this->regex);
+ $smarty->assign("server",$this->server);
+ $smarty->assign("servers",$servers);
+ $smarty->assign("action",$this->action);
+ $smarty->assign("actions",$actions);
+ $smarty->assign("date_select", $date_select);
+
+ $smarty->assign("direction", $this->sort_direction);
+
+ /* Show main page */
+ return ($smarty->fetch (get_template_path('gosa_log_contents.tpl', TRUE)));
+ }
+
+
+ function save_object()
+ {
+ /* Get submitted range */
+ if(isset($_POST['EntriesPerPage'])){
+ if(is_numeric($_POST['EntriesPerPage'])){
+ $this->range = $_POST['EntriesPerPage'];
+ }
+ }
+
+ /* Get actual select boxe values */
+ $logfilter_changed = FALSE;
+ foreach( array("server", "action","time","regex") as $type){
+ if(isset($_POST[$type])){
+ if($type == "server" && $this->server != $_POST['server']){
+ $this->location_id = -1;
+ }
+ $this->$type = $_POST[$type];
+ }
+ }
+
+ /* Filter regex values */
+ if ($this->regex == ""){
+ $this->regex= '*';
+ } else {
+ $new = preg_replace('/\*\**/', '*', $this->regex);
+ $this->regex= $new;
+ }
+
+ /* Set start value */
+ if (isset($_GET['start'])){
+ $this->start= (int)$_GET['start'];
+ }
+
+ /* Reset page number if filter has changed */
+ if ($logfilter_changed > 0){
+ $this->start= 0;
+ }
+
+ /* Adapt sorting */
+ if (isset($_GET['sort'])){
+
+ if($_GET['direction'] == "up"){
+ $this->sort_direction = "down";
+ }else{
+ $this->sort_direction = "up";
+ }
+
+ $this->sort= (int)$_GET['sort'];
+ if ($this->sort < 0 || $this->sort > count($this->fields)){
+ $this->sort= 0;
+ }
+ }
+
+ /* Save attributes in Sessiob, so we are able to recontruct filter on plugin reload */
+ $logview = session::get('logview');
+ $logview['gosa_log'] = array();
+
+ foreach(array("action","server","time","regex") as $attr){
+ $logview['gosa_log'][$attr] = $this->$attr;
+ }
+ session::set('logview',$logview);
+ }
+
+
+ /* Return plugin informations for acl handling
+ #FIXME You can only read attributes within this report plugin
+ static function plInfo()
+ {
+ return (array(
+ "plShortName" => _("Log view"),
+ "plDescription" => _("Log view addon"),
+ "plSelfModify" => FALSE,
+ "plDepends" => array(),
+ "plPriority" => 0,
+ "plSection" => array("addon"),
+ "plCategory" => array("logview" => array("objectClass" => "none", "description" => _("System logs"))),
+
+ "plProvidedAcls" => array()
+ ));
+ }
+ */
+}
+// vim:tabstop=2:expandtab:shiftwidth=2:filetype=php:syntax:ruler:
+?>