accounting

[Uchenna Nebedum]

You're welcome it was the same problem i had, Alan helped me with it.
Always test the installation before adding NAS, that way you can ask more
precise questions.

On Tue, Jul 3, 2018, 14:10 John Martins <jm829580 at gmail.com> wrote:

> now, loook the debug below :
>
> (1) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'acctupdatetime'
> in 'field list'): 42S22
>
> On Tue, Jul 3, 2018 at 2:30 PM, Uchenna Nebedum <nebeduch at gmail.com>
> wrote:
>
> > You sent accounting packet to authentication port.
> >
> > On Tue, Jul 3, 2018, 13:26 John Martins <jm829580 at gmail.com> wrote:
> >
> > > Hello Uchenna,
> > >
> > > Could you tell me in which table was this  acctupdate column missing?
> > When
> > > I send accounting packets from NTRadPing, I get the following error:
> > >
> > > Ready to process requests
> > > Receive - Invalid packet code 4 sent to authentication port from client
> > > global
> > > p
> > > ort 57825
> > > Ready to process requests
> > > Receive - Invalid packet code 4 sent to authentication port from client
> > > global
> > > p
> > > ort 57825
> > > Receive - Invalid packet code 4 sent to authentication port from client
> > > global
> > > p
> > > ort 57825
> > > Ready to process requests
> > > Receive - Invalid packet code 4 sent to authentication port from client
> > > global
> > > p
> > > ort 57825
> > > Ready to process requests
> > >
> > >
> > > Any clue?
> > >
> > > thanks
> > >
> > >
> > >
> > >
> > > On Tue, Jul 3, 2018 at 8:03 AM, Uchenna Nebedum <nebeduch at gmail.com>
> > > wrote:
> > >
> > > > In my freeRADIUS installation from ubuntu repo accounting wasn't
> > working
> > > > because the acctupdate column was missing from the schema. So what
> I'd
> > > > suggest would be to use radclient or NTRadPing and send accounting
> > > packets
> > > > with freeRADIUS in debug mode and watch the output.
> > > >
> > > > On Tue, Jul 3, 2018, 01:40 Alan DeKok <aland at deployingradius.com>
> > wrote:
> > > >
> > > > > On Jul 2, 2018, at 7:52 PM, John Martins <jm829580 at gmail.com>
> wrote:
> > > > > >
> > > > > > The module sql is configured as per wiki, I suppose it's correct.
> > How
> > > > > can I
> > > > > > know if it is properly configured?
> > > > >
> > > > >   If you read the debug output and it shows the SQL module running
> > > > without
> > > > > errors.
> > > > >
> > > > > > have the NAS send the server accounting packets. the NAS is
> sending
> > > > > > packets, plus I test it also from terminal with radtest.
> > > > > > Can you tell me what do you mean when you say that the NAS is not
> > > > sending
> > > > > > packets? the NAS is my router, right? it is sending them.
> > > > >
> > > > >   *ACCOUNTING* packets.  Which, as I said, are not the same as
> > > > > authentication packets.
> > > > >
> > > > >   If you're going to configure a RADIUS server, it helps to
> > understand
> > > > the
> > > > > basic terminology.  Or if you don't understand the terminology I'm
> > > using,
> > > > > ask.
> > > > >
> > > > >   Alan DeKok.
> > > > >
> > > > >
> > > > > -
> > > > > List info/subscribe/unsubscribe? See
> > > > > http://www.freeradius.org/list/users.html
> > > > -
> > > > List info/subscribe/unsubscribe? See http://www.freeradius.org/
> > > > list/users.html
> > > >
> > > -
> > > List info/subscribe/unsubscribe? See
> > > http://www.freeradius.org/list/users.html
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/
> > list/users.html
> >
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html