Radius don't write on MySQL radacct

[Felipe Neuwald]

Marinko,

Yes, radacct is here. Take a look:

mysql> use radius;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------------+
| Tables_in_radius        |
+-------------------------+
| nas                     |
| radacct                 |
| radcheck                |
| radcheck_150208         |
| radcheck_backup         |
| radgroupcheck           |
| radgroupreply           |
| radpostauth             |
| radreply                |
| usergroup               |
| usergroup_backup-070208 |
| usergroup_backup        |
+-------------------------+
12 rows in set (0.01 sec)

mysql> describe radacct;
+--------------------+-------------+------+-----+---------------------+----------------+
| Field              | Type        | Null | Key | Default
| Extra          |
+--------------------+-------------+------+-----+---------------------+----------------+
| RadAcctId          | bigint(21)  | NO   | PRI | NULL
| auto_increment |
| AcctSessionId      | varchar(32) | NO   | MUL |
|                |
| AcctUniqueId       | varchar(32) | NO   | MUL |
|                |
| UserName           | varchar(64) | NO   | MUL |
|                |
| Realm              | varchar(64) | YES  |     |
|                |
| NASIPAddress       | varchar(15) | NO   | MUL |
|                |
| NASPortId          | varchar(15) | YES  |     | NULL
|                |
| NASPortType        | varchar(32) | YES  |     | NULL
|                |
| AcctStartTime      | datetime    | NO   | MUL | 0000-00-00 00:00:00
|                |
| AcctStopTime       | datetime    | NO   | MUL | 0000-00-00 00:00:00
|                |
| AcctSessionTime    | int(12)     | YES  |     | NULL
|                |
| AcctAuthentic      | varchar(32) | YES  |     | NULL
|                |
| ConnectInfo_start  | varchar(50) | YES  |     | NULL
|                |
| ConnectInfo_stop   | varchar(50) | YES  |     | NULL
|                |
| AcctInputOctets    | bigint(12)  | YES  |     | NULL
|                |
| AcctOutputOctets   | bigint(12)  | YES  |     | NULL
|                |
| CalledStationId    | varchar(50) | NO   |     |
|                |
| CallingStationId   | varchar(50) | NO   |     |
|                |
| AcctTerminateCause | varchar(32) | NO   |     |
|                |
| ServiceType        | varchar(32) | YES  |     | NULL
|                |
| FramedProtocol     | varchar(32) | YES  |     | NULL
|                |
| FramedIPAddress    | varchar(15) | NO   | MUL |
|                |
| AcctStartDelay     | int(12)     | YES  |     | NULL
|                |
| AcctStopDelay      | int(12)     | YES  |     | NULL
|                |
+--------------------+-------------+------+-----+---------------------+----------------+
24 rows in set (0.00 sec)

Felipe.

2008/9/12 Marinko Tarlac <mangia81 at gmail.com>:
> It is listed
>
>  1.
>             #
>  2.
>             #  Log traffic to an SQL database.
>  3.
>             #
>  4.
>             #  See "Accounting queries" in sql.conf
>  5.
>     #       sql
>  6.
>             sql
>  7.
>
>
> and I can see sql queries in sql.conf
>
> Did you check your radacct table ?
>
> Felipe Neuwald wrote:
>>
>> Ivan,
>>
>> I hope sql is listed in accouting section. Take a look:
>>
>> radiusd.conf: http://pastebin.ca/1201150
>> sql.conf: http://pastebin.ca/1201151
>>
>> Felipe.
>>
>> 2008/9/12  <tnt at kalik.net>:
>>
>>>
>>> sql is not listed in accounting section. Or it's commented out.
>>>
>>> Ivan Kalik
>>> Kalik Informatika ISP
>>>
>>>
>>> Dana 12/9/2008, "Felipe Neuwald" <felipebgn at gmail.com> piše:
>>>
>>>
>>>>
>>>> Hi all,
>>>>
>>>> I have one FreeRADIUS 1.1.7_2 server running on a FreeBSD 6.2-STABLE
>>>> box, and other FreeBSD 6.3-STABLE box running MySQL 5.0.51a.
>>>>
>>>> These RADIUS system, are running at least for one year, and I got no
>>>> problems, but now, since one month ago, I have no write on radacct
>>>> table. Here is the result of radiusd -X: http://pastebin.ca/1201080
>>>>
>>>> Does anybody knows what does it could be?
>>>>
>>>> Thank you very much,
>>>>
>>>> Felipe Neuwald.
>>>> -
>>>> List info/subscribe/unsubscribe? See
>>>> http://www.freeradius.org/list/users.html
>>>>
>>>>
>>>>
>>>
>>> -
>>> List info/subscribe/unsubscribe? See
>>> http://www.freeradius.org/list/users.html
>>>
>>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>