Author |
Message |
CastB Brekeke Addict
Joined: 05 Feb 2011 Posts: 32
Location: the Netherlands
|
Posted: Tue May 24, 2011 7:09 am Post subject: t_registered table question |
|
|
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/networkpatterns.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! |
|
Back to top |
|
hope Brekeke Master Guru
Joined: 15 Jan 2008 Posts: 862
|
Posted: Thu May 26, 2011 5:08 pm Post subject: |
|
|
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. |
|
Back to top |
|
CastB Brekeke Addict
Joined: 05 Feb 2011 Posts: 32
Location: the Netherlands
|
Posted: Fri May 27, 2011 2:48 pm Post subject: |
|
|
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. |
|
Back to top |
|
hope Brekeke Master Guru
Joined: 15 Jan 2008 Posts: 862
|
Posted: Tue May 31, 2011 11:28 am Post subject: |
|
|
i'm not sure what the awake field is for. |
|
Back to top |
|
janP Brekeke Master Guru
Joined: 25 Nov 2007 Posts: 336
|
Posted: Wed Jun 01, 2011 3:15 pm Post subject: |
|
|
>> 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. |
|
Back to top |
|
|