Hello Carlos -
The error message indicates that there is no column named "CallerId" in the database.
Have you checked the table definitions in the database?
regards
Hugh
On Saturday, Nov 23, 2002, at 13:44 Australia/Melbourne, Carlos Molina (Net-Uno) wrote:
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,AcctSess ionId,AcctInputOctets,AcctStatusType,NASIdentifier,AcctSessionTime,Acct DelayTime) 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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
-- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence.
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
