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

Pratchaya Chatuphian pratchaya.note at gmail.com
Fri Sep 7 12:44:20 CEST 2007


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



More information about the Freeradius-Users mailing list