t_registered table question

CastB · Post by **CastB** » Tue May 24, 2011 7:09 am

1. Brekeke Product Name and version: Brekeke SIP Server advanced 2.4.7.3/286.1

2. Java version: 1.6.0_17

3. OS type and the version: Linux 2.6.18-194.32.1.el5.centos.plus

4. UA (phone), gateway or other hardware/software involved: several

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html : UA behind NAT BKK on the public

6. Your problem:

Hi,

I was looking at the t_registered table (mysql database) and noticed several registered clients in that table from which the expires time is almost 1 day ago. Those expired users does not show up in the BKK admin tool as expected.

Can someone explain to me when BKK remove those users from the database?

Can someone explain to me the goal of the field "awake" in the t_registerd table?

Thanks!

hope · Post by **hope** » Thu May 26, 2011 5:08 pm

the expired record in database is because the client didnot send re-register request to Brekeke and when you check "registered clients" page, brekeke will query to db and select the entry with valid expire time and show in the web page, but it will not delete the expired record from database.
when you restart brekeke sip server the expired record in database may be removed.

CastB · Post by **CastB** » Fri May 27, 2011 2:48 pm

Ok, that explains it, thanks.

So i assume there is no problem if i delete the expired records directly from the database by using a schedule or something.

Do you know what the awake field does? There seems no relation between that field and the expiration of a registration?

Thanks.

hope · Post by **hope** » Tue May 31, 2011 11:28 am

i'm not sure what the awake field is for.

janP · Post by **janP** » Wed Jun 01, 2011 3:15 pm

>> Can someone explain to me when BKK remove those users from the database?

Brekeke SIP Server checks the database and removes expired records frequently while the server is running.
It means you don't have to care about such expired records.

>> Can someone explain to me the goal of the field "awake" in the t_registerd table?

If "awake" is true, Brekeke SIP Server will send a dummy SIP packet for keep-alive a UA and NAT's port-mapping.

Generally, it will be "true" automatically if a UA is in behind NAT.