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

Tim Dancer tim at ibound.net
Fri Feb 20 03:38:33 CST 2009


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


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.
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090220/725e40fd/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: radius.cfg
Type: application/octet-stream
Size: 7488 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090220/725e40fd/attachment-0001.obj>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20090220/725e40fd/attachment-0003.html>


More information about the radiator mailing list