Hi Steve,
On Jan 2, 11:24am, Steve Suehring wrote:
> Subject: (RADIATOR) What am I doing wrong?
> 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:
Im puzzled too. The config looks fine: with the opacket whose dump you sent, I
would expect top see it inserted.
Can you please send to me a more complete transcript from your trace 4 log?
Have you modified the dictionary at all?
Cheers.
>
> 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.
>-- End of excerpt from Steve Suehring
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
