Just add NASIdentifier column to the radacct table and alter accounting_start_query to put %{NAS-Identifier} into NASIdentifier column. Ivan Kalik Kalik Informatika ISP Dana 7/9/2007, "Pratchaya Chatuphian" <pratchaya.note@gmail.com> piše:
Hi, everybody
I need help. I want to keep NAS-Identifier in DB. It can be keep it on DB ? Would you like to suggest/help/guide me ?
Thank you very much Pratchaya
I see Log file /var/log/freeradius/radacct/124.xxx.xxx.xxx/detail-20070829 ###################################### Wed Aug 29 12:56:06 2007 Acct-Status-Type = Stop User-Name = "abcdef" Calling-Station-Id = "00-13-CE-85-5E-1C" Called-Station-Id = "00-16-B6-39-A1-58" NAS-Port-Type = Wireless-802.11 NAS-Port = 0 NAS-Port-Id = "00000000" NAS-IP-Address = 0.0.0.0 NAS-Identifier = "xxxsite1" Framed-IP-Address = 192.168.182.2 Acct-Session-Id = "46d4f94d00000000" Acct-Input-Octets = 4929573 Acct-Output-Octets = 855319 Acct-Input-Gigawords = 0 Acct-Output-Gigawords = 0 Acct-Input-Packets = 7255 Acct-Output-Packets = 6115 Acct-Session-Time = 3273 Acct-Terminate-Cause = User-Request Client-IP-Address = 124.xxx.xxx.xxx Acct-Unique-Session-Id = "f3b7c7399f2effd3" SQL-User-Name = "abcdef" Timestamp = 1188366966
Wed Aug 29 13:01:02 2007 Acct-Status-Type = Start User-Name = "hijklmn" Calling-Station-Id = "00-13-CE-85-5E-1C" Called-Station-Id = "00-16-B6-39-A1-58" NAS-Port-Type = Wireless-802.11 NAS-Port = 0 NAS-Port-Id = "00000000" NAS-IP-Address = 0.0.0.0 NAS-Identifier = "xxxsite1" Framed-IP-Address = 192.168.182.2 Acct-Session-Id = "46d50a7700000000" Client-IP-Address = 124.xxx.xxx.xxx Acct-Unique-Session-Id = "c9fd0ca61d8c8c57" SQL-User-Name = "hijklmn" Timestamp = 1188367262 ######################################
and i see DB ( no have NAS-Identifier Field ) ###################################### Database changed 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 | | | | | UserName | varchar(64) | NO | MUL | | | | Realm | varchar(64) | YES | | NULL | | | NASIPAddress | varchar(15) | NO | MUL | | | | NASPortId | int(12) | 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(32) | YES | | NULL | | | ConnectInfo_stop | varchar(32) | 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)
mysql> ###################################### - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html