Am Donnerstag, 23. Januar 2014, 16:59:30 schrieb Helena Garcia-Nieto:
I am testing the p_usrloc module in order to write the location information of my kamailo server (Kamailio is on version 4.0.2) in two db
As first test both DB are on the same machine, as well as the master db. On final version master and one db would probably be on the same machine and the second db on a different one.
I have read on the p_usrloc module the following note:
The p_usrloc module still has some missing feature, like automatic expiry of contacts and dumping of all users via the fifo cmd.
And I can sadly see that the locations are not being deleted automatically after expiring. [..] Have anyone found a solution or can give me some advice on how can I force the expired locations to be erased from the db, just as the usrloc module does?
Hallo Helena,
we use just a simple regular job (started with linux standard tools like cron etc..) that deletes regularly all old registrations on the databases. Use plain SQL, "DELETE FROM $table WHERE expires < NOW()" or similar.
Best regards,
Henning Westerholt