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