{"id":4376,"date":"2016-12-24T03:57:57","date_gmt":"2016-12-23T19:57:57","guid":{"rendered":"https:\/\/www.darknet.org.uk\/?p=4376"},"modified":"2016-12-24T04:04:34","modified_gmt":"2016-12-23T20:04:34","slug":"dbshield-go-based-database-firewall","status":"publish","type":"post","link":"https:\/\/www.darknet.org.uk\/2016\/12\/dbshield-go-based-database-firewall\/","title":{"rendered":"DBShield &#8211; Go Based Database Firewall"},"content":{"rendered":"<p>DBShield is a Database Firewall written in Go that has protection for MySQL\/MariaDB, Oracle and PostgreSQL databases. It works in a proxy fashion inspecting traffic and dropping abnormal queries after a learning period to populate the internal database with regular queries.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.darknet.org.uk\/wp-content\/uploads\/2016\/12\/DBShield-Go-Based-Database-Firewall-640x360.png\" alt=\"DBShield - Go Based Database Firewall\" width=\"640\" height=\"360\" class=\"aligncenter size-medium wp-image-4379\" srcset=\"https:\/\/www.darknet.org.uk\/wp-content\/uploads\/2016\/12\/DBShield-Go-Based-Database-Firewall-640x360.png 640w, https:\/\/www.darknet.org.uk\/wp-content\/uploads\/2016\/12\/DBShield-Go-Based-Database-Firewall.png 733w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>Learning mode lets any query pass but it records information about it (pattern, username, time and source) into the internal database.<\/p>\n<p>After collecting enough patterns we can run DBShield in protect mode. Protect mode can distinguish abnormal query pattern, user and source and take action based on configurations.<\/p>\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-3033787195489589\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<!-- Darknet Responsive Post Ad Links [previously link ad unit] -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-3033787195489589\"\r\n     data-ad-slot=\"5456620019\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<p>It currently supports DB2, MariaDB, MySQL, Oracle &#038; PostgreSQL all with SSL apart from Oracle and DB2.<\/p>\n<h3>Installation<\/h3>\n<p>Get it:<\/p>\n<pre>$ go get -u github.com\/nim4\/DBShield<\/pre>\n<p>Then you can see help using &#8220;-h&#8221; argument:<\/p>\n<pre>$ $GOPATH\/bin\/DBShield -h\r\nDBShield 1.0.0-beta3\r\nUsage of DBShield:\r\n  -a    get list of abnormal queries\r\n  -c file\r\n      config file (default \"\/etc\/dbshield.yml\")\r\n  -h    show help\r\n  -k    show parsed config and exit\r\n  -l    get list of captured patterns\r\n  -version\r\n      show version<\/pre>\n<p>and run it with your configuration, like:<\/p>\n<pre>$ $GOPATH\/bin\/DBShield -c config.yml<\/pre>\n<p>You can download DBShield here:<\/p>\n<p><a href=\"https:\/\/github.com\/nim4\/DBShield\/archive\/1.0.0-beta4.zip\">DBShield-1.0.0-beta4.zip<\/a><\/p>\n<p>Or read more <a href=\"https:\/\/github.com\/nim4\/DBShield\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DBShield is a Database Firewall written in Go that has protection for MySQL\/MariaDB, Oracle and PostgreSQL databases. It works in a proxy fashion inspecting traffic and dropping abnormal queries after a learning period to populate the internal database with regular queries. Learning mode lets any query pass but it records information about it (pattern, username, [&hellip;]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"DBShield is a Database Firewall written in Go that has protection for MySQL\/MariaDB, Oracle and PostgreSQL databases. It works by inspecting traffic.","_seopress_robots_index":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[12,2,11],"tags":[1322],"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":"Darknet","author_link":"https:\/\/www.darknet.org.uk\/author\/darknet\/"},"_links":{"self":[{"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/posts\/4376"}],"collection":[{"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/comments?post=4376"}],"version-history":[{"count":0,"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/posts\/4376\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/media?parent=4376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/categories?post=4376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darknet.org.uk\/wp-json\/wp\/v2\/tags?post=4376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}