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.