Delete user/user data once user is removed from AD

Does anyone have any throughts on how user/user data can removed once the user is deleted from the ldap. Got to know that there is no OOTB option which takes care of this.

 Appreciate your response on this

Thanks

Rajesh

 

Comments

  • Hi,

     

                        You can run <PORTAL_INSTALL_DIR>/bin/user_manager_config.bat –cleanup to delete the orphan users/groups from the database. But this will work for only aggregate config.

     

     

    Thanks,

    Santosh Kumar S.

     

    From: eLink Entry: OpenText Tempo Social Forum [mailto:[email protected]linkkc.opentext.com]
    Sent: Thursday, March 02, 2017 4:05 PM
    To: eLink Recipient
    Subject: Delete user/user data once user is removed from AD

     

    Delete user/user data once user is removed from AD

     

    Posted by Nair, Rajesh On 03/02/2017 05:30 AM

     

     

    Does anyone have any throughts on how user/user data can removed once the user is deleted from the ldap. Got to know that there is no OOTB option which takes care of this.

     Appreciate your response on this

    Thanks

    Rajesh

     


    [To post a comment, use the normal reply function]

    Forum:

    OpenText Tempo Social Forum

    Content Server:

    Knowledge Center CS16

     

  • Thanks Santhosh for instant response.  We tried this in our test environment <PORTAL_INSTALL_DIR>/bin/user_manager_config.bat –cleanup . The users got deleted from the portal database, but the users are still visible in Collab. Please advise.

     

    Appreciate your response on this.

    Thanks

    Rajesh

     

  • Hi,

     

    Please run the attached file by saving it into <collab_install_dir>\pscripts folder. Note that I slightly changed the existing clearUsersExternalSync to delete the user as well as part from clearing external sync data.

     

    To run the script use the following URL after logging in as admin: http://<collab_host>:<collab_port>/gm/RunScript?script=clearUsersExternalSync.py

     

    Regards,
    SreeRamya

    From: eLink Entry: OpenText Tempo Social Forum [mailto:[email protected]]
    Sent: 09 March 2017 17:11
    To: eLink Recipient
    Subject: RE Delete user/user data once user is removed from AD

     

    RE Delete user/user data once user is removed from AD

     

    Posted by Nair, Rajesh On 03/09/2017 06:40 AM

     

     

    Thanks Santhosh for instant response.  We tried this in our test environment<PORTAL_INSTALL_DIR>/bin/user_manager_config.bat –cleanup . The users got deleted from the portal database, but the users are still visible in Collab. Please advise.

     

    Appreciate your response on this.

    Thanks

    Rajesh

     


    [To post a comment, use the normal reply function]

    Topic:

    Delete user/user data once user is removed from AD

    Forum:

    OpenText Tempo Social Forum

    Content Server:

    Knowledge Center CS16

     

  • Thanks SreeRamya, I could'nt see any difference between the clearUsersExternalSync.py that you shared and which is in our system.

    I ran the script, but could see some exception in the log. Also the user id/data doesnt sems to be removed

    Also the  logs says " Clearing <userid>" for users who are still exists in ldap.

    Please let know how to proceed. I dont see any option to attached the logs, so pasting the exception below.

    Clearing  Vince Walsh
    Clearing  Linda Walton
    Clearing  George Wentzel
    Clearing  Sean Werner
    Clearing  Scott Whang
    Clearing [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: RunScript - returning from script: pscripts/clearUsersExternalSync.py, threadId: http-bio-8088-exec-471.
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: >>> Warning: The following exception should be localized:Unexpected Python exception: <type 'exceptions.UnicodeEncodeError'> - UnicodeEncodeError('ascii', u'J\xf6rg Wiesmann', 1, 2, 'ordinal not in range(128)')
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: ERROR: com.intraspect.exceptions.IntraspectException in:com.intraspect.browser.RunScriptBrowserCmd: Unexpected Python exception: <type 'exceptions.UnicodeEncodeError'> - UnicodeEncodeError('ascii', u'J\xf6rg Wiesmann', 1, 2, 'ordinal not in range(128)')
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]:  at com.intraspect.browser.RunScriptBrowserCmd.handleException(RunScriptBrowserCmd.java:280)
      at com.intraspect.browser.RunScriptBrowserCmd.doitInternal(RunScriptBrowserCmd.java:239)
      at com.intraspect.browser.BrowserCmd.doit(BrowserCmd.java:207)
      at com.intraspect.servlet.GMServlet$2.doit(GMServlet.java:682)
      at com.intraspect.database.WrapTransaction.withCommandStateNew(WrapTransaction.java:251)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:212)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:107)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:92)
      at com.intraspect.servlet.GMServlet.runCmdInstanceInternal(GMServlet.java:586)
      at com.intraspect.servlet.GMServlet.runCmdInstance(GMServlet.java:449)
      at com.intraspect.servlet.GMServlet.doGet(GMServlet.java:180)
      at com.intraspect.servlet.GMServlet.service(GMServlet.java:117)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.apache.catalina.filters.RequestDumperFilter.doFilter(RequestDumperFilter.java:203)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      at com.intraspect.valves.CollabWebDAVFixValve.invoke(CollabWebDAVFixValve.java:34)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: RawUsageDataWriter: no event mapping for RUN_SCRIPT

     

    Thanks

    Rajesh

  • Hey Rajesh,

     

    Take a look into your system locale – should be set to lang_xx_UTF-8

     

    Alternatively prepend to your offending script the Unicode handler as explained here:https://www.python.org/dev/peps/pep-0263/

     

    Problem nicely explained here:http://effbot.org/pyfaq/what-does-unicodeerror-ascii-decoding-encoding-error-ordinal-not-in-range-128-mean.htm

     

    Regards,


    Andy

     

    From: eLink Entry: OpenText Tempo Social Forum [mailto:[email protected]]
    Sent: 13 March 2017 13:51
    To: eLink Recipient
    Subject: RE RE Delete user/user data once user is removed from AD

     

    RE RE Delete user/user data once user is removed from AD

     

    Posted by Nair, Rajesh On 03/13/2017 09:43 AM

     

     

    Thanks SreeRamya, I could'nt see any difference between theclearUsersExternalSync.py that you shared and which is in our system.

    I ran the script, but could see some exception in the log. Also the user id/data doesnt sems to be removed

    Also the  logs says " Clearing <userid>" for users who are still exists in ldap.

    Please let know how to proceed. I dont see any option to attached the logs, so pasting the exception below.

    Clearing  Vince Walsh
    Clearing  Linda Walton
    Clearing  George Wentzel
    Clearing  Sean Werner
    Clearing  Scott Whang
    Clearing [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: RunScript - returning from script: pscripts/clearUsersExternalSync.py, threadId: http-bio-8088-exec-471.
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: >>> Warning: The following exception should be localized:Unexpected Python exception: <type 'exceptions.UnicodeEncodeError'> - UnicodeEncodeError('ascii', u'J\xf6rg Wiesmann', 1, 2, 'ordinal not in range(128)')
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: ERROR: com.intraspect.exceptions.IntraspectException in:com.intraspect.browser.RunScriptBrowserCmd: Unexpected Python exception: <type 'exceptions.UnicodeEncodeError'> - UnicodeEncodeError('ascii', u'J\xf6rg Wiesmann', 1, 2, 'ordinal not in range(128)')
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]:  at com.intraspect.browser.RunScriptBrowserCmd.handleException(RunScriptBrowserCmd.java:280)
      at com.intraspect.browser.RunScriptBrowserCmd.doitInternal(RunScriptBrowserCmd.java:239)
      at com.intraspect.browser.BrowserCmd.doit(BrowserCmd.java:207)
      at com.intraspect.servlet.GMServlet$2.doit(GMServlet.java:682)
      at com.intraspect.database.WrapTransaction.withCommandStateNew(WrapTransaction.java:251)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:212)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:107)
      at com.intraspect.database.WrapTransaction.withCommandState(WrapTransaction.java:92)
      at com.intraspect.servlet.GMServlet.runCmdInstanceInternal(GMServlet.java:586)
      at com.intraspect.servlet.GMServlet.runCmdInstance(GMServlet.java:449)
      at com.intraspect.servlet.GMServlet.doGet(GMServlet.java:180)
      at com.intraspect.servlet.GMServlet.service(GMServlet.java:117)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.apache.catalina.filters.RequestDumperFilter.doFilter(RequestDumperFilter.java:203)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
      at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      at com.intraspect.valves.CollabWebDAVFixValve.invoke(CollabWebDAVFixValve.java:34)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    [Mar 13, 2017 9:20:01 AM (http-bio-8088-exec-471_295)]: RawUsageDataWriter: no event mapping for RUN_SCRIPT

     

    Thanks

    Rajesh


    [To post a comment, use the normal reply function]

    Topic:

    Delete user/user data once user is removed from AD

    Forum:

    OpenText Tempo Social Forum

    Content Server:

    Knowledge Center CS16

     

  • Hi Andrew,

    I was able to run the script and didnt noticed any errors. But the users/user data still exists in the collab system. Please advise

    Appreciate your response on this

     

    Thanks

    Rajesh

  • Hey Rajesh,

     

    Please take look into the Collaboration Vignette Edition Administration Guide v 10.5.1 section 1.7.1.3.

     

    User, once created, never gets deleted nor user’s private objects.

     

    More information on the collaboration retention safeguards are covered in section 2.5.2 of the same guide.

     

     

    Regards,


    Andy

     

     

    From: eLink Entry: OpenText Tempo Social Forum [mailto:[email protected]]
    Sent: 22 March 2017 10:31
    To: eLink Recipient
    Subject: RE RE RE Delete user/user data once user is removed from AD

     

    RE RE RE Delete user/user data once user is removed from AD

     

    Posted by Nair, Rajesh On 03/22/2017 06:29 AM

     

     

    Hi Andrew,

    I was able to run the script and didnt noticed any errors. But the users/user data still exists in the collab system. Please advise

    Appreciate your response on this

     

    Thanks

    Rajesh


    [To post a comment, use the normal reply function]

    Topic:

    Delete user/user data once user is removed from AD

    Forum:

    OpenText Tempo Social Forum

    Content Server:

    Knowledge Center CS16

     

Sign In or Register to comment.