(RADIATOR) [LONG] radiator emerald problems...
Carlos Molina (Net-Uno)
cmolina at net-uno.net
Fri Nov 22 20:44:34 CST 2002
Greetings ...:-)
I ma testing radiator with emerald (not emerald 4), but I
have some problems on tunning my config file. First, I
used the emerald.cfg file to make some changes on it.
The only features that we need are authenticate, emerald
concurrent users feature, and real time users activity
display.
My problem is that all the users auth request will be
fail. On the debug, I see some problems on the DB query
for the AcctSQLStatement update ServerPorts set Username
directive.. See the complete debug at end of this mail.
The key p[art of the debug is "Server message number=207
severity=16 state=1 line=1 server=DIAL_DB_1text=Invalid
column name 'CallerId'." message
Anybody can help me on this ...??
y config file is (really, is the same example config file
from goodies/emerald.cfg):
Foreground
LogStdout
LogDir .
#DbDir .
AuthPort 1645
AcctPort 1646
.
.
.
<Realm DEFAULT>
<AuthBy EMERALD>
# Change DBSource, DBUsername, DBAuth for
your database
# See the reference manual
DBSource
dbi:Sybase:database=emerald
DBUsername hidden
DBAuth hidden
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef
CallDate,Timestamp,integer-date
AcctColumnDef
AcctStatusType,Acct-Status-Type,integer
AcctColumnDef
AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef
AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef
AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef
AcctSessionId,Acct-Session-Id
AcctColumnDef
AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef
AcctTerminateCause,Acct-Terminate-Cause,integer
AcctColumnDef
NASIdentifier,NAS-Identifier
AcctColumnDef
NASIdentifier,NAS-IP-Address
AcctColumnDef NASPort,NAS-Port,integer
AuthSelect ,sa.LoginLimit
AuthColumnDef 0,Simultaneous-Use,check
AcctSQLStatement update ServerPorts set
Username='%n', AcctSes
sionId='%{Acct-Session-Id}', AcctStatusType= case
'%{Acct-Status-Type}' when 'St
art' then 1 when 'Stop' then 2 else 3 end,
CallDate=getdate(), FramedAddress='%a
', CallerId='%{Calling-Station-Id}',
ConnectInfo='%{Connect-Info}' where ServerI
D=(select ServerID from Servers where
IPAddress='%{Client:Name}') and Port=0%{NA
S-Port}
</AuthBy>
</Realm>
-------------- DEBUG START
Packet length = 152
04 9a 00 98 f8 3b 0f fa f0 e9 1f 75 51 49 5c b1
76 82 41 c9 04 06 ac 10 fe fe 05 06 00 00 00 10
1a 0f 00 00 00 09 02 09 41 73 79 6e 63 31 36 3d
06 00 00 00 00 01 0b 67 72 61 74 65 72 6f 6c 6a
1e 06 38 38 30 30 28 06 00 00 00 02 2d 06 00 00
00 01 06 06 00 00 00 02 2c 0a 30 30 30 30 33 43
33 32 07 06 00 00 00 01 08 06 c8 4b 89 c3 31 06
00 00 00 02 2a 06 00 00 8d 88 2b 06 00 03 a9 bb
2f 06 00 00 01 b0 30 06 00 00 02 0a 2e 06 00 00
00 80 29 06 00 00 00 00
Code: Accounting-Request
Identifier: 154
Authentic:
<248>;<15><250><240><233><31>uQI\<177>v<130>A<201>
Attributes:
NAS-IP-Address = 172.16.254.254
NAS-Port = 16
Cisco-NAS-Port = "Async16"
NAS-Port-Type = Async
User-Name = "graterolj"
Called-Station-Id = "8800"
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
Service-Type = Framed
Acct-Session-Id = "00003C32"
Framed-Protocol = PPP
Framed-IP-Address = 200.75.137.195
Acct-Terminate-Cause = Lost-Carrier
Acct-Input-Octets = 36232
Acct-Output-Octets = 240059
Acct-Input-Packets = 432
Acct-Output-Packets = 522
Acct-Session-Time = 128
Acct-Delay-Time = 0
Fri Nov 22 16:02:28 2002: DEBUG: Handling request with
Handler 'Realm=DEFAULT'
Fri Nov 22 16:02:28 2002: DEBUG: Deleting session for
graterolj, 172.16.254.254, 16
Fri Nov 22 16:02:28 2002: DEBUG: Handling with
Radius::AuthEMERALD
Fri Nov 22 16:02:28 2002: DEBUG: Handling accounting with
Radius::AuthEMERALD
Fri Nov 22 16:02:28 2002: DEBUG: do query is: update
ServerPorts set Username='graterolj',
AcctSessionId='00003C32', AcctStatusType= case 'Stop' when
'Start' then 1 when 'Stop' then 2 else 3 end,
CallDate=getdate(), FramedAddress='', CallerId='',
ConnectInfo='' where ServerID=(select ServerID from
Servers where IPAddress='172.16.254.254') and Port=016
DBI handle cleared whilst still active at
/usr/local/share/perl/5.6.1/Radius/Util.pm line 526.
DBI Handle has uncleared implementors data at
/usr/local/share/perl/5.6.1/Radius/Util.pm line 526.
dbih_clearcom (sth 0x851ac80 0x85667c0, com
0x8569400, imp DBD::Sybase::st):
FLAGS 0x113: COMSET IMPSET Warn PrintError
PARENT DBI::db=HASH(0x851c7c4)
KIDS 0 (0 Active)
IMP_DATA undef
LongReadLen 32768
NUM_OF_FIELDS 0
NUM_OF_PARAMS 0
Fri Nov 22 16:02:28 2002: ERR: do failed for 'update
ServerPorts set Username='graterolj',
AcctSessionId='00003C32', AcctStatusType= case 'Stop' when
'Start' then 1 when 'Stop' then 2 else 3 end,
CallDate=getdate(), FramedAddress='', CallerId='',
ConnectInfo='' where ServerID=(select ServerID from
Servers where IPAddress='172.16.254.254') and Port=016':
Server message number=207 severity=16 state=1 line=1
server=DIAL_DB_1text=Invalid column name 'CallerId'.
DBI handle cleared whilst still active at
/usr/local/share/perl/5.6.1/Radius/Util.pm line 526.
DBI Handle has uncleared implementors data at
/usr/local/share/perl/5.6.1/Radius/Util.pm line 526.
dbih_clearcom (sth 0x851ae0c 0x85658c0, com
0x8567de8, imp DBD::Sybase::st):
FLAGS 0x113: COMSET IMPSET Warn PrintError
PARENT DBI::db=HASH(0x853e9fc)
KIDS 0 (0 Active)
IMP_DATA undef
LongReadLen 32768
NUM_OF_FIELDS 0
NUM_OF_PARAMS 0
Fri Nov 22 16:02:28 2002: ERR: do failed for 'update
ServerPorts set Username='graterolj',
AcctSessionId='00003C32', AcctStatusType= case 'Stop' when
'Start' then 1 when 'Stop' then 2 else 3 end,
CallDate=getdate(), FramedAddress='', CallerId='',
ConnectInfo='' where ServerID=(select ServerID from
Servers where IPAddress='172.16.254.254') and Port=016':
Server message number=207 severity=16 state=1 line=1
server=DIAL_DB_1text=Invalid column name 'CallerId'.
Fri Nov 22 16:02:29 2002: DEBUG: do query is: insert into
Calls
(NASPort,AcctTerminateCause,AcctOutputOctets,UserName,CallDate,AcctSessionId,AcctInputOctets,AcctStatusType,NASIdentifier,AcctSessionTime,AcctDelayTime)
values (16,2,240059,'graterolj','Nov 22, 2002
16:02','00003C32',36232,2,'172.16.254.254',128,0)
Fri Nov 22 16:02:29 2002: DEBUG: Accounting accepted
Fri Nov 22 16:02:29 2002: DEBUG: Packet dump:
*** Sending to 172.16.254.254 port 1646 ....
Packet length = 20
05 9a 00 14 f1 48 f1 8e 18 e7 7b f8 f9 93 df d4
2b a2 1c af
Code: Accounting-Response
Identifier: 154
Authentic:
<248>;<15><250><240><233><31>uQI\<177>v<130>A<201>
Attributes:
Thanks a lot.
Carlos
===
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