I think that multiple SQL instances are exactly what I'm looking for! Thank
you for the information!
On Mon, Jul 25, 2011 at 2:54 PM, Danny Stemmet wrote:
> Hi Dave,
>
> I have not tested this, but I will try it as soon as I have a chance..
>
> Create a sql.conf file per client.
>
> Be sure to c
Hi Dave,
I have not tested this, but I will try it as soon as I have a chance..
Create a sql.conf file per client.
Be sure to create an "instance" of type sql per client/realm.
eg.
client1_sql sql {
.
lots of configuration parameter (configurable per client, including
server/database/table
At my place of employment we have a web frontend to our radius server. This
frontend will be used by several different clients. We want to store each
client's usernames/passwords and MAC addresses in their own database. The
database name will be the client's realm name.
The reason we want this data
Thank you
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4381272.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
to use the schema and expand same. Also you may need to expand the
sql.conf file.
Regards
Emmanuel
--- On Fri, 5/6/11, Fajar A. Nugraha wrote:
From: Fajar A. Nugraha
Subject: Re: Radius Database
To: "FreeRadius users mailing list"
Date: Friday, May 6, 2011, 9:56 AM
On Fri, May
SC@ wrote:
>
> I know this website but I didn't find... maybe it is in but where ? i
> think i have asked kindly...
>
> This is a forum, when someone have difficulties we help him...
>
The people who occupy a forum though are generally not paid to help out
and do so with their free time. Sayin
hpmyadmin to test and all is right... but i don't
> know how to connect both... the database of freeradius is in a file, the
> database of phpmy admin is in an other... when i modify my website's code
> to
> manage my radius database it is not find because it is not at the rig
...@lists.freeradius.org
[mailto:freeradius-users-bounces+marius=mindspring.co...@lists.freeradius.org]
On Behalf Of SC@
Sent: Friday, May 06, 2011 3:40 PM
To: freeradius-users@lists.freeradius.org
Subject: Re: Radius Database
I think you didn't understand my problem...
I have no problem with one sof
age a database, i have
create a database with phpmyadmin to test and all is right... but i don't
know how to connect both... the database of freeradius is in a file, the
database of phpmy admin is in an other... when i modify my website's code to
manage my radius database it is not find be
On 06/05/11 14:07, SC@ wrote:
I know this website but I didn't find... maybe it is in but where ? i think
i have asked kindly...
This is a forum, when someone have difficulties we help him...
This the the *wrong* forum.
You're asking for advice on writing a web interface to a MySQL database.
On Fri, May 6, 2011 at 8:07 PM, SC@ wrote:
>
> I know this website but I didn't find... maybe it is in but where ? i think
> i have asked kindly...
> This is a forum, when someone have difficulties we help him...
>
>
You need to know some basic knowledge first before asking.
For example:
(1) Whi
I know this website but I didn't find... maybe it is in but where ? i think
i have asked kindly...
This is a forum, when someone have difficulties we help him...
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375837.html
Sent fro
ok !
And can I have a real help please ? or a link... if i had already find i
would not be here...
thank you.
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375799.html
Sent from the FreeRadius - User mailing list archive at Nabble.com
SC@ wrote:
> But one of the possibilities is to modify a configuration file of freeradius
> to tell it to write in another database, or to put its database in another
> file. No ?
Yes.
This is documented.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/use
But one of the possibilities is to modify a configuration file of freeradius
to tell it to write in another database, or to put its database in another
file. No ?
Thank you
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Radius-Database-tp4375341p4375577.html
Sent from
e to write in the code of my pages (or maybe
> in a configuration file of mysql or xampp or raddb) so that my website
> manages my radius database.
This is a question for MySQL, and has nothing to do with FreeRADIUS.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ork. I think that it comes from the way which is different.
I would like to know what I have to write in the code of my pages (or maybe
in a configuration file of mysql or xampp or raddb) so that my website
manages my radius database.
Thank you very much:)
--
View this message in context:
http
Alan DeKok wrote:
> Steve Bertrand wrote:
>> Considering that the project objective and purpose is designed around
>> FreeRADIUS and it's SQL database, and really doesn't have much use
>> elsewhere.
>>
>>> Leverage the FreeRADIUS name. :)
>> Net::FreeRADIUS::Management ?
>
> I'd say "Net::RADI
Alan Buxey wrote:
>
>> I guess I am a 'small cheese' with only 2m rows in my authentication
>> table? I am using PgSQL and have btree'd my timestamp columns, but it
>> still takes only 3.6s to pull 10k rows worth of just todays data.
>
> ah..you have the immediate advantage of postgreSQL
>
Fo
Steve Bertrand wrote:
> Considering that the project objective and purpose is designed around
> FreeRADIUS and it's SQL database, and really doesn't have much use
> elsewhere.
>
>> Leverage the FreeRADIUS name. :)
>
> Net::FreeRADIUS::Management ?
I'd say "Net::RADIUS::Management". Design t
Hi,
> I guess I am a 'small cheese' with only 2m rows in my authentication
> table? I am using PgSQL and have btree'd my timestamp columns, but it
> still takes only 3.6s to pull 10k rows worth of just todays data.
ah..you have the immediate advantage of postgreSQL
> I thought the point of in
Alexander Clouter wrote:
> Steve Bertrand wrote:
>>>> The radacct table in the RADIUS database grows at an enormously fast
>>>> rate. Regardless of server resources, trying to search or perform
>>>> actions on this table can be a daunting task.
>>&g
Steve Bertrand wrote:
>
>>> The radacct table in the RADIUS database grows at an enormously fast
>>> rate. Regardless of server resources, trying to search or perform
>>> actions on this table can be a daunting task.
>>
>> Yup. In some cases, people
Alan DeKok wrote:
> Steve Bertrand wrote:
>> The radacct table in the RADIUS database grows at an enormously fast
>> rate. Regardless of server resources, trying to search or perform
>> actions on this table can be a daunting task.
>
> Yup. In some cases, people are
Steve Bertrand wrote:
> Again, I'm not a programmer, so the real developers will likely laugh.
Why? If it works... ship it. :)
> The radacct table in the RADIUS database grows at an enormously fast
> rate. Regardless of server resources, trying to search or perform
> actions
Steve Bertrand wrote:
> Hi all,
>
> I'm curious to know what you use to manage your RADIUS database,
> particularly the accounting tables.
>
> For quite some time, I was using severely hacked versions of the
> dialup_admin scripts.
>
> Since then, I've w
Steve Bertrand wrote:
> I'm curious to know what you use to manage your RADIUS database,
> particularly the accounting tables.
"cron", and custom Perl scripts.
> Since then, I've written (ie. been writing) an ISP mgmt/accounting
> system that relies very
Hi all,
I'm curious to know what you use to manage your RADIUS database,
particularly the accounting tables.
For quite some time, I was using severely hacked versions of the
dialup_admin scripts.
Since then, I've written (ie. been writing) an ISP mgmt/accounting
system that relies ve
Yeh, that's what I meant
Sent from my iPhone
On 21/06/2009, at 6:06 PM, "Alan DeKok"
wrote:
> Robert White wrote:
>> I have a question about db connectivity with Radius.
>>
>> I currently have OpenRadius connecting to a mssql database using
>> unixODBC/TDS.
>
> Well... that's not FreeRADIUS.
Robert White wrote:
> I have a question about db connectivity with Radius.
>
> I currently have OpenRadius connecting to a mssql database using unixODBC/TDS.
Well... that's not FreeRADIUS. They are two completely different
pieces of software.
> If the database ever goes down for some reason a
I have a question about db connectivity with Radius.
I currently have OpenRadius connecting to a mssql database using unixODBC/TDS.
If the database ever goes down for some reason and then comes back up, I have
to restart Radius in order to re-establish db connectivity.
Is this an openradius pro
I agree but in my case it was because a package mysql-dev was missing...
when i installed it. everthing went good.
Regards,
Saeed Akhtar
2008/11/20 dgluoyun <[EMAIL PROTECTED]>
> I install the freeradius and mysql with the rpm packages, in the
> default way. nothing special to mention.
>
>
I install the freeradius and mysql with the rpm packages, in the default way.
nothing special to mention.
在2008-11-20,"Saeed Akhtar" <[EMAIL PROTECTED]> 写道:
I'm sorry but how to compile/install it using mysql extensions rlm_sql_mysql...
can u plz guide me.. i cant find any help on internet.
R
, 20 Nov 2008 13:15:42 +0500
> From: [EMAIL PROTECTED]
> To: freeradius-users@lists.freeradius.org
> Subject: Problem in setting up radius database in sql
>
> Hi all,
>I want to setup radius database in mysql I browse through wiki and
> found an artical "SQL How
try 'yum install freeradius-mysql'
Date: Thu, 20 Nov 2008 13:15:42 +0500From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: Problem in setting up radius database in sql
Hi all,
I want to setup radius database in mysql I browse through wiki and found
an artical "S
http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ#It_says_.22Could_not_link_..._file_not_found.22.2C_what_do_I_do.3F
Ivan Kalik
Kalik Informatika ISP
Dana 20/11/2008, "Saeed Akhtar" <[EMAIL PROTECTED]> piše:
>I'm sorry but how to compile/install it using mysql extensions
>rlm_sql_mysql..
I'm sorry but how to compile/install it using mysql extensions
rlm_sql_mysql... can u plz guide me.. i cant find any help on internet.
Regards,
Saeed Akhtar
On Thu, Nov 20, 2008 at 1:43 PM, Alexandre Chapellon <
[EMAIL PROTECTED]> wrote:
> your freeradius seems to be compiled/installed without
your freeradius seems to be compiled/installed without the mysql extensions
rlm_sql_mysql
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi all,
I want to setup radius database in mysql I browse through wiki and
found an artical "SQL How to" http://wiki.freeradius.org/SQL_HOWTO I
went through step by step and when in the last i tried to run radiusd ... I
ended up with following error:
Module: Linked to modu
Hi, I have two radius server since three years ago. They are my two
production AAA servers and can authenticate until 300.000 accounts. So my
RADIUS database (PostgreSQL) grew up enough and I realize that my SQL queries
slow down. I know that I have four table with almost 500.000 registers
Internet-Wifi Operador wrote:
> Very well, I´m doing the same, but i can't find information about the
> way freeradius process the attributes and operator,
Does the documentation help?
doc/processing_users_file
Or "man rlm_users"?
Alan DeKok.
--
http://deployingradius.com - The
Sorry, but I didn't really understand how does that relate to the fact that
I'm
working on a new radius web management interface... :-)
If I could get a sample dumpf of mysql's radius database I could post some
screenshots.
Thanks again.
On 3/10/07, Internet-Wifi Operador &l
find this information please send to me. Thanks
From: "liran tal" <[EMAIL PROTECTED]>
Reply-To: FreeRadius users mailing list
To: "FreeRadius users mailing list"
Subject: requiring a sample of a mysql radius database
Date: Sat, 10 Mar 2007 14:39:12 +0200
Hey everyon
not talking about a dump
of the radius database from your production systems :)
So if you have any test systems I would love it if you could attach a dump
of the radius database.
Thanks guys.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Yudi Wijaya <[EMAIL PROTECTED]> wrote:
> I already set up this in sql.conf
>
> authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM
> ${authcheck_table} WHERE STRCMP(Username, '%{SQL-User-Name}') = 0 and
> (mac='%{Calling-Station-Id}' or isnull(mac) or mac='') ORDER BY id"
#x27;%{Calling-Station-Id}' or isnull(mac) or mac='') ORDER BY id"
postauth_query = "UPDATE ${authcheck_table} set mac='%{Calling-Station-Id}'
WHERE Username = '%{SQL-User-Name}' and (mac='' or isnull(mac))"
then add this to radreply
46 matches
Mail list logo