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

Tim Dancer tim at ibound.net
Mon Feb 23 07:13:09 CST 2009 

I don't get the mysql error when I run the following command which is  
strange because it's the same config:

"radiusd -foreground -log_stdout -trace 4 -config_file /etc/radiator/ 
radius.cfg"

However PPTP still fails. Thoughts?

Tim

On 20 Feb 2009, at 11:38 AM, 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.
>
> 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
>
> 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.
>>
>>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090223/9c265d21/attachment-0001.html>

More information about the radiator mailing list