I have entered two separate NAS information for DB1 and DB2 databases. I hooked up two separate PF-se captive portals to the NAS tables in the DB1 and DB2 databases. Two separate captive portal Internet users will authenticate and provide access to the Internet. The panel operators who enter the management panel I have made (the PF sense) will see the users on their own databases (DB1 or DB2) on the Internet with the captive portal separately. Panel administrators who don't recognize each other can open the same user name and password in the Radcheck table. Internet users with the same user name in separate databases can have separate Internet speeds. I need to separate the accounting. I may not be able to express myself, but I'm sure you are a humble and helpful person... Maybe you want to connect with team Viwer. I'm writing the panel with Ruby on Rails. The rails attribute and the words of a team are using their own. He wants me to put an "s" at the end of the names of the MVC model tables.
(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. Sincerely 2018-02-08 0:52 GMT+03:00 Alan DeKok <aland@deployingradius.com>:
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.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html