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

Hugh Irvine hugh at open.com.au
Sat Mar 17 17:11:37 CST 2007


Hello Haakan -

I will need to see a copy of your configuration file, so could you  
please send me a copy (no secrets)?

And what does the database log show when the error happens?

regards

Hugh


On 18 Mar 2007, at 07:23, Haakan Olofsson wrote:

> 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,FRAMEDIPA 
> DDRESS,NASIDENTIFIER,NASPORT,TIME_STAMP,USERNAME) values (0, 
> \'FB00041D\',1,\'some ip number\',\'10.0.')
>                     959 Query       insert into RADUSAGE  
> (ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLINGSTATIONID,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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,FRAMEDIPA 
> DDRESS,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.



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?

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


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