[RADIATOR] Accounting into microsoft SQL server

[Hugh Irvine]

Hello Nuno -

Try something like this:



<Realm /ubi.pt/i>
       AuthByPolicy ContinueAlways
       <AuthBy SQL>
              ……
              # disable authentication
              AuthSelect
              # set up accounting
              AccountingTable …..
              ……
       </AuthBy>
       <AuthBy RADIUS>
               Identifier PEAP_IAS
               Secret xxxxxxxxxxxxxxxxxxxx
               AuthPort 1812
               AcctPort 1813
               Retries 3
               #AutoMPPEKeys
               SSLeayTrace 4
               Host ubidc1.ubi.pt
               Host ubidc2.ubi.pt
               AcctLogFileName %L/detail
       </AuthBy>
</Realm>
 
 
 
<Realm /pessoal.ubi.pt/i>
        RewriteUsername s/^([^@]+).*/$1/
       AuthByPolicy ContinueAlways
       <AuthBy SQL>
              ……
              # disable authentication
              AuthSelect
              # set up accounting
              AccountingTable …..
              ……
        </AuthBy>
        <AuthBy LDAP2>
                Identifier      Pessoal
                Host            pessoaldc1.pessoal.ubi.pt
                Port            389
                AuthDN          cn=ldap,cn=Users,dc=ubi,dc=pt
                AuthPassword    xxxxxxxxxxxxxxxxx
                BaseDN          ou=PessoalUser,dc=pessoal,dc=ubi,dc=pt
                Scope           sub
                UsernameAttr    cn
                ServerChecksPassword
        </AuthBy>
</Realm>


See section 5.30 in the Radiator 4.8 reference manual ("doc/ref.pdf").

regards

Hugh


On 9 Sep 2011, at 20:52, Nuno Marques wrote:

> Hello,
>  
> I have this two realms which successfully authenticate and both record accounting into a local file. What I wish do to is that the radiator sends the accounting information directly into SQL server. I’ve tried many “personal possible solutions” but ended up discovering that the commands that work with SQL aren’t available in <Authby RADIUS> or <Authby LDAP2>. I should add we do not have SQL database for authentication. Is there any cookbook with the solution? Any contribution are greatly appreciated.
>  
> Thanks in advance,
> Nuno Marques
>  
>  
> <Realm /ubi.pt/i>
>        <AuthBy RADIUS>
>                Identifier PEAP_IAS
>                Secret xxxxxxxxxxxxxxxxxxxx
>                AuthPort 1812
>                AcctPort 1813
>                Retries 3
>                #AutoMPPEKeys
>                SSLeayTrace 4
>                Host ubidc1.ubi.pt
>                Host ubidc2.ubi.pt
>                AcctLogFileName %L/detail
>        </AuthBy>
> </Realm>
>  
>  
>  
> <Realm /pessoal.ubi.pt/i>
>         RewriteUsername s/^([^@]+).*/$1/
>         <AuthBy LDAP2>
>                 Identifier      Pessoal
>                 Host            pessoaldc1.pessoal.ubi.pt
>                 Port            389
>                 AuthDN          cn=ldap,cn=Users,dc=ubi,dc=pt
>                 AuthPassword    xxxxxxxxxxxxxxxxx
>                 BaseDN          ou=PessoalUser,dc=pessoal,dc=ubi,dc=pt
>                 Scope           sub
>                 UsernameAttr    cn
>                 ServerChecksPassword
>         </AuthBy>
> </Realm>
> 
> 
> UBI amiga do ambiente: Antes de imprimir este e-mail pense bem se tem mesmo que o fazer. As árvores são um bem imprescindível.
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh at open.com.au

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. 
Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.