{"id":892,"date":"2014-06-18T02:29:35","date_gmt":"2014-06-18T05:29:35","guid":{"rendered":"http:\/\/www.viazap.com.br\/?p=892"},"modified":"2014-06-18T02:29:35","modified_gmt":"2014-06-18T05:29:35","slug":"instalando-syslog-ng-com-mysql","status":"publish","type":"post","link":"https:\/\/blog.clusterweb.com.br\/?p=892","title":{"rendered":"Instalando Syslog-ng com Mysql"},"content":{"rendered":"<p><strong>1 \u2013 Primeiro instalamos os seguintes pacotes:<\/strong><\/p>\n<p>mysql-server-5.0<br \/>\nsyslog-ng<br \/>\nphp5<br \/>\nphp5-mysql<\/p>\n<p><strong>2 \u2013 Usando o Debian:<\/strong><\/p>\n<p>apt-get install mysql-server-5.0 syslog-ng php5 php5-mysql<\/p>\n<p><strong>3 \u2013 Edite o arquivo \/etc\/php5\/apache2\/<span class=\"skimlinks-unlinked\">php.ini<\/span>\u00a0e descomente a linha extension=<span class=\"skimlinks-unlinked\">mysql.so<\/span><\/strong><\/p>\n<p>extension=<span class=\"skimlinks-unlinked\">mysql.so<\/span><\/p>\n<p><strong>4 &#8211;\u00a0 Edite o arquivo \/etc\/default\/syslog-ng descomentanto a seguinte linha:<\/strong><\/p>\n<p>CONSOLE_LOG_LEVEL=1<\/p>\n<p><strong>Configurando o\u00a0<span class=\"skimlinks-unlinked\">syslog.conf<\/span><\/strong><\/p>\n<p><strong>1 \u2013 Em seguida vamos para configura\u00e7\u00e3o do syslog-ng em \/etc\/syslog-ng\/<span class=\"skimlinks-unlinked\">syslog-ng.conf<\/span>\u00a0e fa\u00e7a as seguintes altera\u00e7\u00f5es:<\/strong><\/p>\n<p><strong>1.1)<\/strong><\/p>\n<p>#(this is equivalent to the &#8220;-r&#8221; syslogd flag)<br \/>\n# udp();<\/p>\n<p>deixe assim:<\/p>\n<p># (this is equivalent to the &#8220;-r&#8221; syslogd flag)<br \/>\nudp();<!--more--><\/p>\n<p><strong>1.2)<\/strong><\/p>\n<p># enable or disable DNS usage<br \/>\n# syslog-ng blocks on DNS queries, so enabling DNS may lead to<br \/>\n# a Denial of Service attack<br \/>\n# (default is yes)<br \/>\nuse_dns(no);<\/p>\n<p>deixe assim:<\/p>\n<p># enable or disable DNS usage<br \/>\n# syslog-ng blocks on DNS queries, so enabling DNS may lead to<br \/>\n# a Denial of Service attack<br \/>\n# (default is yes)<br \/>\nuse_dns(yes);<br \/>\ndns_cache(yes);<\/p>\n<p><strong>baixe o arquivo phpsyslogng-2.8 e\u00a0<\/strong>descompacte dentro de \/var\/www\/:<\/p>\n<p>tar -xvzf phpsyslogng-2.8.<span class=\"skimlinks-unlinked\">tar.gz<\/span> &#8211;directory=\/var\/www\/<\/p>\n<p><strong>Renomei o pacote parar phpsyslogng:<\/strong><\/p>\n<p>mv phpsyslogng-2.8 phpsyslogng<\/p>\n<p><strong>Entre no diretorio script e edite os arquivos<\/strong><\/p>\n<p>cd \/var\/www\/phpsyslogng\/scripts<\/p>\n<p><strong>Adcione a seguinte configura\u00e7\u00e3o ao syslog-ng:<\/strong><\/p>\n<p>cat <span class=\"skimlinks-unlinked\">syslog.conf<\/span> &gt;&gt; \/etc\/syslog-ng\/<span class=\"skimlinks-unlinked\">syslog-ng.conf<\/span><\/p>\n<p><strong>Edite o script syslog2mysql deixando ele assim:<br \/>\n<\/strong><\/p>\n<pre style=\"color: #000000;\">#!\/bin\/bash<\/pre>\n<p>&nbsp;<\/p>\n<p>if [ ! -e \/var\/log\/<span class=\"skimlinks-unlinked\">mysql.pipe<\/span> ]<br \/>\nthen<br \/>\nmkfifo \/var\/log\/<span class=\"skimlinks-unlinked\">mysql.pipe<\/span><br \/>\nfi<br \/>\nwhile [ -e \/var\/log\/<span class=\"skimlinks-unlinked\">mysql.pipe<\/span> ]<br \/>\ndo<br \/>\nmysql -u root &#8211;password=SENHA syslog &lt; \/var\/log\/<span class=\"skimlinks-unlinked\">mysql.pipe<\/span> &gt;\/dev\/null<br \/>\ndone<\/p>\n<p><strong>Adicione a o banco:<\/strong><\/p>\n<p>mysql -uroot -p &lt; <span class=\"skimlinks-unlinked\">dbsetup.sql<\/span><\/p>\n<p><strong>Adicionando o script syslog2mysql.sh na inicializa\u00e7\u00e3o<\/strong><\/p>\n<p>cp syslog2mysql.sh \/usr\/local\/scripts\/<\/p>\n<p>ln -s \/usr\/local\/scripts\/syslog2mysql.sh \/etc\/init.d\/syslog2mysql.sh<\/p>\n<p><strong>Ent\u00e3o coloque-o em \/etc\/<span class=\"skimlinks-unlinked\">rc.local<\/span><\/strong><\/p>\n<p>\/etc\/init.d\/syslog2mysql.sh &amp;<\/p>\n<p><strong>Configurando O Cliente Linux<\/strong><\/p>\n<p><strong>No cliente basta editar o arquivo \/etc\/<span class=\"skimlinks-unlinked\">syslog.conf<\/span>\u00a0adicionando a seguinte linha:<br \/>\n<\/strong><\/p>\n<pre style=\"color: #000000;\">*.*\u00a0\u00a0\u00a0\u00a0\u00a0 @vm-syslog-ng<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>e restartando o servi\u00e7o de log:<br \/>\n<\/strong><\/p>\n<pre style=\"color: #000000;\">\/etc\/init.d\/sysklogd restart<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1 \u2013 Primeiro instalamos os seguintes pacotes: mysql-server-5.0 syslog-ng php5 php5-mysql 2 \u2013 Usando o Debian: apt-get install mysql-server-5.0 syslog-ng php5 php5-mysql 3 \u2013 Edite o arquivo \/etc\/php5\/apache2\/php.ini\u00a0e descomente a linha extension=mysql.so extension=mysql.so 4 &#8211;\u00a0 Edite o arquivo \/etc\/default\/syslog-ng descomentanto a seguinte linha: CONSOLE_LOG_LEVEL=1 Configurando o\u00a0syslog.conf 1 \u2013 Em seguida vamos para configura\u00e7\u00e3o do syslog-ng [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[455,1,42,51,495],"tags":[626,260,625],"class_list":["post-892","post","type-post","status-publish","format-standard","hentry","category-apache2","category-viazap","category-leitura-recomendada","category-linux-linuxrs","category-profissional-de-ti","tag-com-mysql","tag-instalando","tag-syslog-ng"],"_links":{"self":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=892"}],"version-history":[{"count":1,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/892\/revisions"}],"predecessor-version":[{"id":893,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/892\/revisions\/893"}],"wp:attachment":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}