Hi everybody!
We have some realms in radiator cfg, each of them authenticate in a
diferent DBM users database.
We have a session DataBase too ...
Problem is that, when Radiator inserts into sessionDataBase the
Username, it is inserted without Realm. How can it be inserted with the
realm into session DataBase? ...
Logfile :
------------
Wed Feb 2 11:13:07 2000: DEBUG: Rewrote user name to usuario3@myrealm
Wed Feb 2 11:13:07 2000: DEBUG: Handling request with Handler
'Realm=myrealm'
Wed Feb 2 11:13:07 2000: DEBUG: Rewrote user name to usuario3
Wed Feb 2 11:13:07 2000: DEBUG: DBSSQL Deleting session for
usuario3@myrealm, aa.bb.cc.dd, 36
Wed Feb 2 11:13:07 2000: DEBUG: do query is: delete from RADONLINE
where USERNAME='usuario3' and NASIDENTIFIER='aa.bb.cc.dd' and NASPORT=36
Wed Feb 2 11:13:07 2000: DEBUG: Query is: select NASIDENTIFIER,
NASPORT, ACCTSESSIONID from RADONLINE where USERNAME='usuario3'
Wed Feb 2 11:13:07 2000: DEBUG: Handling with Radius::AuthDBFILE
Wed Feb 2 11:13:07 2000: DEBUG: Radius::AuthDBFILE looks for match with
usuario3
Wed Feb 2 11:13:07 2000: DEBUG: Radius::AuthDBFILE ACCEPT:
Wed Feb 2 11:13:07 2000: DEBUG: Access accepted for usuario3
Wed Feb 2 11:13:08 2000: DEBUG: Rewrote user name to usuario3@myrealm
Wed Feb 2 11:13:08 2000: DEBUG: Handling request with Handler
'Realm=myrealm'
Wed Feb 2 11:13:08 2000: DEBUG: Rewrote user name to usuario3
Wed Feb 2 11:13:08 2000: DEBUG: DBSSQL Adding session for
usuario3@myrealm, aa.bb.cc.dd, 36
Wed Feb 2 11:13:08 2000: DEBUG: do query is: delete from RADONLINE
where USERNAME='usuario3' and NASIDENTIFIER='aa.bb.cc.dd' and NASPORT=36
Wed Feb 2 11:13:08 2000: DEBUG: do query is: insert into RADONLINE
(USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP,
FRAMEDADDRESS, PORTTYPE, SERVICETYPE) values ('usuario3', 'aa.bb.cc.dd',
36,'317569843', 949486388, '', '','')
Wed Feb 2 11:13:08 2000: DEBUG: Handling with Radius::AuthDBFILE
Wed Feb 2 11:13:08 2000: DEBUG: Accounting accepted
Radiator cfg is:
-----------------
<SessionDatabase SQL>
Identifier DBSSQL
DBSource dbi:mysql:xxxxx
DBUsername xxxxx
DBAuth xxxxxx
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER,
NASPORT, \
ACCTSESSIONID, TIME_STAMP, FRAMEDADDRESS, PORTTYPE, \
SERVICETYPE) values ('%n', '%N',
%{NAS-Port},'%{Acct-Session-Id}', \
%{Timestamp}, '%{Framed-IP-Address}',
'%{Port-Type}','%{Service-Type}')
DeleteQuery delete from RADONLINE where USERNAME='%n' and \
NASIDENTIFIER='%N' and NASPORT=%{NAS-Port}
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from
RADONLINE \ where USERNAME='%n'
</SessionDatabase>
<Realm myrealm>
MaxSessions 1
RewriteUsername s/^([^@]+).*/$1/
AcctLogFileName ./LOGS/detail
PasswordLogFileName ./LOGS/password
AccountingHandled
<AuthBy DBFILE>
Filename %D/users
</AuthBy>
</Realm>
-------------------------------------------------
In the SessionDatabase, we have tried to put %{User-Name} instead of %n
but the results are the same.
Can somebody help us?
Thanks a lot.
___
CTV - JET [http://www.ctv-jet.com]
Antonio Coloma Brotons / [EMAIL PROTECTED]
Clave p�blica PGP / PGP public KEY
[http://www.ctv.es/PGP-STAFF/acoloma.html]
Dpto. I+D / Ingeniero Inform�tico
Tel: +34 (9)6 5845291 - Fax: +34 (9)6 5844896
___
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
