<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Andres,<br>
<br>
I've just tried your sample(s) in my midPoint 3.0.1 master on
postgresql 9.3 with the following results/remarks:<br>
<br>
1. I had to comment the <capabilities> section, because your
database table does not specify column called "disabled" to contain
enable/disable information.<br>
2. When adding the account to the user, I had to manually enter "id"
attribute value as it has no automatic value computed and it is NOT
NULL in the database table configuration<br>
3. <b>I see no error regarding the password</b>, and the select
reports:<br>
<br>
select * from personas;<br>
id | nombre | apellido | password |
nombre_completo | fecha_creacion <br>
----+---------------------------+----------+------------------+-----------------+----------------------------<br>
1 | test1 | | thisismypassword | |
2014-09-25 21:43:53.133021<br>
(1 row)<br>
<br>
So, I'd suggest to:<br>
<br>
1. add another column to the database table e.g. "disabled" to
correspond with the capabilities section; or if you don't want to
use it, comment the section just like me;<br>
<br>
2. add a schema mapping to inform midPoint that the "id" column
value is not mandatory (the DB sends information that it's NOT NULL
and thus required, but the value will be computed by the DB itself,
not midPoint):<br>
<br>
<attribute><br>
<ref>ri:id</ref><br>
<displayName>Id</displayName><br>
<limitations><br>
<b> <minOccurs>0</minOccurs></b><br>
<access><br>
<read>true</read><br>
<add>false</add><br>
<modify>false</modify><br>
</access><br>
</limitations><br>
</attribute><br>
After these two changes, please try it again just to see if 3.0 is
not somehow showing incorrect error message or something like that.<br>
<br>
After that:<br>
<br>
3. if possible, please try the latest midPoint master snapshot from
<a class="moz-txt-link-freetext" href="http://athena.evolveum.com/builds/master/latest/">http://athena.evolveum.com/builds/master/latest/</a> and see if you can
still see the problem.<br>
<br>
Regards,<br>
Ivan<br>
<br>
<div class="moz-cite-prefix">On 09/25/2014 10:49 PM, Andres Blanco
wrote:<br>
</div>
<blockquote
cite="mid:CANaWiPe3ex_FA6nQ_6UO2Bq5qHDx0a_XK=MPE2tap49Nn8YsYw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>Hey, i was trying out midpoint with a postgresql resource
and when i try to create an account from the GUI i get the
following error: </div>
<div><br>
</div>
<div><span style="color:rgb(185,74,72);font-family:'Helvetica
Neue',Helvetica,Arial,sans-serif;font-size:14.3999996185303px;font-weight:bold;line-height:16px">Update
user failed</span></div>
<div class=""
style="font-size:12px;display:inline-block;padding-right:15px;padding-top:5px;clear:both;width:1357.92504882813px;color:rgb(185,74,72);font-family:'Helvetica
Neue',Helvetica,Arial,sans-serif">
<ul style="margin:0px;list-style:none outside
none;padding:0px">
<li style="padding:1px 0px;list-style:none outside
none;margin:0px;text-overflow:ellipsis;overflow:auto">
<div class=""><span>Save user (Gui)</span></div>
</li>
<li style="padding:1px 0px;list-style:none outside
none;margin:0px;text-overflow:ellipsis;overflow:auto"><span
class=""><u>Cause:</u> <span>
<p style="margin:0px;display:inline">No compile-time
class in PC({<a moz-do-not-send="true"
href="http://midpoint.evolveum.com/xml/ns/public/common/common-3%7Dpassword%29:[PCV%28null%29:[PP%28%7B.../common/common-3%7Dvalue%29:[PPV%28ProtectedStringType:ProtectedStringType%28">http://midpoint.evolveum.com/xml/ns/public/common/common-3}password):[PCV(null):[PP({.../common/common-3}value):[PPV(ProtectedStringType:ProtectedStringType(</a>"123456"),
origin: USER_ACTION:null)]]] (credentials/password
in object:null(null))</p>
</span></span></li>
</ul>
</div>
<div><br>
</div>
<div>If I remove the password from the connector configuration
like this:</div>
<div>from
<icscdbtable:passwordColumn>password</icscdbtable:passwordColumn><br>
</div>
<div>to <span class="" style="white-space:pre"> </span><icscdbtable:passwordColumn></icscdbtable:passwordColumn></div>
<div><br>
</div>
<div>it works, but kind of defeats the purpouse.</div>
<div><br>
</div>
My Midpoint version is 3.0. I attach the stack trace, resource
xml and the db creation script
<div><br>
</div>
<div>any help would be appreciatted</div>
<div><br>
</div>
<div>bye!<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr">
<pre><span style="white-space:pre-wrap">Lic. Andres Blanco
SIU - Toba
Sistema de Información Universitaria (SIU)
República Argentina
Tel +54+11 5217-3101
<a moz-do-not-send="true" href="http://www.siu.edu.ar" target="_blank">http://www.siu.edu.ar</a>
</span></pre>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer
evolveum.com
___________________________________________
"Idem per idem - semper idem Vix."
</pre>
</body>
</html>