Will do guys , thanks again for the assistance and advice with this.
-Original Message-
From: John Dennis
Sent: Friday, June 29, 2012 8:24 PM
To: FreeRadius users mailing list
Cc: dj...@iol.ie ; Alan DeKok
Subject: Re: FreeRADIUS SQl Ippool problem -
On 06/29/2012 02:54 PM, Alan DeKok
On 06/29/2012 02:54 PM, Alan DeKok wrote:
Taz Manian wrote:
but one silly
mistake caused me to try so many different things that i got myself
mixed up with it all.
THAT is really the problem. Trying "many different things" is always
a disaster. Follow the instructions *exactly*. Step by
Taz Manian wrote:
> but one silly
> mistake caused me to try so many different things that i got myself
> mixed up with it all.
THAT is really the problem. Trying "many different things" is always
a disaster. Follow the instructions *exactly*. Step by step.
Trying "many things" means you d
> Did you put a call to sqlippool instance inside post-auth, like the
> wiki tells you to?
>
> --
> Fajar That was the problem - i had it in there but had commented it out at
> some stage because or an error that popped up and forgot to enable it
> again.Thanks for the help on this and i do ap
On Fri, Jun 29, 2012 at 9:19 PM, Taz Manian wrote:
> [sql] expand: SELECT id, groupname, attribute, Value,
> op FROM radgroupcheck WHERE groupname =
> '%{Sql-Group}' ORDER BY id -> SELECT id, groupname,
> attribute, Value, op FROM radgr
'username@realm', '1234567',
'Access-Accept', '2012-06-29 15:13:08')
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql (sql): Released sql socket id: 0
++[sql] returns ok
++[exec] returns noop
Sending A
On Fri, Jun 29, 2012 at 8:46 PM, Taz Manian wrote:
> But the username isnt the problem, that authenticates properly and if i put
> in
You should fix that. There might be a compatibility code that allows
it to work today, but the next versions might not have it.
> I get no info back for the pools
12 07:46:36
-0400
> From: al...@deployingradius.com
> To: dj...@iol.ie; freeradius-users@lists.freeradius.org
> Subject: Re: FreeRADIUS SQl Ippool problem -
>
> Taz Manian wrote:
> > Can you guys confirm that this is the correct format for the SQl side of
> > things please
Taz Manian wrote:
> Can you guys confirm that this is the correct format for the SQl side of
> things please ?
>
> Im still having problems and just want to confirm that this is correct.
It's not.
> mysql> select * from radcheck;
> +++++--
OL_NAME Framed-MTU :=1500
2 EZ_POOL_NAME Service-Type :=Framed-User
3 EZ_POOL_NAME Framed-Protocol :=PPP
If theres anything im missing it would help Thanks
> Date: Thu, 28 Jun 2012 20:38:52 +0700
> Subject: Re: FreeRADIUS SQl Ippool problem -
> From: l...@faja
On Thu, Jun 28, 2012 at 8:22 PM, Taz Manian wrote:
> I did check the wiki , i have been on it for the last 3 days trying to
> figure this out
>
> I did a search for Pool-Name and i got 4 different results as below
>
> http://wiki.freeradius.org/search?q=Pool-Name
>
> http://wiki.freeradius.org/Rlm
Taz Manian wrote:
> I checked each one of them and not one said anything about radcheck or
> radreply.
Because they give examples for the "users" file. They don't give
examples for SQL, LDAP, external programs, Perl, Python, etc.
The "users" file example has the Pool-Name on the first line.
-Name and it
doesnt work nor does it show when i try it with radiusd -X. I appreciate your
input , im really stuck on this one. Im also not sure how to use rlm_sqlipool ?
Taz
> Date: Thu, 28 Jun 2012 19:08:25 +0700
> Subject: Re: FreeRADIUS SQl Ippool problem -
> From: l...@fajar.net
On Thu, Jun 28, 2012 at 7:26 PM, Michell wrote:
> Hello,
>
> to some time ago informed me that the ippool not work properly with mysql.
It works just fine
> As it is now?
> I'm not sure what the problems were occurring, but informed me that it
> worked better and smoothly only in postgres.
IIRC
Michell wrote:
> to some time ago informed me that the ippool not work properly with
> mysql. As it is now?
"someone somewhere said something". That's not helpful.
Read the documentation and examples distributed with FreeRADIUS. They
give you the CORRECT answers.
In this case, raddb/sql/
Hello,
to some time ago informed me that the ippool not work properly with mysql.
As it is now?
I'm not sure what the problems were occurring, but informed me that it
worked better and smoothly only in postgres.
They try to succeed in this scenario freeradius / mysql?
Thanks for listening,
Mich
On Thu, Jun 28, 2012 at 7:08 PM, Fajar A. Nugraha wrote:
> On Thu, Jun 28, 2012 at 7:03 PM, Taz Manian wrote:
>> so i know is readying that - i then have a pool set up in radippool
>
> Also, IMHO you should just use rlm_sqlipool. It's easier to setup and debug.
Sorry, I somehow read "radippool"
On Thu, Jun 28, 2012 at 7:03 PM, Taz Manian wrote:
> Hi Guys,
>
>
>
> Im having a problem with Ippools with freeradius2 and i cant seem to get any
> username to get an address from the pool.
>
> 90% of the usernames will have static IP's but i want a few to be in a pool
> but i really am stumped -
Hi Guys, Im having a problem with Ippools with freeradius2 and i cant seem to
get any username to get an address from the pool.90% of the usernames will have
static IP's but i want a few to be in a pool but i really am stumped - i tried
putting username@realm
Framed-Pool
:=
EZPOOL into the
Hi Alan,
its work
great thx
Chris
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/Freeradius-SQL-PEAP-Tunneled-authentication-was-rejected-tp3360430p3362708.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See
On 28/01/11 12:43, Johan Meiring wrote:
Hi,
Does anyone know what "nabble.com" is and why the mail looks like this?
It's some kind of tedious "post to mailing list via a web UI" nonsense.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
at the top of the file. " I
will try and give an answer thx Chris
--------
View this message in context: Re: Freeradius SQL: PEAP: Tunneled
authentication was rejected.
<http://freeradius.1045715.n5.nabble.com/Freeradius-SQL-PEAP-Tunneled-authentication-was-rejected-tp3360430
probably need to list "sql" in the "inner-tunnel" virtual server.
In 2.1.10, you can test the inner-tunnel directly, without using PEAP.
See the comments at the top of the file. "
I will try and give an answer
thx
Chris
--
View this message in context:
http://f
probably need to list "sql" in the "inner-tunnel" virtual server.
In 2.1.10, you can test the inner-tunnel directly, without using PEAP.
See the comments at the top of the file. "
I will try and give an answer
thx
Chris
--
View this message in context:
http://f
chris wrote:
> i prepare freeradius with eap/peap and the users file that works fine.
>
> Now i setup a sql database,
> i can use radtest or radeapclient to check the user and password in the
> database and it works fine,
> but if i try to connect to freeradius the request will be rejected and i
lm_eap_peap: Received EAP-TLV response.
rlm_eap_peap: Had sent TLV failure. User was rejected earlier in this
session.
rlm_eap: Handler failed in EAP/peap
rlm_eap: Failed in EAP select
++[eap] returns invalid
auth: Failed to validate the user.
Login incorrect: [sqluser/] (from client
dl
exactly, Microsoft Sql Server. But I'll read the doc.
Thanks Phil
2011/1/18 Phil Mayers
> On 18/01/11 15:26, Maiquel Consalter wrote:
>
>> Thanks Phil,
>> i found this, http://it.reinhardt.edu/dave/radius-mssql-howto.html
>>
>
> Do you specifically mean Microsoft SQL server?
>
> Take a look at:
On 18/01/11 15:26, Maiquel Consalter wrote:
Thanks Phil,
i found this, http://it.reinhardt.edu/dave/radius-mssql-howto.html
Do you specifically mean Microsoft SQL server?
Take a look at:
raddb/sql/mssql.conf
...in newer versions of the server source code.
The instructions you reference *may
Thanks Phil,
i found this, http://it.reinhardt.edu/dave/radius-mssql-howto.html
<http://it.reinhardt.edu/dave/radius-mssql-howto.html>thanks :-)
2011/1/18 Phil Mayers
> On 18/01/11 15:19, Maiquel Consalter wrote:
>
>> Hello I wonder if I have to implement freeradius + sql ser
On 18/01/11 15:19, Maiquel Consalter wrote:
Hello I wonder if I have to implement freeradius + sql server. I tried
to find on google but not found.
There is a lot of documentation on this.
Have you looked at:
doc/rlm_sql
raddb/sql.conf
raddbl/sql/*
...and:
http://wiki.freeradius.org
Hello I wonder if I have to implement freeradius + sql server. I tried to
find on google but not found.
Could someone help me.?
Thanks.
--
Att,
Maiquel
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 08/05/2010 12:48 PM, ziko wrote:
Hello.
I have freeradius 2.1.9 on Fedora 13.
I also have mysql-server installed and freeradius-mysql package.
I created database with Daloradius sql script and everything works, but
when i uncomment "sql" in /raddb/sites-enabled/default file, freeradius
gives e
Hello.
I have freeradius 2.1.9 on Fedora 13.
I also have mysql-server installed and freeradius-mysql package.
I created database with Daloradius sql script and everything works, but when i
uncomment "sql" in /raddb/sites-enabled/default file, freeradius gives error,
failed to load sql modules.
Am 18.02.2009 um 16:39 schrieb Marcelo Freitas:
Hello,
I'm trying to authenticate users using CHAP and store the passwords
in the SQL, but I'm having a hard time.
I checked past messages, but I still couldn't get it to work ...
Below is my Access-Request packet
Wed Feb 18 12:31:04 2009
Hello,
I'm trying to authenticate users using CHAP and store the passwords in the SQL,
but I'm having a hard time.
I checked past messages, but I still couldn't get it to work ... Below is my
Access-Request packet
Wed Feb 18 12:31:04 2009
Packet-Type = Access-Request
NAS-Port-T
>Hi, I've got some problem when I try to Authorize with SQL and a windows
>client to Wireless connection.
>
No, you don't.
>
>When I make a test with the command
>Radtest guillaume passtest localhost 1645 testing123
>I've have this result
..
>Sending Access-Accept of id 204 to 127.0.0.1 port 344
Hi, I've got some problem when I try to Authorize with SQL and a windows client
to Wireless connection.
I configure my windowx xp wireless connection to works with PEAP.
My freeradius version is 2.0.0 running on RHEL4 AS
When I make a test with the command
Radtest guillaume passtest localhost 1
A.Dupont wrote:
> hi,
> I want to ask you for a service, can you please send me an example for
> radiusd.conf and rlm_sql.c and sql.c files for only accounting use of
> freeradius without any authentication or authorization.
> I have very high loads and just 5% of the accounting wich is registred
er 2008, 11h32mn 51s
Objet : Re: freeradius & sql server with high loads
hi,
your database is too slow to handle all the accounting in real time.
hence the error messages. hence the lack of accounting
either speed the DB up - and/or add more handles - or move to putting
the details in in
Hello,
I'm using freeradius 1.1.7 with sql server 2005, the problem is that I don't
find all accounting in database, freeradius doesn't send ack for all accounting
tickets (it sends 300 for 4000 tickets from 10 NAS), can you tell me what is
the prob?
here is a part of my radiusd.conf:
max_req
hi,
your database is too slow to handle all the accounting in real time.
hence the error messages. hence the lack of accounting
either speed the DB up - and/or add more handles - or move to putting
the details in in 'after real time' - eg with SQL-Relay - putting
them into a file then using the
Hi A.,
I think the problem is that FR is trying to use more db connections than
the ones available.
You have to check MSSQL configuration and raise your incoming
connections limit.
Regards,
Francesco Cristofori.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.htm
well, SQL-Group in the users file works.
Thanks dennis.
--
Network Administrator / Manager
Webzone Internet
1st Floor (Oakley Street Entrance)
167 Grote Street
Adelaide SA, 5000
Phone 1300 303 932
Fax 08 8221 6204
Email [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
List info/subscribe/unsub
Dennis Skinner wrote:
> Andrew D wrote:
>
>> Basically, depending on the huntgroup I need to send different reply
>> attributes (different NAS types) and if the DB returns the group
>> suspend, different reply attributes are sent.
>
> I don't fully understand what you are trying to do and you s
Andrew D wrote:
> Basically, depending on the huntgroup I need to send different reply
> attributes (different NAS types) and if the DB returns the group
> suspend, different reply attributes are sent.
I don't fully understand what you are trying to do and you snipped a lot
of the debug log, bu
Alan DeKok wrote:
> Andrew D wrote:
>> 1. If the user is found in the sql tables and has reply attributes etc,
>> is it still possible to go through the 'users' file? if so how?
>> I can't seem to get it to do it.
>
> Yes, it's possible. The modules are completely independent, so you
> just c
Andrew D wrote:
> 1. If the user is found in the sql tables and has reply attributes etc,
> is it still possible to go through the 'users' file? if so how?
> I can't seem to get it to do it.
Yes, it's possible. The modules are completely independent, so you
just configure both. In fact, if y
Hi there,
We've got FreeRADIUS Version 1.1.4, for host i386-portbld-freebsd5.5
using unixodbc/freetds connecting to a mssql DB.
I've got a number of questions that I hope someone can answer.
1. If the user is found in the sql tables and has reply attributes etc,
is it still possible to go thro
hi,
I configure freeradius with Sql and ldap.
The base ldap contains the login and the password of 15000 users and any
other parameter.
And I will wish to aply parameters with these users (but not in the base
ldap, for example in the file users, or the base postgresql) The
base postgresql c
Hello,
I installed all of the MySQL elements on my system and created and
configured the database (its name is 'radius'). Here is the
structure:
[EMAIL PROTECTED]:/usr/local/etc/raddb # mysql -u hwc
-p radius
Enter password:
Reading table information for completion of table and column names
You c
I am using freeradius with postgresql 7.4. I was wondering how I
can use hints (I want Strip-User-Name = No).
Any help would be appreciated.
Thanks,
Fei Lung
$ chown flung universe
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
51 matches
Mail list logo