(RADIATOR) Caller ID settings

[david.kramar at aliatel.cz]

Hi Ali
FYI. You can use regular expression in SQL database too.
 
<Realm DEFAULT>
        <AuthBy RADMIN>
                DBSource        dbi:sqldb:database:127.0.0.1
                DBUsername      databaseuser
                DBAuth          databasepassword
 
AuthSelect select PASS_WORD, STATICADDRESS, TIMELEFT, MAXLOGINS,\
                            SERVICENAME,BADLOGINS, VALIDFROM, VALIDTO,\
                            CALLEDSTATIONID, CALLINGSTATIONID,TIMEACCESS from RADUSERS where USERNAME='%n'
 
# first 8 value check Radmin modul inside, but you can use AuthBySQL and define all AuthColumnDef 
# I use AuthBy RADMIN, so I check next 3 (CALLEDSTATIONID, CALLINGSTATIONID,TIMEACCESS) in AuthColumnDef definition.
   
        AuthColumnDef 0,Called-Station-Id,check
        AuthColumnDef 1,Calling-Station-Id,check
        AuthColumnDef 2,Time,check     # you can check "allowed time of week" to login, example -.AL0900-1800

#disable some default query...
            NoDefault
            LogQuery
            UserAttrQuery
            ServiceAttrQuery
            AccountingStopsOnly
 
# this is accouting..
                AccountingTable RADUSAGE
                AcctColumnDef   USERNAME,User-Name
                AcctColumnDef   TIME_STAMP,%b-0%{Acct-Session-Time},literal        #start time in accouting
                AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type,integer
                #............continue..........
                AcctColumnDef   NASPORT,NAS-Port,integer
                AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
                AcctColumnDef   CALLINGSTATION,Calling-Station-Id
                AcctColumnDef   CONNECTSPEED,Ascend-Xmit-Rate
        </AuthBy>
</Realm>

#example database dump
 
 TABLE `RADUSERS` (
  `BADLOGINS` int(11) default NULL,
  `PASS_WORD` varchar(50) default NULL,
  `STATICADDRESS` varchar(30) default NULL,
  `TIMELEFT` int(11) default NULL,
  `MAXLOGINS` int(11) default NULL,
  `USERNAME` varchar(50) NOT NULL default '',
  `VALIDFROM` int(11) default NULL,
  `VALIDTO` int(11) default NULL,
  `CALLEDSTATIONID` varchar(250) default NULL,
  `CALLINGSTATIONID` varchar(250) default NULL,
  `TIMEACCESS` varchar(200) default NULL,
   UNIQUE KEY `RADUSERS_pk` (`USERNAME`)
....

INSERT INTO RADUSERS VALUES ('0','Wcklj:-)5scda',NULL,NULL,NULL,'vpdn1 at vpdn1.com',1028028780,1185746400,'/^8979(228|333)|44444/',/999888|777666/','Al0100-1800');
 
#
Hope help
 
David 
 
 -----Puvodní zpráva-----
Od: Hugh Irvine [mailto:hugh at open.com.au]
Odesláno: 2. srpna 2002 6:47
Komu: Ali Malik
Kopie: radiator at open.com.au
Predmet: Re: (RADIATOR) Caller ID settings






Hello Ali - 


1. Radiator can use one or the other of Called-Station-Id and/or Calling-Station-Id 


2. Your user definition would look like this: 


someuser Password = xxxxx, Calling-Station-Id = nnnnnnn 

        ..... 


3. You can define multiple numbers with regular expressions: 


someuser Password = xxxxx, Calling-Station-Id = /11111|22222|333333/ 

        ....... 


You can list the numbers individually or use pattern matching. 


regards 


Hugh 



On Friday, August 2, 2002, at 03:09 PM, Ali Malik wrote: 


Dear All: 



Finally Iam able to integrate the Quidway 8010 refiner with radius. Now, i want to restrict CLI for dial-in users. I have questions: 

1. How Radiator will handle CLI, 

2. How I can restrict user to connect only when its coming from the defined number. 

3. Can i define multiple numbers ? If yes how many ? 



Kind Regards 



Ali 


-- 

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.