{"id":251,"date":"2007-10-30T23:56:10","date_gmt":"2007-10-30T22:56:10","guid":{"rendered":"https:\/\/bob-team.de\/wordpress\/?p=251"},"modified":"2022-05-24T21:57:55","modified_gmt":"2022-05-24T19:57:55","slug":"datenbank-logging","status":"publish","type":"post","link":"https:\/\/bob-team.de\/wordpress\/2007\/10\/30\/datenbank-logging\/","title":{"rendered":"Datenbank Logging"},"content":{"rendered":"<p><img src='https:\/\/bob-team.de\/wordpress\/wp-content\/uploads\/2007\/10\/tos_logging.png' alt='Screenshot TOS' \/><\/p>\n<p>Die Aufgabe: das Logging eines t\u00e4glich laufenden Jobs soll in einer MySQL-Tabelle erfasst werden.<\/p>\n<p><!--more--><\/p>\n<p>Die L\u00f6sung: per <em>phpMyAdmin<\/em> eine neue Datenbank <em>talend_logs<\/em> anlegen. Einen &#8222;Neuen Benutzer hinzuf\u00fcgen&#8220; (z.B. <em>talend<\/em>). Diesem alle Rechte auf Datenbanken &#8211; die mit dem Benuterznamen beginnen (talend_%) &#8211; gew\u00e4hren. Folgendes SQL-Skript auf die neue Datenbank anwenden:<\/p>\n<pre lang=\"sql\">DROP TABLE IF EXISTS `talend_logs`.`tflows`;\r\nCREATE TABLE  `talend_logs`.`tflows` (\r\n  `moment` datetime default NULL,\r\n  `pid` varchar(20) default NULL,\r\n  `father_pid` varchar(20) default NULL,\r\n  `root_pid` varchar(20) default NULL,\r\n  `system_pid` bigint(20) default NULL,\r\n  `project` varchar(50) default NULL,\r\n  `job` varchar(50) default NULL,\r\n  `job_repository_id` varchar(255) default NULL,\r\n  `job_version` varchar(255) default NULL,\r\n  `context` varchar(50) default NULL,\r\n  `origin` varchar(255) default NULL,\r\n  `label` varchar(255) default NULL,\r\n  `count` int(11) default NULL,\r\n  `reference` int(11) default NULL,\r\n  `thresholds` varchar(255) default NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\r\n\r\nDROP TABLE IF EXISTS `talend_logs`.`tlogs`;\r\nCREATE TABLE  `talend_logs`.`tlogs` (\r\n  `moment` datetime default NULL,\r\n  `pid` varchar(20) default NULL,\r\n  `root_pid` varchar(20) default NULL,\r\n  `father_pid` varchar(20) default NULL,\r\n  `project` varchar(50) default NULL,\r\n  `job` varchar(50) default NULL,\r\n  `context` varchar(50) default NULL,\r\n  `priority` int(3) default NULL,\r\n  `type` varchar(255) default NULL,\r\n  `origin` varchar(255) default NULL,\r\n  `message` varchar(255) default NULL,\r\n  `code` int(3) default NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\r\n\r\nDROP TABLE IF EXISTS `talend_logs`.`tstats`;\r\nCREATE TABLE  `talend_logs`.`tstats` (\r\n  `moment` datetime default NULL,\r\n  `pid` varchar(20) default NULL,\r\n  `father_pid` varchar(20) default NULL,\r\n  `root_pid` varchar(20) default NULL,\r\n  `system_pid` bigint(20) default NULL,\r\n  `project` varchar(50) default NULL,\r\n  `job` varchar(50) default NULL,\r\n  `job_repository_id` varchar(255) default NULL,\r\n  `job_version` varchar(255) default NULL,\r\n  `context` varchar(50) default NULL,\r\n  `origin` varchar(255) default NULL,\r\n  `message_type` varchar(255) default NULL,\r\n  `message` varchar(255) default NULL,\r\n  `duration` bigint(20) default NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;<\/pre>\n<p>Bei den Properties eines Jobs kann unter dem Reiter &#8222;Stats &#038; Logs&#8220; (siehe Abbildung) das Logging aktiviert und auf die Datenbank umgebogen werden. <\/p>\n<ul>\n<li>Stats Table: &#8222;tstats&#8220;<\/li>\n<li>Logs Table: &#8222;tlogs&#8220;<\/li>\n<li>Meter Table: &#8222;tflows&#8220;<\/li>\n<\/ul>\n<p>Anmerkung: diese Einstellungen macht das setzen einzelner <em>tStatsCatcher<\/em>, <em>tLogCatcher<\/em> und <em>tMeterFlowCatcher<\/em> \u00fcberfl\u00fcssig.<\/p>\n<p>Tipp: die &#8222;Stats &#038; Logs&#8220; Einstellungen k\u00f6nnen f\u00fcr alle neuen Jobs im Men\u00fc <em>Preferences &raquo; Talend &raquo; Stats &#038; Logs &raquo; Java<\/em> definiert werden.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Die Aufgabe: das Logging eines t\u00e4glich laufenden Jobs soll in einer MySQL-Tabelle erfasst werden.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[30,22],"class_list":["post-251","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-mysql","tag-talend-open-studio","entry"],"_links":{"self":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":1,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":2766,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/posts\/251\/revisions\/2766"}],"wp:attachment":[{"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bob-team.de\/wordpress\/wp-json\/wp\/v2\/tags?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}