Mysql, Accounting and DialupAdmin

[Erich Titl]

Hi Fajar

on 08.11.2012 03:35, Fajar A. Nugraha wrote:
> 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.

Thanks, I read that URL, actually that one guided me to enter a
Cleartext Password at all.

mysql> select * from radcheck;
+----+----------+--------------------+----+----------------------------------+
| id | username | attribute          | op | value
     |
+----+----------+--------------------+----+----------------------------------+
|  1 | test     | MD5-Password       | := |
81dc9bdb52d04dc20036dbd8313ed055 |
|  2 | test     | NT-Password        | := |
7CE21F17C0AEE7FB9CEBA532D0546AD6 |
|  3 | test     | Cleartext-Password | := | 1234
     |
+----+----------+--------------------+----+----------------------------------+

> 
>>
>> 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

:-(

Do you have a recommendation for AP's that pass this information?

> ... or to be more acccurate, look at your NAS documentation (or ask
> the vendor) how to get it to send accounting packets.

It is a ZyXEL, so basically a black box, even to the local vendor.

Thanks

Erich


-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1877 bytes
Desc: S/MIME Kryptografische Unterschrift
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20121108/5e72a9f9/attachment.bin>