Hello Henning
Thanks for the advice!
We probably need to do that! But... there is no module configuration or
simple kamailio configuration to do it?
Thanks again!!
Helena
-----Original Message-----
From: Henning Westerholt [mailto:hw@kamailio.org]
Sent: jueves, 23 de enero de 2014 17:05
To: sr-users(a)lists.sip-router.org
Cc: Helena Garcia-Nieto
Subject: Re: [SR-Users] P_usrloc - expired locations
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