Mysql, Accounting and DialupAdmin

Erich Titl erich.titl at think.ch
Wed Nov 7 16:16:06 CET 2012


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

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

mysql> select
username,acctstarttime,acctstoptime,acctoutputoctets,acctoutputoctets
from radacct;
+----------+---------------------+---------------------+------------------+------------------+
| username | acctstarttime       | acctstoptime        |
acctoutputoctets | acctoutputoctets |
+----------+---------------------+---------------------+------------------+------------------+
| test     | 2012-11-07 15:09:47 | 2012-11-07 15:15:48 |
0 |                0 |
| test     | 2012-11-07 15:15:48 | 2012-11-07 15:25:02 |
0 |                0 |
| test     | 2012-11-07 15:25:32 | 2012-11-07 15:41:52 |
0 |                0 |
+----------+---------------------+---------------------+------------------+------------------+

Thanks for hints

Erich Titl

-------------- 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/20121107/6d9909f5/attachment.bin>


More information about the Freeradius-Users mailing list