[SR-Users] P_usrloc - expired locations

Henning Westerholt hw at kamailio.org
Thu Jan 23 17:04:35 CET 2014


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



More information about the sr-users mailing list