Hi Steve,
On Jan 3, 1:50pm, Steve Suehring wrote:
> Subject: Re: (RADIATOR) What am I doing wrong?
> 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.
OK, let us know what you find. Could it have been some unprintable chartacters
in your config file?
Cheers.
>
> 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
> >
>
>
>-- 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.
