Hello.
FreeRadius, rlm_sql.
Configured, started, tested = worked.
Task.
Control users access via per group basis. (If user in some group, then
his has (has not) access).
I have "main group" - dialup.
In that group i setup "default values"
Auth-Type := PAP
And Reply
Framed-Protocol := PPP
Service
: Thursday, June 26, 2003 4:10 PM
To: '[EMAIL PROTECTED]'
Subject: RE: How do I know if SQL module is loaded?
Never mind, I think I got it. It seems that the
modules section defines module attributes and alias and
any sections below that references a module will
cause that module being in
The file doc/module_interface explains this pretty good.
Sorry for the noises.
-Original Message-
From: Alex Chen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 4:10 PM
To: '[EMAIL PROTECTED]'
Subject: RE: How do I know if SQL module is loaded?
Never mind, I think I g
] Behalf Of Alex Chen
Sent: Thursday, June 26, 2003 4:03 PM
To: [EMAIL PROTECTED]
Subject: How do I know if SQL module is loaded?
I am trying to build FreeRadius 0.8.1 to use MySQL DB on RH LINUX 8.0 .
Previously I did not install MySQL header file package so rlm_sql_mysql was
not even built.
After I
the '-X' flag, I still did
not see a message
saying the SQL module was loaded, although the sql was in the modules
section.
The file radiusd.conf has the following entry for SQL:
modules {
pap {...}
chap {...}
pam {...}
unix {...}
Hmmm...
Actualy it's not about User-Name.
I'm making user authorization with sql module, but there are two
types of authorization I need (ANI and Pre-Paid Card), so each of them I
want to handle with different module, because of different queries
nedded for ANI and Pre-
On Wed, 11 Jun 2003 10:31:25 +0300, Ar wrote:
> Hi, It's about FreeRadius 0.8.1 and rlm_sql module usage and configuring
> radiusd.conf.
>
> Is it possible to use two sql modules (sql1 and sql2) derived
> from original rlm_sql module?
Yes, like all other modules. They're called instances. Y
Hi, It's about FreeRadius 0.8.1 and rlm_sql module usage and configuring
radiusd.conf.
Is it possible to use two sql modules (sql1 and sql2) derived
from original rlm_sql module?
Is it possible to use only one of them in authorize section
depending on some radius Attributes (like U
>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 27, 2003 2:42 PM
Subject: R: sql module failed
Hi everybody.
I am having the same problem using redhat 9.0
I don't have a clue how to solve this, the FAQ on freeradius.org did not
help much...
Please help!
Michele
-
List info/subs
"Michele Cumar" <[EMAIL PROTECTED]> wrote:
> I am having the same problem using redhat 9.0
>
> I don't have a clue how to solve this, the FAQ on freeradius.org did not
> help much...
The FAQ gives multiple explicit instructions as to how that problem
can be avoided completely. If that is insuf
aggio 2003 12.53
A: [EMAIL PROTECTED]
Oggetto: sql module failed
Hallo all
I just installed freeradius-0.8.1 on redhat 9.0.
I have installed freeradius-0.8 on 7.3 before and all worked perfectly, now
I
have this problem.
When starting radiusd in debug mode "/usr/local/sbin/radiusd -X&
At 04:56 PM 3/11/2003 +, Keith Ballard wrote:
Hi all,
I'm happily using sql module to authorise 1 users.
However I wanted to disallow 1 user and did it by:
Radgroupreply:
29,noaccess,Auth-Type,:=,Reject,0
Usergroup:
1000,fred,noaccess
Radcheck:
1000,fred,password,==,password
It see
Hi all,
I'm happily using sql module to authorise 1 users.
However I wanted to disallow 1 user and did it by:
Radgroupreply:
29,noaccess,Auth-Type,:=,Reject,0
Usergroup:
1000,fred,noaccess
Radcheck:
1000,fred,password,==,password
It seems as long as fred's username & passwo
"Allister Maguire" <[EMAIL PROTECTED]> wrote:
> We have been developing a SQL version of the IP Pools module, it is
> finished but we could not find away to make use of the rlm_sql module,
> which we would like to do.
Have you tried the 'xlat' functions? They might do what you want...
> It use
Hello,
We have been developing a SQL version of the IP Pools module, it is
finished but we could not find away to make use of the rlm_sql module,
which we would like to do.
Here is the problem:
This is a same of one of the queries:
start-begin = "BEGIN"
start-update = "UPDATE ippool SET expiry_
eradius-users-admin@;lists.cistron.nl]On Behalf Of Igor de
> Rooij
> Sent: Monday, October 28, 2002 10:09 AM
> To: [EMAIL PROTECTED]
> Subject: SQL module/query per NAS
>
>
> Hello,
>
> I am looking how to configure freeradius to use different accounting sql
> mod
"Igor de Rooij" <[EMAIL PROTECTED]> wrote:
> I am looking how to configure freeradius to use different accounting sql
> modules/queries per NAS.
>
> basically i want to put something like this in my acct_users file :
>
> DEFAULT NAS-IP-Address == 10.0.0.1, Acct-Status-Type == Stop,
> Auth
Hello,
I am looking how to configure freeradius to use different accounting sql
modules/queries per NAS.
basically i want to put something like this in my acct_users file :
DEFAULT NAS-IP-Address == 10.0.0.1, Acct-Status-Type == Stop,
Auth-Type := SQL1
DEFAULT NAS-IP-Address == 1
Hi All,
I'm using sql module to authorize and authenticate users from Oracle
database. I'm trying to use PAP module to change the encryption type
used for password but it does not work. I tried to define the
authentication type in users file and included the files module in
authorizati
On Fri, May 31, 2002 at 10:48:27AM -0400, Alan DeKok wrote:
> Simon <[EMAIL PROTECTED]> wrote:
> > > That's because of recent changes I made to the module. It now
> > > escapes magic characters, and I'll add '.' to the list of characters
> > > it doesn't escape.
> >
> > Could we please also ad
Simon <[EMAIL PROTECTED]> wrote:
> > That's because of recent changes I made to the module. It now
> > escapes magic characters, and I'll add '.' to the list of characters
> > it doesn't escape.
>
> Could we please also add '@' to the list of non-escaped characters?
> Considering that '@' is u
On Tue, May 28, 2002 at 11:59:51AM -0400, Alan DeKok wrote:
> "Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote:
> > Whenever it receives a user with an IP format, example: 10.1.2.3 it
> > returns failed and it is wrong.
> >
> > I search the code and found that the problem is with this line:
> > radiu
"Rodrigo Gonzalez" <[EMAIL PROTECTED]> wrote:
> Whenever it receives a user with an IP format, example: 10.1.2.3 it
> returns failed and it is wrong.
>
> I search the code and found that the problem is with this line:
> radius_xlat(querystr, MAX_QUERY_LEN,
> inst->config->authorize_check_query, r
I found a little problem with this
module.
Whenever it receives a user with an IP format,
example: 10.1.2.3 it returns failed and it is wrong.
I search the code and found that the problem is
with this line:
radius_xlat(querystr, MAX_QUERY_LEN,
inst->config->authorize_check_query, request
On Thu, 28 Mar 2002, Nikodim Nikodimov wrote:
> Hi All,
> I have one problems with sql module in "authentication" sector. I put sql and
>comment the others modules. And I receive the following mistake:
>
> Thu Mar 28 10:06:30 2002 : Info: rlm_sql: Driver rlm_sql_mysq
Hi All,
I have one problems with sql module
in "authentication" sector. I put sql and comment the others modules. And I
receive the following mistake:
Thu Mar 28 10:06:30 2002 : Info:
rlm_sql: Driver rlm_sql_mysql loaded and linkedThu Mar 28 10:06:30 2002 :
Info: rlm_sql: Att
Alan,
I tried Randy's patch and it worked like a charm. Patched cleanly against
today's CVS snapshot.
Thanks guys,
Jeremy
On Friday 25 January 2002 02:33 pm, you wrote:
> Randy Moore <[EMAIL PROTECTED]> wrote:
> > This patch has not made it into CVS yet. Maybe more people need to try
> > it
Randy Moore <[EMAIL PROTECTED]> wrote:
> This patch has not made it into CVS yet. Maybe more people need to try it
> and comment on it. Alan?
If a few people try and say it works for them, I'll drop it in.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list
At 01:56 PM 1/25/2002 -0800, you wrote:
>I would be happy to try your patch if += isn't sufficient to fix this, but I
>figured I was doing something wrong (which I probably am) and was just going
>to fix the syntax to make it work properly.
No problem on the confusion.
But, yes, you really do n
Jeremy Brown <[EMAIL PROTECTED]> wrote:
> I did update my schema. From the mysql snippet I put in, you will see that
> the last column is "op" and the Ascend-Data-Filter lines have "+=" rather
> than "=".
OK...
> I figured that this would return in the radtest, if the op is set
> right in t
Alan and Randy,
My apologies for the description guys, I know it was confusing, I was just
trying to get as much info out there as possible to help solve the problem.
Alan:
I did update my schema. From the mysql snippet I put in, you will see that
the last column is "op" and the Ascend-Data-
Hi Jeremy,
Most of the attributes you specify below should be in 'radgroupreply', not
in 'radgroupcheck' (everything except AuthType, I believe).
In addition to fixing that, I posted a patch to this list on Jan 13th that
allows you to specify more than one Attribute with the same name. The
s
Jeremy Brown <[EMAIL PROTECTED]> wrote:
> However, I am still unable to get it to return more than one
> X-Ascend-Data-Filter statement. A sample radtest:
Yes have you updated your databse schema? Have you added the
"+=" operators to the appropriate rows?
From your post, it looks lik
Alan,
Thanks for the advice. I uninstalled the old version of FreeRADIUS on my
test server and grabbed the newest CVS snapshot this morning. radiusd -v
outputs:
radiusd: FreeRADIUS Version 0.5, for host i686-pc-linux-gnu, built on Jan 25
2002 at 09:46:13
The dates on both the radiusd execu
Jeremy Brown <[EMAIL PROTECTED]> wrote:
> Everything in the radgroupreply table comes back ok, except if I have to
> different rows with the same Attribute name, in which case it is only
> displaying the first instance of the attribute name.
Grab the latest CVS snapshot, and update the SQL sc
Hello,
I have setup FreeRADIUS 0.4 to use my existing MySQL db to do auth.
Everything works terrific, even got redundancy working.
I do have one problem though. All of my users will be using the same reply
settings, so I have them all set to use the same group "default"
Everything in the ra
I'm wondering if anyone has anymore documentation on the SQL module
than is in the tarball...perhaps a database structure and sql.conf
file they would be willing to share? I'm having difficulty understanding
the proper method for returning mutilple attribute names and values...
-
37 matches
Mail list logo
