(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