(RADIATOR) Problems with SessionDatabase SQL

2000-10-27 Thread Delanet Administration 

I've made a few changes to my sessiondatabase section and radiator does
not seem to honor all of them. In paticular, the username seems to be
returned as the plain value returned by the NAS (%u) despite my having
changed it to %n.  I have it declared as follows:

SessionDatabase SQL
 DBSource dbi:mysql:radius
 DBUsername xxx
 DBAuth  xx

 AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,
NASPortDNIS, CallerID, ConnectInfo) values ('%n', '%N', 0%{NAS-Port},
'%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}',
'%{NAS-Port-Type}',
'%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Connect-Info}')

/SessionDatabase

I know it does see my changes as the addition of the caller source and
destination as well as connect-info does work. Only the username refuses
to change. I'm hoping this is not normal? And is there a way around this
as it is necessary for me to change.

I'm using Radiator 2.16.3 on FreeBSD 4.1.0r with MySQL 3.23.26b.

Thanks in advance,

--

Stephen Comoletti - Network Engineer / Systems Administrator
Delanet Inc. http://www.delanet.com
Frontline Communications Corp. http://www.fcc.net
phone: (302) 326-5800 fax: (302) 326-5802 x312
262 Quigley Blvd, New Castle, DE 19720, USA





===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Re: (RADIATOR) Problems with SessionDatabase SQL

2000-10-27 Thread Hugh Irvine 


Hello Stephen -

On Sat, 28 Oct 2000, Delanet Administration wrote:
 I've made a few changes to my sessiondatabase section and radiator does
 not seem to honor all of them. In paticular, the username seems to be
 returned as the plain value returned by the NAS (%u) despite my having
 changed it to %n.  I have it declared as follows:
 
 SessionDatabase SQL
  DBSource dbi:mysql:radius
  DBUsername xxx
  DBAuth  xx
 
  AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
 ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE,
 NASPortDNIS, CallerID, ConnectInfo) values ('%n', '%N', 0%{NAS-Port},
 '%{Acct-Session-Id}', %{Timestamp}, '%{Framed-IP-Address}',
 '%{NAS-Port-Type}',
 '%{Service-Type}','%{Called-Station-Id}','%{Calling-Station-Id}','%{Connect-Info}')
 
 /SessionDatabase
 
 I know it does see my changes as the addition of the caller source and
 destination as well as connect-info does work. Only the username refuses
 to change. I'm hoping this is not normal? And is there a way around this
 as it is necessary for me to change.
 
 I'm using Radiator 2.16.3 on FreeBSD 4.1.0r with MySQL 3.23.26b.
 

Can you send me a trace 4 debug showing what is happening?

Changing the AddQuery should do what you expect, but perhaps you could give me
a bit more detail on exactly what your requirements are.

thanks

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.



===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.