On Feb 7, 2018, at 4:06 PM, Emrah Yıldırım <emrah.yldrm81@gmail.com> wrote:
First of all, I'm sorry. I sent out the changes I made and the Freeradius-X output. If I need to share other information, please tell me to share.
Please describe what you're doing. i.e. is there any way to tell the users apart? Are the different users stored in different "radcheck" databases? We can't magically understand what you want to do. You have to *tell us*. So far, you're trying *very* hard to give either too little information, or unimportant information.
*freeradius -X*
... Ready to process requests. Received Access-Request Id 44 from 192.168.6.1:15001 to 192.168.6.237:1812 length 133 NAS-IP-Address = 192.168.5.53 NAS-Identifier = 'pfSense.localdomain' User-Name = 'alandekok' User-Password = '123'
Hmm... OK... So you're not going to show how you tell the different users apart. Instead, you create a meaningless test user, and show us debug output from that. That's not helpful.
(0) db1 : EXPAND SELECT id, username, attribu, value, op FROM rad_checks WHERE username = '%{SQL-User-Name}' ORDER BY id
i.e. you've customized the tables and the queries. It would be polite to *say that*. i.e. describe what you did. How do you expect us to help you, if you make it as hard as possible for us to help you? Before you waste any more time, go read this page: http://wiki.freeradius.org/list-help
*/etc/freeradius/mods-available/sql*
I didn't ask for that. Why would you post it?
*etc/freeradius/sites-enabled/inner-tunnel*
And I didn't ask for that. This shouldn't be difficult. Read the documentation. Follow the instructions. Alan DeKok.