Hello Mr. Mayers,
I don't think so cause I've copied the very same sintax that can be found in
oraclesql.conf of FR 1.1.7.
Thank you.
Guilherme Franco
On 9/14/07, Phil Mayers [EMAIL PROTECTED] wrote:
On Fri, 2007-09-14 at 00:05 -0300, Guilherme Franco wrote:
Hello,
I'm using
).
Thank you.
Guilherme Franco
On 9/14/07, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
Hello,
I'm using rlm_sql_log in freeradius 1.1.4.
In order to correctly work with acct-input/ output gigawords,
Upgrade to 1.1.7.
Alan DeKok.
-
List info/subscribe/unsubscribe
radacct set... ...acctiputoctets = 0 32 | 98...
Looks like the rlm_sql_log module was not compiled to parse that sintax.
What can I do, please (besides create a procedure on the DB to treat that)?
Thank you very much.
Guilherme Franco
-
List info/subscribe/unsubscribe? See http
not when the user
[EMAIL PROTECTED] (proxy) gets authenticated.
Thank you.
On 6/13/07, Alan Dekok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
Hi,
Sorry for bothering you guys.
I would like to humbly ask if there's any ideas on this?
There's a lot there, and it's not clear what's
Hi,
Sorry for bothering you guys.
I would like to humbly ask if there's any ideas on this?
Thanks.
On 6/11/07, Guilherme Franco wrote:
Hello Mr. Alan,
Thank you for answering.
Below, you will find a working local authentication, user
[EMAIL PROTECTED] (without proxy), where the VSA ERX
Hello Mr. Alan,
Thank you for answering.
Below, you will find a working local authentication, user
[EMAIL PROTECTED] (without proxy), where the VSA ERX-Service-Bundle is
found in radreply (although the debug doesn't says that) and sent back
to the B-RAS:
rad_recv: Access-Request packet from
Hello,
Running Freeradius 1.1.4 on RHEL with an Oracle backend.
I'm at a Carrier and every @bar.com request is configured to be
proxied but I have a problem where a VSA (in radreply table) is not
even sent to bar.com.
In my database:
select * from radcheck;
ID USERNAME ATTRIBUTE
Mr. Alan and Mr. Peter,
Sorry for the lack of information.
I'll give more details about the problem on Monday.
Thank you very much.
On 5/12/07, Peter Nixon [EMAIL PROTECTED] wrote:
On Sat 12 May 2007, Guilherme Franco wrote:
Ok,
But a lot of times, on the process of server restart
DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
On my earlier posts (months ago, with 1.1.4), it has been told that the
latest CVS would solve the problem. I thought that 1.1.6 would include
the fix from the CVS head.
1.1.6 Changelog:
*Fixed bug in PostgreSQL module that caused
correct the behaviour as well, because the server
did crash sometimes (I've sent some valgrind outputs to you in previous
posts).
Using the latest CVS will fix the problem?
Thank you very much.
On 5/10/07, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
This was happening with 1.1.4
Hello,
Using Freeradius 1.1.6 on latest RHEL AS4 x64 with rlm_sqlippool, using
PostgreSQL
8.2.1.
After some hours operating, freeradius start to log lots of Info:
rlm_sqlippool: ip=[] len=0. Running the allocate-find query directly
under
psql shows no problem.
Issuing service radiusd restart
Hello,
Same with me, but acct is necessary.
The solution was radsqlrelay.
Regards,
Guilherme
On 2/13/07, Stefan Winter [EMAIL PROTECTED] wrote:
Hi,
1.1.4 will run for a few hours and then either stop responding to
requests or die. There is no seg fault warning in any log file. If I
Hello,
Even with radsqlrelay working, sqlippool loses dbhandles with postgresql.
Because of this, the cron.hourly job is still necessary...
--
Date: Feb 8, 2007 10:40 AM
Subject: VALGRIND: Major impact on authentication!
To: FreeRadius users mailing
it with
postgresql 8.2.3 and/or Oracle 10gr2.
Thank you!
---
On 2/12/07, Peter Nixon [EMAIL PROTECTED] wrote:
Guilherme
Can you please recap on your current configuration and version of FR?
Regards
Peter
On Mon 12 Feb 2007 19:10, Guilherme Franco wrote:
Hello,
Even
Hello,
Thank you for the consulting offer Mr. Peter but, as you told, there
seems to be some bugs in the rlm_sql oracle driver.
As everything was good before and now it's breaking, the most probable
cause is the increase in the number of auth users, which brings lots
of acct (0 users in
Hello Mr. Alan,
Thank you for your concern!
Just another message I've seen under /var/log/messages:
kernel: radiusd[1672]: segfault at 0110 rip
002a97de2c1e rsp 007fbfffe340 error 4
Gonna implement radrelay now, then! (I was holding back because I've
seen somewhere in this
Hello,
Of course, I can test sqlippool with Oracle. I just need to do it after
midnight because the earlier problems with Freeradius were so dramatic
that I've received orders to remove freeradius and install some commercial
software. Also, those tests would need to be synthetic ones, since the
Hi,
I did run valgrind radiusd -xxx at Wed Feb 7 19:15:08 2007 and at
Wed Feb 7 20:59:04 2007 radiusd DIED.
Afterwards, service radius restart would not work and of lots of
Error: Internal error processing module entry, Error:
rlm_sql_oracle: fetch failed in sql_fetch_row: ORA-24338: statement
Hello,
Thanks to everyone!
I'm using Oracle just for radcheck/radacct and PostgreSQL for radippool only.
No, Mr. Peter, no one is using dial-up admin nor anything alike when
the problem occurs, just pure auth (without acct).
I've disabled the cron.hourly job and the problem appeared again
Thanks Mr. DeKok,
I've already downloaded valgrind, just need to setup everything in a
time where the user won't suffer from the downtime.
Mr. Marshall, the only transaction is in rlm_sqlippool.
Thanks.
On 2/6/07, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
Also, it's
:
Guilherme Franco wrote:
Also, it's important to note that this server is the proxy radius and
those error messages appear:
Error: Discarding duplicate request from client ERX-1:5 - ID: 115
due to unfinished request 32
Info: The maximum number of threads (32) are active
Mr. Peter,
On 2/6/07, Peter Nixon [EMAIL PROTECTED] wrote:
OK. Well we have added a few more things this week. The last commit was just
over an hour ago for:
http://bugs.freeradius.org/show_bug.cgi?id=414
Yes, I've been watching the progress in Automatic report from sources
(radiusd) in the
Hi,
Freeradius 1.1.4 is randomly losing connection to both databases and it's
causing total loss in the authentication process:
Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to
connect 0
Info: rlm_sql (sql_postgresql): There are no DB handles to use! skipped 0,
tried to
Hello,
Thank you all for your prompt answers!
The database takes between 15ms and 40ms to answer to freeradius and has
only 40.000 entries there, so it isn't big.
PostgreSQL is updated to it's latest version and vaccum runs every night.
The queries are from sqlippool.conf, so...
Thanks!
-
Hello,
Considering that all things indicate that there might be a problem with the
DB, I did some tweaks in PostgreSQL and took off the cron.hourly job.
Gonna watch out for problems then, thanks!
-
Hi,
Freeradius 1.1.4 is randomly
I'm testing PostgreSQL performance with various tools.
Thanks!
On 2/5/07, Dennis Skinner [EMAIL PROTECTED] wrote:
Alan DeKok wrote:
As this is random, it's hard to debug, but at the same time freeradius
loses the connection, several other applications can successfully
connect/ maintain
Hello,
In authorize section I have the following:
sql {
notfound = reject
}
In post-auth:
Post-Auth-Type REJECT {
sql
attr_filter.access_reject
}
Both works correctly but I would like to log notfound users into
radpostauth table as
Hi,
Freeradius 2.0 alpha was working correctly since November 1st.
Then, this month, suddenly the server started to die, complaining of
Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried
to connect 0.
The server runs threaded with max_servers = 32 and num_sql_socks = 32
Thanks Mr. Mayers,
The database is Oracle on a powerful machine which only do acct/ auth.
All the relevant auth/ accounting queries are indexed to speed things
up.
There's a PostgreSQL database to take care of the sqlippool module.
The strange thing is that even when the accounting is off
Hello,
In authorize section I have the following:
sql {
notfound = reject
}
In post-auth:
Post-Auth-Type REJECT {
sql
attr_filter.access_reject
}
Both works correctly but I would like to log notfound users into radpostauth
table as
Michelle,
Seems like someone took off your NASes either from your naslist or
clients.conf files, in your raddb dir.
In those files you need at least an entry like this (for clients.conf):
client 10.10.10.1 {
secret = secret123
}
Where 10.10.10.1 would be your NAS address and
So, that was it!
It works now, thanks.
Back to the threads again :)
On 12/12/06, Guilherme Franco [EMAIL PROTECTED] wrote:
Thanks a lot!
I gonna test it right now!
On 12/12/06, Alan DeKok [EMAIL PROTECTED] wrote:
Peter Nixon wrote:
Running CVS HEAD in single threaded mode works
Yes, I'm using it single-threaded, since September.
I don't want to go back to 1.1.3 since it gave me problems.
Thanks.
On 12/12/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Tue 12 Dec 2006 03:08, Guilherme Franco wrote:
No way man!
:)
I've done a CVS clean install now (EVERYTHING old
Thanks a lot!
I gonna test it right now!
On 12/12/06, Alan DeKok [EMAIL PROTECTED] wrote:
Peter Nixon wrote:
Running CVS HEAD in single threaded mode works around the problem for
the time
being...
Ugh. After staring at the code a little more, the bug is in threads.c,
where it was passing
packet is received.
Thanks you!
On 12/6/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
I'm not HUPing the server in any way, never.
Ok..
GDB output:
Starting program: /usr/local/sbin/radiusd
[Thread debugging using libthread_db enabled]
[New Thread 182896328384 (LWP
installed the latest CVS above the old one, not a clean
install.
That might be the problem, what do you think?
Thank you.
On 12/11/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
Hello,
I did a set follow-fork-mode child in gdb now but then, there's no
assertion failed
Ok,
The log is below, thank you.
Gonna delete and clean install it, I just thought that ./configure,
make, make install would overwrite everything except the confs.
radiusd -xxx
Mon Dec 11 19:47:58 2006 : Info: Ready to process requests.
Mon Dec 11 19:47:58 2006 : Debug: Nothing to do.
conf, configured it from scratch.
Please help!
Thanks.
On 12/11/06, Guilherme Franco [EMAIL PROTECTED] wrote:
Ok,
The log is below, thank you.
Gonna delete and clean install it, I just thought that ./configure,
make, make install would overwrite everything except the confs.
radiusd -xxx
Mon Dec
!
On 12/11/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
I've done a CVS clean install now (EVERYTHING old deleted before
install and rebooted machine) but the same error occurs!
OK... it's just that I have a difficult time reproducing the problem,
so it's kind of hard
packet is received.
Thanks you!
On 12/6/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco wrote:
I'm not HUPing the server in any way, never.
Ok..
GDB output:
Starting program: /usr/local/sbin/radiusd
[Thread debugging using libthread_db enabled]
[New Thread 182896328384 (LWP
Hi,
I'm not HUPing the server in any way, never.
GDB output:
Starting program: /usr/local/sbin/radiusd
[Thread debugging using libthread_db enabled]
[New Thread 182896328384 (LWP 31483)]
Detaching after fork from child process 31486.
Program exited normally.
(gdb) info threads
No registers.
Hello,
Freeradius-snapshot-20061203 crashes, when running just radiusd with
proxy (radiusd -X doesn't crash):
It logs the following Error: Assertion failed in listen.c, line 621,
which is rad_assert(request-proxy_listener == listener);
Thanks.
-
List info/subscribe/unsubscribe? See
Hello,
I'm having problems again, when running radiusd (radiusd -X doesn't crash):
Before, in freeradius-snapshot-20061002 it was Error: Assertion failed
in listen.c, line 620, which was: rad_assert(request-proxy_listener
== listener);
Now, in freeradius-snapshot-20061203 it gives me Error:
Hello,
I'm trying to do a CVS login and got this error:
cvs -d :pserver:[EMAIL PROTECTED]:/source login
Logging in to :pserver:[EMAIL PROTECTED]:2401:/source
CVS password: ***
cvs [login aborted]: connect to cvs.freeradius.org:2401 failed: A
connection attempt failed because the
Hello,
I'm trying to do a cvs checkout but it won't let me:
cvs -d :pserver:[EMAIL PROTECTED]:/source login
Logging in to :pserver:[EMAIL PROTECTED]:2401/source
CVS password: anoncvs
cvs -d :pserver:[EMAIL PROTECTED]:/source checkout radiusd
It just hangs in the checkout part...
Any
Hi,
Doing proxy, freeradius always ignore the static Framed-IP-Address set
in radreply table and sets the random SQLIPPOOL instead.
Without proxy, SQLIPPOOL won't assign an IP from the pool and grabs
the Framed-IP-Address correctly.
I guess it's because the Framed-IP-Address = 255.255.255.254
Hello,
'{%SQL-User-Name}' does not work for SQLIPPOOL, it always appears blank.
What should I use in order to get the username?
Thank you.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Nevermind, I used %{User-Name} and it works.
Hello,
'{%SQL-User-Name}' does not work for SQLIPPOOL, it always appears blank.
What should I use in order to get the username?
Thank you.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
it be, please?
Thank you very much.
On 10/28/06, Peter Nixon [EMAIL PROTECTED] wrote:
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
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 differently, say, POOL1 assigns static IPs
and POOL2 dynamic
Hello,
Whenever I run radiusd alone, without the -X this error occurs in
the first authentication request:
Error: Assertion failed in listen.c, line 620
This line indicate the proxy part.
Running CVS radiusd -X generates no error at all.
Any clues?
Thanks.
-
List
Oh sorry, it's not the latest one because theres only cistron in the CVS page.
I can't download freeradius cvs then.
Please check the page: ftp://ftp.freeradius.org/pub/radius/CVS-snapshots/
Thanks.
On 10/25/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote
Yes, indeed, thanks. I just wanted to notify about the dead link as
well as the browse cvs tree:
http://www.freeradius.org/cgi-bin/cvsweb.cgi/radiusd/
By now, I'll use plain cvs to download it.
Thank you.
On 10/25/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED
Hello,
In sqlippool.conf I've instantiated:
sqlippool DYNAMIC{
...
allocate-find = SELECT framedipaddress FROM ${ippool_table} \
WHERE pool_name = '%{check:Pool-Name}' AND expiry_time 'now'::timestamp(0) \
ORDER BY RANDOM() \
LIMIT 1 \
FOR UPDATE
...
}
sqlippool STATIC{
...
allocate-find
Hello,
I'm only seeing cistron on the cvs:
FTP directory /pub/radius/CVS-snapshots/ at
ftp.freeradius.org
Up to higher level directory
10/23/2006 09:10201,051 radiusd-cistron-1.6-snapshot-20061023.tar.gz
-
List
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,
Does anyone already have a program to block freeradius on-the-fly?
ie: user has PAID = YES in radcheck table. Whenever I set PAID = NO,
the user would no longer authenticate the next time he/ she logs in.
OK, this works, but, if the user is already loged in, even if I set
PAID = NO, the
Thanks, I didn't know about the POD (it wasn't on the wiki when I've
read it before)
On 10/16/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Mon 16 Oct 2006 16:25, Guilherme Franco wrote:
Hi,
Does anyone already have a program to block freeradius on-the-fly?
ie: user has PAID = YES
Thanks Owen
On 10/16/06, Owen DeLong [EMAIL PROTECTED] wrote:
On Oct 16, 2006, at 6:25 AM, Guilherme Franco wrote:
Hi,
Does anyone already have a program to block freeradius on-the-fly?
ie: user has PAID = YES in radcheck table. Whenever I set PAID = NO,
the user would no longer
Hi,
You have to download it from oracle and then set all the needed paths,
like LD_LIBRARY_PATH and ORA_HOME, pointing to the place where you
descompressed oraclient. After that you need to recompile the
rlm_oracle module under freeradiusxxx/src/modules/.
Cheers
On 10/10/06, Dourty, Brian R.
Hello,
Survey Not Found
Sorry but this survey is no longer available. Please contact us if
you require any further information.
For more information on GroupSurveys, you can visit our site at
http://www.group-surveys.com
On 10/5/06, Alan DeKok [EMAIL PROTECTED] wrote:
In order to better
, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote:
Survey Not Found
Whoops... the make active link didn't work. I poked it again.
Alan DeKok.
--
http://deployingradius.com - The web site of the book
http://deployingradius.com/blog/ - The blog
-
List info
{...}).
If I specify sql-instance-name = sql2 in sqlippool.conf it does not works.
I appreciate any help on this issue. Thanks!
On 9/29/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Fri 29 Sep 2006 15:23, Guilherme Franco wrote:
Thanks for all the answers Mr. Peter!
To clarify some things:
NONE
, as soon as I have the time to look for, I hope to patch
rlm_sqlippool.c and CVS it along with oracle.sqlippool.conf and
radippool schema for oracle.
Greetings
On 10/3/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Tue 03 Oct 2006 19:29, Guilherme Franco wrote:
Hello,
I've installed Postgres
Nevermind the proxy issue, I've managed to circumvent it using attrs file
Thanks
On 10/3/06, Guilherme Franco [EMAIL PROTECTED] wrote:
Mr. Peter,
Thanks, I was using sql_instance2{...} instead of sql sql_instance2{...}
:)
Everything is working nice now with this hybrid oracle/postgresql
operation before any
query).
About the postgresql installation, I was thinking in installing it. I
will do that just to see it's behaviour, thanks.
THANKS A LOT AGAIN!
On 9/29/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Fri 29 Sep 2006 01:02, Guilherme Franco wrote:
Thank you very much for your
PROTECTED] wrote:
On Wed 27 Sep 2006 16:41, Guilherme Franco wrote:
Hi,
I know you guys must be angry with all the questions I'm posting here.
In Devel-List, I found this: Is it usefull to community? (SQLIPPOOL
and NASCATS) by Roman M. Bibikov on Thu, 16 Oct 2003 17:36:26 +1100.
He says
Hello,
I had to modify oracle-dialup.conf to make accounting on/off to work.
In AcctSessionTime, the original query would generate expected
NUMBER, got INTERVAL error.
Here is the original:
accounting_onoff_query = UPDATE ${acct_table1} SET
AcctStopTime=TO_DATE('%S','-mm-dd hh24:mi:ss'),
Hi,
I know you guys must be angry with all the questions I'm posting here.
In Devel-List, I found this: Is it usefull to community? (SQLIPPOOL
and NASCATS) by Roman M. Bibikov on Thu, 16 Oct 2003 17:36:26 +1100.
He says that created a sucessfull ip pool in Oracle (exactly what I'm
trying to
Thank you very much!
On 9/27/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote:
Sending duplicate proxied request to home server foo.com port 1645 - ID:
16
Assertion failed in listen.c, line 558
This is now fixed in CVS. You'll have to do a cvs update
the error occurred, and anything you might
have done that may have caused the error.
More information about this error may be available in the server error log.
Microsoft-IIS/5.0 Server at us.freeradius.org Port 80
On 9/27/06, Guilherme Franco [EMAIL PROTECTED] wrote:
Thank you very much!
On 9/27
Hello,
I'm in a situation where I have 2 freeradius servers, working
perfectly with rlm_sql_oracle (the entire AAA is done in Oracle,
except the ippool).
It's not possible to have the same pool configured the same way in the
2 servers, and also It's totally out of question to configure range1
;
FRAMEDIPADDRESS
--
192.168.1.1
Thanks.
On 9/26/06, Peter Nixon [EMAIL PROTECTED] wrote:
On Tue 26 Sep 2006 14:45, Guilherme Franco wrote:
Hi,
This is what happens:
SQL UPDATE radippool SET nasipaddress = '', pool_key =
0,callingstationid = '', expiry_time
Hello!
I've created a new sqlippool.conf customized for Oracle.
The queries in there returns no error but I get this:
modcall: entering group post-auth for request 0
Value Of the Pool-Name is [FOO] and its [3] Chars
rlm_sql (sql): Reserving sql socket id: 2
radius_xlat: 'BEGIN'
BEGIN
)
for try in /usr/include/oracle/10.1.0.3/
THANK YOU!
On 9/20/06, Peter Nixon [EMAIL PROTECTED] wrote:
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
HI,
Please, this is a very important problem that is affecting thousands
of customers of mine:
I have 2 realms for send proxy requests (foo.com and bar.net)
If the proxy server foo.com goes down (for whatever reason) this happens:
rad_recv: Access-Request packet from host 192.168.1.1 port
freeradius with ./configure --enable-developer?
If not, it will take only a couple of minutes to get it recompiled again.
Thank you!
On 9/20/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote:
If the proxy server foo.com goes down (for whatever reason) this happens
back here to ask.
Thanks a lot!
On 9/20/06, Tuyan Ozipek [EMAIL PROTECTED] wrote:
On Wed, 2006-09-20 at 14:14 -0300, Guilherme Franco wrote:
Hello,
Unfortunately, even with freeradius-snapshot-20060920.tar.gz and
using the ./configure --with-modules=rlm_sqlippool option, the
module did
Hello,
Because I need the sqlippool.
I was using 1.1.2 and when 1.1.3 was released, I was in a rush to
deliver a working environment to the client. 1.1.3 broke somethings
for me. Because of that I started to use CVS nightly builds.
Until now, no other problem has appeared besides the listen.c
.
Thanks everybody, I'm going to test all until it works now!
Case closed, thanks.
On 9/20/06, Peter Nixon [EMAIL PROTECTED] wrote:
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
Hi Mr. Peter,
Like you told me before, you did some cleanups in the sqlippool.conf.
Well, I've tried to install todays freeradius CVS, and it installed
without the sqlippool module, don't know why.
So, I've compiled it manually from
freeradius-snapshot-20060918/src/modules/rlm_sqlippool/
OK,
...
--- Walking the entire request list ---
Waking up in 1 seconds...
rad_recv: Access-Request packet from host 192.168.1.1 port 1385,
id=21, length=60
Sending duplicate proxied request to home server 192.168.1.2 port 1645 - ID: 16
Assertion failed in listen.c, line 558
Aborted
Thanks.
Guilherme
Hello,
I work in a Carrier and have an important question regarding SQL query check:
I need to check a value in authorize_check_query (oracle-dialup.conf)
to see if the user has paid his ADSL service. If he did paid the
service, the request would be proxied to the ISP radius to
authenticate the
of typo in the config file
that Guilherme Franco is using.
also, trace shows that there is no allocate-clear statement set for
sqlippool to use.
here is the allocate-clear statement that i used for my test..
allocate-clear = UPDATE radippool \
SET nasipaddress = '', pool_key = 0
: Guilherme Franco [EMAIL PROTECTED]
To: FreeRadius users mailing list
freeradius-users@lists.freeradius.org
Hi Peter,
Like you told me before, you did some cleanups in the sqlippool.conf.
Well, I've tried to install todays freeradius CVS, and it installed
without
Thank you very much, I will test it out
In the mean time I figured out to use radgroupcheck with values
Auth-Type=Reject and some users associated to that usergroup.
Thanks again!
06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote:
The problem is, If PAID
file that Guilherme Franco is using.
also, trace shows that there is no allocate-clear statement set for
sqlippool to use.
here is the allocate-clear statement that i used for my test..
allocate-clear = UPDATE radippool \
SET nasipaddress
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
another of ERX's crazy behaviors.
Thanks!
On 9/18/06, Alan DeKok [EMAIL PROTECTED] wrote:
Guilherme Franco [EMAIL PROTECTED] wrote:
Using Proxy, when user mistypes the password, radiusd -X crashes with
Assertion failed in listen.c, line 558
I don't see that here... Are you HUP'ing
Hello,
I've just managed to make it work using := instead of == in attrs file.
:)
-- Forwarded message --
From: Guilherme Franco [EMAIL PROTECTED]
Date: Sep 15, 2006 3:51 PM
Subject: VSA does not work when using PROXY
To: FreeRadius users mailing list freeradius-users
Hi Peter,
Like you told me before, you did some cleanups in the sqlippool.conf.
Well, I've tried to install todays freeradius CVS, and it installed
without the sqlippool module, don't know why.
So, I've compiled it manually from
freeradius-snapshot-20060918/src/modules/rlm_sqlippool/
OK, but
Hi,
I need to set override = yes in radiusd.conf in order to the user get an IP.
This way because it's a proxy request.
i.e: [EMAIL PROTECTED] - proxy to realm - realm authorize user -
myradius sets the IP
The IP assignment does not work with override = no, because the proxy
radius tends to
Hello,
Using Proxy, when user mistypes the password, radiusd -X crashes with
Assertion failed in listen.c, line 558
Line 558 = rad_assert(request-listener == listener);
Thanks.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hello,
Please Help!
Using latest CVS - Proxy-Radius does not pass the VSA, as below (in users):
DEFAULT Pool-Name := test
X-Ascend-Client-Primary-DNS = x.x.x.x,
X-Ascend-Client-Assign-DNS = 1,
Thank you!
I'm downloading it right now.
Thanks again!
On 9/13/06, Peter Nixon [EMAIL PROTECTED] wrote:
Hi
Please update to the latest sqlippool.conf in cvs as I have just committed a
lot of cleanups to it.
Cheers
Peter
On Tue 12 Sep 2006 23:56, Guilherme Franco wrote:
Mr. Peter
:
On Tue 12 Sep 2006 22:44, Guilherme Franco wrote:
Thanks Mr. Nixon,
I thought that someone might have already created such a schema.
But that's not a problem.
I'll be playing with the errors and as I get a working schema I'll post
back.
Just another doubt: Is there any way to create a pool
onhttp://ora-12154.ora-code.com/ Personally I've seen oracle clients that suddenly refuse to work because it decides that it wants ip-name mappings. Usually a trip to the dns or /etc/hosts solves the prob
eOn 31/ago/06, at 16:38GMT+02:00, Guilherme Franco wrote:Mr. Peter,I did a test right now
URGENT!Hi,I'm getting this error Could not connect to SQL database. in dialupadmin. (using OCI8 with ORACLE)
Radiusd connects to Oracle without any problems, dialupadmin don't.Please help.Thank you.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
,
Peter Nixon [EMAIL PROTECTED] wrote:
On Thu 31 Aug 2006 16:17, Guilherme Franco wrote: URGENT! Hi, I'm getting this error *Could not connect to SQL database. *in dialupadmin. (using OCI8 with ORACLE) *
*Radiusd connects to Oracle without any problems, dialupadmin don't.Does your PHP module have
, it states Parse error: syntax error, unexpected '' in
/www/htdocs/test.php on line 10 (then, tcpdump in oracle server shows nothing)
I think that the same problem is blocking dialupadmin from connecting with oracle.
What might it be?Thanks.On 8/31/06, Guilherme Franco
[EMAIL PROTECTED] wrote
1 - 100 of 105 matches
Mail list logo