3 Jul
2018
3 Jul
'18
9:10 a.m.
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@gmail.com> wrote: > You sent accounting packet to authentication port. > > On Tue, Jul 3, 2018, 13:26 John Martins <jm829580@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@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@deployingradius.com> > wrote: > > > > > > > On Jul 2, 2018, at 7:52 PM, John Martins <jm829580@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 >