Re: (RADIATOR) Question about Calls table
Hello Lin - This is because the default format for integer-date is being used. If you want to change it you should specify your own DateFromat. See sections 6.28.14 and 6.3 in the Radiator 3.3.1 reference manual. regards Hugh On Wednesday, November 6, 2002, at 07:55 AM, Huaikun Lin wrote: Hi Hugh Here is my radius configuration: Foreground LogStdout LogDir /var/log/radius DbDir /local/etc/radius PidFile /var/run/radiusd.pid SnmpgetProg /local/bin/snmpget AuthPort1645 AcctPort1646 Trace 3 client xxx ... /client Handler Request-Type = Accounting-Request RewriteUsername s/^([^@]+).*/$1/ AuthBy EMERALD # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSourcedbi:Sybase:server=xxx;database=xxx DBUsername DBAuth # You can add to or change these if you want. AccountingTable Calls AcctColumnDef UserName,User-Name AcctColumnDef CallDate,Timestamp,integer-date AcctColumnDef AcctStatusType,Acct-Status-Type,integer AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer AcctColumnDef AcctSessionId,Acct-Session-Id AcctColumnDef AcctSessionTime,Acct-Session-Time,integer AcctColumnDef AcctTerminateCause,Ascend-Disconnect-Cause,integ er # AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer # AcctColumnDef NASIdentifier,NAS-Identifier AcctColumnDef NASIdentifier,NAS-IP-Address AcctColumnDef NASPort,NAS-Port,integer AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check /AuthBy # Log all accounting into daily log files AcctLogFileName /var/log/radius/log/%Y%m%d.act /Handler Handler RewriteUsername s/^([^@]+).*/$1/ # If Platypus rejects the login, forward it to the old Radius server #AuthByPolicy ContinueUntilAccept PasswordLogFileName %L/password.log AuthBy EMERALD # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSourcedbi:Sybase:server=;database=xxx DBUsername xx DBAuth xx AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check /AuthBy AuthBy DBFILE Filename %D/users /AuthBy AuthBy FILE Filename %D/users /AuthBy /Handler The following is one example of trace 4 debug: Thu Sep 5 23:00:03 2002: DEBUG: Packet dump: *** Received from 203.96.xx.xx port 39577 Code: Access-Request Identifier: 167 Authentic: 00X24200t00,400B173 Attributes: Proxy-Action = AUTHENTICATE User-Name = andy.hema User-Password = 184/2139gG192374177232252250223 NAS-IP-Address = 192.168.8.253 NAS-Port = 278 Acct-Session-Id = 18159809 USR-Interface-Index = 1534 Service-Type = Framed-User Framed-Protocol = PPP Chassis-Call-Slot = 2 Chassis-Call-Span = 1 Chassis-Call-Channel = 22 Calling-Station-Id = Called-Station-Id = 1900 Connect-Speed = NONE NAS-Port-Type = Async User-Id = andy.hema NAS-Identifier = ipw1-n1-15.ipnet.telecom.co.nz User-Realm = actrix Proxy-State = 0 Thu Sep 5 23:00:03 2002: DEBUG: Rewrote user name to andy.hema Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler Realm=twor.ac.nz should be use d to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler Request-Type = Accounting-Requ est should be used to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler should be used to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Handling request with Handler '' Thu Sep 5 23:00:03 2002: DEBUG: Rewrote user name to andy.hema Thu Sep 5 23:00:03 2002: DEBUG: Deleting session for andy.hema, 192.168.8.253, 278 Thu Sep 5 23:00:03 2002: DEBUG: do query is: delete from RADONLINE where NASIDE NTIFIER='192.168.8.253'
Re: (RADIATOR) Question about Calls table
Hi Hugh Here is my radius configuration: Foreground LogStdout LogDir /var/log/radius DbDir /local/etc/radius PidFile /var/run/radiusd.pid SnmpgetProg /local/bin/snmpget AuthPort1645 AcctPort1646 Trace 3 client xxx ... /client Handler Request-Type = Accounting-Request RewriteUsername s/^([^]+).*/$1/ AuthBy EMERALD # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSourcedbi:Sybase:server=xxx;database=xxx DBUsername DBAuth # You can add to or change these if you want. AccountingTable Calls AcctColumnDef UserName,User-Name AcctColumnDef CallDate,Timestamp,integer-date AcctColumnDef AcctStatusType,Acct-Status-Type,integer AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer AcctColumnDef AcctSessionId,Acct-Session-Id AcctColumnDef AcctSessionTime,Acct-Session-Time,integer AcctColumnDef AcctTerminateCause,Ascend-Disconnect-Cause,integ er # AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer # AcctColumnDef NASIdentifier,NAS-Identifier AcctColumnDef NASIdentifier,NAS-IP-Address AcctColumnDef NASPort,NAS-Port,integer AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check /AuthBy # Log all accounting into daily log files AcctLogFileName /var/log/radius/log/%Y%m%d.act /Handler Handler RewriteUsername s/^([^]+).*/$1/ # If Platypus rejects the login, forward it to the old Radius server #AuthByPolicy ContinueUntilAccept PasswordLogFileName %L/password.log AuthBy EMERALD # You can use this to force Radiator to limit # maximum session times to how many minutes # are left in subaccounts.timeleft DefaultSimultaneousUse 1 TimeBanking # Change DBSource, DBUsername, DBAuth for your database # See the reference manual DBSourcedbi:Sybase:server=;database=xxx DBUsername xx DBAuth xx AddATDefaults AuthSelect ,sa.LoginLimit AuthColumnDef 0,Simultaneous-Use,check /AuthBy AuthBy DBFILE Filename %D/users /AuthBy AuthBy FILE Filename %D/users /AuthBy /Handler The following is one example of trace 4 debug: Thu Sep 5 23:00:03 2002: DEBUG: Packet dump: *** Received from 203.96.xx.xx port 39577 Code: Access-Request Identifier: 167 Authentic: 00X24200t00,400B173 Attributes: Proxy-Action = AUTHENTICATE User-Name = andy.hema User-Password = 184/2139gG192374177232252250223 NAS-IP-Address = 192.168.8.253 NAS-Port = 278 Acct-Session-Id = 18159809 USR-Interface-Index = 1534 Service-Type = Framed-User Framed-Protocol = PPP Chassis-Call-Slot = 2 Chassis-Call-Span = 1 Chassis-Call-Channel = 22 Calling-Station-Id = Called-Station-Id = 1900 Connect-Speed = NONE NAS-Port-Type = Async User-Id = andy.hema NAS-Identifier = ipw1-n1-15.ipnet.telecom.co.nz User-Realm = actrix Proxy-State = 0 Thu Sep 5 23:00:03 2002: DEBUG: Rewrote user name to andy.hema Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler Realm=twor.ac.nz should be use d to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler Request-Type = Accounting-Requ est should be used to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Check if Handler should be used to handle this request Thu Sep 5 23:00:03 2002: DEBUG: Handling request with Handler '' Thu Sep 5 23:00:03 2002: DEBUG: Rewrote user name to andy.hema Thu Sep 5 23:00:03 2002: DEBUG: Deleting session for andy.hema, 192.168.8.253, 278 Thu Sep 5 23:00:03 2002: DEBUG: do query is: delete from RADONLINE where NASIDE NTIFIER='192.168.8.253' and NASPORT=0278 Thu Sep 5 23:00:03 2002: DEBUG: Handling with Radius::AuthEMERALD Thu Sep 5 23:00:03 2002: DEBUG: Handling with Radius::AuthEMERALD Thu Sep 5 23:00:03 2002: DEBUG: Query is: select DateAdd(Day, ma.extension+ma.o verdue, maExpireDate), DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
(RADIATOR) Question about Calls table
Hi
I am using SQL server and radiator 3.1 radius.
In SQL server,we have a table calls which records the accounting data.
Recently,I found the data in one of the field CallDate (data
type:datetime) is not exactly
acurate. This data type should record data like 2002-11-05 12:05:23. But
the actual
data is something like 2002-11-05 12:05:00 which the second field is
alway 0.
(The year,month,day,hour,min are right.)
When I check the radius debug, I can see the Insert statement doesn't include
the second field and make the data is not 100% acurate:
insert into Calls
(UserName,AcctStatusType,NASPort,CallDate,AcctSessionId,AcctInputOctets,AcctSessionTime,
AcctOutputOctets) values ('test',2,541262250,'Nov 5, 2002
12:10','204301AA-3DC6C5C6',25 45013,14466,66242572)
I think the insert statement in radius script causes the inacurate.
If there is no second field in there,the SQL database makes it to be 00.
Is there anywhere to fix that?
How to fix it.
Lin
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
Re: (RADIATOR) Question about Calls table
Hello Lin -
I will need to see a copy of your Radiator configuration file (no
secrets) together with a trace 4 debug showing what is happening.
regards
Hugh
On Tuesday, November 5, 2002, at 10:21 AM, Huaikun Lin wrote:
Hi
I am using SQL server and radiator 3.1 radius.
In SQL server,we have a table calls which records the accounting
data.
Recently,I found the data in one of the field CallDate (data
type:datetime) is not exactly
acurate. This data type should record data like 2002-11-05 12:05:23.
But the actual
data is something like 2002-11-05 12:05:00 which the second field
is alway 0.
(The year,month,day,hour,min are right.)
When I check the radius debug, I can see the Insert statement
doesn't include
the second field and make the data is not 100% acurate:
insert into Calls
(UserName,AcctStatusType,NASPort,CallDate,AcctSessionId,AcctInputOctets
,AcctSessionTime,
AcctOutputOctets) values ('test',2,541262250,'Nov 5, 2002
12:10','204301AA-3DC6C5C6',25 45013,14466,66242572)
I think the insert statement in radius script causes the inacurate.
If there is no second field in there,the SQL database makes it to be
00.
Is there anywhere to fix that?
How to fix it.
Lin
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.410 / Virus Database: 231 - Release Date: 10/31/2002
NB: I am travelling this week, so there may be delays in our
correspondence.
--
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.
