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