That was wierd. I have two different acctsql portions in the config file,
one was getting the info one wasn't. I had to match them up and now it
appears all is well. I'm going to do some more digging to see if I can
find any more details.
Thanks for the help.
Steve
------------------------------------------------------
Steve Suehring
Voyager.net Network Operations Systems Engineer
------------------------------------------------------
On Mon, 3 Jan 2000, Mike McCauley wrote:
> 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.
