[SR-Users] P_usrloc - expired locations
Helena Garcia-Nieto
helena.gnieto at morodo.co.uk
Thu Jan 23 17:06:12 CET 2014
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 at kamailio.org]
Sent: jueves, 23 de enero de 2014 17:05
To: sr-users at 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
More information about the sr-users
mailing list