Antonio Modesto wrote:
> It seems to be ok, the load average of the server:
>
> load averages: 0.00, 0.00, 0.00
>
>
> I even created some indexes on radippool table:
Well.. the default IP Pool indexes should be OK. And the default
constraints should be OK. It's not an index problem.
A
It seems to be ok, the load average of the server:
load averages: 0.00, 0.00, 0.00
I even created some indexes on radippool table:
+---++--+--+--+---+-+--++--++-+
| Ta
Antonio Modesto wrote:
> I noticed that there
> where 98 clients connected on a specific NAS, but there was only 80
> entries for that NAS on radippool table, thus there was a possibility of
> when a new client was establishing a connection, it would get an IP that
> was in use but was not in the t
Antonio Modesto wrote:
> I use radius sqlippool to assign IP address to my users, yesterday,
> after a restart on radius service, it started to assign IP address that
> were already in use to the users.
Then the SQL IP Pool was erased somehow.
Restarting FreeRADIUS won't change the SQL databa
2012/10/23 Phil Mayers
> On 23/10/12 11:52, Antonio Modesto wrote:
>
>> Hi,
>>
>> I use radius sqlippool to assign IP address to my users, yesterday,
>> after a restart on radius service, it started to assign IP address that
>> were already in use to the users. I'm almost crazy here, I don't know
On 23/10/12 11:52, Antonio Modesto wrote:
Hi,
I use radius sqlippool to assign IP address to my users, yesterday,
after a restart on radius service, it started to assign IP address that
were already in use to the users. I'm almost crazy here, I don't know
what can be causing this, we have been u
2011/12/20 Коньков Евгений :
> Hi, FreeRadius.
>
> while frame IP address to user there are three stage in sqlippool
>
> clear
> find
> update
>
> clear stage - clear info about expired framed IP (JUST CLEAR!)
> so *new* connected user have a chance get IP address of *current* online user
> whose
Sorry for all =)
I had error in dictionary and
some attributes was overriden by MPD-...
i.e. NAS-IP-Address
After adding
BEGIN-VENDOR
...
END-VENDOR
in old dictionary file, all is OK
Best regards
Max Mazur.
On Wed, 10 Feb 2010, sirmax wrote:
Hi
I use rlm_sqlippool with postgress and see s
> I have problems with ip pool. I use sqlippool on my
> configuration (postgresqlippool.conf included to radiusd.conf and
> sqlippool
> added to my default configuration file which in enabled-site directory)
>
>
> But i receive errors that server cannot define ip for client or
> [sqlippool] No Pool
Hi Ivan Kalik,
Sorry, How to debug ?
Best regards,
Tseveen.
Ivan Kalik wrote:
I'm trying to use rlm_sqlippool with mysql. User can get IP address from
pool with Pool-Name attribute but all users get same IP address.
How to solve this ?
Debug?
Ivan Kalik
Kalik Informatika ISP
-
List i
> I'm trying to use rlm_sqlippool with mysql. User can get IP address from
> pool with Pool-Name attribute but all users get same IP address.
>
> How to solve this ?
Debug?
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Neville wrote:
It's not as simple as your making it. Also, I am using %{NAS-Port} and
not %{Calling-Station-Id} due to the Lack of Calling-Station-Id.
Why didn't you say that in the first message? Giving out *part* of
the information is annoying.
I Understand, but I was trying to make the
Neville wrote:
> It's not as simple as your making it. Also, I am using %{NAS-Port} and
> not %{Calling-Station-Id} due to the Lack of Calling-Station-Id.
Why didn't you say that in the first message? Giving out *part* of
the information is annoying.
> pool-key = "%{NAS-Port}"
> # pool-key =
Neville wrote:
I've facing a problem since rebuild, where every user is being allocated
the same IP from the sqlippool, and I'm not sure why this is happening.
...
pppd does not pass back Client-IP-Address or Client-Station-Id
"Calling-Station-Id".
table structure for radipool is
Yes.
Neville wrote:
> I've facing a problem since rebuild, where every user is being allocated
> the same IP from the sqlippool, and I'm not sure why this is happening.
...
> pppd does not pass back Client-IP-Address or Client-Station-Id
"Calling-Station-Id".
> table structure for radipool is
Yes
Sebastian Krieger wrote:
> I want to get freeradius running with the sqlippool module and mysql
> backend on Ubuntu 8.04 LTS Server.
> Everything works so far, but it seems still impossible to enable the
> sqlippool on Debian based systems.
This should be fixed in 2.1.4 when it's released. Or,
Have your ranges[network/prefix] created in a separate table and use a
"stored procedure"(i've used in MySQL) to populate your radippool
table with corresponding ip addresses.
HTH
On Thu, Nov 6, 2008 at 10:58 AM, Ovi C <[EMAIL PROTECTED]> wrote:
> Hi, I'm using Debian Lenny with freeradius vers
>Hi, I'm using Debian Lenny with freeradius version 2.0.4 and postgresql
>database backend.
>I want to dynamically alocate a range of ip's from a pool i've created but it
>doesn't work. It only works if I add single ip's not ranges.
>
Yes, that's how it's supposed to work.
Ivan Kalik
Kalik Inf
Alexandre Chapellon wrote:
> I have manually relinked rlmsqlippool to rlm_sql and now the sqlippool
> module does not crash anymore.
> Is it a bug or something specific to debian as I I built FR using
> dpkg-builpackages?
It looks like one more fix that has to go into the sql/sqlippool
modules.
I have manually relinked rlmsqlippool to rlm_sql and now the sqlippool
module does not crash anymore.
Is it a bug or something specific to debian as I I built FR using
dpkg-builpackages?
This worries me a lots because i realised i had a lot of ld warnings at
compil time, complaiig about symbol that
ht-
>Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Ivan Kalik
>Verzonden: donderdag 3 juli 2008 18:33
>Aan: FreeRadius users mailing list
>Onderwerp: Re: sqlippool
>
>Yes. You will need to use database management to replicate them and keep
>them in sync.
>
>Iva
PROTECTED] Namens Ivan Kalik
Verzonden: donderdag 3 juli 2008 18:33
Aan: FreeRadius users mailing list
Onderwerp: Re: sqlippool
Yes. You will need to use database management to replicate them and keep
them in sync.
Ivan Kalik
Kalik Informatika ISP
Dana 3/7/2008, "Laar, Johan van de&quo
Yes. You will need to use database management to replicate them and keep
them in sync.
Ivan Kalik
Kalik Informatika ISP
Dana 3/7/2008, "Laar, Johan van de" <[EMAIL PROTECTED]> piše:
>Is it possible to use two sql instances (sql-instance-name) for the same IP
>pool? (with version 2.0.5)
>To ach
On Sun 22 Jun 2008, Deep Purple wrote:
> Hello
> Please Help me
> sqlippool error
> select FramedIPAddress,NASIPAddress,CallingStationID,username from
> radippool; FramedIPAddress| NASIPAddress | CallingStationID | username
> 172.16.2.1 | 127.0.0.1 | 121.111.111.123 | user1
> 172.
Deep Purple wrote:
> freeradius-1.1.7.tar.gz
> pptpd-1.3.3-1.fc5
> mysql 5.0.27 sqlippool
> user1 online ==> 172.16.1.30
> next user connect user2 ==> 172.16.1.30 ( duplicate IPs )
The SQL IPPool module functions better in 2.0.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://ww
This is with reference to the email with subject "SQLippool problems
(duplicate IPs handed out)" posted by Dave on Jan 14 2008.
According to him when the number of connections are increased(30+), it
was unavoidable that duplicate IPs being handed out.
I would like to know the MySQL storage used.
rsg wrote:
Hi,
Can you provide me with some more info to proceed with this?
There's no need to email me directly; I read the list.
I'm not quite sure of how to do it with "allocate-find".
Neither am I. It was a general suggestion.
Personally I wouldn't do it that way; I'd just insert the
Hi,
Can you provide me with some more info to proceed with this?
I'm not quite sure of how to do it with "allocate-find".
How could I define IP Prefixes and have my DB tables filled only with
network prefixes?
Many thanks for your help.
rg
On Mon, Mar 31, 2008 at 12:42 PM, rsg <[EMAIL PROTEC
Thanks a lot for the reply and valuable suggestions Phil.
Sorry for the mistyped IP prefix: 10.0.0.0/16 would make sense I
guess. Could you think of the trouble if we are to have tables with
different subnets allocated to different networks.
Regards,
rg
On Mon, Mar 31, 2008 at 12:31 PM, Phil Ma
rsg wrote:
Hi,
SQLIPPOOL requires, maintenance of an IP address table carrying individual IPs
Is there a way to handle IP prefixes (prefix/range format) so that in
large networks having many different networks could main and utilze
this effectively.
Sure; write an "allocate-find" SQL query th
Dave wrote:
> I use the sql IP pool setup with mysql, and been using it fine for a
> while, but I have a problem where if I have an influx of connections at
> one time (30++) That freeradius will hand out an IP to my NAS, but it
> doesnt get written to the database fast enuff and another thread of
Peter Nixon wrote:
I downloaded and installed ver 2.0.0 and have been fighting with it for
hours. I was going to move to the rlm_ippool module to fix this, but
using this module or the sqlippool module regardless of what is set in
radgroupreply or radreply I always get the error
rlm_ippool: Could
Dave
This is quite possible, as I dont think the MySQL queries currently do the
correct locking. If you can fix the problem, please send us a patch.
-Peter
On Mon 14 Jan 2008, Dave wrote:
> I use the sql IP pool setup with mysql, and been using it fine for a
> while, but I have a problem where
it's ok when delegate is commented
On Dec 13, 2007 7:34 PM, <[EMAIL PROTECTED]> wrote:
> That's nothing to do with freeradius. Debug PPP and see what's missing.
> Netmask?
>
> Ivan Kalik
> Kalik Informatika ISP
>
>
> Dana 13/12/2007, "hadi golestani" <[EMAIL PROTECTED]> piše:
>
> >in windows xp
That's nothing to do with freeradius. Debug PPP and see what's missing.
Netmask?
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, "hadi golestani" <[EMAIL PROTECTED]> piše:
>in windows xp after verifying username and password.
>
>On Dec 13, 2007 3:02 PM, <[EMAIL PROTECTED]> wrote:
>
>> >with t
in windows xp after verifying username and password.
On Dec 13, 2007 3:02 PM, <[EMAIL PROTECTED]> wrote:
> >with this attribute connection fails in registeration section with this
> >error: connection closed by remote host
> >
>
> Registration section???
>
> Ivan Kalik
> Kalik Informatika ISP
>
>
>with this attribute connection fails in registeration section with this
>error: connection closed by remote host
>
Registration section???
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
with this attribute connection fails in registeration section with this
error: connection closed by remote host
On Dec 13, 2007 2:28 PM, <[EMAIL PROTECTED]> wrote:
> Framed-IP-Address with :=
>
> Ivan Kalik
> Kalik Informatika ISP
>
>
> Dana 13/12/2007, "hadi golestani" <[EMAIL PROTECTED]> piše:
Framed-IP-Address with :=
Ivan Kalik
Kalik Informatika ISP
Dana 13/12/2007, "hadi golestani" <[EMAIL PROTECTED]> piše:
>thanks, it's ok now.
>
>How about assigning a static ip to username without ip-pool.
>
>On Dec 13, 2007 1:54 PM, <[EMAIL PROTECTED]> wrote:
>
>> >
>> >what's wrong in my confi
thanks, it's ok now.
How about assigning a static ip to username without ip-pool.
On Dec 13, 2007 1:54 PM, <[EMAIL PROTECTED]> wrote:
> >
> >what's wrong in my configurations?
> >
>
> Not much.
>
> >rlm_sqlippool: Framed-IP-Address already exists
> > modcall[post-auth]: module "sqlippool" retur
>
>what's wrong in my configurations?
>
Not much.
>rlm_sqlippool: Framed-IP-Address already exists
> modcall[post-auth]: module "sqlippool" returns noop for request 8
You have Framed-IP-Address already set, probably by the Service-Type
entry in users file. ippool in radiusd.conf has an option t
Francesco Cristofori wrote:
> I know that Alan said it's not a FR issue
> (http://lists.cistron.nl/pipermail/freeradius-users/2006-October/057588.
> html), but many people says that turning on RTLD_GLOBAL is a security
> weakness, so perhaps it's overall good to fix the code to make it work
> even
default vacuum cost limit for
> # autovacuum, -1 means use
> # vacuum_cost_limit
>
> -Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> s.org] On Behalf Of Pet
t delay for
> > # autovacuum, -1 means use
> > # vacuum_cost_delay
> > #autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
> > #
; # autovacuum, -1 means use
> # vacuum_cost_limit
>
> -----Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> s.org] On Behalf Of Peter Nixon
> Sent: Thursday, July
On Thu 26 Jul 2007, Alan DeKok wrote:
> Roy Walker wrote:
> > Ok chaning the indexes definately made some difference. The database
> > load still went off the charts, but the radius logs were much better
> > with DB errors connect errors. This still seems horribly slow.
>
> The problem is that
26, 2007 9:53 AM
To: FreeRadius users mailing list
Subject: Re: SQLIPPool performance issue
On Thu 26 Jul 2007, Kenneth Marshall wrote:
> Roy,
>
> It sounds like you may need to adjust the DB parameters. The defaults,
> even in 8.2, are still fairly conservative. Would you post your
cu
Roy Walker wrote:
> Ok chaning the indexes definately made some difference. The database load
> still went off the charts, but the radius logs were much better with DB
> errors connect errors. This still seems horribly slow.
The problem is that RADIUS servers take less time to do things than
On Thu 26 Jul 2007, Kenneth Marshall wrote:
> Roy,
>
> It sounds like you may need to adjust the DB parameters. The defaults,
> even in 8.2, are still fairly conservative. Would you post your current
> settings for things like:
>
> max_connections
> shared_buffers
> work_mem
> maintenance_work_mem
changes you have, I would be most
> appreciative.
>
> Roy
>
>
>
>
> From: [EMAIL PROTECTED] on behalf of Peter Nixon
> Sent: Wed 7/25/2007 6:30 PM
> To: FreeRadius users mailing list
> Subject: Re: SQLIPPool performance issue
>
>
>
> Hi Roy
>
behalf of Peter Nixon Sent: Wed 7/25/2007 6:30 PM
> To: FreeRadius users mailing list
> Subject: Re: SQLIPPool performance issue
>
>
>
> Hi Roy
>
> The default indexes are:
>
> CREATE INDEX radippool_poolname_ipaadr ON radippool USING btree
> (pool_name
list
Subject: Re: SQLIPPool performance issue
Hi Roy
The default indexes are:
CREATE INDEX radippool_poolname_ipaadr ON radippool USING btree (pool_name,
framedipaddress);
CREATE INDEX radippool_poolname_expire ON radippool USING btree (pool_name,
expiry_time);
CREATE INDEX
Original Message-
> From:
> [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> s.org] On Behalf Of Peter Nixon
> Sent: Wednesday, July 25, 2007 5:21 PM
> To: FreeRadius users mailing list
> Subject: Re: SQLIPPool performance issue
>
> On Wed 25 Jul 2007, Roy Walker wrote:
25, 2007 1:30 PM
To: FreeRadius users mailing list
Subject: Re: SQLIPPool performance issue
Mr. Walker,
It sounds as if you need to tune your postgresql installation.
By the way, postgresql 8.2.4 will out perform 8.1.9. You should
probably turn on query logging and see what the queries are and
if
list
Subject: Re: SQLIPPool performance issue
On Wed 25 Jul 2007, Roy Walker wrote:
> I am having a problem with the SQLIPPOOL performance. This is
migration
> of an existing radius server using flat user files (old server is
> running radius 1.1.0).
Hi Roy
You don't specify wh
On Wed 25 Jul 2007, Roy Walker wrote:
> I am having a problem with the SQLIPPOOL performance. This is migration
> of an existing radius server using flat user files (old server is
> running radius 1.1.0).
Hi Roy
You don't specify which version of FreeRADIUS you are using.. Which is it?
What doe
Mr. Walker,
It sounds as if you need to tune your postgresql installation.
By the way, postgresql 8.2.4 will out perform 8.1.9. You should
probably turn on query logging and see what the queries are and
if they can be optimized. Maybe you are missing an index or two,
although you may just have too
Peter Nixon <[EMAIL PROTECTED]> said:
> On Thu 28 Jun 2007, Hugh Messenger wrote:
> > Peter Nixon <[EMAIL PROTECTED]> said:
> > > On Thu 28 Jun 2007, Alan DeKok wrote:
> > > > Hugh Messenger wrote:
> > > > > With my current configuration, if sqlippool cannot assign an IP,
> the
> > > > > authentica
On Thu 28 Jun 2007, Peter Nixon wrote:
> > Speaking of which. What would be the simplest way of having an email
> > alert if a 'notfound' happens? This is all for PPPOE wireless clients,
> > which are carefully provisioned. So we should never end up running out
> > of dynamic pool space, and I n
On Thu 28 Jun 2007, Hugh Messenger wrote:
> Peter Nixon <[EMAIL PROTECTED]> said:
> > On Thu 28 Jun 2007, Alan DeKok wrote:
> > > Hugh Messenger wrote:
> > > > With my current configuration, if sqlippool cannot assign an IP, the
> > > > authentication still succeeds.
> > >
> > > The module return
Peter Nixon <[EMAIL PROTECTED]> said:
> On Thu 28 Jun 2007, Alan DeKok wrote:
> > Hugh Messenger wrote:
> > > With my current configuration, if sqlippool cannot assign an IP, the
> > > authentication still succeeds.
> >
> > The module returns NOOP. It could arguable return "fail".
Just a nitpic
On Thu 28 Jun 2007, Alan DeKok wrote:
> Hugh Messenger wrote:
> > With my current configuration, if sqlippool cannot assign an IP, the
> > authentication still succeeds.
>
> The module returns NOOP. It could arguable return "fail".
>
> > How can I set things up so if no IP is available, the auth
Hugh Messenger wrote:
> With my current configuration, if sqlippool cannot assign an IP, the
> authentication still succeeds.
The module returns NOOP. It could arguable return "fail".
> How can I set things up so if no IP is available, the authentication
> will fail with some informative Reply
Thanks Peter, that will do.
But I came into another problem, regarding this.
I've created entries in radreply such as "[EMAIL PROTECTED]
Framed-IP-Address = 1.1.1.2".
When the user authenticates, freeradius finds the data from radreply,
but sqlippool still assigns a random IP.
What can it be,
On Fri 27 Oct 2006 01:50, Guilherme Franco wrote:
> Hi,
>
> This is very important, please.
>
> In ippool module I can use two or more pools just by setting
>
> ippool POOL1{...}
> ippool POOL2{...}
>
> In SQLIPPOOL, I know that I can create as many pools as I wan't but I
> need to treat that pools
Hi Peter,
Regarding this post, the problem with Oracle and sqlippool still exists.
I've altered the postgresql inet to varchar and it works. But in
oracle, with varchar it does not works (the query return exactly the
same result in oracle's sqlplus as in postgresql, but freeradius keeps
saying "
Hi Jan and Roberto
We ARE doing serious work on sqlippool but it is all with Postgresql. As Jan
says someone with a little MySQL knowledge shoudn't have problems making
those queries work with MySQL. Once you have them working please send them to
my so I can include them in cvs.
Cheers
Peter
Someone needs to do some serious work on sqlippool. I'd do so, but
currently I have no need for SQL-assigned IPs, as I only have one
RADIUS server - and if it fails over, the least thing I have to worry
about is current IP assignments.
I recommend finding someone who is adept at *SQL and buy them
On Thu 21 Sep 2006 03:03, Guilherme Franco wrote:
> Thanks,
>
> I used that broken config because it was stated in freeradius user
> list as "Sucsessfully installed rlm_sqlippool" from Alfred H. Dahl in
> Tue, 8 Feb 2005 20:58:34 +0100.
At that time rlm_sqlippool did not exist as part of FreeRADIU
Thanks,
I used that broken config because it was stated in freeradius user
list as "Sucsessfully installed rlm_sqlippool" from Alfred H. Dahl in
Tue, 8 Feb 2005 20:58:34 +0100.
I did read the docs.
I only didn't know how could I specify 192.168.1.1/28, if I do not
have inet, but that's ok.
Tha
On Wed 20 Sep 2006 23:32, Guilherme Franco wrote:
> Thanks, that's ok now.
>
> I removed the block as you said and now it shows the queries. I had
> added those block earlier because I've seen this configuration from
> another post as a working sqlippool configuration...
OK. Well, if you had just
Thanks, that's ok now.
I removed the block as you said and now it shows the queries. I had
added those block earlier because I've seen this configuration from
another post as a working sqlippool configuration...
Now, if netmask does not exist, nor range-start - range-stop, how can
I specify that
Hello,
Unfortunately, even with freeradius-snapshot-20060920.tar.gz and
using the ./configure --with-modules="rlm_sqlippool" option, the
module did not install.
I needed again, to compile it manually from
freeradius-snapshot-20060920/src/modules/rlm_sqlippool/
And then, the same problem persis
On Wed 20 Sep 2006 05:49, Guilherme Franco wrote:
> I need to thank you again and congratulate you guys for such a great
> support.
You're welcome. Thanks for helping us make FreeRADIUS better :-)
> Question: Even with freeradius-snapshot-20060920.tar.gz I will need to
> use ./configure --with-mo
I need to thank you again and congratulate you guys for such a great support.
Question: Even with freeradius-snapshot-20060920.tar.gz I will need to
use ./configure --with-modules="rlm_sqlippool"?
If all works well, I assume that in radcheck table, the users need to
have "Pool-Name := test_pool"
Yes, that's true.
Unfortunately, the IT area developed a software that creates users in
a GUI and then those users goes to Oracle. The application would also
create and manage ip-pools. (just like a Dialup-up admin).
Because of that, I desperately need sqlippool in oracle. Can't be done
in the B
If you can (ie. If you control the NAS equipment) then I recommend you create
your dynamic pools there and only assign static ips from radius as a NAS will
ALWAYs be better at knowing who is connected to it than RADIUS will.
In the case where you do not control the NAS equipment, then radius bas
Thank you.
That's the problem, I have 2 RADIUS servers working concurrently. If I
set one ippool in server1, server2 needs another ippool with another
range, and that's a grand problem.
This is why I need sqlippool.
I'm going to test freeradius-snapshot-20060920.tar.gz and see if it works.
Is
Hi Guilherme
A couple of things.
I just updated the cvs so freeradius-snapshot-20060919.tar.gz is not current
enough. You need to get freeradius-snapshot-20060920.tar.gz once it is rolled
latter tonight, or get the latest code from the repository using "cvs"
Secondly, Tuyan works together with
Gentlemen,
Thank you very much for lending me your time.
I'm downloading freeradius-snapshot-20060919.tar.gz right now.
Yes, my allocate-clear is configured exactly as Tuyan's and that's why
I stated before that "regardless of my configuration in sqlippool.conf
and radiusd.conf" the trace is al
It turns out that sqlippool.conf was in the Makefile for 1.1.x but not for CVS
head. It didnt affect us because we use an rpm.
Guilherme can you please test a new cvs checkout?
Also, because sqlippool is still experimental you need to explicitly enable it
with
./configure --with-modules="rlm_s
81 matches
Mail list logo
