{"id":65,"date":"2012-12-17T01:24:59","date_gmt":"2012-12-17T01:24:59","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=65"},"modified":"2017-03-13T02:12:05","modified_gmt":"2017-03-13T02:12:05","slug":"3004-303-there-have-been-too-many-unsuccessful-login-attempts-please-see-the-system-administrator","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=65","title":{"rendered":"3004-303 There have been too many unsuccessful login attempts; please see the system administrator"},"content":{"rendered":"<p>Sometimes I am needed to do a little Operating System administration.\u00a0 I work with a couple of a databases that are on the IBM AIX operating system.<\/p>\n<p>Although I work with a very talented AIX administrator, he is not always available.\u00a0\u00a0 Many times he is pulled on into meetings that can last all afternoon.\u00a0 Not good if you have a user who can not access one of the systems.\u00a0 Thankfully he has given me privileges to administer some of the more simple tasks.<\/p>\n<p>The issue I faced was a user who wanted to remote to one of the database servers, and he could not log on.\u00a0 The e-mail read that he was unable to log on with no other details.\u00a0 My first instinct was to go into SMITTY and reset his password.\u00a0 After changing his user account password, I e-mailed him to try again.<\/p>\n<p>The next e-mail he sent included the following error message:<\/p>\n<p><span style=\"color: #0000ff;\">3004-303 There have been too many unsuccessful login attempts; please see the system administrator<\/span><\/p>\n<p>Side Note: At home I have an old IBM RS6000 with an old version of AIX 5 on it.\u00a0 Nice for practicing.\u00a0 The screen shots are from that server, and not one of my production servers from work.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/RS6000.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-66\" title=\"RS6000\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/RS6000.jpg\" alt=\"\" width=\"195\" height=\"326\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/RS6000.jpg 195w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/RS6000-179x300.jpg 179w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/RS6000-125x210.jpg 125w\" sizes=\"(max-width: 195px) 100vw, 195px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>For this example, my &#8220;mike&#8221; account on the server is set in SMITTY to lock after three failed attempts.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/error.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-67\" title=\"error\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/error.jpg\" alt=\"\" width=\"597\" height=\"140\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/error.jpg 597w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/error-300x70.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/error-210x49.jpg 210w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/a><\/p>\n<p>As a privileged user, I need to see how many times the user unsuccessfully attempted to log on. Run this command to see the number of attempts:<\/p>\n<p><span style=\"color: #0000ff;\">\/usr\/sbin\/lsuser -a unsuccessful_login_count &lt;username&gt;<\/span><\/p>\n<p>Note: replace &lt;username&gt; for the user account in question.<\/p>\n<p>Because this is my own personal server, I get to log on as root.\u00a0 Your AIX administrator may need to bump up you privileges to run these commands.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/unsuccessful_login_count.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-68\" title=\"unsuccessful_login_count\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/unsuccessful_login_count.jpg\" alt=\"\" width=\"520\" height=\"64\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/unsuccessful_login_count.jpg 520w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/unsuccessful_login_count-300x36.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/unsuccessful_login_count-210x25.jpg 210w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/a><\/p>\n<p>As seen above, the failed attempts is four, which one more then permitted by the configuration set in SMITTY.<\/p>\n<p>Run the following command to reset the failed attempt count back to zero:<\/p>\n<p><span style=\"color: #0000ff;\">\/usr\/bin\/chsec -f \/etc\/security\/lastlog -a unsuccessful_login_count=0 -s &lt;username&gt;<\/span><\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/reset.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-69\" title=\"reset\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/reset.jpg\" alt=\"\" width=\"752\" height=\"75\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/reset.jpg 752w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/reset-300x29.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2012\/12\/reset-210x20.jpg 210w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/a><\/p>\n<p>After I reset the user account to zero, I then reran the &#8216;lsuser&#8217; statement to verify that the &#8216;unsuccessful_login_count&#8217; was zero.<\/p>\n<p>The user was then able to access the server, and I was able to move on to the next thing.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes I am needed to do a little Operating System administration.\u00a0 I work with a couple of a databases that are on the IBM AIX operating system. Although I work &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=65\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":67,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-65","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aix"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/65"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":14,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":320,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/320"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/67"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}