cancel
Showing results for 
Search instead for 
Did you mean: 

Failed CST update and possible to use truncate Sbr_CurrentSessions ?

wangchun.sha_
New Contributor

Failed CST update and possible to use truncate Sbr_CurrentSessions ?

Hi, there

Any one have seen this error in SBR message logs before?

=================

05/31/2011 18:04:32 (0065): Looking up shared secret
05/31/2011 18:04:32 (0065): Statistics attributes included in packet that is not an accounting STOP. Processing continues.
05/31/2011 18:04:32 (0065): NAS-IP-Address in request: x.x.x.x

05/31/2011 18:04:32 (0065): Determining if this radius should act as a proxy
05/31/2011 18:04:32 (0065): Sending accounting response
05/31/2011 18:04:32 (0065): Failed CST update for NAS="x.x.x.x", user="USER10" error code: -1
05/31/2011 18:04:32 (0065): Error in CST while processing acct request ignored
05/31/2011 18:04:32 (0065): Sending accounting response

=================

And why CST is failed ?

This radius server also report a lot of RemoveExiredHARKObjects error:

==============

05/31/2011 17:40:58 (0049): RemoveExpiredHARKObjects returned 0x'ffffffff'
05/31/2011 17:40:58 (0049): RemoveExpiredDHCPRKObjects returned 0x'ffffffff'
05/31/2011 17:40:58 (0049): RemoveExpiredReauthenticationRecords returned 0x'ffffffff'
05/31/2011 17:40:58 (0049): RemoveExpiredMobilityKeysObjects returned 0x'ffffffff'
05/31/2011 17:40:58 (0049): RemoveExpiredTtlsCacheRecords returned 0x'ffffffff'
05/31/2011 17:41:17 (0049): RemoveExpiredHARKObjects returned 0x'ffffffff'
05/31/2011 17:41:17 (0049): RemoveExpiredDHCPRKObjects returned 0x'ffffffff'
05/31/2011 17:41:17 (0049): RemoveExpiredReauthenticationRecords returned 0x'ffffffff'
05/31/2011 17:41:17 (0049): RemoveExpiredMobilityKeysObjects returned 0x'ffffffff'
05/31/2011 17:41:17 (0049): RemoveExpiredTtlsCacheRecords returned 0x'ffffffff'

==============

I check the CST table using

mysql -D SteelBeltedRadius -e "select count(*) from Sbr_CurrentSessions where Sbr_ExpirationTime < now()";

[email protected]:~> mysql -D SteelBeltedRadius -e "select count(*) from Sbr_CurrentSessions where Sbr_ExpirationTime < now()";

+----------+
| count(*) |
+----------+
| 273359 |
+----------+

But if I check the table status: cst table have about 1960077 sessions.

mysql> show table status;
-------------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+-------------------------+------------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+
| Sbr_Abort | ndbcluster | 10 | Fixed | 1 | 28 | 32768 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | |
| Sbr_CdrAccounts | ndbcluster | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | |
| Sbr_CurrentSessions | ndbcluster | 10 | Dynamic | 1960077 | 108 | 508428288 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | |
|

May I use

mysql -D SteelBeltedRadius -e "truncate Sbr_CurrentSessions";

To clear the CST table ?

b/r

Sha

4 REPLIES 4
vbarsalou_
Occasional Contributor

Re: Failed CST update and possible to use truncate Sbr_CurrentSessions ?

Error code -1 is a generic ndb error, and could be caused by corruption in your database or an invalid field in the request. What version are you running?_

overburdened_
Contributor

Re: Failed CST update and possible to use truncate Sbr_CurrentSessions ?

Can you post the packet details?

This message is a bit strange: "Statistics attributes included in packet that is not an accounting STOP"

You may have some bad formated radius packets.

There are scripts in the /opt/JNPRHadm directory to clear out the CST table, if that is really what you want to do. You can use the DelSession.sh script: DelSession -a

Please be careful as this will remove ALL sessions from the table.

wangchun.sha_
New Contributor

Re: Failed CST update and possible to use truncate Sbr_CurrentSessions ?

Hi,

thanks for your reponse.

My radius is running on 7.20.4782. on SunOS 5.10.

I guess it is due to some fault in the database. How could fix that ?

And in my folder of /opt/JNPRhadm/, I don't have DeleteSession.sh Smiley Sad

Thanks in advance.

b/r

Sha

jcanchola_
Contributor

Re: Failed CST update and possible to use truncate Sbr_CurrentSessions ?

You may want to open a case with JTAC, It looks like you have quite a few problems that will take a more attention than we can give you through the forum.

I wouldn't think it is a problem with the database, but we need to make sure that SBR is able to communicate with the database and that there isn't anything major missing.