Update user properties automatically

[Sanu Soman]

Hi All,

I'm looking for to automatically update user's proprties in jira (LDAP integrated) once they login/created account in jira.

Is this possible?

Thanks,

Sanu P Soman

[Andris Grinbergs]

I use nightly SQL which populates user's properties from LDAP to Jira DB. Altho - jira restart is needed...

[Sanu Soman]

nightly SQL?

[Andris Grinbergs]

It's actually PERL script which is called every night - it retrieves info from LDAP and pushes it with SQL to Jira DB.

[Andris Grinbergs]

I use this SQL to get list of users which have have missing user property:

select

name

from

external_entities

where

external_entities.name not in

(

select

external_entities.name

from

propertystring,

propertyentry,

external_entities

where

propertystring.id=propertyentry.id and

external_entities.id=propertyentry.entity_id and

propertyentry.property_key="jira.meta.UserCustomID"

)

Then cycle those users, get value for each with $ldap->search

And write found value to Jira DB:

INSERT INTO propertystring (id,propertyvalue) VALUES (\@newID, \"$UserCustomID\");";

And update sequence after that:

UPDATE SEQUENCE_VALUE_ITEM SET SEQ_ID=(SELECT (((max(id)+20) div 100)+1)*100 from propertyentry) where SEQ_NAME=\"OSPropertyEntry\";";

[Boris Georgiev _Appfire_]

You can implement listener com.atlassian.jira.event.user.UserEventListener and then set user properties in the com.atlassian.jira.event.listeners.mail.MailListener.userSignup(UserEvent)

[Sanu Soman]

Is it possible to share some sample script on this?