Hi, ok. good point in a high traffic env.
The same thing may work if you build a binary which works with the ul_delete_urecord(domain, aor) (http://www.opensips.org/html/docs/modules/1.5.x/usrloc.html) and call it each time a user registers. BR uwe Jayesh Nambiar schrieb: > Hi Uwe, > This will not work well if i use db_mode as 2 in the usrloc module. > db_mode 1 does lot of DB queries !!! > > --- Jay > > On Wed, Jun 17, 2009 at 4:33 PM, Uwe Kastens <ki...@kiste.org > <mailto:ki...@kiste.org>> wrote: > > Hi, > > You could solve this by working with AVP and sql. The idea could be: > > if (method=="REGISTER"){ > Authentication goes here > $avp(s:user)=$aU; > avp_db_query("select count() from location where > username='$avp(s:user)'","var(x)"); > > if var(x) > 0 { > avp_db_query("delete from location where username='$avp(s:user)'"); > } > > save("location"); > Untested! > > BR > > Uwe > Jayesh Nambiar schrieb: > > Hi All, > > I had a requirement of allowing only one registration per user in a > > particular scenario. I did not want to use the max_contacts > parameter of > > registrar module as it wont work right !!! The drawback was: > > If device A had registered successfully and for some reason got > > disconnected from the internet, the device won't unregister itself. > > Opensips still has the record in the location table for that > device, now > > if the internet comes back and when the device tries to register > again, > > opensips will not allow since it already has the record in the > location. > > The device will have to wait until the earlier registration expires in > > the opensips. > > The idea was to have a way of updating the location table if same user > > is trying to REGISTER from same location or different location. > Meaning > > if user A is registered from location A and someone else using same > > credentials of user A tries to register from location B, the location > > table should only update the earlier record to location B and not keep > > location A and location B both for user A. > > > > Is there a way to do this. Any help will be highly appreciiated. > > > > Thanks in advance. > > > > --- Jay > > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Users mailing list > > Users@lists.opensips.org <mailto:Users@lists.opensips.org> > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > -- > > kiste lat: 54.322684, lon: 10.13586 > > -- kiste lat: 54.322684, lon: 10.13586 _______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users