Need to keep NAS-Identifier = "xxxsite1" in DB

[tnt at kalik.co.yu]

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