Hi All.
Wanted to share something with you as I have found many people have been looking for this in some form or another.
I have an LDAP directory and have successfully linked BOXI R2 SP2 FP2.4 to this. As you will all know BOXI does not poll for changes to the LDAP directory and thus when you add/delete/modify a user the changes are not reflected in BOXI.
What you have to do is create a Program Object in BOXI that will force the refresh.
I have implemented this using Java as this can be used under both Windows and Unix (I use Unix).
This java program implements the IProgramBaseEx class meaning that you do not need to specify a logon or a CMS. Because the Java program is contained inside the CMS repo it knows your CMS. Because you will add this (and schedule this) program objects as the Administrator, it uses this account to run the object.
All the java program does is update the LDAP information in the repository. The SI_UPDATE_TS property is changed to todays date, however it is the COMMIT that forces the CMS to request a refresh from LDAP.
Note that I have supplied the .java file for you and also the .jar file. I know some people are wary of using executables provided by people uknown to them.
Instructions:
- Download UpdatePlugin.java
- Download UpdatePlugin.bat
- Create a folder lib_XIR2SP2
- Search for and copy all *.jar files from Business Objects directory to lib_XIR2SP2
- Run the bat from DOS
- Jar the file (jar cfm UpdatePlugin *.class)
- Add to BOXI as a Program Object using the CMC. Notice that you must update the “Class to run:” (under Process/Paramters) to UpdatePlugin.
- Schedule to run.
(Yes, you can create a JAR in Windows and run this inside the Program Job Server in Unix)
If you download the Jar file all you will have to do is :
- Add to BOXI as a Program Object using the CMC. Notice that you must update the “Class to run:” (under Process/Paramters) to UpdatePlugin.
- Schedule to run.
Just incase the files do not work here is the Java Code:
import java.util.Date;
import com.crystaldecisions.sdk.exception.SDKException;
import com.crystaldecisions.sdk.framework.CrystalEnterprise;
import com.crystaldecisions.sdk.framework.IEnterpriseSession;
import com.crystaldecisions.sdk.occa.infostore.IInfoObjects;
import com.crystaldecisions.sdk.occa.infostore.IInfoObject;
import com.crystaldecisions.sdk.occa.infostore.IInfoStore;
import com.crystaldecisions.sdk.plugin.authentication.ldap.IsecLDAP;
import com.crystaldecisions.sdk.plugin.desktop.program.IProgramBaseEx;
public class UpdatePlugin implements IProgramBaseEx{
public void run(IEnterpriseSession enterpriseSession, IInfoStore infoStore, IInfoObject infoObject, String objectId, String[] args) throws SDKException {
try {
System.out.println("Scheduled Java App for Update LDAP");
System.out.println("CMS is " + enterpriseSession.getCMSName());
System.out.println("Querying for the plugin");
//Query for any object in the CMS.
String lQuery = "SELECT TOP 1 * "
+ "FROM CI_SYSTEMOBJECTS "
+ "WHERE SI_NAME='secLDAP'";
IInfoObjects lInfoObjects = (IInfoObjects) infoStore.query(lQuery);
if (lInfoObjects.size() > 0) {
System.out.println("A plugin was found");
IsecLDAP lPlugin = (IsecLDAP) lInfoObjects.get(0);
System.out.println("Old value: " + lPlugin.properties().getProperty("SI_UPDATE_TS").getValue());
lPlugin.properties().getProperty("SI_UPDATE_TS").setValue(new Date());
System.out.println("Commiting the value");
infoStore.commit(lInfoObjects);
}//if
else{
System.out.println("no plugin was found using SQL [" + lQuery + "]");
}//else
}//try
catch (SDKException lException) {
lException.printStackTrace();
}//catch
}//run
}//class
Compile_Class_R2SP2_bat.zip (0.0 KB)
UpdatePlugin_java.zip (1.0 KB)
UpdatePlugin_jar.zip (1.0 KB)
stephenEclectic (BOB member since 2004-12-07)