{"id":1070,"date":"2012-01-09T22:41:48","date_gmt":"2012-01-09T22:41:48","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/techblog\/?p=1070"},"modified":"2023-08-07T13:17:28","modified_gmt":"2023-08-07T19:17:28","slug":"expiring-password-for-as400-user-profiles","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/techblog\/?ht_kb=expiring-password-for-as400-user-profiles","title":{"rendered":"Expiring Password for AS400 User Profiles"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">For customers who utilize m-Power over an AS\/400 database, mrc recommends utilizing a JDBC username that is set to have a password that does not expire. However, certain organizations do not permit this option.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When a password is nearing its expiration date, the AS\/400 is designed to prompt the user to update his or her password. However, the AS\/400, by default, is unaware if a user is connecting via a terminal connection or via a JDBC connection. The issue is that a JDBC connection is unmonitored and does not support prompted interaction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">m-Power will attempt to run an application (whether that is a run-time application or the m-Power interface), and while it is trying to connect to the database, the AS\/400 is awaiting a response for your updated password credentials. In the end, it appears that your system is simply unresponsive and has hung.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, there is a JDBC connection property that will solve the problem.&nbsp; This property is called &#8220;prompt&#8221; and setting it to false will bypass these expire issues.&nbsp; To do so, add &#8220;property=false&#8221; to your JDBC connection property string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When sign-on security is enabled for generated apps, if the app is authenticated by the AS400 user profile, modify the correct JDBC connection in this file:<br>\/m-power\/mrcjava\/WEB-INF\/classes\/mrc-spring-context.xml<br>to append the property:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>;prompt=false<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">When logging onto the m-Power interface, set this file:<br>\/m-power\/proddata\/conf\/db2_toolbox_driver.properties<br>with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>connection_properties=translate binary\\=true;naming\\=system;prompt\\=false<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If your main m-Power user&#8217;s password expires, then also change file:<br>\/m-power\/mrcwebgui\/WEB-INF\/classes\/mrc-spring-context.xml<br>to append the property:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>;prompt=false<\/code><\/pre>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon\"><strong>Note:<\/strong> It is <strong>strongly<\/strong> recommended to set your main m-Power user&#8217;s password to never expire.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For customers who utilize m-Power over an AS\/400 database, mrc recommends utilizing a JDBC username that is set to have a password that does not expire. However, certain organizations do not permit this option. When a password is nearing its expiration date, the AS\/400 is designed to prompt the user&#8230;<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-1070","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1070","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1070"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1070\/revisions"}],"predecessor-version":[{"id":12062,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=\/wp\/v2\/ht-kb\/1070\/revisions\/12062"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1070"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=1070"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/techblog\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=1070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}