Hello-
The NAS-Identifier isn't getting inserted into our sql accounting
table. I've poked around and can't find the reason. Everything looks
right but a trace level 4 indicates that radiator is not even attempting
to put it in there. Here is the revelant portion from the config:
AccountingTable ACCOUNTING
AccountingStopsOnly
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
AcctColumnDef ACCTDELAYTIME,Acct-Delay-Time,integer
AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
AcctColumnDef ACCTSESSIONID,Acct-Session-Id
AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
AcctColumnDef NASIDENTIFIER,NAS-IP-Address,char
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address
Sun Jan 2 11:02:32 2000: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME,
ACCTTERMINATECAUSE, NASPORT, FRAMEDIPADDRESS)
values
Originally I did _not_ define the NASIDENTIFIER as char in the config so I
changed it to explicitly define it as a char... no luck. Basically this
is just a copied config from the Radiator manual. The only exception
is that instead of NAS-Identifier, the packets I'm seeing have
NAS-IP-Address instead. I've tried is as NAS-Identifier as well.
I'm kinda confused here too. We're using an SQL session database as well
and it has the default insert statement and it works fine. This menas
that it's using NAS-Identifier as an attribute. Originally our
AcctColumnDef was as NAS-Identifier. I only changed it to NAS-IP-Address
when that one didn't work and I looked at the packet. If I change
attribute(not the field name) in the AcctColumnDef do I need to do
anything else except restart radius?
Attributes:
User-Name = "suehring"
NAS-IP-Address = xxx.xxx.xxx.xxx <-- (This was defined correctly)
Acct-Status-Type = Stop
Acct-Session-Id = "151263824"
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
Service-Type = Framed-User
NAS-Port-Type = Async
NAS-Port = 2309
Calling-Station-Id = ""
Called-Station-Id = ""
Framed-Protocol = PPP
Framed-IP-Address = xxx.xxx.xxx.xxx
Acct-Session-Time = 3041
Acct-Terminate-Cause = User-Request
Acct-Input-Octets = 202974
Acct-Output-Octets = 2518389
Acct-Input-Packets = 4778
Acct-Output-Packets = 5746
I've got to be doing something wrong!!! It has to be a typo somwehere.
Steve
p.s. Here's the column defs from SQL:
+--------------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+----------+------+-----+---------+-------+
| USERNAME | char(50) | | MUL | | |
| TIME_STAMP | int(11) | YES | | NULL | |
| ACCTSTATUSTYPE | char(10) | YES | | NULL | |
| ACCTDELAYTIME | int(11) | YES | | NULL | |
| ACCTINPUTOCTETS | int(11) | YES | | NULL | |
| ACCTOUTPUTOCTETS | int(11) | YES | | NULL | |
| ACCTSESSIONID | char(30) | YES | | NULL | |
| ACCTSESSIONTIME | int(11) | YES | | NULL | |
| ACCTTERMINATECAUSE | int(11) | YES | | NULL | |
| NASIDENTIFIER | char(50) | YES | | NULL | |
| NASPORT | int(11) | YES | | NULL | |
| FRAMEDIPADDRESS | char(22) | YES | | NULL | |
+--------------------+----------+------+-----+---------+-------+
------------------------------------------------------
Steve Suehring
Voyager.net Network Operations Systems Engineer
------------------------------------------------------
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
