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:h...@kamailio.org] Sent: jueves, 23 de enero de 2014 17:05 To: sr-users@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 _______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
