{"id":689,"date":"2014-12-10T04:17:54","date_gmt":"2014-12-10T04:17:54","guid":{"rendered":"http:\/\/www.incredigeek.com\/home\/?p=689"},"modified":"2014-12-10T04:19:18","modified_gmt":"2014-12-10T04:19:18","slug":"how-to-unblock-an-ip-from-cphulk-from-the-command-line","status":"publish","type":"post","link":"https:\/\/www.incredigeek.com\/home\/how-to-unblock-an-ip-from-cphulk-from-the-command-line\/","title":{"rendered":"How To &#8220;Unblock&#8221; an IP from cPHulk from the Command Line"},"content":{"rendered":"<p>cPHulk uses a MySQL database to keep track of different IP&#8217;s to block, white list, black list, etc.<\/p>\n<p>When there have been X amount of failed login attempts from an IP, cPHulk adds an entry for the IP in the brutes table.<\/p>\n<p>To &#8220;unblock&#8221; the IP we need to delete the entry.<\/p>\n<p>open up the cPHulk MySQL database.<\/p>\n<pre>root@localhost [~]# mysql cphulkd<\/pre>\n<p>If your interested you can view all tables that cPHulk uses.<\/p>\n<pre>show tables;<\/pre>\n<p>Take a look at all the IP&#8217;s in the brutes table.<\/p>\n<pre>SELECT IP FROM brutes;<\/pre>\n<p>example:<\/p>\n<pre>mysql&gt; SELECT IP FROM brutes;\r\n+---------------+\r\n| IP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\r\n+---------------+\r\n| 30.134.41.221 |\u00a0\u00a0\u00a0\u00a0 &lt;--\u00a0 IP we want to unblock\r\n| 31.134.40.251 |\r\n+---------------+\r\n2 rows in set (0.00 sec)\r\n\r\nmysql&gt;<\/pre>\n<p>To unblock the IP we just need to delete the row that has the IP address we want.<\/p>\n<pre>mysql&gt; DELETE FROM brutes WHERE IP=\"30.134.41.221\";<\/pre>\n<p>It should return the following.<\/p>\n<pre>mysql&gt; DELETE FROM brutes WHERE IP=\"30.134.41.221\";\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql&gt;<\/pre>\n<p>Exit MySQL.<\/p>\n<pre>mysql&gt; exit\r\nBye\r\nroot@localhost [~]#<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>cPHulk uses a MySQL database to keep track of different IP&#8217;s to block, white list, black list, etc. When there have been X amount of failed login attempts from an IP, cPHulk adds an entry for the IP in the &hellip; <a href=\"https:\/\/www.incredigeek.com\/home\/how-to-unblock-an-ip-from-cphulk-from-the-command-line\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,195,3],"tags":[8,196,197,7,166],"class_list":["post-689","post","type-post","status-publish","format-standard","hentry","category-command-line","category-cpanel","category-linux","tag-command-line-2","tag-cpanel-2","tag-cphulk","tag-linux-2","tag-terminal"],"_links":{"self":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":2,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/689\/revisions"}],"predecessor-version":[{"id":691,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/posts\/689\/revisions\/691"}],"wp:attachment":[{"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/media?parent=689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/categories?post=689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.incredigeek.com\/home\/wp-json\/wp\/v2\/tags?post=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}