{"id":881,"date":"2013-04-12T07:35:02","date_gmt":"2013-04-12T11:35:02","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=881"},"modified":"2013-04-12T07:46:48","modified_gmt":"2013-04-12T11:46:48","slug":"error-sql30082n-reason-code-15-o-24-en-db2","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2013\/04\/12\/error-sql30082n-reason-code-15-o-24-en-db2\/","title":{"rendered":"Error SQL30082N Reason Code 15 (o 24) en DB2"},"content":{"rendered":"<p>Si ya estas trabajando con DB2 9.1 o superior pero en los \u00faltimos sistemas operativos de linux, puede aparecer el error <\/p>\n<pre class=\"brush: bash\">\r\nSQL30082N Security processing failed with Reason Code 15\r\n\"Security processing at the server failed \"\r\n<\/pre>\n<p>o<\/p>\n<pre class=\"brush: bash\">\r\nSQL30082N Security processing failed with Reason Code 24\r\n\"USERNAME AND\/OR PASSWORD INVALID \"\r\n<\/pre>\n<p>La razon la encontre <a href=\"https:\/\/www-01.ibm.com\/support\/docview.wss?uid=swg21470246\">aqu\u00ed<\/a> y tiene que ver con el algoritmo de encriptaci\u00f3n de la password. Recordemos que DB2 utiliza el usuario de sistema operativo, a \u00e9l es qui\u00e9n tu le asignas los permisos para accesar a una base de datos o a un esquema de DB2.<\/p>\n<p>El problema es que actualmente los sistemas operativos Linux vienen con el algoritmo sha512 implementado para encriptar la password, siendo que DB2 s\u00f3lo trabaja con MD5 o SHA1, por lo tanto tienes que cambiar el algoritmo de encriptamiento de la password.<\/p>\n<p><strong>Actualizaci\u00f3n:<\/strong> Aqu\u00ed explico como <a href=\"https:\/\/gonzalo.aro.cl\/blog\/2013\/04\/12\/cambiando-algoritmo-de-encriptamiento-de-la-password-en-linux\/\" title=\"Cambiando algoritmo de encriptamiento de la password en linux\">cambiar el algoritmo de encriptamiento en linux<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si ya estas trabajando con DB2 9.1 o superior pero en los \u00faltimos sistemas operativos de linux, puede aparecer el error SQL30082N Security processing failed with Reason Code 15 \u00abSecurity processing at the server failed \u00bb o SQL30082N Security processing failed with Reason Code 24 \u00abUSERNAME AND\/OR PASSWORD INVALID \u00bb La razon la encontre aqu\u00ed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,16,36,37],"tags":[],"class_list":["post-881","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-centos","category-db2","category-unix"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/881"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=881"}],"version-history":[{"count":2,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/881\/revisions"}],"predecessor-version":[{"id":886,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/881\/revisions\/886"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}