(RADIATOR) Having some DBissues when using radmin/radiator and OTP

Haakan Olofsson olofson at dax.net
Sat Mar 17 14:23:13 CST 2007


Hello

Well i fixed everything to work with Radmin and OTP together with 
Cisco VPN 300 and made some extra stuff in DATABASE like separate 
fields for telephone number and such for the users when sending out 
smses , and it works like a charm, but i noticed this error in the 
log file, do you have any idea of what the problem can be?

Sat Mar 17 19:11:05 2007: DEBUG: AuthBy RADMIN result: IGNORE, Database failure


And some logs from the mysql are included aswell

070317 19:11:06     959 Connect     radius at localhost on radmin
                     959 Query       delete from RADONLINE where 
NASIDENTIFIER='10.0.202.2' and NASPORT=01956
                     959 Query       insert into RADONLINE (USERNAME, 
NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, 
NASPORTTYPE, SERVICETYPE) values ('olofson', '10.0.202.2', 1956, 
'FB00041D', 1174158666, '10.0.202.65', 'Virtual', 'Framed')
                     959 Query       insert into RADMESSAGES 
(TIME_STAMP, TYPE, MESSAGE) values (1174158666, 4, 'Handling with 
Radius::AuthRADMIN')
                     959 Query       insert into RADMESSAGES 
(TIME_STAMP, TYPE, MESSAGE) values (1174158666, 4, 'Handling 
accounting with Radius::AuthRADMIN')
                     959 Query       insert into RADMESSAGES 
(TIME_STAMP, TYPE, MESSAGE) values (1174158666, 4, 'do query is: 
\'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,\'FB00041D\',1,\'some ip number\',\'10.0.')
                     959 Query       insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip 
number','10.0.202.65','10.0.202.2',1956,1174158666,'olofson')
                     959 Query       insert into RADMESSAGES 
(TIME_STAMP, TYPE, MESSAGE) values (1174158666, 0, 'do failed for 
\'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,\'FB00041D\',1,\'some ip number\',\'10.0')
                     959 Quit
                     960 Connect     radius at localhost on radmin
                     960 Query       insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip 
number','10.0.202.65','10.0.202.2',1956,1174158666,'olofson')
                     960 Query       insert into RADMESSAGES 
(TIME_STAMP, TYPE, MESSAGE) values (1174158666, 0, 'do failed for 
\'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,\'FB00041D\',1,\'some ip number\',\'10.0')
                     960 Quit


Radiator/Radmin log




Sat Mar 17 19:11:05 2007: DEBUG: Handling with Radius::AuthRADMIN
Sat Mar 17 19:11:05 2007: DEBUG: Handling accounting with Radius::AuthRADMIN
Sat Mar 17 19:11:05 2007: DEBUG: do query is: 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0.
Sat Mar 17 19:11:05 2007: ERR: do failed for 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0
Sat Mar 17 19:11:05 2007: ERR: do failed for 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0
Sat Mar 17 19:11:05 2007: DEBUG: AuthBy RADMIN result: IGNORE, Database failure
Sat Mar 17 19:11:06 2007: ERR: Attribute number 66 is not defined in 
your dictionary
Sat Mar 17 19:11:06 2007: DEBUG: Packet dump:
*** Received from 10.0.202.2 port 1696 ....
Code:       Accounting-Request
Identifier: 15
Authentic:  <179>>W{<222><165><189><234><184><248><241>`<193><237><21><169>
Attributes:
         User-Name = "olofson"
         NAS-Port = 1956
         Service-Type = Framed
         Framed-Protocol = PPP
         Framed-IP-Address = 10.0.202.65
         Class = "juniks"
         Calling-Station-Id = "some ip number"
         Acct-Status-Type = Start
         Acct-Session-Id = "FB00041D"
         Acct-Authentic = RADIUS
         Acct-Delay-Time = 0
         NAS-IP-Address = 10.0.202.2
         NAS-Port-Type = Virtual

Sat Mar 17 19:11:06 2007: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Sat Mar 17 19:11:06 2007: DEBUG:  Adding session for olofson, 10.0.202.2, 1956
Sat Mar 17 19:11:06 2007: DEBUG: do query is: 'delete from RADONLINE 
where NASIDENTIFIER='10.0.202.2' and NASPORT=01956':
Sat Mar 17 19:11:06 2007: DEBUG: do query is: 'insert into RADONLINE 
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, 
FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values ('olofson', 
'10.0.202.2', 1956, 'FB00041D', 1174158666, '10.0.202.65', 'Virtual', 
'Framed')':
Sat Mar 17 19:11:06 2007: DEBUG: Handling with Radius::AuthRADMIN
Sat Mar 17 19:11:06 2007: DEBUG: Handling accounting with Radius::AuthRADMIN
Sat Mar 17 19:11:06 2007: DEBUG: do query is: 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0.
Sat Mar 17 19:11:06 2007: ERR: do failed for 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0
Sat Mar 17 19:11:06 2007: ERR: do failed for 'insert into RADUSAGE 
(ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPADDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) 
values (0,'FB00041D',1,'some ip number','10.0
Sat Mar 17 19:11:06 2007: DEBUG: AuthBy RADMIN result: IGNORE, Database failure


Keep up the good work people

/ Olofson @ Tele2 Norway AS

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list