{"id":2055,"date":"2023-03-28T18:37:39","date_gmt":"2023-03-28T16:37:39","guid":{"rendered":"https:\/\/blog.mhasin.eu\/?p=2055"},"modified":"2023-03-28T18:42:40","modified_gmt":"2023-03-28T16:42:40","slug":"mssql-to-elk","status":"publish","type":"post","link":"https:\/\/blog.mhasin.eu\/?p=2055","title":{"rendered":"MSSQL to ELK"},"content":{"rendered":"\n<p>Nastavenie logstash:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>input {\n    jdbc {\n        jdbc_validate_connection => false\n        # The path to our downloaded jdbc driver\n        jdbc_driver_library => \"\/opt\/mssql-jdbc-12.2.0.jre8.jar\"\n        # The name of the driver class for SqlServer\n        jdbc_driver_class => \"com.microsoft.sqlserver.jdbc.SQLServerDriver\"\n        jdbc_connection_string => \"jdbc:sqlserver:\/\/192.168.1.40:1433;databaseName=epcDev;user=mato;password=mato;encrypt=false;\"\n        jdbc_user => \"hasin\"\n        jdbc_password => \"hasin12345\"\n        statement => \"SELECT * FROM mato\"\n        schedule => \"* * * * *\"\n\n       }\n}\n\n\nfilter { }\n\n\noutput {\n    elasticsearch {\n        \"hosts\" => \"localhost:9200\"\n        \"index\" => \"index_name\"\n\n\n    }\n\n}\n\n\n<\/code><\/pre>\n<div class=\"pdf24Plugin-cp\"> \t<form name=\"pdf24Form0\" method=\"post\" action=\"https:\/\/doc2pdf.pdf24.org\/wordpress.php\" target=\"pdf24PopWin\" onsubmit=\"var pdf24Win = window.open('about:blank', 'pdf24PopWin', 'resizable=yes,scrollbars=yes,width=600,height=250,left='+(screen.width\/2-300)+',top='+(screen.height\/3-125)+''); pdf24Win.focus(); if(typeof pdf24OnCreatePDF === 'function'){void(pdf24OnCreatePDF(this,pdf24Win));}\"> \t\t<input type=\"hidden\" name=\"blogCharset\" value=\"Cw1x07UAAA==\" \/><input type=\"hidden\" name=\"blogPosts\" value=\"MwQA\" \/><input type=\"hidden\" name=\"blogUrl\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLQUA\" \/><input type=\"hidden\" name=\"blogName\" value=\"c\/LxdwcA\" \/><input type=\"hidden\" name=\"blogValueEncoding\" value=\"gzdeflate base64\" \/><input type=\"hidden\" name=\"postId_0\" value=\"MzIwNQUA\" \/><input type=\"hidden\" name=\"postTitle_0\" value=\"8w0ODvRRKMlXcPXxBgA=\" \/><input type=\"hidden\" name=\"postLink_0\" value=\"yygpKSi20tdPyslP18vNSCzOzNNLLdW3L7A1MjA1BQA=\" \/><input type=\"hidden\" name=\"postAuthor_0\" value=\"y00syfcwNAIA\" \/><input type=\"hidden\" name=\"postDateTime_0\" value=\"MzIwMtY1MNY1slAwtLAyMLYytgQA\" \/><input type=\"hidden\" name=\"postContent_0\" value=\"dVLBctsgEL3rKxj1lhkjS3Y7iSzp0qSnNJ3GuWswrCJcBASQ3Uwm\/15AcZR4pujArnj73rK8pNLNHbGOHEByQEI9+tj2ZZXpJvGr0gYQFcTaOj3qxU4o+mdBFYO0qcLWcKlHh14S5Nee7ehbeErbAxGcEQctVVICdVxJVDeoI8LCO\/ILeugBaeJ65BRSo0FMHaVQhAGbWJnhBzCfqad\/reA7Q8xzYE0zpV02WPskFgGyyAtc4CXeG7jEe2LSM0VJBkCqQ87HE9t0V9Qpg7ZPYgvmf6oTLmhSNeCBU6Os6hz20jZW4YDG29+3E8l1LEs\/c80zaa0zXD5GwnBUvvOUWZZfFTj\/dolzvF6W+Xq12viJkh2xcOcvUIOm13DYjB5fD8SpjfatHZVhUwaSmmft6jjyzVkHoSiK9sRyeXZ44pkBebFaf51R3isOBpAuIrY3tzffH9AF+nH\/6ycK2h+QtAc2CojAC\/T2pckJ8Jq8erd1XDjfzwsKiRrdbC3w43acWiCG9h88lvbKOptGWu9NIkJeXhXL5aydcsng74SJYRve3Wsnk3KUrrJoZ+97A03yDw==\" \/> \t\t<a href=\"https:\/\/www.pdf24.org\" target=\"_blank\" title=\"www.pdf24.org\" rel=\"nofollow\"><img src=\"https:\/\/blog.mhasin.eu\/wp-content\/plugins\/pdf24-post-to-pdf\/img\/pdf_32x32.png\" alt=\"\" border=\"0\" height=\"32\" \/><\/a> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<span class=\"pdf24Plugin-cp-text\">Send article as PDF<\/span> \t\t<span class=\"pdf24Plugin-cp-space\">\u00a0\u00a0<\/span> \t\t<input class=\"pdf24Plugin-cp-input\" style=\"margin: 0px;\" type=\"text\" name=\"sendEmailTo\" placeholder=\"Enter email address\" \/> \t\t<input class=\"pdf24Plugin-cp-submit\" style=\"margin: 0px;\" type=\"submit\" value=\"Send\" \/> \t<\/form> <\/div>","protected":false},"excerpt":{"rendered":"Nastavenie logstash: \u00a0\u00a0 Send article as PDF \u00a0\u00a0\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"arc_restricted_post":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2055","post","type-post","status-publish","format-standard","hentry","category-nezaradene"],"_links":{"self":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/2055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2055"}],"version-history":[{"count":2,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/2055\/revisions"}],"predecessor-version":[{"id":2057,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=\/wp\/v2\/posts\/2055\/revisions\/2057"}],"wp:attachment":[{"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mhasin.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}