problem with oracle scheme - table radacct

Peter Nixon listuser at peternixon.net
Tue Apr 11 15:07:45 CEST 2006


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060411/5fc7ec62/attachment.pgp>


More information about the Freeradius-Users mailing list