accounting

John Martins jm829580 at gmail.com
Tue Jul 3 15:10:43 CEST 2018


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
>


More information about the Freeradius-Users mailing list