User Provision with Database Table Connector and MD5 Password

[Muttley]

Hi,

using Database Table Connector which is the best way to provision user
passwords as md5 ?
(or any other digest algoritm like sha-1)?

Do you have any suggestions (a virtual attribute, a database trigger)?

Thanks!
Denis

[Francesco Chicchiriccò]

Hi Denis,
Syncope delegates communication to external resources to ConnId, a fork of - unfortunately dead - Sun's Identity Connectors framework. You can check [2] to see available connector bundles.

Database table connector seems not to support the feature you are requesting, hence I've open issue [3] on ConnId.
Please star that issue in order to get notified about progresses.

Thinking about a workaround, a database trigger could have some chances, in my opinion: basically this trigger should, upon INSERT or UPDATE involving password column, perform an additional UPDATE hashing password value.

Please let us know if you find something simpler or better than this.

Regards.

[1] http://connid.googlecode.com
[2] http://code.google.com/p/connid/wiki/AvailableConnectorBundles
[3] http://code.google.com/p/connid/issues/detail?id=23

-- 
Francesco Chicchiriccò

"Computer Science is no more about computers than astronomy
is about telescopes." (E. W. Dijkstra)