(RADIATOR) Radiator configuration File and Password

[Shaun Eck]

Hi

I would like to get some assistance on how to have 
the password clipped from within the configuration file radius.cfg. Let me 
explain further. We have configured the radius.cfg file to be able 
to authenticate both from a file and from a database. The authentication 
is done by implementing the subscribers table as recommended by the installation 
process. However we are denied access when the user that is logging-in is 
in the subscribers table. We have found that by including the additional 
spaces in the password that equal the size of the password ,field define in the 
subscribers table, only then are we able tologin.

Table: subscribers
username 
char(12)

Example:
Login Name: vcas
Password:vcas+8spaces

(RADIATOR) Help with AuthBy SQL

[Shaun Eck]

Hi 
I am somewhat confuse about how or when Radiator 
issues an Accounting Request. All I am trying to do is to update the 
balancetime field in the subscribers table on an informix database. I am 
not sure if I need to define an AccountingTable in order for me to update the 
subscribers table or not. From what I have gathered in order for me to 
update the subscribers table all I have to do is just issued the following 
statement. Please tell me what it is that I am doing wrong.

In the radius.cfg file in the realm sql.realm and 
in the method AuthBy SQL I have the following.
Realm sql.realm
 
RewriteUserName S/^([^@]+).*/$1/
AuthBy SQL
 Identifier SQL
 DBSource 
 dbi:Infomix:tis
 DBUsername 
informix
 DBAuth 
  l1gaw01

 AuthSelect 
select password, balancetime from subscribers where (username = '%n' and 


 balancetime  0)

 AuthColumnDef 
0,Password, check
 AuthColumnDef 
1,Session-Timeout, reply

 AddToReply 
 Service-Type = Framed-User, Framed-Protocol = 
PPP

 AuthSQLStatement 
 update subscribers set balancetime = 
balancetime-0%{Acct-Session-Time} 
  

   where 
username = '%n"
 /AuthBy
/Realm

The problem that I am having is I dont know how or 
when an accounting request is received, therefore I am unsuccessful at updating 
the subscribers balancetime. Is there something outside the scope of this 
handler thats affecting the update statement?

Please Can you point me in the right 
direction

Peace!

(RADIATOR) Update Not working

[Shaun Eck]

Hi
I have tried updating the balancetime in the Database, however it is not 
working, could you please tell me what I am doing wrong.
Regards
Realm sql.realm
RewriteUsername s/^([^@]+).*/$1/
AuthBy SQL
 Identifier SQL
 DBSource dbi:Informix:tis
 DBUsername xx
 DBAuth xx
AuthSelect select password, balancetime from subscribers where (username='%n' 
and balancetime  0)
AuthColumnDef  0,Password,check
AuthColumnDef  1,Session-Timeout,reply
AddToReply  Service-Type = Framed-User,Framed-Protocol = 
PPP
AcctSQLStatement update subscribers set balancetime = 
balancetime-0%{Acct-Session-Time} where username = '%n"
/AuthBy
/Realm