Mysql, Accounting and DialupAdmin

[Fajar A. Nugraha]

On Wed, Nov 7, 2012 at 10:16 PM, Erich Titl <erich.titl at think.ch> wrote:
> Hi Folks
>
> I succeeded to get my set up running with FR 2.2.0 and Mysql, e.g. I can
> connect through a ZyXEL NWA 3160 using credentials in the MySQL database
> using a M$ Windows 7 client.
>
> Everything is still quite raw and blurry to me. Could someone point me
> to the right dos for the following?
>
> 1) I had to enter cleartext password into the mysql database, apparently
> other formats were not accepted

Because you use Windows client, which defaults to EAP-MSCHAPv2. See
http://deployingradius.com/documents/protocols/compatibility.html
If your main concern is "I don't want to store cleartext password in
db", you should be able to use NT-Password. Search the list archive,
there's a recent thread about this.

>
> 2) I could see login and logout information, but no data usage, e.g.
> dowload and upload sizes appear to be zeroes.

Some NAS (e.g. AP's flashed with dd-wrt) simply doesn't send
accounting packets. Blame your NAS :P
... or to be more acccurate, look at your NAS documentation (or ask
the vendor) how to get it to send accounting packets.

-- 
Fajar