[RADIATOR] Change Default Size for Capabilities Field

[James Austin]

Heiki,

Need to implement below on a Windows 2008R2 that's running Radiator using mssql for DB.  Got your original msg from Nick Dewar with Telrad.
  
Looks like the default size for capabilities field in the DB is not long
enough. We will update the default wimax.sql file to accomondate this.
 
Please do this:
 
% mysql --user=mikem --password=fred wimax
...
mysql> alter table device_session modify capabilities varchar(500);
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
This should make the capabilities column long enough to store the long data.
 
The DB is used to cache keys for the sessions for possible later use.
 
Thanks,
Heikki
 
 
> Thu Nov  7 08:56:57 2013: DEBUG: Query to 'dbi:mysql:wimax': 'select sessionid, mip_rk, mip_spi, fa_rk from device_sessi
> on where sessionid=?': 71e628120e103b761a02d722169bc9f1
> Thu Nov  7 08:56:57 2013: DEBUG: do query to 'dbi:mysql:wimax': 'insert into device_session (outer_nai, sessionid, napid
> , bsid, nspid, msid, capabilities, timezoneoffset, nai, cui, mip_rk, mip_spi, fa_rk, key_expires) values (?, ?, ?, ?, ?,
>  ?, ?, ?, ?, ?, ?, ?, ?, ?)': {am=1}3B3E025B6EE8544B5B7F3CB97C2D2C2A at WiMax.com 71e628120e103b761a02d722169bc9f1   â ☺☻♥
>  20-10-7A-A3-34-A0 52656c656173653d312e302c4163636f756e74696e672d4361706162696c69746965733d49502d53657373696f6e2d4261736
> 5642c41534e2d4e6574776f726b2d536572766963652d4361706162696c69746965733d363530 0 test  1524b4d44461082cc3711be9db0cedd194
> 77ce4cd841cc749332df003e810bc0e41056b91779373955f407b1b7013ca4a29fc4815f38fc07c3c03c96b68b646f 2187798856 5d0016276497ac
> 05de0b866dc47b4ffbbbe82133 1383872217
> Thu Nov  7 08:56:57 2013: ERR: do failed for 'insert into device_session (outer_nai, sessionid, napid, bsid, nspid, msid
> , capabilities, timezoneoffset, nai, cui, mip_rk, mip_spi, fa_rk, key_expires) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?)': Data too long for column 'capabilities' at row 1
> Thu Nov  7 08:56:57 2013: DEBUG: Connecting to 'dbi:mysql:wimax'
> 
> Thu Nov  7 08:56:57 2013: ERR: do failed for 'insert into device_session (outer_nai, sessionid, napid, bsid, nspid, msid
> , capabilities, timezoneoffset, nai, cui, mip_rk, mip_spi, fa_rk, key_expires) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?)': Data too long for column 'capabilities' at row 1
> Thu Nov  7 08:56:57 2013: DEBUG: AuthBy WIMAX result: IGNORE, Failed to create new device_session
> Thu Nov  7 08:57:02 2013: DEBUG: Packet dump:
> *** Received from 192.168.11.10 port 1812 ....


James Austin
Manager Technology & Projects
Crystal Communications Ltd.
281-300-8294  Mobile
281-361-5199  Office