23 Jan
2014
23 Jan
'14
6:04 p.m.
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