I've added two new fields into radippool table that i am using for DHCP
dynamic pools.
`gateway` varchar(15) NOT NULL DEFAULT '',
`netmask` varchar(15) NOT NULL DEFAULT '',
in ippool-dhcp.conf i've added new fields:
allocate-find = SELECT framedipaddress,gateway,netmask FROM
framedipaddress,gateway,netmask FROM
${ippool_table}
I am not able to figure out how to address new fields inside
policy.conf. Is it even possible?
I don't think so. The sqlippool module has large parts of the logic in C
code, including which columns it expects the query to return and what it
does
'',
in ippool-dhcp.conf i've added new fields:
allocate-find = SELECT framedipaddress,gateway,netmask FROM
${ippool_table}
I am not able to figure out how to address new fields inside
policy.conf. Is it even possible?
I don't think so. The sqlippool module has large parts of the logic
Ethan Hayon wrote:
Yes, MAC address is unique for each user. The MAC should be a unique
identifier when assigning IP's.
That's the goal.
Yes, the NAS is sending accounting data. This is what redacct looks like
(some columns omitted)
That seems OK.
Right now, I'm thinking there is a
Hi, I'm trying to set up FreeRADIUS 2.2 to act as an authentication and
accounting system as well as a DHCP server. (I'm relaying DHCP requests from a
pfSense box).
I am trying to use sqlippools on FreeRADIUS, but I have noticed that my ippools
are filling up quickly (I am only testing with
Ethan Hayon wrote:
Hi, I'm trying to set up FreeRADIUS 2.2 to act as an authentication and
accounting system as well as a DHCP server. (I'm relaying DHCP requests from
a pfSense box).
Are you doing DHCP *and* RADIUS?
I am trying to use sqlippools on FreeRADIUS, but I have noticed that my
Jan 10 23:53:34 2013 : Debug: rlm_sql (sql): Reserving sql socket id: 3
Thu Jan 10 23:53:34 2013 : Info: [sqlippool]expand: %{User-Name} -
b8:8d:12:10:8d:f6
Thu Jan 10 23:53:34 2013 : Info: [sqlippool] sql_set_user escaped user --
'b8:8d:12:10:8d:f6'
Thu Jan 10 23:53:34 2013 : Info: [sqlippool
Ethan Hayon wrote:
When I run the server in debug mode the Acct-Unique-Session-ID remains
the same across the interim accounting updates. However,
re-authentications don't seem to have a unique key associated with them.
That makes no sense. There is *nothing* unique to each user you can
On Jan 11, 2013, at 6:38 PM, Alan DeKok al...@deployingradius.com wrote:
Hi Alan, Thanks for the response
Ethan Hayon wrote:
When I run the server in debug mode the Acct-Unique-Session-ID remains
the same across the interim accounting updates. However,
re-authentications don't seem to have
On Nov 1, 2012, at 1:02 PM, bea...@gmail.com wrote:
If they are coming in as a Virtual connection, drop out of SQLIPPOOL and
just let freeradius auth the connection and then let OpenVPN use it's
predefined IP pool which we will in turn NAT?
This should be possible with a bit of unlang
.
Regards,
--
Jon The Nice Guy Spriggs
On 1 November 2012 20:28, Blake Covarrubias bl...@covarrubi.as wrote:
On Nov 1, 2012, at 1:02 PM, bea...@gmail.com wrote:
If they are coming in as a Virtual connection, drop out of SQLIPPOOL and
just let freeradius auth the connection and then let
You can either use an unlang wrapper around the sqlippoolto either skip it
or to call another sqlippool instanceor (and maybe better) define a
virtual-server instance for queries coming from openvpn and have a totally
different config for them (this keeps the server functionality
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 using this scheme for at least three months
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
2012/10/23 Phil Mayers p.may...@imperial.ac.uk
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
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 database
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
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:
+---++--+--+--+---+-+--++--++-+
|
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.
Alan
Hi,
I'm testing sqlippool, so far it's working well, but I'm with a exception
that I haven't thought about it before. We use radius to authenticate the
clients on wireless access points and with PPPoE, and now I started using
sqlippool to dynamically distribute the IP's and BGP to announce
On 21 Aug 2012, at 16:20, Antonio Modesto mode...@isimples.com.br wrote:
Hi,
I'm testing sqlippool, so far it's working well, but I'm with a exception
that I haven't thought about it before. We use radius to authenticate the
clients on wireless access points and with PPPoE, and now
On 21/08/12 16:20, Antonio Modesto wrote:
Hi,
I'm testing sqlippool, so far it's working well, but I'm with a
exception that I haven't thought about it before. We use radius to
authenticate the clients on wireless access points and with PPPoE, and
now I started using sqlippool to dynamically
2012/8/21 Phil Mayers p.may...@imperial.ac.uk
On 21/08/12 16:20, Antonio Modesto wrote:
Hi,
I'm testing sqlippool, so far it's working well, but I'm with a
exception that I haven't thought about it before. We use radius to
authenticate the clients on wireless access points
I've configured it this way:
if (Framed-Protocol == PPP) {
sqlippool
}
It's working so far, I'll do some more tests.
Thanks a lot.
2012/8/21 Antonio Modesto mode...@isimples.com.br
2012/8/21 Phil Mayers p.may...@imperial.ac.uk
On 21/08/12 16:20, Antonio
On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote:
Antonio Modesto wrote:
I am trying to test sqlippool on freeradius, but i've found that the
documentation explains very well how to implement it, but it doesn't
explain very well how I can set a user or a group to use this pool
On Wed, 2012-02-01 at 09:19 -0200, Antonio Modesto wrote:
On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote:
Antonio Modesto wrote:
I am trying to test sqlippool on freeradius, but i've found that the
documentation explains very well how to implement it, but it doesn't
was released long after that.w
, but the module rlm_sqlippool is
not working in this version of freeradius. Then if I decide to use
sqlippool, will I need to upgrade to freeradius 2.x and change this
Attribute in all my MySQL database?
It's better if you upgrade, *and* if you change the attribute
2012/2/1 Antonio Modesto mode...@isimples.com.br:
On Wed, 2012-02-01 at 09:19 -0200, Antonio Modesto wrote:
On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote:
Antonio Modesto wrote:
I am trying to test sqlippool on freeradius, but i've found that the
documentation explains very well
to Cleartext-Password was done in 1.1.4. The 1.1.8
version was released long after that.w
, but the module rlm_sqlippool is
not working in this version of freeradius. Then if I decide to use
sqlippool, will I need to upgrade to freeradius 2.x and change this
Attribute in all my MySQL database
Antonio Modesto wrote:
Sorry for the ignorance, but where must I put this section? Can I just
put it anywhere in radiusd.conf or it must be inside another section?
You don't. I had assumed you were running version 2.
Alan DeKok.
-
List info/subscribe/unsubscribe? See
On Wed, 2012-02-01 at 19:53 +0700, Fajar A. Nugraha wrote:
2012/2/1 Antonio Modesto mode...@isimples.com.br:
On Wed, 2012-02-01 at 09:19 -0200, Antonio Modesto wrote:
On Tue, 2012-01-31 at 21:00 +0100, Alan DeKok wrote:
Antonio Modesto wrote:
I am trying to test sqlippool
On Wed, 2012-02-01 at 14:24 +0100, Alan DeKok wrote:
Antonio Modesto wrote:
Sorry for the ignorance, but where must I put this section? Can I just
put it anywhere in radiusd.conf or it must be inside another section?
You don't. I had assumed you were running version 2.
Not in my
2012/2/1 Antonio Modesto mode...@isimples.com.br:
But I don't want to use per-user pools, if it is possible,
the better solution for me would be setting the pool based on some
information of the NAS, because my routing topology doesn't permit a single
pool for all cities that we attend.
It
with these things. So far I didn't get setting the pool_name to a
custom name, I am testing with the default sqlippool.
My production radius server is running freeradius 1.1.8, I installed
freeradius 2 in another server with another SQL database and copied the
configuration files from the production server
Antonio Modesto wrote:
My production radius server is running freeradius 1.1.8, I installed
freeradius 2 in another server with another SQL database and copied the
configuration files from the production server to the test server and
changed some stuff to get it running, then I am doing these
2012/2/2 Antonio Modesto mode...@isimples.com.br:
My production radius server is running freeradius 1.1.8, I installed
freeradius 2 in another server with another SQL database and copied the
configuration files from the production server to the test server and
changed some stuff to get it
Hi,
I am trying to test sqlippool on freeradius, but i've found that the
documentation explains very well how to implement it, but it doesn't
explain very well how I can set a user or a group to use this pool. Can
someone explain me how can I do this? i've set up a pool called
'main_pool
Antonio Modesto wrote:
I am trying to test sqlippool on freeradius, but i've found that the
documentation explains very well how to implement it, but it doesn't
explain very well how I can set a user or a group to use this pool.
Set:
update control {
Pool-Name
hi
Is anyone have a success story of optimizing ippool sql table to make it
work faster?
The default scheme is very slow, and then you have about 25000 subscribers
it's not work.
I trying to add indexes to this table. It make fast selects, but slow
updates.
[code]
CREATE TABLE `radippool` (
`id`
-wise using NDB or memory would be best, but it won't
be the best choice for common mysql setups. You MIGHT be able to gain
some improvements by using innodb (without changing anything else).
Maybe.
Then there's the problem with queries. The default sqlippool query
would basically lock the table
On 01/12/2012 11:59 AM, Fajar A. Nugraha wrote:
That's why having a dba is important. If you can't do it yourself,
hire one. Or learn to be one. Depending on your deployment scale, the
cost is justifiable. Seriously.
Agreed, this is the key. SQL optimisation is a specialist task, and if
you
performance-wise using NDB or memory would be best, but it won't
be the best choice for common mysql setups. You MIGHT be able to gain
some improvements by using innodb (without changing anything else).
Maybe.
Then there's the problem with queries. The default sqlippool query
would basically
On Thu, Jan 12, 2012 at 8:15 PM, Phil Mayers p.may...@imperial.ac.uk wrote:
So in short, for now:
- revert your changes
- try changing the engine to innodb
- if it's still too slow, hire a dba, and/or be prepared to implement
mysql cluster (or something like clustrix)
- use postgres
;o)
On Thu, Jan 12, 2012 at 8:30 PM, Alexander Kosykh avkos...@gmail.com wrote:
One more question.
Where can I take nas-type value to use it in user authorization? Radius take
it from mysql nasinfo table at startup. I take it from DB every time
subscriber try to authorize.
That's pretty much the
I have interim accounting value 10 minutes and IP lease time is 30 minutes.
2012/1/12 Phil Mayers p.may...@imperial.ac.uk
On 01/12/2012 11:59 AM, Fajar A. Nugraha wrote:
That's why having a dba is important. If you can't do it yourself,
hire one. Or learn to be one. Depending on your
On 01/12/2012 01:33 PM, Fajar A. Nugraha wrote:
I avoid postgres like plague in the past due to vacuum :)
It has autovacuum now, but the bad image remains. To be fair, it's
probably similar with the way many people avoid mysql due to
myisam-related issues :)
Funnily enough I avoid MySQL like
On 01/12/2012 01:40 PM, Alexander Kosykh wrote:
I have interim accounting value 10 minutes and IP lease time is 30 minutes.
So you should be getting, what, ~40 accounting packets/second with 25k
users online. Does this correspond to the query load you're seeing?
40 SQL updates/second is
AAA/second.
FAN For most practical purposes, the current sqlippool is good enough. Not
FAN perfect, but good enough.
--
С уважением,
Коньков mailto:kes-...@yandex.ru
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
2011/12/20 Коньков Евгений kes-...@yandex.ru:
I have Acct-Interim-Interval = 300
And I have script that ckeck zombie sessions once per 15min
Does it also remove the zombie sessions? If yes, set lease-duration =
900 on your sqlippool.conf.
NAS server and freeradius both are on localhost and
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 IP address is expired.
This will cause IP
2011/12/20 Коньков Евгений kes-...@yandex.ru:
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
Здравствуйте, Fajar.
Вы писали 20 декабря 2011 г., 8:30:36:
FAN 2011/12/20 Коньков Евгений kes-...@yandex.ru:
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
Здравствуйте, Коньков.
Вы писали 20 декабря 2011 г., 9:22:27:
КЕ Здравствуйте, Fajar.
КЕ Вы писали 20 декабря 2011 г., 8:30:36:
FAN 2011/12/20 Коньков Евгений kes-...@yandex.ru:
Hi, FreeRadius.
while frame IP address to user there are three stage in sqlippool
clear
find
update
clear
penalty. It might be acceptable if you only handle (for
example) 10 AAA/minute, but it won't be feasible if you need to handle
10 AAA/second.
For most practical purposes, the current sqlippool is good enough. Not
perfect, but good enough.
--
Fajar
-
List info/subscribe/unsubscribe? See http
connect
nas2 8 user connect
but sqlippool is
Username NASIPAddress CalledStationIdCallingStationID
expiry_timepool_key
user1
2011-09-19
20:00:00 0
user2
127.0.0.1 1xx.3xx
On 01/01/2011 08:56 PM, Marten Pape wrote:
But back to Topic:
Is it possible to call a module manually in another section? I'd like to
Yes, IIRC:
accounting {
ippool.post-auth
}
This might fail for other reasons (for example, the accounting request
might not contain required fields).
Alan DeKok schrieb:
Marten Pape wrote:
Ji Bryan, hi all,
Does anyone know such a dhcp server (couldn't figure out such a feature
in ISC dhcp server) or a script that transfers this? So I wouldn't have
to script this on my own.
The ISC DHCP server doesn't have this feature.
Alan DeKok schrieb:
Marten Pape wrote:
Ji Bryan, hi all,
Does anyone know such a dhcp server (couldn't figure out such a feature
in ISC dhcp server) or a script that transfers this? So I wouldn't have
to script this on my own.
The ISC DHCP server doesn't have this feature.
program needs to know, which IP should be assigned to the
Client. Therefore I need to set up an IP-Pool management - which IP is
in use, which one not? The modules ippool and espacially sqlippool are
very nice to use and configure. Is it possible to execute them manually?
I'd like to retrieve
Marten Pape wrote:
Ji Bryan, hi all,
Does anyone know such a dhcp server (couldn't figure out such a feature
in ISC dhcp server) or a script that transfers this? So I wouldn't have
to script this on my own.
The ISC DHCP server doesn't have this feature.
FreeRADIUS, however, can work as a
in the accounting-section of the default-server.
This external program needs to know, which IP should be assigned to the
Client. Therefore I need to set up an IP-Pool management - which IP is
in use, which one not? The modules ippool and espacially sqlippool are
very nice to use and configure
that is called in the accounting-section of the default-server.
This external program needs to know, which IP should be assigned to the
Client. Therefore I need to set up an IP-Pool management - which IP is
in use, which one not? The modules ippool and espacially sqlippool are
very nice to use
Hello I am new in this list I am setting up a freeradius server with mysql and
sqlippool but I am facing some problems with sqlippool which cannot deliver an
ip address to subscribers. I installed Freeradius 2.1.3 on OpenBSD 4.6 with
mysql support
here is the output of radiusd -X
sqlippool
Hello I am new in this list I am setting up a freeradius server with
mysql and sqlippool but I am facing some problems with sqlippool which
cannot deliver an ip address to subscribers. I installed Freeradius
2.1.3 on OpenBSD 4.6 with mysql support
here is the output of
radiusd -X
sqlippool
: query affected rows = 1
Wed Feb 10 11:31:33 2010 : Info: [sqlippool] Allocated IP 95.69.165.245
[f5a5455f]
Wed Feb 10 11:31:33 2010 : Info: [sqlippool]expand: COMMIT - COMMIT
Wed Feb 10 11:31:33 2010 : Debug: rlm_sql_postgresql: Status: PGRES_COMMAND_OK
Wed Feb 10 11:31:33 2010 : Debug
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
Chekushin
Sent: Thursday, January 14, 2010 7:38 AM
To: freeradius-users@lists.freeradius.org
Subject: freeradius + sqlippool
Good afternoon!
I have a question. It is necessary to assign ip-address by
RADUIS-server to gprs user. My decision is to use freeradius+sqlippool
for this purpose
Good afternoon!
I have a question. It is necessary to assign ip-address by
RADUIS-server to gprs user. My decision is to use freeradius+sqlippool
for this purpose . But there is one problem. ippool name is initially
unknown. It should be taken depending on a phone number. I.e. there is
one more
[mailto:freeradius-users-bounces+rkartadinata=pocket@lists.freeradiu
s.org] On Behalf Of Konstantin Chekushin
Sent: Thursday, January 14, 2010 7:38 AM
To: freeradius-users@lists.freeradius.org
Subject: freeradius + sqlippool
Good afternoon!
I have a question. It is necessary to assign ip
Hello All,
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
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-Name
Dear all,
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 ?
Best regards,
Tseveendorj
TunamalCom LLC
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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
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
WiMAX can also works in DHCP proxy mode: acquire IP address from ip pool in
RADIUS and convert to DHCP message format for the R6 interface.
IP address assignment has nothing to do with the EAP method (EAP-TLS) you
are using. I make the ip pool assignment working using sqlippool. What is
your
Hi,
I read from a post back in 2007 that freeRADIUS ippool or sqlippool does
not support assigning IP via EAP/TLS. I was wondering if this is still
the case?
Alan mentioned that there would be options that might be part of 2.0
release. Is there any solution for this with the current release
Victor Tangendjaja wrote:
I read from a post back in 2007 that freeRADIUS ippool or sqlippool does
not support assigning IP via EAP/TLS. I was wondering if this is still
the case?
Yes. Because when 802.1X is used, IP address assignment is done via DHCP.
Alan mentioned that there would
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
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 =
with the configuration.
Are you able to provide some pointers please, e.g. where sqlippool should be
placed or what other files should I look into or order to track the error
down.
Thx
Nev
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
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.
I have a DaloRadius / FreeRadius2.1.6 / Poptop (pptpd) 1.3.4 / ppp 2.4.4.-2 /
mysql 5.0.45
pppd does not pass back Client-IP-Address or Client
: [sqlippool]expand: UPDATE radippool SET
nasipaddress = '', pool_key = 0, callingstationid = '', username = '',
expiry_time IS NULL WHERE expiry_time = NOW() - INTERVAL 1 SECOND; - UPDATE
radippool SET nasipaddress = '', pool_key = 0, callingstationid = '',
username
Zemke, Kai wrote:
Thu Jul 9 14:44:08 2009 : Debug: rlm_sql_mysql: MYSQL check_error: 1064
received
That's a MySQL error. Are you using the standard queries?
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Thu Jul 9 14:44:08 2009 : Debug: rlm_sql_mysql: MYSQL check_error: 1064
received
Thu Jul 9 14:44:08 2009 : Error: sqlippool_command: database query error
in: 'UPDATE radippool SET nasipaddress = '', pool_key = 0,
callingstationid = '', username = '', expiry_time IS NULL WHERE
. Juli 2009 20:29
An: FreeRadius users mailing list
Betreff: Re: Ips dont get assigned using sqlippool
Thu Jul 9 14:44:08 2009 : Debug: rlm_sql_mysql: MYSQL check_error: 1064
received
Thu Jul 9 14:44:08 2009 : Error: sqlippool_command: database query error
in: 'UPDATE radippool SET
Hello,
I got it. I defined Pool-Name attribute in wrong place.
Tseveen.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hello,
Sorry for ask newbie question.
I would like to implement sqlippool functionality on FreeRADIUS 2.1.3. I
read /usr/local/share/doc/freeradius/rlm_sqlippool
there has following note
IP-Pool Attribute (Keep in mind that its a **CHECK** item, not reply)
I didn't understand. which
Hi Ivan,
Many thanks for your suggestion. However, (using 2.1.3) my
sqlippool.conf file is now:
sqlippool {
#
## SQL instance to use (from sql.conf) ##
#
sql-instance-name = sql
Many thanks for your suggestion. However, (using 2.1.3) my
sqlippool.conf file is now:
sqlippool {
#
## SQL instance to use (from sql.conf) ##
#
sql-instance-name = sql
Pool
Hi Ivan,
t...@kalik.net wrote:
Many thanks for your suggestion. However, (using 2.1.3) my
sqlippool.conf file is now:
sqlippool {
#
## SQL instance to use (from sql.conf) ##
#
sql
I've tried adding to the radcheck table ( INSERT into `radcheck` SET
`id` = 0, `username` = '447', `op` = ':=', `value` =
'%{control:Huntgroup-Name}`; )
Typo. It should be ' not ` at the end.
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See
: rlm_sql (sql): Reserving sql socket id: 2
Wed Feb 18 16:53:34 2009 : Info: [sqlippool]expand:
%{Calling-Station-ID} - 4477XX
Wed Feb 18 16:53:34 2009 : Info: [sqlippool] sql_set_user escaped user
-- '4477XX'
Wed Feb 18 16:53:34 2009 : Info: [sqlippool]expand: START
TRANSACTION - START
I've tried adding to the radcheck table ( INSERT into `radcheck` SET
`id` = 0, `username` = '447', `attribute` = 'Pool-Name' `op` =
':=', `value` =
'%{control:Huntgroup-Name}`; )
Sorry The result is still the same:
OK. sql safe characters in play. Then use unlang:
update control {
What I would love to do is set up Huntgroups (OK so that bit works too!)
and then in the sqlippool.conf just assign pool-name = %{Huntgroup-Name}
This doesn't work, and all I get is pool-name is undefined.
Does anyone have any ideas?
%{control:Huntgroup-Name}
Ivan Kalik
Kalik Informatika ISP
Hi all,
I have, what I think is a simple problem, with a simple answer that
doesn't work.
The environment I am supply authentication requests to, require that I
respond with a fixed IP address in each NAS domain.
eg NAS-IP-Addresses 192.168.1.0/28 should get an IP from the pool
10.0.0.0/16
Hi,
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.
At first I tried the freeradius 1.1.7-1build4 packages supplied
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, you
Original-Nachricht
Datum: Fri, 30 Jan 2009 11:51:20 +0100
Von: t...@kalik.net
An: FreeRadius users mailing list freeradius-users@lists.freeradius.org
Betreff: Re: IP-Assignment with sqlippool based on nas-ip-address
Now, the behaviour of the server changed in the way
I'm afriad, but this won't work in my environment. I will need a different
subnetmask.
Can you explain why do you think 255.255.255.255 netmask won't work for
you. Do you know how that netmask works?
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See
1 - 100 of 263 matches
Mail list logo