Subject: Realm proxy HOW-TO??
From: Danai Chudthong <[email-masked]>
To: [email-masked]
Cc: [email-masked]
Date: Sun, 12 Feb 2006 07:56:07 -0800 (PST)

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            
   |
+--------------------+--------------+---------------------+
| [email-masked] | 192.168.1.2  | 2006-02-12
12:29:47 |
| [email-masked] | 192.168.1.2  | 2006-02-12
12:44:33 |
| [email-masked] | 192.168.1.2  | 2006-02-12
12:52:34 |
| [email-masked] | 192.168.1.2  | 2006-02-12
16:23:10 |
| [email-masked] | 192.168.1.2  | 2006-02-12
17:28:01 |
| [email-masked] | 192.168.1.2  | 2006-02-12
17:30:51 |
| [email-masked] | 192.168.1.2  | 2006-02-12
17:35:39 |
| [email-masked] | 192.168.1.2  | 2006-02-12
17:35:46 |
| [email-masked] | 192.168.1.2  | 2006-02-12
17:37:33 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
17:53:49 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
17:54:15 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
18:03:09 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
21:54:47 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
21:55:39 |
| [email-masked] | 192.168.1.2  | 2006-02-12
21:56:39 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
22:12:11 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
22:19:01 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
22:20:01 |
| [email-masked]  | 192.168.1.2  | 2006-02-12
22:26:12 |
| [email-masked]  | 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