Hello, I have used mysql with freeradius for a long time but i have a problem of performance it is time to use a memory database like redis i store the msisdn and ip of my customers then this customer will send an access request to my freeradius server to authenticate so my question is simple as iam storing my data ip and msisdn in redis how to configure authorisation in redis module in freeradius server to authenticate my customers Thanks in advance Best Regards Mettichi Bassem
...or tweak MySQL (use InnoDB, improve caches etc - or use a better more performant DB instead - eg PostgreSQL alan
Hello, i wouldn't like to use any sql database, i would like to ,use a memory database that is why i have choosed redis as the ebst solution but i don't know why until this time only accounting is working why they didn't developped a module for authorization. Best regards Mettichi Bassem 2017-12-26 12:20 GMT+01:00 Alan Buxey <alan.buxey@gmail.com>:
...or tweak MySQL (use InnoDB, improve caches etc - or use a better more performant DB instead - eg PostgreSQL
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
...or tweak MySQL (use InnoDB, improve caches etc - or use a better more performant DB instead - eg PostgreSQL
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
Repeat that 666 more times and you will figure it out by yourself! -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+m_zouhairy=skno.by@lists.freeradius.org] On Behalf Of Bassem Mettichi Sent: Tuesday, December 26, 2017 2:34 PM To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Subject: Re: Hello, i wouldn't like to use any sql database, i would like to ,use a memory database that is why i have choosed redis as the ebst solution but i don't know why until this time only accounting is working why they didn't developped a module for authorization. Best regards Mettichi Bassem 2017-12-26 12:20 GMT+01:00 Alan Buxey <alan.buxey@gmail.com>: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Dec 26, 2017, at 6:34 AM, Bassem Mettichi <mettichi@gmail.com> wrote:
i wouldn't like to use any sql database, i would like to ,use a memory database that is why i have choosed redis as the ebst solution but i don't know why until this time only accounting is working why they didn't developped a module for authorization.
We understand. You can stop saying the same thing over and over and over and over again. The short answer is that you have to create this solution yourself. As I said already, the SQL module has a default schema, queries, etc., for authorization. The Redis module doesn't have that. So no matter how many times you ask this question, the answer will always be the same. There is NO default schema, queries, etc. for authorization in the Redis module. Alan DeKok.
Hi Bassem, I have acheived the auth from redis using custom perl script. You can use the same it's pretty efficient. Thanks On Wed, Dec 27, 2017 at 3:50 AM, Alan DeKok <aland@deployingradius.com> wrote:
On Dec 26, 2017, at 6:34 AM, Bassem Mettichi <mettichi@gmail.com> wrote:
i wouldn't like to use any sql database, i would like to ,use a memory database that is why i have choosed redis as the ebst solution but i don't know why until this time only accounting is working why they didn't developped a module for authorization.
We understand. You can stop saying the same thing over and over and over and over again.
The short answer is that you have to create this solution yourself. As I said already, the SQL module has a default schema, queries, etc., for authorization. The Redis module doesn't have that.
So no matter how many times you ask this question, the answer will always be the same. There is NO default schema, queries, etc. for authorization in the Redis module.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/ list/users.html
-- Regards, Jehanzaib
participants (5)
-
Alan Buxey -
Alan DeKok -
Bassem Mettichi -
J E H A N Z A I B -
Vacheslav