powered by Jive Software

Ldap and database

Hi,

when i delete user from ldap, the roster and its groups remains in database, for ex. user suspended was deleted from the AD, but its garbage still persist in the database:

mysql> select * from ofRoster;

±---------±--------------±-------------------------±----±----±-----±----- --------------------+

| rosterID | username | jid | sub | ask | recv | nick |

±---------±--------------±-------------------------±----±----±-----±----- --------------------+

| 1 | administrator | rty@mt-lab-server08 | 0 | 0 | -1 | NULL |

| 6 | suspended | suspended1@192.168.36.18 | 0 | 0 | -1 | suspended1@192.168.36.18 |

| 7 | suspended | suspended3@192.168.36.18 | 0 | 0 | -1 | NULL |

±---------±--------------±-------------------------±----±----±-----±----- --------------------+

3 rows in set (0.00 sec)

mysql> select * from ofRosterGroups;

±---------±-----±----------+

| rosterID | rank | groupName |

±---------±-----±----------+

| 6 | 0 | test |

| 7 | 0 | test |

±---------±-----±----------+

2 rows in set (0.00 sec)

Please give me and advice how to delete the user and clean its garbage i a right way, sure i can create some script to do that, but i think its not an option. Thanks.