=?iso-8859-1?q?Kiran?= <[EMAIL PROTECTED]> wrote:
> I am using the following query for authorization and I
> am getting the error 1064 from MySql (PARSE ERROR).
> But when I am giving the same query replacing the
> variables with values, I am getting the output. Can
> someone explain me why.
Loo
Hi
I am using the following query for authorization and I
am getting the error 1064 from MySql (PARSE ERROR).
But when I am giving the same query replacing the
variables with values, I am getting the output. Can
someone explain me why.
"(select id,UserName,Attribute,Value,op from
${authreply_tab
ted it and it works well now :) Thanks!
Soujanya
From: "Alan DeKok" <[EMAIL PROTECTED]>> To: [EMAIL PROTECTED]> Subject: Re: freeradius mysql simultaneous-use question URGENT=20> Date: Tue, 16 Dec 2003 16:33:11 -0500> Reply-To: [EMAIL PROTECTED]>=20> Soujanya Rao &
Soujanya Rao <[EMAIL PROTECTED]> wrote:
> Can anyone tell me where I am going wrong? This is urgent and I am
> clueless as to what else needs to be done.
Ensure that 'sql' is listed in the 'accounting' section.
Run: radiusd -X
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://ww
Hi,
I am new to freeradius. I need some help in using simultaneous-use for detecting double logins using mysql only. Here is my current set up:
> select * from radgroup check
++--- +---++---+| id | GroupName | Attribute | op | Value |
nevermind. figured that out too. feel free to flame me on that one.
didn't bother to look around first. ;)
On Mon, 2003-11-17 at 12:32, Rob Hinst wrote:
> Hi Alan,
>
> Thanks again. I managed to get it working by changing this line:
>
> sql_user_name = "%{Stripped-User-Name}"
>
> to this:
>
>
Hi Alan,
Thanks again. I managed to get it working by changing this line:
sql_user_name = "%{Stripped-User-Name}"
to this:
sql_user_name = "%{User-Name}"
I just have one last question. Is there any simple way (a config
setting) to enable encrypted passwords in sql, or do I have to do some
hack
Thanks very much, I'll try to figure out the rest on my own.
On Mon, 2003-11-17 at 11:51, Alan DeKok wrote:
> Rob Hinst <[EMAIL PROTECTED]> wrote:
> > and also (and probably the more important question), what would cause
> > xlat to return nothing? I can't seem to find what the xlat routine does.
Rob Hinst <[EMAIL PROTECTED]> wrote:
> This is what the authorize and authenticate sections of my radiusd.conf
> file look like. Basically, I had it working properly off of the unx
> passwd file, and then i added "sql" to the authorize section and removed
> "files". I also removed "unix" from the a
Rob Hinst <[EMAIL PROTECTED]> wrote:
> and also (and probably the more important question), what would cause
> xlat to return nothing? I can't seem to find what the xlat routine does.
It's the dynamic translation of strings in the configuration file.
See 'sql.conf' for the SQL queries. The attr
and also (and probably the more important question), what would cause
xlat to return nothing? I can't seem to find what the xlat routine does.
On Mon, 2003-11-17 at 11:25, Alan DeKok wrote:
> Rob Hinst <[EMAIL PROTECTED]> wrote:
> > Obviously.. but I thought I had configured a response (otherwise
Hi Alan,
Thanks for the response, sorry to be a continuing pest, but I've added a
few additional comments/questions inline:
On Mon, 2003-11-17 at 11:25, Alan DeKok wrote:
> Rob Hinst <[EMAIL PROTECTED]> wrote:
> > Obviously.. but I thought I had configured a response (otherwise I
> > wouldn't ha
Rob Hinst <[EMAIL PROTECTED]> wrote:
> Obviously.. but I thought I had configured a response (otherwise I
> wouldn't have written). I'm trying to auth as robtest/test. My radcheck
> table looks like this:
The error messages were definitive, in that they showed the 'xlat'
routine returning *nothi
On Mon, 2003-11-17 at 10:17, Alan DeKok wrote:
> Rob Hinst <[EMAIL PROTECTED]> wrote:
> > radius_xlat: ''
> > modcall[authorize]: module "sql" returns fail for request 0
> > modcall: group authorize returns fail for request 0
> > There was no response configured: rejecting request 0
>
> Maybe
Rob Hinst <[EMAIL PROTECTED]> wrote:
> radius_xlat: ''
> modcall[authorize]: module "sql" returns fail for request 0
> modcall: group authorize returns fail for request 0
> There was no response configured: rejecting request 0
Maybe those lines mean something...
Alan DeKok.
-
List info/s
Hi Ulrich,
Below is the full output from radiusd -X.
On Mon, 2003-11-17 at 04:22, Ulrich Walcher wrote:
> Am Sam, 2003-11-15 um 04.03 schrieb Rob Hinst:
> > Hi all,
> >
> >
> > My goal is to use Freeradius with the sql module for authenticating
> > users. I'm using version 0.9.2 (installed fr
Am Sam, 2003-11-15 um 04.03 schrieb Rob Hinst:
> Hi all,
>
>
> My goal is to use Freeradius with the sql module for authenticating
> users. I'm using version 0.9.2 (installed from rpms i created with the
> specfile that came with the tarball). There doesn't seem to be a wealth
> of information av
= localhost
> nastype = other # localhost isn't usually a NAS...
> }
>
>
> Without this, radius will reject packets from localhost.
>
>
> []Âs
>
>
> Marcio
>
>
> - Original Message -
> From: "Rob Hinst" <[EMAIL PROTEC
ginal Message -
From: "Rob Hinst" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 15, 2003 12:03 AM
Subject: freeradius + mysql problems
> Hi all,
>
>
> My goal is to use Freeradius with the sql module for authenticating
> users. I
Hi all,
My goal is to use Freeradius with the sql module for authenticating
users. I'm using version 0.9.2 (installed from rpms i created with the
specfile that came with the tarball). There doesn't seem to be a wealth
of information available for using the sql module, but I've been working
off o
Hello,
We have here many DSL user. The radius of the Providers,
inquires with our radius. A radtest with the Provider
returns the following:
rad_recv: Access-Accept packet from host aaa.aaa.aaa.aaa:1812, id=16,
length=62
Framed-MTU = 1445
Service-Type = Framed-User
Framed
On Tue, 21 Oct 2003 18:36:10 +0800
"wanghao" <[EMAIL PROTECTED]> wrote:
> yes but my english no good .pls look this:
> accounting {
> #
> # Ensure that we have a semi-unique identifier for every
> # request, and many NAS boxes are broken.
> acct_unique
>
>
t;[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 6:35 PM
Subject: Re: FreeRadius+ mysql => No authenticate method (Auth-Type)
configuration found for the request
> On Tue, 21 Oct 2003 18:13:03 +0800
> "wanghao" <[EMAIL PROTECTED]> wrote:
>
> >
> &g
-
> From: "Alexey Sheshka" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 21, 2003 6:11 PM
> Subject: Re: FreeRadius+ mysql => No authenticate method (Auth-Type)
> configuration found for the request
>
>
> > On Tue, 21
anghao |//look this
++--+---++-+
3 rows in set (0.01 sec)
- Original Message -
From: "Alexey Sheshka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 6:11 PM
Subject: Re: FreeRadius+ mysql =&g
On Tue, 21 Oct 2003 11:42:51 +0200
[EMAIL PROTECTED] (Rens Houben) wrote:
> In other news for Tue, Oct 21, 2003 at 12:29:05PM +0300, Alexey Sheshka has been
> seen typing:
> > On Tue, 21 Oct 2003 11:13:23 +0200
> > [EMAIL PROTECTED] (Rens Houben) wrote:
>
> > > In other news for Tue, Oct 21, 200
In other news for Tue, Oct 21, 2003 at 12:29:05PM +0300, Alexey Sheshka has been seen
typing:
> On Tue, 21 Oct 2003 11:13:23 +0200
> [EMAIL PROTECTED] (Rens Houben) wrote:
> > In other news for Tue, Oct 21, 2003 at 12:05:19PM +0300, Alexey Sheshka has been
> > seen typing:
> > Try this from a
On Tue, 21 Oct 2003 11:13:23 +0200
[EMAIL PROTECTED] (Rens Houben) wrote:
> In other news for Tue, Oct 21, 2003 at 12:05:19PM +0300, Alexey Sheshka has been
> seen typing:
>
> {snip}
>
> > auth: No authenticate method (Auth-Type) configuration found for the request:
> > Rejecting the user
> >
On 21 Oct 2003 11:10:01 +0200
Ulrich Walcher <[EMAIL PROTECTED]> wrote:
> Check http://www.frontios.com/freeradius.html
Thanks, I know about this manual.
--
PGP key : http://pgp.dtype.org:11371/pks/lookup?op=get&search=0x0BE90515
-
List info/subscribe/unsubscribe? See http://www.freeradi
On Tue, 21 Oct 2003 11:13:23 +0200
[EMAIL PROTECTED] (Rens Houben) wrote:
> In other news for Tue, Oct 21, 2003 at 12:05:19PM +0300, Alexey Sheshka has been
> seen typing:
>
> {snip}
>
> > auth: No authenticate method (Auth-Type) configuration found for the request:
> > Rejecting the user
> >
Hi Alexey,
do u have setup proxy.conf (even if u dont use it )
i have resolv this problem by setting up this file .
# proxy.conf
proxy server {
synchronous = no
retry_delay = 5
retry_count = 3
dead_time = 120
default_fallback = yes
post_proxy_authorize = y
In other news for Tue, Oct 21, 2003 at 12:05:19PM +0300, Alexey Sheshka has been seen
typing:
{snip}
> auth: No authenticate method (Auth-Type) configuration found for the request:
> Rejecting the user
> auth: Failed to validate the user.
> SQL module instaled. Instalation instructions from
Check http://www.frontios.com/freeradius.html
Am Die, 2003-10-21 um 11.05 schrieb Alexey Sheshka:
> Hi !
>
> I'm trying to setup FreeRadius with mysql but get a reject message:
> rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=22, length=20
> Output ftom radiusd -X :
>
> rlm_sql (sq
Hi !
I'm trying to setup FreeRadius with mysql but get a reject message:
rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=22, length=20
Output ftom radiusd -X :
rlm_sql (sql): Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded radutmp
radutmp: filename = "/usr
On Wed, 8 Oct 2003, net.art communications GmbH wrote:
> Hello,
>
> Can anybody help me?
> Password Expiration is not work here.
>
> In userfile work this fine, but not in
> MySql.
>
> mysql> SELECT * FROM radcheck;
> ++--+++--+
> | id | UserName | Attribute
Hello,
Can anybody help me?
Password Expiration is not work here.
In userfile work this fine, but not in
MySql.
mysql> SELECT * FROM radcheck;
++--+++--+
| id | UserName | Attribute | op | Value|
++--+++--+
Ferreira
Sent: 01 October 2003 11:15 PM
To:
[EMAIL PROTECTED]
Subject: RES: FreeBSD +freeradius
+mysql
Hi
Doron,
You can get my config files from www.ispadmin.com.br/downloads.html
The page is in Portuguese-Brazil, but willl be easy to view files
Hi All,
I have made several attemps at getting Freeradius
with mysql authentication on Freebsd
working. These attempts have all been in vain. Does anyone on this list have a howto and a copy of working config
files any tips tricks any info would be really appreciated.
Thanks
Dor
Internet
Catalao - Go - Brazil
-Mensagem original-De:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Em nome de Doron
ShmaryahuEnviada em: quarta-feira, 1 de outubro de 2003
18:03Para: [EMAIL PROTECTED]Assunto:
FreeBSD +freeradius +mysql
Hi
All,
I have
made
I tried in the following ways
1. accounting_stop_query = "insert into ;insert
into..."
it has thrown the error saying the sql statement was
incorrect :(
2. accounting_stop_query = "insert into ";"insert
into..."
it has just taken the first query and not the second
one.
--- Ulrich Walc
I didn't test it but did you try to add a semicolon and the next
statement?
I don't know if the accounting part is coded in another way than the
authorization part, but in authorization it works...
Am Mon, 2003-09-15 um 16.00 schrieb Kiran:
> Hi,
>
> I am using freeradius-0.9.1, MySql 4.0 and usi
Hi,
I am using freeradius-0.9.1, MySql 4.0 and using TCL
2.0 in Cisco AS5400.
How can I have more than one SQL statements to be
executed in sql.conf whenever there is an accounting
request.
Basically, I want to insert into one table and update
the second table once the call is finished. How can
> This simple script shell should be convenient. Just replace the IP
> address of your freeradius server (and the username / password /
> secret if you've changed the default configuration).
What I posted earlier is ugly and could be like this:
#!/bin/sh
# steve authenticates
radclient -x 172.16
En réponse à [EMAIL PROTECTED] :
> sorry for my poor english (im Brasilian), well, i'm starting at
> freeradius and mysql, i've installed freeradius + mysql following
> the www.frontios.com/freeradius.html howto, seems all ok, localy
> with radtest radius returns a message
Hi list,
sorry for my poor english (im Brasilian), well, i'm starting at freeradius and mysql,
i've installed freeradius + mysql following the www.frontios.com/freeradius.html
howto, seems all ok, localy with radtest radius returns a message of OK using the
table in mysql, but i wa
A four-year-old will very quickly get over news of the death of Santa if
told that it was due to his fully loaded sleigh crashing in the back
garden."
-- Mil Millington
"L U C A S" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/09/2003 03:43 PM
Please res
I'm using Freeradius and have some
problems that don't let me sleep..:-)
I want to authentificate our users not
only by username and passwort, I need to check also NAS-IP-Address or
Called-Station-ID. This I need to manage different NAS with one Radius, the
users only have to get access t
How do I deny access to a
specific group of users in Mysql, using Nas-Ip-Address or
Called-Station-Id?
I have NAS1 for dial-up access
and NAS2 for cable, but user´s from NAS1 can connect in cable. It´s wrong,
ok??
Help me.
Lucas
PS: In radgroupcheck I put
('1',dial-up,'Nas-Ip-Addr
lt;[EMAIL PROTECTED]>
Subject: freeradius+mysql prepaid (block time)
Date: Tue, 26 Aug 2003 00:41:54 -0400
I have freeradius running and authenticating/accounting via mysql. Very
slick.
I can see the accounting showing up in mysql with an accurate
AcctSessionTime. Is there a way to keep a running t
On Tue August 26 2003 07:41, Scott wrote:
> I have freeradius running and authenticating/accounting via mysql. Very
> slick.
>
> I can see the accounting showing up in mysql with an accurate
> AcctSessionTime. Is there a way to keep a running total of these times per
> user and authenticate not o
> I have freeradius running and authenticating/accounting via mysql. Very
> slick.
Me too :)
> I can see the accounting showing up in mysql with an accurate
> AcctSessionTime. Is there a way to keep a running total of these times
per
> user and authenticate not only on the basis of password but
I have freeradius running and authenticating/accounting via mysql. Very
slick.
I can see the accounting showing up in mysql with an accurate
AcctSessionTime. Is there a way to keep a running total of these times per
user and authenticate not only on the basis of password but also on the
value of
On Fri, 11 Jul 2003, Dave wrote:
> Hi,
>
> I'm using Freeradius with MySQL. It's run fine but
> freeradius doesn't seems to write in the
> AcctTerminateCause field in the Accounting table when
> there's a failed login. This make the Failed Login
> page of Dialup Admin empty with no records.
Y
> From: Dave
> Sent: Saturday, 12 July 2003 7:08 AM
> I'm using Freeradius with MySQL. It's run fine but
> freeradius doesn't seems to write in the
> AcctTerminateCause field in the Accounting table when
> there's a failed login. This make the Failed Login
> page of Dialup Admin empty with
Dave <[EMAIL PROTECTED]> wrote:
> I'm using Freeradius with MySQL. It's run fine but
> freeradius doesn't seems to write in the
> AcctTerminateCause field in the Accounting table when
> there's a failed login.
Does it *recieve* that attribute?
Do the SQL queries update that field?
Di
Hi,
I'm using Freeradius with MySQL. It's run fine but
freeradius doesn't seems to write in the
AcctTerminateCause field in the Accounting table when
there's a failed login. This make the Failed Login
page of Dialup Admin empty with no records.
Is there any additional configuration to
more help???
- Original Message -
From: "Paul Hampson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 6:02 PM
Subject: RE: md5 + freeradius + mysql
> > From: [EMAIL PROTECTED]
> > Sent: Thursday, 10 July 2003 3:45
> From: [EMAIL PROTECTED]
> Sent: Thursday, 10 July 2003 3:45 AM
> >> From: [EMAIL PROTECTED]
> >> Sent: Wednesday, 9 July 2003 9:38 PM
> >> how to use md5+radius+mysql, currently I use crypt of linux, but want to
> >> use md5. in radiusd.conf, modified an option in pap for md5 but he did
> >> no
>> From: [EMAIL PROTECTED]
>> Sent: Wednesday, 9 July 2003 9:38 PM
>
>> how to use md5+radius+mysql, currently I use crypt of linux, but want to
>> use md5. in radiusd.conf, modified an option in pap for md5 but he did
>> not
>> advance, what I can make?
>
> What do you mean by 'did not advance'? I
> From: [EMAIL PROTECTED]
> Sent: Wednesday, 9 July 2003 9:38 PM
> how to use md5+radius+mysql, currently I use crypt of linux, but want to
> use md5. in radiusd.conf, modified an option in pap for md5 but he did not
> advance, what I can make?
What do you mean by 'did not advance'? In what way d
Hello,
how to use md5+radius+mysql, currently I use crypt of linux, but want to
use md5. in radiusd.conf, modified an option in pap for md5 but he did not
advance, what I can make?
Thank's
Sorry, but my english is terrible!
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/
It works ok , thank you very much :)
On Thu, 2003-06-26 at 11:30, Oliver Graf wrote:
> On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote:
> > The passwords stored in mysql are encrypted in a strange way . For
> > example using crypt encryption the password stored in the database is
> >
On Thu, Jun 26, 2003 at 11:21:58AM +0300, Nickitas wrote:
> The passwords stored in mysql are encrypted in a strange way . For
> example using crypt encryption the password stored in the database is
> this :"$1$JLBPzLpM$hHtpEcBBpJiuzxs7RLr1P0"
this is an md5 password created with glibc crypt
Hello everyone and sorry cause this is gonna be a little bit long ,
I am having a problem making Freeradius , Dialup Admin and Mysql work
correctly .
I am using Freeradius v 0.8.1 and mysql verion 3.23.49 in a RedHat 7.3
Linux .
I had no problem setting up radius to work authenticating fr
On Wed, Jun 11, 2003 at 12:35:22PM -0400, Jason Lixfeld wrote:
> FreeRadius wouldn't stop users from being able to browse, bottom line.
> Your NAS may be doing something funky, and the fact that the bert user
> who logs in last at the bottom of your -X seems to be getting the filter
> std.ppp a
isn't busted and if you are doing filtering that it's
sane and not dropping traffic that shouldn't be dropped.
-Original Message-
From: "UK1 Webmail Customer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Wed, 11 Jun 2003 17:29:46 - (UTC)
I am a freeradius newbie just installed 0.8.1 with mysql users can
authenticate from mysql or users file ...several differing solutions tried
see radiud -X output below. (specifically users chris - mysql , brian
-mysql and bert -user file.)
Everything seems to work ok except browsing on port 80 ma
Hi all,
I'm looking for a script that reads citron radius log file and dump into
the FR mysql database.
Thanks,
Chhai
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi, I'm working with Quintum Tenor
GateWay/GateKeeper and have a problem:For user authenthication, Quintum
sends two packets: Authentication ana Authorization.I'm using MySQL with
freeRadius and can't understand how can my radius understand whether comes
Authentication and whether Authorizat
nessy [EMAIL PROTECTED]
On Fri, 14 Mar 2003, Pedro Alvarez-Tabío wrote:
> Date: Fri, 14 Mar 2003 11:35:16 +0100
> From: Pedro Alvarez-Tabío <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: FreeRADIUS & MYSQL
>
Carlo Tovazzi wrote:
try to launch ./configure in
/freeradius-0.8.1/src/modules/rlm_sql/
probably is absent the rlm module for sql
> rlm_sql (sql): Make sure it (and all its dependent libraries!) are
in the search
> ath of your system's ld.
> radiusd.conf[14]: sql: Module instantiation failed.
try to launch ./configure in
/freeradius-0.8.1/src/modules/rlm_sql/
probably is absent the rlm module for sql
> rlm_sql (sql): Make sure it (and all its dependent libraries!) are in
the search
> ath of your system's ld.
> radiusd.conf[14]: sql: Module instantiation failed.
-
List info/subscri
Did you add the tables?? on radius database
mysql -uroot -prootpass radius < db_mysql.sql
you can find db_mysql.sql
in the path where you unpacked tarball of freeradius then
it's in these directory
freeradius-0.8.1/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
because in that .sql ther
Hello,
I'm having problems with configuring freeRADIUS with MySQL.
I have done (Linux RH 7.3):
- Installed MySQL
- freeRADIUS:
./configure --localstatedir=/var --sysconfdir=/etc
--with-mysql-include-dir=/usr/local/mysql/include
--with-mysql-lib-dir=/usr/local/mysql/lib
--with-mysql-di
Iq wrote:
I will appreciate any help on how can I get accounting done on the data in
mysql (even an sql query will do), for the moment I am using plain text
files and getting accounting done by "Optigold ISP" log parser.
I want customers to check their usgae using a web base interface.
why don
you write your own scripts or use the same commands
Perhaps somebody else on the list might have more information but I just
wanted to write a quick reply. =)
Evren
On Tue, 21 Jan 2003, Iq wrote:
> Hi Everyone,
>I have steup freeradius+mysqlfairly easy wi
Hi Everyone,
I have steup freeradius+mysqlfairly easy with the
following links.
http://www.ccs.neu.edu/home/peterm/freeradiusbuild.html
http://www.frontios.com/freeradius.html
I did connect for a while to my POP as well using mysql at the backend. But
i don't know how
03-Jan-03 at 17:54, Marnix Petrarca ([EMAIL PROTECTED]) wrote :
> First of all, I have Freeradius latest version working with MySQL latest
> version.
>
> The plan is to run a 2-server fail-over config running as a primary daemon
> either FreeRadius or IC-Radius, which processes I plan to manage
Hi All,
forgive me if this cross-over question is partly due elsewhere - I really
do need some assistance here, or advice at least. Flame me at your leisure!
First of all, I have Freeradius latest version working with MySQL latest
version.
I have the following setup in mind: I just ordered the
CTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 28, 2002 3:59 PM
Subject: Linux+freeradius+mysql
> Hi everyone,
>tried freeradius with mysql, got it working but how do
I
> get usage details out of radacct table. Is there a query provided
anywhere.
> I ma
Use dialup_admin to view usage. You can find the sql queries in the source code
Chhai
-Original Message-
From: Iq [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 28 November 2002 3:29 PM
To: [EMAIL PROTECTED]
Subject: Linux+freeradius+mysql
Hi everyone,
tried freeradius
Hi everyone,
tried freeradius with mysql, got it working but how do I
get usage details out of radacct table. Is there a query provided anywhere.
I made two sessions and got both of them in radacct.
Bellow is a copy of what I got in radacct
mysql> select * from radacct where U
PROTECTED]]
Posted At: 24 November 2002 07:25
Posted To: FreeRadius
Conversation: How to configure
between FreeRadius & MySQL ?
Subject: How to configure between
FreeRadius & MySQL ?
Hi folks:
I want to use MySQL as name & password
database, but I don
Hi folks:
I want to use MySQL as name &
password
database, but I don't know how to configure. Could someone give me files
which are needed to modify
or teach me how to configure ? Thanks a lot!
Best Regards
Tim Liu
<[EMAIL PROTECTED]> wrote:
> I read the notes on this on the frontios site, and there was a mention of
> the need to add field "op" type varchar(2) to the radcheck and
> radgroupcheck tables, for version 0.5 and newer, but I'm only running
> 0.4.
> Does anyone have any ideas or do I need to supply
Greetings,
Here's my problem. I hope someone can help, I'm beating my head on the
table. I apologize for the length, but I want to be as clear and complete
as possible to make it easier to answer.
I'm using freeradius 0.4 and the freeradius-mysql and the
radiud-freeradius-mysql pa
At 11:19 AM 9/19/2002 -0500, NetNITCO Systems Administration wrote:
> > At 04:59 PM 9/19/2002 +0300, Konstantin Tsolov wrote:
> > >i use freeradius-0.4 to AAA a dialup realm (@realm)
> > >(should work for 0.4+ i guess, it's a relly simple setup)
> > >and here's what works for me:
>
>I think he was
> At 04:59 PM 9/19/2002 +0300, Konstantin Tsolov wrote:
> >i use freeradius-0.4 to AAA a dialup realm (@realm)
> >(should work for 0.4+ i guess, it's a relly simple setup)
> >and here's what works for me:
I think he was answering my original post from 09/11/2002 and offering a copy
of his config
:-) thank you, Chris!
On Thursday 19 September 2002 18:12, you wrote:
> At 04:59 PM 9/19/2002 +0300, Konstantin Tsolov wrote:
> >i use freeradius-0.4 to AAA a dialup realm (@realm)
> >(should work for 0.4+ i guess, it's a relly simple setup)
> >and here's what works for me:
>
> Lot's of fixes are
At 04:59 PM 9/19/2002 +0300, Konstantin Tsolov wrote:
>i use freeradius-0.4 to AAA a dialup realm (@realm)
>(should work for 0.4+ i guess, it's a relly simple setup)
>and here's what works for me:
Lot's of fixes are incorporated into recent releases. The server is
now up to version 0.7.1.
You s
i use freeradius-0.4 to AAA a dialup realm (@realm)
(should work for 0.4+ i guess, it's a relly simple setup)
and here's what works for me:
--radiusd.conf--
...
modules {
...
preprocess {
...
hints = ${confdir}/hints
...
}
> NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote:
> > but I need to be able to authenticate with user/passwords from MySQL.
>
> No, you don't. You do NOT want to give your users accounts to log
> in to your MySQL server.
>
> You want to pull the user's authorization items from MySQ
NetNITCO Systems Administration <[EMAIL PROTECTED]> wrote:
> but I need to be able to authenticate with user/passwords from MySQL.
No, you don't. You do NOT want to give your users accounts to log
in to your MySQL server.
You want to pull the user's authorization items from MySQL
(e.g. Pass
> I use Postgresql on 0.5, but apart from that ... Here's a cut-down
> version of the config I use, if it's any help. Note that my PAP
> section is commented out; from memory, yours had encryption_scheme
> set to clear.
Are you defining 'Auth-Type' in your sql database? If so, could you please
NetNITCO Systems Administration wrote:
> Does anybody use Freeradius, storing accounting and user/passwords in MySQL,
> and use PAP for authentication?
I use Postgresql on 0.5, but apart from that ... Here's a cut-down
version of the config I use, if it's any help. Note that my PAP
section is
> > rlm_sql: Pairs do not match [test1]
> > rlm_sql: Released sql socket id: 0
> >modcall[authorize]: module "sql" returns notfound
>
> I'm a bit rusty on this, but I don't think a lot of the SQL stuff, like
> setting the Auth-Type, is going to work until you fix this portion.
I agree. I wi
On 12 Sep 2002, bart wrote:
> Hi,
>
> Iv just upgraded our radiusd server to freeradius 7.1, Iv started uesing
> MySQL accounting, still authing from passwd file for now. The MySQL
> accounting worked first time and works great.
>
> So I'm not reinventing the wheel, dose any one have some (php?)
Hi,
Iv just upgraded our radiusd server to freeradius 7.1, Iv started uesing
MySQL accounting, still authing from passwd file for now. The MySQL
accounting worked first time and works great.
So I'm not reinventing the wheel, dose any one have some (php?) scripts
to work with the MySQL accounting
NetNITCO Systems Administration wrote:
>> Try setting the operator to ':='. Otherwise the sql module will try to do a
>> comparison and fail.
> Thanks for the info. I have changed that entry, but the problem that still
> remains is that is appears that radius is unable to determine the Auth-Typ
>
> Try setting the operator to ':='. Otherwise the sql module will try to do a
> comparison and fail.
>
Thanks for the info. I have changed that entry, but the problem that still
remains is that is appears that radius is unable to determine the Auth-Type
as PAP, which I have set in the radgro
1 - 100 of 139 matches
Mail list logo