Hello Primoz -
On Sat, 18 Nov 2000, Primoz Jeroncic wrote:
> Hi
>
> I'm totaly new to this thing since we have only evaluation version
> of Radiator. I have to test Radiator to see if it works as we would
> like it in our configuration. So here's my config: We have Cisco
> AS5300 as VoIP gateway, PC with Microsoft SQL and Radiator
> currently running on same PC as SQL. We need to get attributes
> cisco-h323-credit-time and cisco-h323-credit-amount back from
> Radiator to AS5300. It works nice when I use text user file,
> but when I tried to use SQL database it doesn't really work.
> I made SQL database called radius based on ansiCreate.sql
> script which comes with Radiator distribution. Then I added
> my user with password, leaving ENCRYPTEDPASSWORD field and
> CHECKATTR field empty but added next line in REPLYATTR field:
> cisco-h323-credit-amount = "h323-credit-amount=100.00",cisco-h323-credit-time =
>"h323-credit-time=1000"
> I copied those two lines from userfile where it worked when I
> had it done like this:
> 1234 Password = "5678"
> cisco-h323-credit-amount = "h323-credit-amount=100.00",
> cisco-h323-credit-time = "h323-credit-time=1000"
>
> Now caller manage to authenticate on Radiator, it even puts
> data to table ACCOUNTING but Radiator doesn't send REPLYATTR
> back to AS5300. My radius config file looks like this:
>
> <Client 10.10.10.10>
> Secret test
> DupInterval 0
> </Client>
> # I also added this client to SQL.
> <ClientListSQL>
> DBSource dbi:ODBC:radius_odb
> DBUsername: sa
> DBAuth
> </ClientListSQL>
> <Realm DEFAULT>
> <AuthBy>
> DBSource dbi:ODBC:radius_odb
> DBUsername: sa
> DBAuth
> AcctColumnDef START_TIME,cisco-h323-setup-time
> </AuthBy>
> </Realm DEFAULT>
>
> Did I miss something? Because when I was trying before with txt
> database AS5300 gave me at least "invalid AVPair" if I put wrong
> syntax for "cisco-h323-credit-time". Now it doesn't complain
> at all because it looks like it doesn't get anything back from
> Radiator. Also debugging on Radiator doesn't show anything about
> sending something back to Cisco.
>
You will need to do something like this in your AuthBy SQL clause:
<Realm DEFAULT>
<AuthBy>
DBSource dbi:ODBC:radius_odb
DBUsername: sa
DBAuth
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
from SUBSCRIBERS where USERNAME='%n'
AuthColumnDef 0, User-Password, check
AuthColumnDef 1, GENERIC, check
AuthColumnDef 2, GENERIC, reply
</AuthBy>
</Realm DEFAULT>
have a look at section 6.26.7 in the Radiator 2.16.3 reference manual.
hth
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.
