[RADIATOR] Change Default Size for Capabilities Field

[James Austin]

Heikki,

That seemed to work.  However I am still unable to get the WiMax device to authenticate.

Can you take a look at the attached debug file and provide your thoughts?

Regards,


James Austin
Manager Technology & Projects
Crystal Communications Ltd.
281-300-8294  Mobile
281-361-5199  Office
________________________________________
From: radiator-bounces at open.com.au [radiator-bounces at open.com.au] On Behalf Of Heikki Vatiainen [hvn at open.com.au]
Sent: Monday, September 22, 2014 11:50 AM
To: radiator at open.com.au
Subject: Re: [RADIATOR] Change Default Size for Capabilities Field

On 09/19/2014 09:42 PM, James Austin wrote:

> 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.

This change does not affect Radiator configuration. Once you have done
the change on the MS SQL server, that should be it. I think something
like this should work:

alter table device_session alter column capabilities ...

Where ... is the new size while the type remains the same. You should
check what the current type is, I did not want to guess it.

Note: the current version 4.13 already uses the longer size so this is
not required for new installations (unless it's still too short).

Thanks,
Heikki


> 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.

--
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.
_______________________________________________
radiator mailing list
radiator at open.com.au
http://www.open.com.au/mailman/listinfo/radiator
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: debug.txt
Url: http://www.open.com.au/pipermail/radiator/attachments/20140923/6324d234/attachment-0001.txt