[RADIATOR] Mysql error in "View log"...

Hugh Irvine hugh at open.com.au
Sat Feb 21 00:25:53 CST 2009


Hello Tim -

Comments below.

On 20 Feb 2009, at 20:38, Tim Dancer wrote:

> Hi Hugh,
>
> Thanks for the reply. It only appears once but then everything seems  
> to function correctly. PPPOE log's in perfectly and the NAS clients  
> are all being taken into consideration, so it is definitely using  
> the Radmin Mysql db data.
>

I'm not sure why this would happen - is the MySQL database on the same  
machine?

> We're running:
>
> Radiator 4.3.1 (trial)
> Centos 5.2
> Mysql 5.0.45
> Radmin 1.11 (Mysql)
> Mikrotik 3.20 (Router)
>
> Another issue:
>
> I can authenticate using PPPOE but PPTP isn't sending the router the  
> right info? My reply contains:
>
> Framed-Protocol = PPP
> Framed-Routing = None
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
> Framed-Routing = none
> Framed-Poo = hs-pool-2 (works and allocates the correct ip's)
> Service-Type = Framed-User
>

The reply shown in the debug has MS-MPPE-Send-Key and MS-MPPE-Recv-Key  
set, so I don't know what else to suggest other than to ask the vendor  
what RADIUS attributes are required in the reply.

Radiator is getting an accounting start, which normally indicates that  
the session has successfully started.

What does the debug on the Mikrotik router show?

regards

Hugh


> When I initiate a PPTP connection, the router shows the  
> authentication is successful but disconnects immediately. When  
> checked my local machine logs I get "MPPE required but peer  
> refused". Would I need different reply attributes for PPTP?
>
> Below is a debug output of a PPTP attempt and a
>
> [root at localhost ~]# radiusd -foreground -log_stdout -trace 4 - 
> config_file /etc/radiator/radius.cfgFri Feb 20 19:30:56 2009: DEBUG:  
> Creating StreamServer tcp port 0.0.0.0:9048
> Fri Feb 20 19:30:56 2009: DEBUG: Adding Clients from SQL database
> Fri Feb 20 19:30:56 2009: DEBUG: Query is: 'select
> 	NASIDENTIFIER,
> 	SECRET,
> 	IGNOREACCTSIGNATURE,
> 	DUPINTERVAL,
> 	DEFAULTREALM,
> 	NASTYPE,
> 	SNMPCOMMUNITY,
> 	LIVINGSTONOFFS,
> 	LIVINGSTONHOLE,
> 	FRAMEDGROUPBASEADDRESS,
> 	FRAMEDGROUPMAXPORTSPERCLASSC,
> 	REWRITEUSERNAME,
> 	NOIGNOREDUPLICATES,
> 	PREHANDLERHOOK from RADCLIENTLIST':
> Fri Feb 20 19:30:56 2009: DEBUG: ClientListSQL adds Client  
> 192.168.1.118
> Fri Feb 20 19:30:56 2009: DEBUG: ClientListSQL adds Client  
> 192.168.1.121
> Fri Feb 20 19:30:56 2009: DEBUG: ClientListSQL adds Client 192.168.1.3
> Fri Feb 20 19:30:56 2009: DEBUG: Finished reading configuration file  
> '/etc/radiator/radius.cfg'
> This Radiator license will expire on 2009-03-30
> This Radiator license will stop operating after 1000 requests
> To purchase an unlimited full source version of Radiator, see
> http://www.open.com.au/ordering.html
> To extend your license period, contact admin at open.com.au
>
> Fri Feb 20 19:30:56 2009: DEBUG: Reading dictionary file '/etc/ 
> radiator/dictionary'
> Fri Feb 20 19:30:56 2009: DEBUG: Creating authentication port  
> 0.0.0.0:1645
> Fri Feb 20 19:30:56 2009: DEBUG: Creating accounting port 0.0.0.0:1646
> Fri Feb 20 19:30:56 2009: NOTICE: Server started: Radiator 4.3.1 on  
> localhost.localdomain (LOCKED)
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 54973 ....
> Code:       Access-Request
> Identifier: 39
> Authentic:  Ay<230><163><189><233>(G<141>q<214><233><28>x<225><190>
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 16
> 	NAS-Port-Type = Virtual
> 	User-Name = "test123"
> 	Calling-Station-Id = "192.168.1.3"
> 	Called-Station-Id = "192.168.1.118"
> 	MS-CHAP-Challenge = <207>\<225>)I<145><196><229> 
> +<243><144><226><205><4><221><165>
> 	MS-CHAP2-Response =  
> < 
> 1 
> > 
> < 
> 0 
> > 
> < 
> 12 
> > 
> J 
> < 
> 132 
> > 
> 4W 
> < 
> 203 
> > 
> < 
> 12 
> > 
> < 
> 23 
> > 
> < 
> 163><197><211><254><31><6><208><223><0><0><0><0><0><0><0><0><207>3Cc- 
> u<164><237><200><225>Hp<177><246><206>b<192>n<255><210><185><241><12>s
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
>
> Fri Feb 20 19:31:01 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:01 2009: DEBUG:  Deleting session for test123,  
> 192.168.1.118, 16
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=016':
> Fri Feb 20 19:31:01 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:01 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:01 2009: DEBUG: Query is: 'select PASS_WORD,  
> STATICADDRESS, TIMELEFT, MAXLOGINS, SERVICENAME, BADLOGINS,  
> VALIDFROM, VALIDTO from RADUSERS where USERNAME='test123'':
> Fri Feb 20 19:31:01 2009: DEBUG: Query is: 'select ATTR_ID,  
> VENDOR_ID, IVALUE, SVALUE, ITEM_TYPE from RADSTCONFIG where  
> NAME='Standard' order by ITEM_TYPE':
> Fri Feb 20 19:31:01 2009: DEBUG: Query is: 'select ATTR_ID,  
> VENDOR_ID, IVALUE, SVALUE, ITEM_TYPE from RADCONFIG where  
> NAME='test123' order by ITEM_TYPE':
> Fri Feb 20 19:31:01 2009: DEBUG: Radius::AuthRADMIN looks for match  
> with test123 [test123]
> Fri Feb 20 19:31:01 2009: DEBUG: Query is: 'select NASIDENTIFIER,  
> NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where  
> USERNAME='test123'':
> Fri Feb 20 19:31:01 2009: DEBUG: ValidFrom date converted to:  
> 1234831800
> Fri Feb 20 19:31:01 2009: DEBUG: Expiration date converted to:  
> 1266357600
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'update RADUSERS set  
> BADLOGINS=0 where USERNAME='test123'':
> Fri Feb 20 19:31:01 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:01 2009: DEBUG: Access accepted for test123
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'insert into  
> RADAUTHLOG (TIME_STAMP, USERNAME, TYPE) values (1235151061,  
> 'test123', 1)':
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 54973 ....
> Code:       Access-Accept
> Identifier: 39
> Authentic:  <146><228>Y<247><20>:<176><9>8<171>F4<3<168>x
> Attributes:
> 	MS-CHAP2-Success = "<1>S=6961663B7B530C846F51472C77E073A8C5269FF2"
> 	MS-MPPE-Send-Key = >l<200>J02<161><245>l<20><200><175>+]<218><250>
> 	MS-MPPE-Recv-Key =  
> <137>AR<154><255><241><229><210>)<144><241><1><225>0a<180>
> 	Service-Type = Framed-User
> 	Framed-Compression = Van-Jacobson-TCP-IP
> 	Framed-Protocol = PPP
> 	Framed-MTU = 1500
> 	Framed-Routing = None
> 	Framed-Pool = "hs-pool-2"
>
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 56274 ....
> Code:       Accounting-Request
> Identifier: 40
> Authentic:   
> +<227><144><181><241><192><27><200><146><202>N<155>8<135>y<241>
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 16
> 	NAS-Port-Type = Virtual
> 	User-Name = "test123"
> 	Calling-Station-Id = "192.168.1.3"
> 	Called-Station-Id = "192.168.1.118"
> 	Acct-Session-Id = "8170000c"
> 	Framed-IP-Address = 192.168.2.163
> 	Acct-Authentic = RADIUS
> 	Event-Timestamp = 1235128381
> 	Acct-Status-Type = Start
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
> 	Acct-Delay-Time = 0
>
> Fri Feb 20 19:31:01 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:01 2009: DEBUG:  Adding session for test123,  
> 192.168.1.118, 16
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=016':
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'insert into RADONLINE  
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,  
> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('test123',  
> '192.168.1.118', 16, '8170000c', 1235151061, '192.168.2.163',  
> 'Virtual', 'Framed-User')':
> Fri Feb 20 19:31:01 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:01 2009: DEBUG: Handling accounting with  
> Radius::AuthRADMIN
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'update RADUSERS set  
> TIMELEFT=TIMELEFT-0, OCTETSINLEFT=OCTETSINLEFT-0,  
> OCTETSOUTLEFT=OCTETSOUTLEFT-0 where USERNAME='test123'':
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'insert into RADUSAGE  
> (ACCTDELAYTIME 
> ,ACCTSESSIONID 
> ,ACCTSTATUSTYPE 
> ,DNIS,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME)  
> values (0,'8170000c',1,'192.168.1.118','192.168.2.163','M
> Fri Feb 20 19:31:01 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:01 2009: DEBUG: Accounting accepted
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 56274 ....
> Code:       Accounting-Response
> Identifier: 40
> Authentic:  a;<203><17>"P<222><171><31><214>1<5>u<11><133>*
> Attributes:
>
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 41254 ....
> Code:       Accounting-Request
> Identifier: 41
> Authentic:  YU#j<249><183>f<138><9>_<249>{T<155><217><198>
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 16
> 	NAS-Port-Type = Virtual
> 	User-Name = "test123"
> 	Calling-Station-Id = "192.168.1.3"
> 	Called-Station-Id = "192.168.1.118"
> 	Acct-Session-Id = "8170000c"
> 	Framed-IP-Address = 192.168.2.163
> 	Acct-Authentic = RADIUS
> 	Event-Timestamp = 1235128381
> 	Acct-Session-Time = 0
> 	Acct-Input-Octets = 18
> 	Acct-Input-Gigawords = 0
> 	Acct-Input-Packets = 3
> 	Acct-Output-Octets = 24
> 	Acct-Output-Gigawords = 0
> 	Acct-Output-Packets = 3
> 	Acct-Status-Type = Stop
> 	Acct-Terminate-Cause = User-Request
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
> 	Acct-Delay-Time = 0
>
> Fri Feb 20 19:31:01 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:01 2009: DEBUG:  Deleting session for test123,  
> 192.168.1.118, 16
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=016':
> Fri Feb 20 19:31:01 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:01 2009: DEBUG: Handling accounting with  
> Radius::AuthRADMIN
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'update RADUSERS set  
> TIMELEFT=TIMELEFT-00, OCTETSINLEFT=OCTETSINLEFT-018,  
> OCTETSOUTLEFT=OCTETSOUTLEFT-024 where USERNAME='test123'':
> Fri Feb 20 19:31:01 2009: DEBUG: do query is: 'insert into RADUSAGE  
> (ACCTDELAYTIME 
> ,ACCTINPUTOCTETS 
> ,ACCTOUTPUTOCTETS 
> ,ACCTSESSIONID 
> ,ACCTSESSIONTIME 
> ,ACCTSTATUSTYPE 
> ,ACCTTERMINATECAUSE 
> ,DNIS,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP
> Fri Feb 20 19:31:01 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:01 2009: DEBUG: Accounting accepted
> Fri Feb 20 19:31:01 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 41254 ....
> Code:       Accounting-Response
> Identifier: 41
> Authentic:  <229><146><145><175>o<214>3<212>y{<185><251>H<213><1>R
> Attributes:
>
> Fri Feb 20 19:31:05 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 40926 ....
> Code:       Access-Request
> Identifier: 42
> Authentic:  <133><226>*<133><133>HvlyY=u<202><191><221>w
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 17
> 	NAS-Port-Type = Ethernet
> 	User-Name = "test123"
> 	Calling-Station-Id = "00:1B:63:96:09:9C"
> 	Called-Station-Id = "pppoe-mik"
> 	NAS-Port-Id = "ether2"
> 	MS-CHAP-Challenge = <255>Yi<28><199>{<153>(J<245><9>t><155>8#
> 	MS-CHAP2-Response = <1><0>*M<205><168>i<30>P4x.(! 
> _ 
> < 
> 226 
> > 
> < 
> 234 
> > 
> < 
> 240 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> < 
> 0 
> > 
> U 
> < 
> 19 
> > 
> l 
> < 
> 233 
> ><143>}<145>,<14><249>j<24>U<11><176><144><140>p<140><173><225>ix<219>
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
>
> Fri Feb 20 19:31:05 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:05 2009: DEBUG:  Deleting session for test123,  
> 192.168.1.118, 17
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=017':
> Fri Feb 20 19:31:05 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:05 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:05 2009: DEBUG: Query is: 'select PASS_WORD,  
> STATICADDRESS, TIMELEFT, MAXLOGINS, SERVICENAME, BADLOGINS,  
> VALIDFROM, VALIDTO from RADUSERS where USERNAME='test123'':
> Fri Feb 20 19:31:05 2009: DEBUG: Query is: 'select ATTR_ID,  
> VENDOR_ID, IVALUE, SVALUE, ITEM_TYPE from RADSTCONFIG where  
> NAME='Standard' order by ITEM_TYPE':
> Fri Feb 20 19:31:05 2009: DEBUG: Query is: 'select ATTR_ID,  
> VENDOR_ID, IVALUE, SVALUE, ITEM_TYPE from RADCONFIG where  
> NAME='test123' order by ITEM_TYPE':
> Fri Feb 20 19:31:05 2009: DEBUG: Radius::AuthRADMIN looks for match  
> with test123 [test123]
> Fri Feb 20 19:31:05 2009: DEBUG: Query is: 'select NASIDENTIFIER,  
> NASPORT, ACCTSESSIONID, FRAMEDIPADDRESS from RADONLINE where  
> USERNAME='test123'':
> Fri Feb 20 19:31:05 2009: DEBUG: ValidFrom date converted to:  
> 1234831800
> Fri Feb 20 19:31:05 2009: DEBUG: Expiration date converted to:  
> 1266357600
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'update RADUSERS set  
> BADLOGINS=0 where USERNAME='test123'':
> Fri Feb 20 19:31:05 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:05 2009: DEBUG: Access accepted for test123
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'insert into  
> RADAUTHLOG (TIME_STAMP, USERNAME, TYPE) values (1235151065,  
> 'test123', 1)':
> Fri Feb 20 19:31:05 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 40926 ....
> Code:       Access-Accept
> Identifier: 42
> Authentic:  <13><141><><238><203><198><187>_<183>4<231>u<189>i<244>
> Attributes:
> 	MS-CHAP2-Success = "<1>S=52F1B21409A17D427F593DCA020DA221F5D832A1"
> 	MS-MPPE-Send-Key = <250><9>9[<243><228><244><198><254>wt!<23><150>tD
> 	MS-MPPE-Recv-Key =  
> <136>r<244><249><144><189><20>n<147><199><215>B<128>Sk<185>
> 	Service-Type = Framed-User
> 	Framed-Compression = Van-Jacobson-TCP-IP
> 	Framed-Protocol = PPP
> 	Framed-MTU = 1500
> 	Framed-Routing = None
> 	Framed-Pool = "hs-pool-2"
>
> Fri Feb 20 19:31:05 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 51796 ....
> Code:       Accounting-Request
> Identifier: 43
> Authentic:  n<214>5je<129>;<243>;<196>Z<146><181>$<198><239>
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 17
> 	NAS-Port-Type = Ethernet
> 	User-Name = "test123"
> 	Calling-Station-Id = "00:1B:63:96:09:9C"
> 	Called-Station-Id = "pppoe-mik"
> 	NAS-Port-Id = "ether2"
> 	Acct-Session-Id = "8170000d"
> 	Framed-IP-Address = 192.168.2.182
> 	Acct-Authentic = RADIUS
> 	Event-Timestamp = 1235128384
> 	Acct-Status-Type = Start
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
> 	Acct-Delay-Time = 0
>
> Fri Feb 20 19:31:05 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:05 2009: DEBUG:  Adding session for test123,  
> 192.168.1.118, 17
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=017':
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'insert into RADONLINE  
> (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,  
> FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('test123',  
> '192.168.1.118', 17, '8170000d', 1235151065, '192.168.2.182',  
> 'Ethernet', 'Framed-User')':
> Fri Feb 20 19:31:05 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:05 2009: DEBUG: Handling accounting with  
> Radius::AuthRADMIN
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'update RADUSERS set  
> TIMELEFT=TIMELEFT-0, OCTETSINLEFT=OCTETSINLEFT-0,  
> OCTETSOUTLEFT=OCTETSOUTLEFT-0 where USERNAME='test123'':
> Fri Feb 20 19:31:05 2009: DEBUG: do query is: 'insert into RADUSAGE  
> (ACCTDELAYTIME 
> ,ACCTSESSIONID 
> ,ACCTSTATUSTYPE 
> ,DNIS,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME)  
> values (0,'8170000d',1,'pppoe-mik','192.168.2.182','Mikro
> Fri Feb 20 19:31:05 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:05 2009: DEBUG: Accounting accepted
> Fri Feb 20 19:31:05 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 51796 ....
> Code:       Accounting-Response
> Identifier: 43
> Authentic:  <143><248>*!/7)<148><195><246>5><189><130>1<19>
> Attributes:
>
> Fri Feb 20 19:31:07 2009: DEBUG: Packet dump:
> *** Received from 192.168.1.118 port 44385 ....
> Code:       Accounting-Request
> Identifier: 44
> Authentic:  R<188><4><207>{@<182><162>b<17><142>pg<248><177>[
> Attributes:
> 	Service-Type = Framed-User
> 	Framed-Protocol = PPP
> 	NAS-Port = 17
> 	NAS-Port-Type = Ethernet
> 	User-Name = "test123"
> 	Calling-Station-Id = "00:1B:63:96:09:9C"
> 	Called-Station-Id = "pppoe-mik"
> 	NAS-Port-Id = "ether2"
> 	Acct-Session-Id = "8170000d"
> 	Framed-IP-Address = 192.168.2.182
> 	Acct-Authentic = RADIUS
> 	Event-Timestamp = 1235128386
> 	Acct-Session-Time = 1
> 	Acct-Input-Octets = 28356
> 	Acct-Input-Gigawords = 0
> 	Acct-Input-Packets = 81
> 	Acct-Output-Octets = 3217
> 	Acct-Output-Gigawords = 0
> 	Acct-Output-Packets = 40
> 	Acct-Status-Type = Stop
> 	Acct-Terminate-Cause = User-Request
> 	NAS-Identifier = "MikroTik"
> 	NAS-IP-Address = 192.168.1.118
> 	Acct-Delay-Time = 0
>
> Fri Feb 20 19:31:07 2009: DEBUG: Handling request with Handler  
> 'Realm=DEFAULT'
> Fri Feb 20 19:31:07 2009: DEBUG:  Deleting session for test123,  
> 192.168.1.118, 17
> Fri Feb 20 19:31:07 2009: DEBUG: do query is: 'delete from RADONLINE  
> where NASIDENTIFIER='192.168.1.118' and NASPORT=017':
> Fri Feb 20 19:31:07 2009: DEBUG: Handling with Radius::AuthRADMIN:
> Fri Feb 20 19:31:07 2009: DEBUG: Handling accounting with  
> Radius::AuthRADMIN
> Fri Feb 20 19:31:07 2009: DEBUG: do query is: 'update RADUSERS set  
> TIMELEFT=TIMELEFT-01, OCTETSINLEFT=OCTETSINLEFT-028356,  
> OCTETSOUTLEFT=OCTETSOUTLEFT-03217 where USERNAME='test123'':
> Fri Feb 20 19:31:07 2009: DEBUG: do query is: 'insert into RADUSAGE  
> (ACCTDELAYTIME 
> ,ACCTINPUTOCTETS 
> ,ACCTOUTPUTOCTETS 
> ,ACCTSESSIONID 
> ,ACCTSESSIONTIME 
> ,ACCTSTATUSTYPE 
> ,ACCTTERMINATECAUSE 
> ,DNIS,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP
> Fri Feb 20 19:31:07 2009: DEBUG: AuthBy RADMIN result: ACCEPT,
> Fri Feb 20 19:31:07 2009: DEBUG: Accounting accepted
> Fri Feb 20 19:31:07 2009: DEBUG: Packet dump:
> *** Sending to 192.168.1.118 port 44385 ....
> Code:       Accounting-Response
> Identifier: 44
> Authentic:  <174><137><183>b8<227><231>N<169>0<217>8qan<183>
> Attributes:
>
> My Radiator config is also attached.
>
> Sorry for the verbosity of this post.
>
> Thanks,
> Tim
>
> <radius.cfg>
>
> On 20 Feb 2009, at 12:42 AM, Hugh Irvine wrote:
>
>>
>> Hello Tim -
>>
>> The "View log" appears to be looking for the RADONLINE table in a  
>> MySQL database (which seems odd).
>>
>> Can you tell me what version of Radiator you are running? On what  
>> hardware/software platform? And can you please send me a copy of  
>> your configuration file?
>>
>> regards
>>
>> Hugh
>>
>>
>> On 19 Feb 2009, at 22:50, Tim Dancer wrote:
>>
>>> Hi all,
>>>
>>> I keep getting this error in the "View log" section of the  
>>> Radiator Web Gui.
>>>
>>> "Thu Feb 19 19:50:52 2009: ERR: do failed for 'delete from  
>>> RADONLINE where NASIDENTIFIER='192.168.1.118' and NASPORT=077':  
>>> MySQL server has gone away"
>>>
>>> Thoughts?
>>>
>>> Thanks,
>>> Tim
>>>
>>>
>>> _______________________________________________
>>> radiator mailing list
>>> radiator at open.com.au
>>> http://www.open.com.au/mailman/listinfo/radiator
>>
>>
>>
>> NB:
>>
>> Have you read the reference manual ("doc/ref.html")?
>> Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
>> Have you had a quick look on Google (www.google.com)?
>> Have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>> Have you checked the RadiusExpert wiki:
>> http://www.open.com.au/wiki/index.php/Main_Page
>>
>> -- 
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>> Includes support for reliable RADIUS transport (RadSec),
>> and DIAMETER translation agent.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>> -
>> CATool: Private Certificate Authority for Unix and Unix-like systems.
>>
>>
>



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.




More information about the radiator mailing list