[Help-gnu-radius] Error and acct_stop_query

[Morten Winther]

Hi

I now use the patches you send me.

However a zero is appended to all NAS-IP-Address in mysql, like: 
0217.157.161.246

Its not the query in sqlserver:

acct_start_query        INSERT INTO accounting \
                       (status, username, event_start, nas_ip_address, 
nas_port_id, \
                       nas_ident, acct_session_id, framed_ip_address, \
                       called_station_id, calling_station_id) VALUES ( \
                       %C{Acct-Status-Type},\
                       '%u',\
                       now(),\
                       '%C{NAS-IP-Address}',\
                       '%C{NAS-Port-Id}',\
                       '%C{NAS-Identifier}',\
                       '%C{Acct-Session-Id}',\
                       '%C{Framed-IP-Address}',\
                       '%C{Called-Station-Id}',\
                       '%C{Calling-Station-Id}')


I have a lot of theese - every 5th min:

Tue Apr 27 08:56:53 2004
       Acct-Status-Type = Stop
       Acct-Session-Id = 00000000000000000000
       Acct-Terminate-Cause = NAS-Reboot
       NAS-Identifier = CPHCSO01
       Called-Station-Id = 00-90-0E-00-74-AC
       NAS-Port-Type = 15
       User-Name =
       Timestamp = 1083049013
       Request-Authenticator = Verified

Apr 27 09:23:11 Acct.warning: (Accounting-Request ip 0 "" 
CSID=00-90-0E-00-74-AC): acct_stop_query updated 0 records
Apr 27 09:26:57 Acct.warning: (Accounting-Request ip 0 "" 
CSID=00-90-0E-00-74-A0): acct_stop_query updated 0 records
Apr 27 09:27:42 Acct.warning: (Accounting-Request ip 0 "" 
CSID=00-90-0E-00-75-76): acct_stop_query updated 0 records
Apr 27 09:28:26 Acct.warning: (Accounting-Request ip 0 "" 
CSID=00-90-0E-00-74-AC): acct_stop_query updated 0 records
Apr 27 09:32:12 Acct.warning: (Accounting-Request ip 0 "" 
CSID=00-90-0E-00-74-A0): acct_stop_query updated 0 recor

Is the nas going crazy?
Should this execute the acct_nasdown_query or the acct_stop_query ?



--
Best regards

Morten Winther
System & Application Architect

MW Interactive 

E-mail: address@hidden
Mobile: +45 60 60 66 66
http://www.mwi.dk

--
Best regards

Morten Winther
System & Application Architect

MW Interactive 

E-mail: address@hidden
Mobile: +45 60 60 66 66
http://www.mwi.dk