Hi Can someone help me to get the erx vsa attributtes into the mysql. As I can see they are processed correctly, but the sql statement is empty for this part. Regards Martin Ovenstone relevant VSAs ERX-Input-Gigapkts = 2 ERX-Output-Gigapkts = 1 ERX-Pppoe-Description = "pppoe 00:12:59:12:90:4e" ERX-Ingress-Policy-Name = "L2TP50" == conf.sql .... accounting_stop_query = "INSERT into ${acct_table2} (AcctStatusType, UserName, EventTimestamp, AcctDelayTime, NASIdentifier, AcctSessionId, NASIPAddress, Class, ServiceType, FramedProtocol, FramedCompression, CallingStationId, AcctTunnelConnection, AcctInputGigawords, AcctInputOctets, AcctOutputGigawords, AcctOutputOctets, AcctInputPackets, AcctOutputPackets, ConnectInfo, NASPortType, NASPort, NASPortId, AcctSessionTime, AcctTerminateCause, AcctAuthentic, TunnelType, TunnelPreference, TunnelMediumType, TunnelClientEndpoint, TunnelClientAuthId, TunnelServerEndpoint, TunnelServerAuthId, TunnelAssignmentId, AcctInputGigapackets, AcctOutputGigapackets, PppoeDescription, IngressPolicyName ) values( '%{Acct-Status-Type}', '%{User-Name}', '%{Event-Timestamp}', '%{Acct-Delay-Time}', '%{NAS-Identifier}', '%{Acct-Session-Id}', '%{NAS-IP-Address}', '%{Class}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-Compression}', '%{Calling-Station-Id}', '%{Acct-Tunnel-Connection}', '%{Acct-Input-Gigawords}', '%{Acct-Input-Octets}', '%{Acct-Output-Gigawords}', '%{Acct-Output-Octets}', '%{Acct-Input-Packets}', '%{Acct-Output-Packets}', '%{Connect-Info}', '%{NAS-Port-Type}', '%{NAS-Port}', '%{NAS-Port-Id}', '%{Acct-Session-Time}', '%{Acct-Terminate-Cause}', '%{Acct-Authentic}', '%{Tunnel-Type}', '%{Tunnel-Preference}', '%{Tunnel-Medium-Type}', '%{Tunnel-Client-Endpoint}', '%{Tunnel-Client-Auth-Id}', '%{Tunnel-Server-Endpoint}', '%{Tunnel-Server-Auth-Id}', '%{Tunnel-Assignment-Id}', '%{request:Acct-Input-Gigapackets}', '%{request:Acct-Output-Gigapackets}', '%{request:Pppoe-Description}', '%{request:Ingress-Policy-Name}')" ... === Output of radiusd -X ...... rad_recv: Accounting-Request packet from host 192.168.1.35:49273, id=141, length=453 Acct-Status-Type = Stop User-Name = "testuser@mydomain.net" Event-Timestamp = "Jun 28 2006 00:00:00 CEST" Acct-Delay-Time = 0 NAS-Identifier = "nasxyz" Acct-Session-Id = "erx atm 13/0.1123433234:11.3602:0030292668" NAS-IP-Address = 192.168.21.33 Class = 0x746573745f636c6173735f303031 Service-Type = Framed-User Framed-Protocol = PPP Framed-Compression = None Calling-Station-Id = "#nasxyz#A130#11#3602" Acct-Tunnel-Connection = "0005681578" Acct-Input-Gigawords = 2 Acct-Input-Octets = 703351 Acct-Output-Gigawords = 1 Acct-Output-Octets = 7489000 Acct-Input-Packets = 177814 Acct-Output-Packets = 178321 Connect-Info = "speed:UBR:1536" NAS-Port-Type = xDSL NAS-Port = 3490385426 NAS-Port-Id = "atm 13/0.1123433234:11.3602" Acct-Session-Time = 72024 Acct-Terminate-Cause = NAS-Request Acct-Authentic = RADIUS Tunnel-Type:0 = L2TP Tunnel-Preference:0 = 1 Tunnel-Medium-Type:0 = IP Tunnel-Client-Endpoint:0 = "192.168.25.33" Tunnel-Client-Auth-Id:0 = "nasxyz" Tunnel-Server-Endpoint:0 = "192.168.254.106" Tunnel-Server-Auth-Id:0 = "lau01a03" Tunnel-Assignment-Id:0 = "mydomain.net_106" ERX-Input-Gigapkts = 2 ERX-Output-Gigapkts = 1 ERX-Pppoe-Description = "pppoe 00:13:49:42:90:4e" ERX-Ingress-Policy-Name = "L2TP50" Processing the preacct section of radiusd.conf modcall: entering group preacct for request 0 modcall[preacct]: module "preprocess" returns noop for request 0 rlm_acct_unique: Hashing 'NAS-Port = 3490385426,Client-IP-Address = 192.168.1.35,NAS-IP-Address = 192.168.21.33,Acct-Session-Id = "erx atm 13/0.1123433234:11.3602:0030292668",User-Name = "testuser@mydomain.net"' rlm_acct_unique: Acct-Unique-Session-ID = "8c41e765ee42c86a". modcall[preacct]: module "acct_unique" returns ok for request 0 rlm_realm: Looking up realm "mydomain.net" for User-Name = "testuser@mydomain.net" rlm_realm: No such realm "mydomain.net" modcall[preacct]: module "suffix" returns noop for request 0 modcall[preacct]: module "files" returns noop for request 0 modcall: leaving group preacct (returns ok) for request 0 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 0 radius_xlat: '/var/log/radius/radacct/192.168.1.35/detail-20060803' rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/192.168.1.35/detail-20060803 modcall[accounting]: module "detail" returns ok for request 0 modcall[accounting]: module "unix" returns ok for request 0 radius_xlat: '/var/log/radius/radutmp' radius_xlat: 'testuser@mydomain.net' rlm_radutmp: Logout for NAS 192.168.21.33 port 3490385426, but no Login record modcall[accounting]: module "radutmp" returns ok for request 0 radius_xlat: 'testuser@mydomain.net' rlm_sql (sql): sql_set_user escaped user --> 'testuser@mydomain.net' radius_xlat: 'INSERT into radacct_2 (AcctStatusType, UserName, EventTimestamp, AcctDelayTime, NASIdentifier, AcctSessionId, NASIPAddress, Class, ServiceType, FramedProtocol, FramedCompression, CallingStationId, AcctTunnelConnection, AcctInputGigawords, AcctInputOctets, AcctOutputGigawords, AcctOutputOctets, AcctInputPackets, AcctOutputPackets, ConnectInfo, NASPortType, NASPort, NASPortId, AcctSessionTime, AcctTerminateCause, AcctAuthentic, TunnelType, TunnelPreference, TunnelMediumType, TunnelClientEndpoint, TunnelClientAuthId, TunnelServerEndpoint, TunnelServerAuthId, TunnelAssignmentId, AcctInputGigapackets, AcctOutputGigapackets, PppoeDescription, IngressPolicyName ) values( 'Stop', 'testuser@mydomain.net', 'Jun 28 2006 00:00:00 CEST', '0', 'nasxyz', 'erx atm 13/0.1123433234:11.3602:0030292668', '192.168.21.33', '0x746573745f636c6173735f303031', 'Framed-User', 'PPP', 'None', '=23nasxyz=23A130=2311=233602', '0005681578', '2', '703351', '1', '7489000', '177814', '178321', 'speed:UBR:1536', 'xDSL', '3490385426', 'atm 13/0.1123433234:11.3602', '72024', 'NAS-Request', 'RADIUS', 'L2TP', '1', 'IP', '192.168.25.33', 'nasxyz', '192.168.254.106', 'lau01a03', 'mydomain.net_106', '', '', '', '')' radius_xlat: '/var/log/radius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_mysql: query: INSERT into radacct_2 (AcctStatusType, UserName, EventTimestamp, AcctDelayTime, NASIdentifier, AcctSessionId, NASIPAddress, Class, ServiceType, FramedProtocol, FramedCompression, CallingStationId, AcctTunnelConnection, AcctInputGigawords, AcctInputOctets, AcctOutputGigawords, AcctOutputOctets, AcctInputPackets, AcctOutputPackets, ConnectInfo, NASPortType, NASPort, NASPortId, AcctSessionTime, AcctTerminateCause, AcctAuthentic, TunnelType, TunnelPreference, TunnelMediumType, TunnelClientEndpoint, TunnelClientAuthId, TunnelServerEndpoint, TunnelServerAuthId, TunnelAssignmentId, AcctInputGigapackets, AcctOutputGigapackets, PppoeDescription, IngressPolicyName ) values( 'Stop', 'testuser@mydomain.net', 'Jun 28 2006 00:00:00 CEST', '0', 'nasxyz', 'erx atm 13/0.1123433234:11.3602:0030292668', '192.168.21.33', '0x746573745f636c6173735f303031', 'Framed-User', 'PPP', 'None', '=23nasxyz=23A130=2311=233602', '0005681578', '2', '703351', '1', '7489000', '177814', '178321', 'speed:UBR:1536', 'xDSL', '3490385426', 'atm 13/0.1123433234:11.3602', '72024', 'NAS-Request', 'RADIUS', 'L2TP', '1', 'IP', '192.168.25.33', 'nasxyz', '192.168.254.106', 'lau01a03', 'mydomain.net_106', '', '', '', '') rlm_sql (sql): Released sql socket id: 0 modcall[accounting]: module "sql" returns ok for request 0 modcall: leaving group accounting (returns ok) for request 0 Sending Accounting-Response of id 141 to 192.168.1.35 port 49273