Different databases with single freeradius

[Emrah Yıldırım]

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 at deployingradius.com>:

> On Feb 7, 2018, at 4:06 PM, Emrah Yıldırım <emrah.yldrm81 at 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
>