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" <[EMAIL PROTECTED]> 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 > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
