(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