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}[email protected]
> 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
_______________________________________________
radiator mailing list
[email protected]
http://www.open.com.au/mailman/listinfo/radiator
