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?
>> http://lists.freeradius.org/pipermail/freeradius-u
>> 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
> ( 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
On Tue, Aug 27, 2013 at 8:04 PM, 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 able and willing
Hello Users --
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 able and willing to assist in
troubleshooting a PostgreSQL integration with FreeRADIUS? If the initial
message was not received for whatever reason, I'l
17.08.2012 15:39, Phil Mayers пишет:
See "safe-characters" in your "sql" config.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
It's work fine for me!
Regards,
Sergey Antipov
e-mail: greendayonf...@gmail.com
skype: greendayonfire
-
List info/subscribe/un
On 08/17/2012 05:28 AM, Антипов Сергей wrote:
Hi!
I use Debian Squeeze with FreeRADIUS Version 2.1.10 (2.1.10+dfsg-2) and
PostgreSQL 8.4 (8.4.12-0squeeze1).
VSA Cisco, having a sign '=' in value, like 'Cisco-AVPair =
"out-carrier-id=***"' are written to te base in bad form -
"out-carrier-id=3D*
Hi!
I use Debian Squeeze with FreeRADIUS Version 2.1.10 (2.1.10+dfsg-2) and
PostgreSQL 8.4 (8.4.12-0squeeze1).
VSA Cisco, having a sign '=' in value, like 'Cisco-AVPair =
"out-carrier-id=***"' are written to te base in bad form -
"out-carrier-id=3D***".
How to solve this problem?
--
С ува
Josip Rodin wrote:
> Alan, please apply the patch:
Applied, thanks.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Mon, Dec 07, 2009 at 11:53:45PM +0100, Josip Rodin wrote:
> On Mon, Dec 07, 2009 at 10:02:39PM +, Adrian Klaver wrote:
> > > Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update SQL
> > > accounting STOP record - ERROR: invalid input syntax for integer: ""
> > >
> > > accounti
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 ('200
On Mon, Dec 07, 2009 at 10:02:39PM +, Adrian Klaver wrote:
> > Mon Dec 7 13:19:01 2009 : Error: [ourlittle_sql] Couldn't update SQL
> > accounting STOP record - ERROR: invalid input syntax for integer: ""
> >
> > accounting_stop_query = "UPDATE ${acct_table2} \
> > SET
> > AcctSessionTim
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 re
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 record - ERROR: invalid input syntax for integer: ""
s
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:
http://dl.dropbox.com
Alan DeKok 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 ex
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 ex
Duarte Fonseca wrote:
>
> 2009/11/12 Alexander Clouter :
>
>> 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:
>>
>> CFLAGS='-O0 -g' ./config
Hi Alex,
Again thanks for the help.
2009/11/12 Alexander Clouter :
> 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:
>
> CFLAGS='-O0 -g' ./con
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 :
> On 11/12/2009 12:28 PM,
Duarte Fonseca 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
>
> Applied the change
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 re
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 thi
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
Ap
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 th
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 output
Duarte Fonseca 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 src/modules/rlm_sql/drivers/rlm_sql_postgresql/
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 http://w
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 :
> Duarte Fonseca wrote:
>> Hi list,
>>
>> Just checking if anyone has any more suggestions on how I should
>> proceed with this.
>
> A fix is in the "s
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
Hi,
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.
After some time investigating this and going over the logs I can now
reproduce this behavior easily by following these ste
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
examp
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
--
Este mensaje le ha llegado mediante el servicio de correo electronico que
ofrece Infomed para respaldar el
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.
>
> 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 exampl
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 m
> So i start by adding the section to proxy.conf
>
> --proxy.conf
> realm Safeword {
> type = radius
> authhost= :1645
> accthost= :1646
> secret =
> }
>
> realm Portwise {
> type = radius
> authhost= :1645
>
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
OK. So it seems to be possible.
So i start by adding the section to proxy.conf
--proxy.conf
realm Safeword {
type = radius
authhost= :1645
accthost= :1646
secret =
}
realm Portwise {
type = radius
authhost=
>
>
> 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
>
> FreeRadiu
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 SQL:
Is
> 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
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 e
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 (saf
Hello.
I am trying to replace an old Cisco Secure ACS with Freeradius.
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 (safeword) if a users profile contains a
value.
>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.
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'
Sunday
-
List info/subscribe/unsubscribe? See http://www.freer
Hi,
I think the 'now' (*with* quotes) in postgresql/schema.sql (table
radpostauth, field authdate) should become now() (*without* quotes).
In the old way the default date will be the fixed date from the
time the table was created, which is not the intention I presume.
In the new way the default d
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 some
Dear all,
I have successfully configured freeradius and posgtgresql sql according to doc
that is in freeradius bundle. My cisco vsa is also 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?
Yes!!! You're right
Freeradius doesn't have permission to select the tables. Now it's working
fine.
Thanks
Daniel
2007/6/29, Pshem Kowalczyk <[EMAIL PROTECTED]>:
Hi,
You haven't pasted the whole log, but judging from the following lines:
Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL
Hi,
You haven't pasted the whole log, but judging from the following lines:
Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
I suspect that freeradius can't talk to the database. Have a look at
the beginning of the debug messages, you should be able to see the
lines referring to the
Hi,
I'm using Freeradius 1.1.6 with PostgreSQL 8.1.
When I try to do #radtest joao senhasecreta 127.0.0.1:1812 0 testing123
Te radiusd (in debug mode) returns:
#rad_recv: Access-Request packet from host 127.0.0.1:32779, id=220, length=56
#User-Name = "joao"
#User-Password = "senh
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
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).
I understand that this might not be the best way to handle things, but for
hi
On Tuesday 29 March 2005 13:49, [EMAIL PROTECTED] wrote:
> Hello all,
>
> I have read a lot of docs in making the postgresql works with freeradius v
> 1.0.2 however, all my effort proves abortive.
>
> I will be glad if I can be directed to a mail on the list or docs to read
> to get freeradius work
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
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?
>>
>>
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
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
--
Siderite <[EMAIL PROTECTED]>
-
List info/subscribe/unsubscribe? See http://www
Hello,
I am trying to run pgsql-voip(version 1.01) schema on
RHAT 7.3, however I am seeing the following error :
rlm_sql (pgsql-voip): Reserving sql socket id: 6
ERROR: duplicate key violates unique constraint
"stoptelephonycombo"
I checked the database and found the following
indexes:
Indexes:
.
David
- Original Message -
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 w
"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
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 tables created by freeradius and
what
1
rlm_sql (sql): Released sql socket id: 24
Sending Accounting-Response of id 18 to 5.6.7.8:1646
I hope this will help you...
Thanks for your help!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Pascal
Polleunus
Sent: Tuesday, April 20, 2004 11:01 AM
To
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 uncommente
ECTED]
[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
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 right. Following is the final
output from "freeradius -xxyz -l stdout" :
Do you have something like this:
Module: Loaded SQL
rlm_sql (sql): Driv
Hi
I have freeradius 0.9.3, compiled on a Debian Unstable system for PostgreSQL
support.
Once I installe everything, it seems to work right. Following is the final
output from "freeradius -xxyz -l stdout" :
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to
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 all
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 rlm_uni
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 rlm_unix not found. I just comme
74 matches
Mail list logo