Solved: Gigawords

2007-09-17 Thread Guilherme Franco
= '%{Acct-Input-Octets}' + ('%{Acct-Input-Gigawords}' * 4294967296), AcctOutputOctets = '%{Acct-Output-Octets}' + ('%{Acct-Output-Gigawords}' * 4294967296) Guilherme Franco On 9/14/07, Guilherme Franco <[EMAIL PROTECTED]> wrote: > > Hi Mr. D

Re: Gigawords

2007-09-14 Thread Guilherme Franco
12/12). 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, &

Re: Gigawords

2007-09-14 Thread Guilherme Franco
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: > &

Gigawords

2007-09-13 Thread Guilherme Franco
conf, but this results in invalid queries like: "update 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.

Re: Big "VSA + Proxy" problem

2007-06-13 Thread Guilherme Franco
sent to the B-RAS, while it's 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

Re: Big "VSA + Proxy" problem

2007-06-12 Thread Guilherme Franco
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] (withou

Re: Big "VSA + Proxy" problem

2007-06-11 Thread Guilherme Franco
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 ho

Big "VSA + Proxy" problem

2007-06-07 Thread Guilherme Franco
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

Re: 1.1.6 with rlm_sqlippool: ip=[] len=0

2007-05-12 Thread Guilherme Franco
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

Re: 1.1.6 with rlm_sqlippool: ip=[] len=0

2007-05-11 Thread Guilherme Franco
d. That's it. Thanks. On 5/10/07, Alan 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

Re: 1.1.6 with rlm_sqlippool: ip=[] len=0

2007-05-10 Thread Guilherme Franco
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

Re: 1.1.6 with rlm_sqlippool: ip=[] len=0

2007-05-09 Thread Guilherme Franco
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 restar

Re: 1.1.4 stops responding to requests

2007-02-13 Thread Guilherme Franco
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

Re: Update: Major impact on authentication!

2007-02-12 Thread Guilherme Franco
ing to update to the latest CVS head and try 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:

Update: Major impact on authentication!

2007-02-12 Thread Guilherme Franco
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 lis

VALGRIND: Major impact on authentication!

2007-02-08 Thread Guilherme Franco
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 m

Re: VALGRIND: Major impact on authentication!

2007-02-08 Thread Guilherme Franco
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 September

VALGRIND: Major impact on authentication!

2007-02-07 Thread Guilherme Franco
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: state

Re: Again: Major impact on authentication!

2007-02-07 Thread Guilherme Franco
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 d

Re: Again: Major impact on authentication!

2007-02-06 Thread Guilherme Franco
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)" i

Re: Again: Major impact on authentication!

2007-02-06 Thread Guilherme Franco
er 2006, until now that things started to freak out. Thank you! On 2/6/07, Peter Nixon <[EMAIL PROTECTED]> wrote: > On Tue 06 Feb 2007 15:27, Alan DeKok wrote: > > Guilherme Franco wrote: > > > Also, it's important to note that this server is the proxy radius and >

Re: Again: Major impact on authentication!

2007-02-06 Thread Guilherme Franco
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 wr

Again: Major impact on authentication!

2007-02-06 Thread Guilherme Franco
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 after

Re: RE : Re: Major impact on authentication!

2007-02-05 Thread Guilherme Franco
Sorry Mr. Geoffroy, your message arrived only now in my e-mail. Somehow, every list message takes a large amount of time to come into my e-mail. Thank you for your concerns and yes, postgresql has debug/ analyze commands that displays the time that commit or anything else take to complete. On 2

Re: Major impact on authentication!

2007-02-05 Thread Guilherme Franco
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/ main

Hibernating: Major impact on authentication!

2007-02-05 Thread Guilherme Franco
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 losing

Re: Major impact on authentication!

2007-02-05 Thread Guilherme Franco
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! - Li

Major impact on authentication!

2007-02-05 Thread Guilherme Franco
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 c

Re: SEVERE! radiusd 2.0 and 1.1.4 dying! Segmentation fault

2007-01-27 Thread Guilherme Franco
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 (with

SEVERE! radiusd 2.0 and 1.1.4 dying! Segmentation fault

2007-01-27 Thread Guilherme Franco
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 (th

Log notfound users

2007-01-27 Thread Guilherme Franco
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 well,

Re: RADIUS will no longer start!

2007-01-24 Thread Guilherme Franco
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 se

Log notfound users

2007-01-24 Thread Guilherme Franco
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 well,

Re: !!! Assertion failed in listen.c, line 621 !!!

2006-12-13 Thread Guilherme Franco
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 H

Re: !!! Assertion failed in listen.c, line 621 !!!

2006-12-12 Thread Guilherme Franco
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 pass

Re: !!! Assertion failed in listen.c, line 621 !!!

2006-12-12 Thread Guilherme Franco
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

Re: !!! Assertion failed in listen.c, line 621 !!!

2006-12-11 Thread Guilherme Franco
! 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 prob

!!! Assertion failed in listen.c, line 621 !!!

2006-12-11 Thread Guilherme Franco
'm not using any old 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 e

Re: Assertion failed in listen.c, line 621

2006-12-11 Thread Guilherme Franco
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. Sleep

Re: Assertion failed in listen.c, line 621

2006-12-11 Thread Guilherme Franco
Besides that, I've 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"

Assertion failed in listen.c, line 621

2006-12-11 Thread Guilherme Franco
he first 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]

Re: Assertion failed in listen.c, line 621

2006-12-09 Thread Guilherme Franco
he first 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]

Re: Assertion failed in listen.c, line 621

2006-12-06 Thread Guilherme Franco
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. (g

Assertion failed in listen.c, line 621

2006-12-05 Thread Guilherme Franco
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 ht

(CVS) Error: Assertion failed in listen.c, line 621

2006-12-03 Thread Guilherme Franco
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: As

CVS error

2006-12-02 Thread Guilherme Franco
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 connected

SOLVED '{%SQL-User-Name}' does not work for SQLIPPOOL

2006-10-31 Thread Guilherme Franco
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

'{%SQL-User-Name}' does not work for SQLIPPOOL

2006-10-31 Thread Guilherme Franco
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

PROBLEM - Proxy + SQLIPPOOL + Framed-IP-Address

2006-10-31 Thread Guilherme Franco
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 c

CVS problem

2006-10-31 Thread Guilherme Franco
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 problems

Re: SQLIPPOOL problem

2006-10-28 Thread Guilherme Franco
What can 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 > > ip

SQLIPPOOL problem

2006-10-26 Thread Guilherme Franco
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 ones,

Important question about module instantiation

2006-10-25 Thread Guilherme Franco
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-fin

Re: Error: Assertion failed in listen.c, line 620

2006-10-25 Thread Guilherme Franco
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&qu

Re: Error: Assertion failed in listen.c, line 620

2006-10-25 Thread Guilherme Franco
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 Fran

Error: Assertion failed in listen.c, line 620

2006-10-25 Thread Guilherme Franco
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 info/subscribe/unsubs

cvs issue

2006-10-24 Thread Guilherme Franco
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 info/subscri

Re: sqlippool + MySQL

2006-10-17 Thread Guilherme Franco
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 "

Re: block users on-the-fly

2006-10-16 Thread Guilherme Franco
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, >

Re: block users on-the-fly

2006-10-16 Thread Guilherme Franco
t's only really any good for 1 or 2 NAS'es - if you want your system to scale to 30-40 nases then you'll probably want to keep it simple to manage and debug, and get radius to handle periodic reauthentication. Hope this helps, Jan On 16/10/06, Guilherme Franco <[EMAIL PROTECTED]>

Re: block users on-the-fly

2006-10-16 Thread Guilherme Franco
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?

block users on-the-fly

2006-10-16 Thread Guilherme Franco
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 user

Re: RHEL4 and Oracle Instant Client

2006-10-10 Thread Guilherme Franco
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. (I

Re: FreeRADIUS user Survey

2006-10-05 Thread Guilherme Franco
, 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://dep

Re: FreeRADIUS user Survey

2006-10-05 Thread Guilherme Franco
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 u

Re: UPDATED: dumb humble question about sqlippool

2006-10-03 Thread Guilherme Franco
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 n

Re: UPDATED: dumb humble question about sqlippool

2006-10-03 Thread Guilherme Franco
I have to thank you again for all your help! Now it's my turn to contribute, 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: O

UPDATED: dumb humble question about sqlippool

2006-10-03 Thread Guilherme Franco
#x27;s confs (sql{..}) and sql2.conf containing postgres confs (sql2{...}). 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, Guilhe

Re: dumb humble question about sqlippool

2006-09-29 Thread Guilherme Franco
; came from thought. To solve this, I had to change "BEGIN" in allocate-begin for "commit" (a normal oracle 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 AGA

Re: dumb humble question about sqlippool

2006-09-28 Thread Guilherme Franco
only way would do this as an enhancement to the already deployed solution for the client, thanks. Thank you again! On 9/28/06, Peter Nixon <[EMAIL PROTECTED]> wrote: On Wed 27 Sep 2006 16:41, Guilherme Franco wrote: > Hi, > > I know you guys must be angry with all the question

CRITICAL! NFS/ SQLIPPOOL :~(

2006-09-27 Thread Guilherme Franco
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 fo

Re: ULTRA IMPORTANT! Proxy - Assertion failed in listen.c, line 558 error

2006-09-27 Thread Guilherme Franco
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!

Re: ULTRA IMPORTANT! Proxy - Assertion failed in listen.c, line 558 error

2006-09-27 Thread Guilherme Franco
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 i

dumb humble question about sqlippool

2006-09-27 Thread Guilherme Franco
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 d

Accounting issues in Oracle solved

2006-09-27 Thread Guilherme Franco
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')

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Guilherme Franco
ows selected SQL> Thank you. On 9/26/06, Peter Nixon <[EMAIL PROTECTED]> wrote: On Tue 26 Sep 2006 00:49, Guilherme Franco wrote: > Mr. Nixon, > > Please accept my humble apologies for the earlier spam. > > I would like to test your experimental module sqlippool in Oracle

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Guilherme Franco
there is no problem. If you have ANOTHER problem, then post the debug for it. The first query is not SUPPOSED to work if the pool_key doesn't exist. I CLEARS existing IP leases. Do you have any active leases right now? If not why would you be trying to clear them? Peter On Tue 26 Sep 2006

Re: Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-26 Thread Guilherme Franco
ingstationid from radippool where callingstationid <> ''),expiry_time FOR UPDATE; 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, > >

Apologies for Mr. Peter Nixon and updated sqlippool debug

2006-09-25 Thread Guilherme Franco
Mr. Nixon, Please accept my humble apologies for the earlier spam. I would like to test your experimental module sqlippool in Oracle and in return, contribute somehow with my working configs and tables to the CVS. I understand that you are a busy man, so please excuse me if I did bother you. T

debug for sqlippool

2006-09-22 Thread Guilherme Franco
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 rlm_sql_

Re: sqlippool not working

2006-09-20 Thread Guilherme Franco
, but that's ok. 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

Re: ULTRA IMPORTANT! Proxy - Assertion failed in listen.c, line 558 error

2006-09-20 Thread Guilherme Franco
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 o

Re: sqlippool not working

2006-09-20 Thread Guilherme Franco
ation about those things, so I come 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 .

Re: ULTRA IMPORTANT! Proxy - Assertion failed in listen.c, line 558 error

2006-09-20 Thread Guilherme Franco
installing 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

ULTRA IMPORTANT! Proxy - Assertion failed in listen.c, line 558 error

2006-09-20 Thread Guilherme Franco
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 1385

Re: sqlippool not working

2006-09-20 Thread Guilherme Franco
ply a matter of changing the 10.1.0.3 version and something to the new one in configure.in of rlm_sql_oracle, but I was in a rush: # Look for Oracle10g "Instant Client" installed from RPM if test "x$ORACLE_INCLUDE" = "x"; then old_CFLAGS="$CFL

Re: sqlippool not working

2006-09-19 Thread Guilherme Franco
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"

Re: sqlippool not working

2006-09-19 Thread Guilherme Franco
> > > > Peter > > > > > > > > On Tue 19 Sep 2006 17:44, Tuyan Ozipek wrote: > > > > > Hi Peter, > > > > > > > > > > When i installed (compiled from source) the > > > > > freeradius-snapshot-20060918 tarball, the onl

Re: Matter of Life and Death - SQL and Proxy

2006-09-19 Thread Guilherme Franco
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

Re: sqlippool not working

2006-09-19 Thread Guilherme Franco
(which i copied from some other test > > > environment). Since sqlippool module is not(yeah, we run it on > > > production happily for sometime..) considered stable yet, we do not > > > build it by default.(Lets check sqlippool.conf file installation in the > > > mak

Re: sqlippool not working

2006-09-19 Thread Guilherme Franco
ion in the > makefiles tho.) > > I am running it now on my development machine with no problems. > > The only thing possible is there is some type of typo in the config file > that Guilherme Franco is using. > > also, trace shows that there is no allocate-clear statement set for

Matter of Life and Death - SQL and Proxy

2006-09-19 Thread Guilherme Franco
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

ERROR! Proxy listen.c error

2006-09-19 Thread Guilherme Franco
st to home server 192.168.1.2 port 1645 - ID: 16 Assertion failed in listen.c, line 558 Aborted Thanks. "Guilherme Franco" wrote: I was worried about this, but when I tested with the user authenticating from an ADSL modem, there are no problems. So, might be just another of ERX&

Oracle conf Attached: sqlippool not working

2006-09-19 Thread Guilherme Franco
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, b

sqlippool not working

2006-09-18 Thread Guilherme Franco
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 w

Fwd: VSA does not work when using PROXY

2006-09-18 Thread Guilherme Franco
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

Re: ERROR! Proxy listen.c error

2006-09-18 Thread Guilherme Franco
. So, might be just 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,

VSA does not work when using PROXY

2006-09-15 Thread Guilherme Franco
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, ERX-Virtual-Rout

ERROR! Proxy listen.c error

2006-09-15 Thread Guilherme Franco
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

URGENT! User does not get VSA attribute If override = yes and in radiusd.conf and using PROXY

2006-09-15 Thread Guilherme Franco
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

  1   2   >