(RADIATOR) [LONG] radiator emerald problems...
Hugh Irvine
hugh at open.com.au
Fri Nov 22 20:58:40 CST 2002
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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' 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 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