Forum

This content is now out of date.

Visit Our Community

Changing the default scheduled task to syncronize LDAP groups & Users


By Default LDAP groups / users are syncronized (flattened) on a daily basis.
However this can be modified within the Yellowfin DB.
Important!
Making changes to the Yellowfin DB can cause undesired effects, so it'a always recommended making a backup before making such changes.


Within the TaskSchedule table you should see records 'Group Flatten Task' & 'LDAPUpdateTask'.
Group Flatten Task flattens all LDAP groups and rebuilds them so if new users have been added, or existing users have been removed this will make sure the LDAP group in Yellowfin also matches the server.
Alternatively you can also run the attached 'FlattenGroups.jsp'. Simply copy this to your Yellowfin ROOT folder and access it via URL <Yellowfin ServerFlattenGroups.jsp

LDAPUpdateTask will flag YF users as deleted once this user has been removed from the LDAP server.
When a user is deleted from the LDAP server they can no longer be authenticated when logging into Yellowfin. This task simply flags the user as deleted.

Here is an example of the standard records:
[code]

IpOrg ScheduleSubjectCode ScheduleUnitCode ScheduleUnitId ScheduleIsOn LocalTimezoneCode FrequencyTypeCode FrequencyCode FrequencyUnit LastRunGMTDateTime LastRunDate LastRunTime LastRunStatus LastRunErrorDesc ScheduledLocalRunTime PriorityCode PrioritySetByCode
1 SYSTEMTASK GroupFlattenTask 0 0 AUSTRALIA/SYDNEY DAILY NULL 0 2.01E+13 00:00.0 82800 SUCCESS NULL 0 NULL NULL
1 SYSTEMTASK LDAPUpdateTask 0 0 AUSTRALIA/SYDNEY DAILY NULL 0 2.01E+13 00:00.0 82800 SUCCESS NULL 0 NULL NULL
[/code]
You can change the above to �FrequencyTypeCode = HOURS, FrequencyUnit = 5 �(so this will run every 5 hours).

Example after makign changes:
[code]

IpOrg ScheduleSubjectCode ScheduleUnitCode ScheduleUnitId ScheduleIsOn LocalTimezoneCode FrequencyTypeCode FrequencyCode FrequencyUnit LastRunGMTDateTime LastRunDate LastRunTime LastRunStatus LastRunErrorDesc ScheduledLocalRunTime PriorityCode PrioritySetByCode
1 SYSTEMTASK GroupFlattenTask 0 0 AUSTRALIA/SYDNEY HOURS NULL 5 2.01E+13 00:00.0 82800 SUCCESS NULL 0 NULL NULL
1 SYSTEMTASK LDAPUpdateTask 0 0 AUSTRALIA/SYDNEY DAILY NULL 0 2.01E+13 00:00.0 82800 SUCCESS NULL 0 NULL NULL
[/code]
Note: You will need to restart the YF service after making changes to the Yellowfin DB.

Related Posts:
LDAP authentication Guide
Creating LDAP Users
Creating LDAP Groups
Defining the Default Role
LDAP connection settings & provisions

If you are recieving errors, or having issues setting this up, please email [color="#0000FF">support@yellowfin.com.au[/color]


Hi David,

The FlattenGroups.jsp file you mention doesn't seem to be attached to your post.

regards
Robin
Hi Robin,

It has now been attached.

Regards,
David
Hi Guys,

Just tried to modify the TaskSchedule table with FrequencyTypeCode = HOURS, FrequencyUnit = 5 (so this will run every 5 hours) without success. I am not too sure if HOURS is the correct frequency type code for version 7.1 as the schedules do not seem to have this as an option.

I have since changed it to FrequencyTypeCode = MINUTES, FrequencyUnit = 300 (5x60) and this seems to work OK now.

Regards,
Brad

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.