Quick follow-up on this issue. It's resolved. I wanted to share the
resolution with the community should anyone encounter a similar issue.
One part of the equation was provided by Phil and Fajar below:
Did you read Phil's excellent reply?
( cc-ing you directly since it seems you have trouble receiving mails from
the list )
Apologies! My comcast.net account was bouncing mail from the list for
reasons unknown. I saw the bounce rating jump from 1 to 3 over the course
of this week, so I resubscribed with a proper e-mail address.
Did you read Phil's excellent reply?
http://lists.freeradius.org/pipermail/freeradius-users/2013-August/067991.html
After Fajar kindly forwarding the link to me, I was able to see the reply.
Thanks you, Fajar, and Dan as well.
s/Dan/Phil/
Please place my head in a vice and crank it shut
On Tue, Aug 27, 2013 at 8:04 PM, mdeche...@comcast.net wrote:
Hello Users --
( cc-ing you directly since it seems you have trouble receiving mails from
the list )
I'm writing again to verify whether or not my initial question submitted
to the list was seen. Is there anyone on-list who is
On 2009-Dec-07, at 06:00, Josip Rodin wrote:
Hi,
I've observed an SQL logging problem with FreeRADIUS (2.x) and
PostgreSQL
(8.1), on several different installations I occasionally get these
errors:
Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update
SQL accounting STOP
On Mon, Dec 07, 2009 at 01:16:02PM -0700, Guy Fraser wrote:
sql trace log indicates that this is the offending query:
UPDATE radacct
SET AcctStopTime = ('2009-12-07 13:19:01'::timestamp -
'6'::interval),
AcctSessionTime = CASE WHEN '' = '' THEN
(EXTRACT(EPOCH FROM ('2009-12-07
Hi,
I'd suggest changing sql_query() function in sql_postgresql.c to:
...
if (!errormsg) return -1;
...
instead of the current block of code { errormsg = FATAL ERROR }
Well I tried this change, you can see the gdb output at:
Alexander Clouter wrote:
This is a different implosion this time round to your last one. Looks
like Alan's SQL patch simply postponed the SIGSEGV to a different part
of the code. Not sure what should be done, but it looks like errorcode
also needs to be changed (probably set to NULL
Alan DeKok al...@deployingradius.com wrote:
This is a different implosion this time round to your last one. Looks
like Alan's SQL patch simply postponed the SIGSEGV to a different part
of the code. Not sure what should be done, but it looks like errorcode
also needs to be changed
Hi John,
As long as the hammer does the job. At this stage although I'm aware
that RPM packaging is much more powerful my lack of knowledge about it
doesn't allow for a more sensible approach.
Hopefully this will change time ;)
thanks,
Duarte
2009/11/12 John Dennis jden...@redhat.com:
On
Hi Alex,
Again thanks for the help.
2009/11/12 Alexander Clouter a...@digriz.org.uk:
You should also compile the whole thing with optimisations turned off
and debugging symbols in there; you are not doing the former so it might
make it more difficult to work out what is wrong:
Duarte Fonseca fonseca.dua...@gmail.com wrote:
2009/11/12 Alexander Clouter a...@digriz.org.uk:
You should also compile the whole thing with optimisations turned off
and debugging symbols in there; you are not doing the former so it might
make it more difficult to work out what is wrong:
Hi Alan,
If you could point out which specific commit(s) address this issue I
would be very grateful.
Thank you,
Duarte
2009/11/6 Alan DeKok al...@deployingradius.com:
Duarte Fonseca wrote:
Hi list,
Just checking if anyone has any more suggestions on how I should
proceed with this.
A
Duarte Fonseca wrote:
Hi Alan,
If you could point out which specific commit(s) address this issue I
would be very grateful.
$ git log src/modules/rlm_sql/drivers/rlm_sql_postgresql
...
45877bf44b02d418b6fb263a39e5de07ced58b6e
Alan DeKok.
-
List info/subscribe/unsubscribe? See
Duarte Fonseca fonseca.dua...@gmail.com wrote:
If you could point out which specific commit(s) address this issue I
would be very grateful.
One day we will persaude Alan to put something more verbose in the git
commit logs :)
Until then:
git log -p -n1
Thanks Alan and Alex,
I thought it was that one, just wanted to make sure as I gave it a
quick test and it seems the problem is still there.
I'm doing some more tests to make sure it's not me doing something
silly, I'll be in touch if I keep having problems (hopefully with gdb
and valgrind
Hi again,
So the problem seems to still be present, this is how I'm testing,
please let me know if I'm doing something wrong.
I got the redhat SRPM from
http://people.redhat.com/jdennis/freeradius-rhel-centos/src/freeradius2-2.1.7-2.el5.src.rpm
Applied the change to the source file and built
On 11/12/2009 11:38 AM, Duarte Fonseca wrote:
Hi again,
So the problem seems to still be present, this is how I'm testing,
please let me know if I'm doing something wrong.
I got the redhat SRPM from
http://people.redhat.com/jdennis/freeradius-rhel-centos/src/freeradius2-2.1.7-2.el5.src.rpm
Hi John,
The only change I did to the spec file was change the release (and
later add the --enable-developer)
What I did do was go to the SOURCES dir and unpack the
freeradius-server archive, change the file in question, pack up
freeradius-server replacing the original tar.bz2 archive.
I did
On 11/12/2009 12:28 PM, Duarte Fonseca wrote:
Hi John,
The only change I did to the spec file was change the release (and
later add the --enable-developer)
What I did do was go to the SOURCES dir and unpack the
freeradius-server archive, change the file in question, pack up
freeradius-server
Duarte Fonseca fonseca.dua...@gmail.com wrote:
So the problem seems to still be present, this is how I'm testing,
please let me know if I'm doing something wrong.
I got the redhat SRPM from
http://people.redhat.com/jdennis/freeradius-rhel-centos/src/freeradius2-2.1.7-2.el5.src.rpm
Hi Alan,
Thanks for the advice, I've tried the same test with radiusd -f and
here are the results
Some runs just produce this:
# radiusd -f
Segmentation fault
Others produce a more verbose output, hope it helps:
# radiusd -f
*** glibc detected *** radiusd: double free or corruption (fasttop):
Duarte Fonseca wrote:
I've got a freeRadius (v2.1.7) install running on CentOs using
postgresql to store accounting data and have noticed that occasionally
freeRadius seems to die unexpectedly.
See doc/bugs. You can run the server in foreground mode (radiusd -f),
too.
If it dies after a
On 08/27/2009 01:46 AM, Magui wrote:
If it is posible:
How to combine freeradius with postgresql?
How I can conect freeradius to postgres?
some one know about this or have experience?
any help will be welcome, thank you
Of course it's possible. There is existing documentation, files, and
You don't. Use unlang.
Let´s say every user-record contains information in the table
Authentication-Server (Safeword or Portwise).
update control {
Proxy-To-Realm := %{sql:SELECT...FROM Authentication-Server WHERE...}
}
Hello again.
Sorry, i am new to unlang.
Can you please provide me
You don't. Use unlang.
Let´s say every user-record contains information in the table
Authentication-Server (Safeword or Portwise).
update control {
Proxy-To-Realm := %{sql:SELECT...FROM Authentication-Server
WHERE...}
}
Can you please provide me a more precise example of unlang
OK. I just misunderstood earlier about proxy.conf.
Thank you for the answers.
Regards
Mika
--
View this message in context:
http://www.nabble.com/Freeradius%2C-PostgreSQL-and-One-Time-Password-backends-tp23996193p24183023.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
OK. So it seems to be possible.
So i start by adding the section to proxy.conf
--proxy.conf
realm Safeword {
type = radius
authhost= ip:1645
accthost= ip:1646
secret = secret
}
realm Portwise {
type = radius
mikoi wrote:
But how do i configure users file so that it does query the SQL-database?
You don't. You edit raddb/sites-available/default,
raddb/radiusd.conf, and raddb/sql.conf
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
So i start by adding the section to proxy.conf
--proxy.conf
realm Safeword {
type = radius
authhost= ip:1645
accthost= ip:1646
secret = secret
}
realm Portwise {
type = radius
authhost= ip:1645
mikoi wrote:
I am trying to replace an old Cisco Secure ACS with Freeradius.
That's always a good idea.
My idea is to use PostgreSQL as a database where all information is added
(users, nases etc), but instead of passwords i want Freeradius to ask a
backend One-Time Password system
Hello.
I´m still in the designphase of this and new to Freeradius.
Freeradius and postgresql installed on the same box. Connection through
sql.conf was my thought.
Tables in the database:
users
usergroups
Authentication-server (proxy-to server)
naslist
huntgroups (for combining aaa-clients)
For
I´m still in the designphase of this and new to Freeradius.
Freeradius and postgresql installed on the same box. Connection through
sql.conf was my thought.
The question was how does freeradius talk to authentication database.
What does it send to it and what does it get back?
Ivan Kalik
The question was how does freeradius talk to authentication database.
What does it send to it and what does it get back?
I´ll do my best to explain.
Access-Request packet from NAS/AAA-client contains:
User-Name
User-Password (One-Time-Password)
NAS-IP-Address
FreeRadius checks with SQL:
Is
mikoi wrote:
The question was how does freeradius talk to authentication database.
What does it send to it and what does it get back?
No. *Your* question was about using Safeword authentication with
FreeRADIUS. When we asked you how FreeRADIUS talked to the Safeword
system, you responded
The question was how does freeradius talk to authentication database.
What does it send to it and what does it get back?
I´ll do my best to explain.
Access-Request packet from NAS/AAA-client contains:
User-Name
User-Password (One-Time-Password)
NAS-IP-Address
FreeRadius checks with
Login attempt after setup result in error.
Please what do I do wrong?
Database connection error
Error Message: DB Error: not found
Debug: Unable to include the DB/postgresql.php file for
'postgresql://radius:radp...@127.0.0.1/radius'
That's not a freeradius error. Try daloRadius forum.
Ivan
Hi nix,
Wednesday, August 1, 2007, 2:56:13 PM, you wrote:
inserted in the database. Now the problem here is how to retrieve
the data from the database. Is there any pre-made front end of this
kind of things? I need to calculate daily/weekly/monthly voip CDR.
Daily run at 12:01 can be
trol anon wrote:
I was wondering if anyone might be able to point me in the right
direction with regard to setting up freeradius with postgres so that
each realm is authenticated out of a separate database (on the same
postgres server).
The SQL queries are configurable. Just replace the
Pe 27 Jan 2005, la 03:13, Graeme Lee [EMAIL PROTECTED] a scris:
Siderite wrote:
Hello... I am trying to make freeradius authenticate some access
packets using the output of SQL stored procedures (that eventually would
do the billing as well). Can it be done? And if yes, how?
thank you
Manda Costin wrote:
Pe 27 Jan 2005, la 03:13, Graeme Lee [EMAIL PROTECTED] a scris:
Siderite wrote:
Hello... I am trying to make freeradius authenticate some access
packets using the output of SQL stored procedures (that eventually would
do the billing as well). Can it be done? And if yes,
Siderite wrote:
Hello... I am trying to make freeradius authenticate some access
packets using the output of SQL stored procedures (that eventually would
do the billing as well). Can it be done? And if yes, how?
thank you
Give an example of what you're trying to do. I use the following for
David Young [EMAIL PROTECTED] wrote:
Hi, I'm new to the list and I was just wondering if there's some
straightforward documentation out there on how to set up freeradius with
postgresql. The only document i've found is for Oracle and even that
document doesn't explain any details about the
-
From: Alan T. DeKok [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 4:21 PM
Subject: Re: freeradius + postgresql howto
David Young [EMAIL PROTECTED] wrote:
Hi, I'm new to the list and I was just wondering if there's some
straightforward documentation out there on how
Polleunus
Sent: Tuesday, April 20, 2004 11:01 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Freeradius + PostgreSQL not working
VoipOne NOC wrote:
Hi
I have freeradius 0.9.3, compiled on a Debian Unstable system for
PostgreSQL support.
Once I installe everything, it seems to work
This is what I am using {I am not using 0.9.3, but 1.0-pre0 from CVS}
for radiusd.conf :
...snip...
modules {
...snip...
$INCLUDE ${confdir}/postgresql.conf
...snip...
}
...snip...
authorize {
preprocess
chap
mschap
suffix
eap
# 'files' can be
]
[mailto:[EMAIL PROTECTED] On Behalf Of Pascal
Polleunus
Sent: Tuesday, April 20, 2004 11:01 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Freeradius + PostgreSQL not working
VoipOne NOC wrote:
Hi
I have freeradius 0.9.3, compiled on a Debian Unstable system for
PostgreSQL
Truong Manh Cuong wrote:
Hi all,
I installed freeradius 0.93 and use postgresql. I don't know how to config radius for authorizing. it rejects all request because it use system account.
I want to config radius so that it query account in postgresql database. how to do it ?
it reported that
Try changing the Auth-type from system to local in the users file.
Jeremy
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Truong
Manh Cuong
Sent: Friday, February 13, 2004 6:20 AM
To: [EMAIL PROTECTED]
Subject: freeradius+postgresql: access-reject
Hi
49 matches
Mail list logo
