Dear all I sent this mail to freeradius user group and think I should forward to develope group too. Thanks Danai ----------------------------------------------------------------- Dear all I setup freeradius for my EAP-TLS with realm configuration and everything is fine. But I have some problem about database. The realm name is shown in table raddpostauth but it's not shown in table radacct which is more important. I checked in debug mode and found that freeradius send username with out realm to AP during post-auth process then AP send only username to freeradius for accounting. How to set freeradius to send user@realm to AP in post-auth? I'm not sure what I miss.. Any idea please? For more information, please review in sql query below. Thanks Danai mysql> select username, Realm, NASIPAddress, AcctStartTime, AcctStopTime from radacct where AcctStartTime >= 20060212; +----------+-------+--------------+---------------------+---------------------+ | username | Realm | NASIPAddress | AcctStartTime | AcctStopTime | +----------+-------+--------------+---------------------+---------------------+ | danai | | 192.168.1.2 | 2006-02-12 12:29:47 | 2006-02-12 12:44:32 | | danai | | 192.168.1.2 | 2006-02-12 12:44:34 | 2006-02-12 12:52:33 | | danai | | 192.168.1.2 | 2006-02-12 12:52:35 | 2006-02-12 16:23:09 | | danai | | 192.168.1.2 | 2006-02-12 16:23:10 | 2006-02-12 17:27:56 | | danai | | 192.168.1.2 | 2006-02-12 17:28:01 | 2006-02-12 17:30:48 | | danai | | 192.168.1.2 | 2006-02-12 17:30:52 | 2006-02-12 17:32:58 | | danai | | 192.168.1.2 | 2006-02-12 17:35:39 | 2006-02-12 17:35:45 | | danai | | 192.168.1.2 | 2006-02-12 17:35:46 | 2006-02-12 17:36:58 | | danai | | 192.168.1.2 | 2006-02-12 17:37:33 | 2006-02-12 21:56:37 | | danai | | 192.168.1.2 | 2006-02-12 17:53:49 | 2006-02-12 17:54:09 | | danai | | 192.168.1.2 | 2006-02-12 17:54:16 | 2006-02-12 18:03:05 | | danai | | 192.168.1.2 | 2006-02-12 18:03:09 | 0000-00-00 00:00:00 | | danai | | 192.168.1.2 | 2006-02-12 21:54:47 | 2006-02-12 21:55:06 | | danai | | 192.168.1.2 | 2006-02-12 21:55:39 | 2006-02-12 21:56:10 | | danai | | 192.168.1.2 | 2006-02-12 21:56:39 | 2006-02-12 22:25:04 | | danai | | 192.168.1.2 | 2006-02-12 22:12:11 | 2006-02-12 22:18:44 | | danai | | 192.168.1.2 | 2006-02-12 22:19:01 | 2006-02-12 22:19:23 | | danai | | 192.168.1.2 | 2006-02-12 22:20:01 | 0000-00-00 00:00:00 | | danai | | 192.168.1.2 | 2006-02-12 22:26:12 | 2006-02-12 22:26:34 | | danai | | 192.168.1.2 | 2006-02-12 22:26:35 | 0000-00-00 00:00:00 | +----------+-------+--------------+---------------------+---------------------+ 20 rows in set (0.00 sec) mysql> select user, NASIPAddress, date from radpostauth where date >= 20060212; +--------------------+--------------+---------------------+ | user | NASIPAddress | date | +--------------------+--------------+---------------------+ | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 12:29:47 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 12:44:33 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 12:52:34 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 16:23:10 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 17:28:01 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 17:30:51 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 17:35:39 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 17:35:46 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 17:37:33 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 17:53:49 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 17:54:15 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 18:03:09 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 21:54:47 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 21:55:39 | | danai@kmitnb.ac.th | 192.168.1.2 | 2006-02-12 21:56:39 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 22:12:11 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 22:19:01 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 22:20:01 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 22:26:12 | | danai@kmitt.ac.th | 192.168.1.2 | 2006-02-12 22:26:35 | +--------------------+--------------+---------------------+ 20 rows in set (0.00 sec) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com