On Mon 10 Apr 2006 23:21, Mathieu Legare wrote:
Using freeradius 1.1.0 on RHEL 4.0 update 3 with Oracle 9 database backend for accounting, we discovered the following problem while trying to add our wireless stuff to our RADIUS system. We've been using the current setup for PPP login with a Cisco access server without any problem.
So the NAS is a Nortel WLAN Security Switch 2380 (more or less a Trapeze device if i am not mistaken). The WLAN switch sends a "start accounting" packet, unfortunalety the content of the %{NAS-Port-Id} variable that the WLAN switch sends seems to be in the following format: "2049/1" which is NOT a NUMERIC(12) (or integer if using the MySQL driver). This cause an ORA-01722 error . We've changed the NasPortId field type to VARCHAR2(15) to fix the problem.
I really don't know if changing the type of the NasPortId field to varchar2 can introduce other problems, so far we haven't notice any.
Although I have not seen this type of value previously the RFC does device NAS-Port-Id as string so I will update all of the sample schemas to take this into account. Regards -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc