(RADIATOR) Rejecting Caller-ID from SQL without auth from SQL
    Viraj Alankar 
    valankar at ifxcorp.com
       
    Wed Feb 20 16:57:36 CST 2002
    
    
  
On Fri, Feb 15, 2002 at 09:38:37AM -0500, Viraj Alankar wrote:
> Now I was able to get it working with the following config. However, it
> appears the select query is still called twice when the callerid doesn't exist
> in the table. Basically in this config I took out the options in
> VE_Check_CallerID.
Just wanted to let you know I was able to get it working without any problems
now. Adding the 'NoDefault' to the SQL authby stopped it from executing the
query twice. Here is what I did:
<AuthBy SQL>
        Identifier VE_CallerID
        ...
        AuthSelect select "Reject" from ve where callerid = '%{Calling-Station-Id}'
        AuthColumnDef 0, Auth-Type, check
        AccountingTable
        NoDefault
</AuthBy>
<AuthBy FILE>
        Identifier VE_Check_CallerID
        Filename        %D/VE_Check_CallerID.users
</AuthBy>
<AuthBy FILE>
        Identifier My_Users_File
        Filename        ...
</AuthBy>
<Handler>
        AuthBy VE_Check_CallerID
</Handler>
And VE_Check_CallerID.users has:
DEFAULT Auth-Type = VE_CallerID
DEFAULT Auth-Type = My_Users_File
Thanks for the help.
Viraj.
===
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