>> Seems that running additional radius server on management server will
>> be a no-go for me. I'm reverting back to first idea and trying to find
>> a workaround to get freeradius to start even if accounting/management
>> DB is unreachable... Any ideas welcome.
>
>
> Run the detail reader in a sep
On 11/06/13 13:12, Yann Belin wrote:
We then have a detail reader (see "copy-acct-to-home-server"
virtual server) that reads this file and relays it to the
management RADIUS server for centralised logging.
If the management server goes down, the files on disc just grow
until it comes back again
>> We then have a detail reader (see "copy-acct-to-home-server"
>> virtual server) that reads this file and relays it to the
>> management RADIUS server for centralised logging.
>>
>> If the management server goes down, the files on disc just grow
>> until it comes back again and then the logs are
> We then have a detail reader (see "copy-acct-to-home-server"
> virtual server) that reads this file and relays it to the
> management RADIUS server for centralised logging.
>
> If the management server goes down, the files on disc just grow
> until it comes back again and then the logs are relaye
> Which version are you on?
>
> This might be better/possible in 3.0, as the connection pool stuff might let
> you set "0" as the number of initial server connections.
Sorry, i should have started with that... Running 2.1.12, which indeed
doesn't allow me to do so.
-
List info/subscribe/unsubscri
On Mon, Jun 10, 2013 at 05:14:16PM +0200, Yann Belin wrote:
> I am trying to build a multi-server setup, where each server uses a
> local user database (replicated from a central management server) and
> buffers its accounting data before pushing it back to the management
> server. I have tried two
On 10/06/13 16:14, Yann Belin wrote:
On many aspects method #1 is better, but I would like to find a way to
make the connection to management server optional at start-up, as I in
my case accounting is secondary and should not be interfering with
auth.
Which version are you on?
This might be b
except for one thing - by design, if the management
sql server is unavailable for some reason, freeradius will refuse to
launch. It should not be an issue in 99% of the cases but still bugs
me a little bit.
- Second method uses a cron'd "radsqlrelay" and "sql_log". It will
>Thanks Alan, acct relay works fine now using proxy.conf and
>copy-acct-to-home-server!
>One final question: Is it possible to replicate the Users table (mysql) using
>FreeRadius2?
>The idea is never having to worry if a new user was properly created on both
>servers (or deleted on both servers)
Marius Pesé wrote:
> Thanks Alan, acct relay works fine now using proxy.conf and
> copy-acct-to-home-server!
That's good to hear.
> One final question: Is it possible to replicate the Users table (mysql) using
> FreeRadius2?
No. MySQL has replication. You should use that.
> The idea is
-Original Message-
From: Of Alan DeKok
Sent: Wednesday, July 07, 2010 4:10 PM
To: FreeRadius users mailing list
Subject: Re: RadSQLRelay
Marius Pesé wrote:
> We are still struggling to get our FreeRadius2 servers running on
> CentOS5.5 to relay accounting packages to one a
Marius Pesé wrote:
> We are still struggling to get our FreeRadius2 servers running on
> CentOS5.5 to relay accounting packages to one another.
? raddb/sites-available/copy-acct-to-home-server
> However if we start radsqlrelay
Uh... why?
> (radsqlrelay -d mysql -b freeradius
d the
textfile with the queries without problems.
However if we start radsqlrelay (radsqlrelay -d mysql -b freeradius -h
196.25.xxx.xxx -u root -p /var/log/radius/radacct/relay/sql-relay) it
opens quite a few connections to the secondary database, but does not seem to
use the text file
Hi,
> Or, delete the sql_log queries, and use the ones from rlm_sql that are
> known to work.
yes.i was thinking about why we have the stuff defined twice.
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[EMAIL PROTECTED] wrote:
> now - whilst radsqlrelay is recommended for those whose accounting DB systems
> cannot keep up with the real flow of packets - and we recommend it - its not
> productive to have imho a broken default config. the issues which i can see
> from this are the fol
hi,
I've been looking at the current state of the default (commented
out ready for use) radsqlrelay commands in radiusd.conf . for a
quick reminder they look like this:
# sql_log {
# path = "${radacctdir}/sql-relay"
# acct_t
Hi David/List,
On Tue, 2008-01-15 at 17:19 +, David Wood wrote:
> Sometimes blind code changes don't work out. Unfortunately I am
> flying blind, as I don't use radsqlrelay and I can't quickly concoct an
> environment for it.
>
>
> I think line 53 should
ius/sql-relay.work: Invalid argument
Sometimes blind code changes don't work out. Unfortunately I am
flying blind, as I don't use radsqlrelay and I can't quickly concoct an
environment for it.
I think line 53 should actually be
my $FLOCK_STRUCT = 'q2is2'
as off_t
ins what should become the net/freeradius2
> port for the 2.0.0 release version.
>
> http://www.freebsd.org/cgi/query-pr.cgi?pr=119582
>
> However, radsqlrelay is version 1.7 in the released 2.0.0 as well.
>
> >I'm no real coder myself, hence, the need to seek dire
Hi Roy and everyone,
In message <[EMAIL PROTECTED]>, roy
<[EMAIL PROTECTED]> writes
Application versions that are being used:
FreeBSD 6.3-PRERELEASE
p5-DBD-Pg-1.49
p5-DBI-1.60.1
postgresql-client-8.1.11
freeradius-devel-2.0.0.p2
radsqlrelay v1.7
FreeRADIUS 2.0.0-pre2 is some wa
Apologies for cross-posting.
Just wondering if anyone else was able to run radsqlrelay successfully
on FBSD 6.3.
I've ran into file lock issue right after I've tried running the pl
script:
# ls -al
total 8
drwxr-xr-x 3 root wheel 512 Jan 14 13:39 .
drwxr-xr-x 5 root wheel 512 Ja
Stefan Winter wrote:
> attempting to kill a running radsql with ^C doesn't do anything, and
> kill'ing it with TERM doesn't impress it either on my system. I had to
> send KILL to get rid of it. Is this intentional?
The radsqlrelay script doesn't exit immediately. It
hitting similar problem, when experimenting with
radsqlrelay. IIRC I was not able to break it when it was not able to
connect do DB. It sets $need_exit to 1 on signal, but value was not
checked when it was constantly re-trying to connect to DB. Your
problem may be similar.
However, "fixing"
Hi,
attempting to kill a running radsql with ^C doesn't do anything, and kill'ing
it with TERM doesn't impress it either on my system. I had to send KILL to
get rid of it. Is this intentional?
Then, on startup I see it instantiated but only the post-auth query is printed
on startup with -X - l
Alexander Serkin wrote:
> Nicolas Baradakis wrote:
>
> > Please create a patch with "diff -u radsqlrelay.orig radsqlrelay"
> > and post it to the list. I'll add it in version 1.1.3.
>
> Here it is:
>
> --- radsqlrelay.orig 2006-08-16 15:40:58.22
Nicolas Baradakis wrote:
Alexander Serkin wrote:
Finally radsqlrelay works for me with oracle too after patching 2
strings as you said.
Please create a patch with "diff -u radsqlrelay.orig radsqlrelay"
and post it to the list. I'll add it in version 1.1.3
Alexander Serkin wrote:
> Finally radsqlrelay works for me with oracle too after patching 2
> strings as you said.
Please create a patch with "diff -u radsqlrelay.orig radsqlrelay"
and post it to the list. I'll add it in version 1.1.3.
--
Nicolas Baradakis
-
List info/
Nicolas Baradakis wrote:
radsqlrelay was added in version 1.1.0 and since then it was never
changed. (you can check the CVS log if you want)
Yes. i was wrong. In my case i've just fed sqllog to sqlplus utility.
Finally radsqlrelay works for me with oracle too after patching 2
strings a
Alexander Serkin wrote:
> > Nicolas Baradakis wrote:
> >
> > > Maybe you could use "radsqlrelay" for accounting data, so FreeRADIUS
> > > doesn't interact with the database anymore. See the manpages for
> > > rlm_sql_log(5) and radsqlrelay(8)
Alexander Serkin wrote:
Nicolas Baradakis wrote:
Maybe you could use "radsqlrelay" for accounting data, so FreeRADIUS
doesn't interact with the database anymore. See the manpages for
rlm_sql_log(5) and radsqlrelay(8) for more details.
didn't think about this yet. I
sent them over the wide area network and then on the other
> end, I will decompress it and then I will use 'radsqlrelay' to
> read the flat files and store them into MSSQL.
The files from "rlm_sql_log" are just plain SQL statements. If
you don't insert the records o
then on the other
end, I will decompress it and then I will use 'radsqlrelay' to
read the flat files and store them into MSSQL.
But a quick check on the latest radius server snap shot revealed
that the program 'radsqlrelay' - a perl script - only support
'mysql
[EMAIL PROTECTED] wrote:
> 3. if the radsqlrelay process dies (or i kill -9 it) - after
> restarting it - all the data in the detail-file will processed
> again
You're right. At startup radsqlrelay sends the detail-file from the
beginning, but perhaps some records were
On Sun, 6 Mar 2005 [EMAIL PROTECTED] wrote:
hi all,
i've tested radsqlrelay for moving big acct-logs (detail-file) into my
database - and have read the comments about the code:
1. is it possibile to (log-)rotate the detail-file - when radsqlrelay is
running - and read it ?
Why? The idea is
hi all,
i've tested radsqlrelay for moving big acct-logs (detail-file) into my
database - and have read the comments about the code:
1. is it possibile to (log-)rotate the detail-file - when radsqlrelay is
running - and read it ?
2. i've read about the .work file - but couldn't
Bart Van Daal wrote:
> is it possible to build it against the 1.0.2 tree or am I stuck with
> the cvs version. The libraries differ from the cvs version and the
> 1.0.2 version.
Yes, it is possible. As reported in the mailing list, I'm building
radsqlrelay in the 1.0.2 source tr
Bart Van Daal wrote:
> Nicolas I'm currently using your radsqlrelay.c with the 1.0.2
> release and I've patched the makefile. I'm very new to this whole
> patching and code-hacking thing. I'm getting the following error
> message while making radsqlrelay: thanks f
Subject: RE: radsqlrelay for 1.0.2
Hi Bart,
On Thu, 2005-03-03 at 15:36 +0100, Bart Van Daal wrote:
> Hi Nicolas, hi Roy,
>
> Nicolas I'm currently using your radsqlrelay.c with the 1.0.2 release
> and I've patched the makefile. I'm very new to this whole patching and
. I'm getting the following error message while making radsqlrelay:
> thanks for any pointers how to compile radsqlrelay.
The patches were already committed on the current CVS. You may try
building from it. I've done some stress tests on the version and it
looks OK so far.
Regards,
Roy
Hi Nicolas, hi Roy,
Nicolas I'm currently using your radsqlrelay.c with the 1.0.2 release and
I've patched the makefile. I'm very new to this whole patching and
code-hacking
thing. I'm getting the following error message while making radsqlrelay:
thanks for any pointers how to
ROY wrote:
> > This version can be built in the 1.0.x source tree. It has been modified
> > to fix the detail file locking issue under heavy load. Since you are
> > running tests on radsqlrelay, I'd be grateful if I could receive some
> > feedback from you on this v
Hi Nicolas,
On Mon, 2005-02-21 at 19:06 +0100, Nicolas Baradakis wrote:
> You could use the following patch to build radsqlrelay in the 1.0.x
> source tree. However, you need to fix some minor compilation errors in
> radsqlrelay.c because some variables are different between the release
ROY wrote:
> anyone got a patch for 1.0.2 Makefile to be able to compile
> radsqlrelay?
You could use the following patch to build radsqlrelay in the 1.0.x
source tree. However, you need to fix some minor compilation errors in
radsqlrelay.c because some variables are different betwe
hi,
anyone got a patch for 1.0.2 Makefile to be able to compile
radsqlrelay?
thanks,
roy
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Mon, 2005-02-14 at 18:17 +0800, ROY wrote:
> i've noticed it doesn't recognize some AVPairs even when i add them to a
> custom dictionary such as the ff. Cisco AVP's:
>
> release-source
> gw-rxd-cgn
> gw-final-xlated-cgn
> remote-media-address
>
> my dictionary.custom:
> ATTRIBUTE remote
On Mon, 2005-02-14 at 11:37 +0200, Kostas Kalevras wrote:
>
> No. If you want to call modules, just use radrelay which will relay
> accounting
> records to the radius server, instead of sql.
i've noticed it doesn't recognize some AVPairs even when i add them to a
custom dictionary such as the f
On Mon, 2005-02-14 at 11:43 +0200, Kostas Kalevras wrote:
> Please recheck your detail file. You 'll also find out there's a timestamp
> attribute which signifies when the accounting record was received. Obviously,
> if
> you start radsqlrelay a few days after you 'v
On Mon, 14 Feb 2005, ROY wrote:
Hi,
I'm having a weird problem with radsqlrelay; it doesn't report the same
Acct-Delay-Time and Acct-Unique-Session-Id as with the detail file when
injecting into sql db. The attributes are defined on the dictionary and
is A/V's are present on
On Mon, 14 Feb 2005, ROY wrote:
Hi again,
Is there a way that rlm_preprocess can be called inside radsqlrelay?
No. If you want to call modules, just use radrelay which will relay accounting
records to the radius server, instead of sql.
Thanks,
Roy
-
List info/subscribe/unsubscribe? See http
Hi again,
Is there a way that rlm_preprocess can be called inside radsqlrelay?
Thanks,
Roy
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
I'm having a weird problem with radsqlrelay; it doesn't report the same
Acct-Delay-Time and Acct-Unique-Session-Id as with the detail file when
injecting into sql db. The attributes are defined on the dictionary and
is A/V's are present on the detail file.
-- query str
On Thu, 6 Jan 2005, Alan DeKok wrote:
> Dustin Doris <[EMAIL PROTECTED]> wrote:
> > Anyone know if radsqlrelay is going to be included in 1.0.2 release?
>
> I don't think so. It will be in 1.1.0, though.
>
> Alan DeKok.
>
> -
OK. Thanks for the follo
Dustin Doris <[EMAIL PROTECTED]> wrote:
> Anyone know if radsqlrelay is going to be included in 1.0.2 release?
I don't think so. It will be in 1.1.0, though.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Anyone know if radsqlrelay is going to be included in 1.0.2 release?
Thanks
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
54 matches
Mail list logo