On 26/05/11 12:06, Pedro Costa wrote:
But my issue is that i'm not able to authenticate (regardless of the
IMSI - No database query is required for this) and execute the SQL XLAT
being (the SQL SELECT that will get the IP Pool name for the specific IMSI).
Why not? Be specific. Tell us what you
Hi,
I'm currently trying to implement an authorization process only, between a
Cisco GGSN and Freeradius.
My idea is for the freeradius to authenticate regardless of the MS (IMSI)
and after authentication it Queries a Postgresql Database based upon IMSI to
get the IP Pool that he will be used.
O
advice
is welcome.
t.
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/freeradius-radacct-table-postgres-tablespace-per-year-tp4393180p4393180.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http
: Thursday, October 15, 2009 3:45 PM
To: FreeRadius users mailing list
Subject: Re: Postgres
On 10/15/2009 09:17 AM, Sparkes, David wrote:
> Hi again,
>
> Ok... well I have created the tables using
> /etc/raddb/sql/postgresql/schema.sql and populated the tables
manually.
>
> However
On 10/15/2009 09:17 AM, Sparkes, David wrote:
Hi again,
Ok... well I have created the tables using
/etc/raddb/sql/postgresql/schema.sql and populated the tables manually.
However no postgresql.conf file exists in either
/etc/raddb/sql/postgresql or /etc/raddb/postgresql. Have I missed a
packag
.org] On Behalf Of John Dennis
Sent: Thursday, October 15, 2009 2:35 PM
To: FreeRadius users mailing list
Subject: Re: Postgres
On 10/15/2009 07:01 AM, Alan DeKok wrote:
> Sparkes, David wrote:
>> I was working through the example to set up PostGres; I just was
thrown
>> when
On 10/15/2009 07:01 AM, Alan DeKok wrote:
Sparkes, David wrote:
I was working through the example to set up PostGres; I just was thrown
when I tried to set up the database ("Setting up the RADIUS database"
section), as I reached these lines:
cd /usr/share/doc/packages/freeradius/do
Sparkes, David wrote:
> I was working through the example to set up PostGres; I just was thrown
> when I tried to set up the database ("Setting up the RADIUS database"
> section), as I reached these lines:
>
> cd /usr/share/doc/packages/freeradius/doc/examples
Hi again,
Radius works fine. I've been using it for a few weeks with no hitches.
I was working through the example to set up PostGres; I just was thrown
when I tried to set up the database ("Setting up the RADIUS database"
section), as I reached these lines:
cd /usr/sha
Hi,
> Sorry, I should clarify. I have spent some time looking through the
> docs including, http://wiki.freeradius.org/SQL_HOWTO, but that is the
> wrong version of FreeRadius (1.1.7) and doesn't work.
had a quick look through - seems to be reasonbly fine - which bit didnt work?
whats your issu
From:
freeradius-users-bounces+david.sparkes=keymile@lists.freeradius.org
[mailto:freeradius-users-bounces+david.sparkes=keymile@lists.freerad
ius.org] On Behalf Of Vegard Svanberg
Sent: Thursday, October 15, 2009 11:31 AM
To: FreeRadius users mailing list
Subject: Re: Postgres
* Sparkes,
th SQL (postgres, mysql, oracle or mssql). you will need to
apply this schema to your SQL - after creating a suitable user and database
for it. then you need to configure the relevant $raddb/sql/* stuff and
add the required bit to $raddb/sql.conf once you have configured
the SQL, you can then add i
* Sparkes, David [2009-10-15 11:21]:
> I would like to get Freeradius working with a PostgreSQL database: are
> there any handy HOWTOs or Tutorials that explain how to do this?
It's pretty easy, just study the docs and sample configs.
Just a warning: You might run into the same problem as me, s
Hi,
I would like to get Freeradius working with a PostgreSQL database: are
there any handy HOWTOs or Tutorials that explain how to do this?
I am running RedHet EL5.
Relevant Packages:
freeradius2.x86_64 2.1.7-2.el5
installed
freeradius2-libs.x86_64 2.
Hi all,
i’m sperimenting a strange problem using freeradius.
We have a full installation on freeradius 2.1.1 using postgreSql 8.1 running
onto 2 different machines.
The auth work fine 8we have tested it for two days with a killer script that
tests in continuously) but if the proxy stops sending
Hi,
> Add a "server" column to the schema, or to the query, with NULL value.
didnt work. as hinted at, rlm_sql now has a num_fields thing
to see if you've used 5 or 6 rows. if you use 5, you're normal,
if you've used 6 then the new field is the virtual server.
hmmmtoo dumb really, but I'll
ror: sql_postgresql: calling unimplemented
> function
There is no "sql_num_rows" function in postgres, which is needed by
the NAS initialization routines. I guess it should be added.
see: ... numfields = PQnfields(pg_sock->result)
in the "query" routine. Maybe
rving sql socket id: 9
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: query affected rows = 39 , fields = 5
rlm_sql (xbase): Read entry
nasname=127.0.0.1,shortname=localhost,secret=topsecretstuff
sql_postgresql: calling unimplemented function
this is postgres 8.1.11 - no chan
hi,
I wonder how many of you have needed to change the
postgres schema for radacct table - the default
value of VARCHAR(32) for the AcctSessionId seems
to be very low - our user-names are often that long
by themselves! (domain and full path when using
machine auth for example) I've submit
delay int8,
acctstopdelay int8, nasidentifier varchar(40), clientipaddress inet,
CONSTRAINT radacct_pkey PRIMARY KEY (acctuniqueid, radacctid))
> Date: Fri, 14 Mar 2008 03:38:52 -0700> From: [EMAIL PROTECTED]> To:
> freeradius-users@lists.freeradius.org> Subject: Postgres SQL Alar
x27;t insert SQL
accounting START record - ERROR: duplicate key violates unique constraint
"radacct_acctuniqueid_key"
But, in any case all such start records are put to database.
How I cat stop put such duplicate records?
--
View this message in context:
http://www.nabble.com/Postgr
rs-bounces+ben=wisper-
> [EMAIL PROTECTED] [mailto:freeradius-users-
> [EMAIL PROTECTED] On Behalf Of
> Baltazar Ruiz
> Sent: Thursday, December 27, 2007 12:27 PM
> To: freeradius-users@lists.freeradius.org
> Subject: Freeradius + Postgres not working with init.d script
>
>
Baltazar Ruiz wrote:
> My problem is that when I execute:
>
>radiusd -sxxx
>
> everything runs fine,
It doesn't change UID's, because it's running in debugging mode.
> Error: rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server
> [EMAIL PROTECTED]:database
> Error: rlm_sql_pos
Hello everyone,
I'm running:
Freeradius 1.1.3 + Postgresql Version: 8.1.9, Release: 1.el5 on CentOS 5
My problem is that when I execute:
radiusd -sxxx
everything runs fine, but, when I execute:
/etc/init.d/radiusd start
I get the following error:
Error: rlm_sql_postgresql: Couldn't co
On Fri 13 Jul 2007, Hugh Messenger wrote:
> Peter Nixon said:
> > Yep. This was something I added a couple of years ago because I realised
> > that
> > my report database was spending half of its time recalculating the the
> > Session Time every time the report was rerun. Its much more efficient to
Peter Nixon said:
> Yep. This was something I added a couple of years ago because I realised
> that
> my report database was spending half of its time recalculating the the
> Session Time every time the report was rerun. Its much more efficient to
> do
> it once, and then just set the delay time t
On Fri 13 Jul 2007, Hugh Messenger wrote:
> Something I noticed whilst comparing the postgres and mysql rlm_sql
> configs is that when postgres sets an AcctStartTime or AcctStopTime, it
> figures in the delay time, whereas the mysql queries don't.
Yep. This was something I added a c
Something I noticed whilst comparing the postgres and mysql rlm_sql configs
is that when postgres sets an AcctStartTime or AcctStopTime, it figures in
the delay time, whereas the mysql queries don't.
For example, in accounting_stop_query, postgres has:
AcctStopTime = (now() - '%{
Santiago Balaguer García wrote:
> I have several roaming agreements and usually add a new entry in
> proxy.conf file when I sign a new one. I realize that I my DB about
> radius appears the /realms/ table. Do you know it this table is useful?
> Can I put my realm from /proxy.conf/ file to /realm/
Hi people,
I have several roaming agreements and usually add a new entry in proxy.conf file when I sign a new one. I realize that I my DB about radius appears the realms table. Do you know it this table is useful? Can I put my realm from proxy.conf file to realm table?
Thanks,
Sorry forget to add
If some one has sample database insert and configuration for server and client
please send me
--- Ibrar Ahmed <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am a newbie in radius installation/configuration. I want to setup my radius
> client / server so
> I
> can authenticate/au
Hi,
I am a newbie in radius installation/configuration. I want to setup my radius
client / server so I
can authenticate/authorize a user name/password from postgresql database in
plain text. For client
I am using radexample.c file..
--ibrar
__
m_sql (auth): Released sql socket id: 0
Sending Access-Reject of id 39 to 165.146.6.102 port 2323
That is, both request went to the same socket (and thus postmaster
backend).
I would suggest bumping the logging on postgres and seeing if you can
determine why a query against the same ba
ed sql socket id: 0
Sending Access-Reject of id 39 to 165.146.6.102 port 2323
That is, both request went to the same socket (and thus postmaster backend).
I would suggest bumping the logging on postgres and seeing if you can
determine why a query against the same backend, on the same conn
en running radiusd
-X. Before I show these, let me tell you my setup:
(1) Using freeradius 1.1.4 now (was using 1.1.3 when I first posted on
the forumn)
(2) Using Postgres 8.2
I should also mention that since my last email, we have totally
reinstalled the whole system. Another interesting thing to
Jack Allan wrote:
>> If in postgressql.conf, I set num_sql_socks to a number x, then when I
> run NTRadPing (or any other Radius client), I am only able to
> successfully authenticate a user x times. After this, rlm_sql gives up
> the ghost (at least I think???) and I need to restart the freeradius
Hi To All
If in postgressql.conf, I set num_sql_socks to a number x, then when I
run NTRadPing (or any other Radius client), I am only able to
successfully authenticate a user x times. After this, rlm_sql gives up
the ghost (at least I think???) and I need to restart the freeradius
server for
"Gregory J. Marsh" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED],FreeRadius users mailing
list
To: "'FreeRadius users mailing list'"
Subject: RE: FreeRADIUS and Postgres annoyance
Date: Tue, 8 Aug 2006 11:24:24 -0400
I have the nas table working. Her
On 8 Aug 2006, at 18:02, Dennis Skinner wrote:
Or always run your test queries as the user that FR is using and from
the FR machine instead of root and/or from localhost.
I would have done that, except I've made my own package which only
contains the minimum postgres stuff needed
Joe Warren-Meeks wrote:
>
> Sorry guys, my fault.. mainly permissions problems on the relevant
> tables in postgres.
>
> Although I haven't got the nas table working yet though, so pointers
> there will help..
>
> (moral of the story, tcpdump -w out.dmp -A
06 9:53 AM
To: FreeRadius users mailing list
Subject: Re: FreeRADIUS and Postgres annoyance
Sorry guys, my fault.. mainly permissions problems on the relevant
tables in postgres.
Although I haven't got the nas table working yet though, so pointers
there will help..
(moral of the story, t
Joe Warren-Meeks wrote:
(moral of the story, tcpdump -w out.dmp -A -nvi eth0 -s0 port 5432 plus
ethereal is a good thing.)
Agreed, but you can make this a bit simpler by using tethereal.
josh.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Sorry guys, my fault.. mainly permissions problems on the relevant
tables in postgres.
Although I haven't got the nas table working yet though, so pointers
there will help..
(moral of the story, tcpdump -w out.dmp -A -nvi eth0 -s0 port 5432
plus ethereal is a good thing.)
-
radiusd: FreeRADIUS Version 1.1.2, for host , built on Jul 27 2006 at
16:42:40
Linux auth2 2.6.15-23-server #1 SMP Tue May 23 15:10:35 UTC 2006 i686
GNU/Linux
Hey there,
I had radiusd working nicely with MySQL, but apparently we have to
use Postgres, which is fine.. Recompiled it with
Anyone seen this?
I'm getting some strange errors from postgres, it's almost as if my
queries aren't filled in the whole way.
What am I missing? Is my switch just not returning all of the proper
accounting info?
-Bob
--- Walking the entire request list ---
Cleaning up
doesn't anyone use this kind of setup?
André Lemos wrote:
a bit more information:
radius_xlat: 'SELECT radgroupreply.id, radgroupreply.GroupName,
radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM
radgroupreply,usergroup ??WHERE usergroup.Username = 'user2' AND
a bit more information:
radius_xlat: 'SELECT radgroupreply.id, radgroupreply.GroupName,
radgroupreply.Attribute, ??radgroupreply.Value, radgroupreply.Op ??FROM
radgroupreply,usergroup ??WHERE usergroup.Username = 'user2' AND
usergroup.GroupName = radgroupreply.GroupName ??ORDER BY
radgrouprep
Hi,
I'm sorry to be bothering you, but I'm having a strange problem with
this combo.
I am using freeradius 1.0.5 and have the following user:
radius=# select * from radcheck order by id;
id | username | attribute | op | value
+--+-++-
10 | use
Hi,
I'm sorry to be bothering you, but I'm having a strange problem with
this combo.
I am using freeradius 1.0.5 and have the following user:
radius=# select * from radcheck order by id;
id | username | attribute | op | value
+--+-++-
10 | use
On Thu, 2005-08-12 at 15:57 -0500, Brian A. Seklecki wrote:
> On Wed, 7 Dec 2005, leunam atebro wrote:
>
> > I am new to this freeradius server, can you give me
> > some idea on how to authenticate freeradius in a
> > postgres database? Also, I need sample configurat
On Wed, 7 Dec 2005, leunam atebro wrote:
I am new to this freeradius server, can you give me
some idea on how to authenticate freeradius in a
postgres database? Also, I need sample configuration
Working, tested, proven sample configuration files are [what this project
is in] in desperate
I am new to this freeradius server, can you give me
some idea on how to authenticate freeradius in a
postgres database? Also, I need sample configuration
to test the server. My NAS client is CISCO(2500) with
11.3 IOS.
Help is highly appreciated..
Thank you...
Nuel
Hi, how can i configure freeradius to use unix sockets instead of tcp
when using postgres for backend?
thanks
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Joel Bjerk <[EMAIL PROTECTED]> wrote:
> I managed to get freeradius to use the nas table (from postgres) but I
> had to load the SQL module from the 'authorize' section of radiusd.conf.
> What I would like to do is load the SQL module for the reading of the
> nas t
I managed to get freeradius to use the nas table (from postgres) but I
had to load the SQL module from the 'authorize' section of radiusd.conf.
What I would like to do is load the SQL module for the reading of the
nas table only. Is this possible?
On Fri, 2005-10-14 at 11:30 -0400, Gun
Yes, it is possible, at least in 1.0.5. My nas list is in MySQL. The DB
table columns are in a fixed sequence and referred by
position and not by name. The nas identifier must be either a DNS
resolvable name or IP address or
IP Address/netmask, e.g. 200.100.100.0/255.255.255.0.
I only have 'clie
Joel Bjerk <[EMAIL PROTECTED]> wrote:
> Is it possible to use the nas table for client information instead of
> clients.conf? I tried uncommenting readclients=yes in sql.conf but the
> server read the clients from clients.conf.
It should work in 1.0.5.
Alan DeKok.
-
List info/subscribe/unsu
Is it possible to use the nas table for client information instead of
clients.conf? I tried uncommenting readclients=yes in sql.conf but the
server read the clients from clients.conf.
Thanks,
Joel
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Mon, 2005-19-09 at 15:31 +0100, Mark Olliver wrote:
> Hi All,
>
> I am looking at using a postgres database as the backend storage system for
> freeradius and I think I have this part configured correctly. Does anyone
> have
> any scripts for creating simple user a/c&#
Hi All,
I am looking at using a postgres database as the backend storage system for
freeradius and I think I have this part configured correctly. Does anyone have
any scripts for creating simple user a/c's into the database?
The second more important thing is that I want to use P
- Original Message -
From: Santiago Balaguer García
To: freeradius-users@lists.freeradius.org
Sent: Wednesday, July 20, 2005 7:37 PM
Subject: Postgres problem
I am migrating mu MySQL DB to Postgres. My authentication ios OK, but the
accounting query insertion fails with the following
I am migrating mu MySQL DB to Postgres. My authentication ios OK, but the accounting query insertion fails with the following error:
rlm_sql_postgresql: Status: PGRES_FATAL_ERRORrlm_sql_postgresql: affected rows =rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
Алексей В. Лабута wrote:
How can I using postgres NAS table?
I not found info about this :(
rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql:
/*
* Table structure for table 'nas'
* This is not currently used by FreeRADIUS but is usefull for reporting
* anyway.
*/
CREATE
Hi All!
How can I using postgres NAS table?
I not found info about this :(
My ware is:
ibm x335
suse 9.3
freeradius 1.0.2
postgres 8.0.3
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Saturday 14 May 2005 04:18, Graeme Lee wrote:
> Stefano Martini <[EMAIL PROTECTED]> wrote:
> >Hi all,
> >I'm using freeradius-1.0.2 on a debina 3.1 i386 platform with
> >gcc-3.3.5.
> >I compiled the radius server, without errors, and want to use
>
On Sat, 14 May 2005 12:18:22 +1000
Graeme Lee <[EMAIL PROTECTED]> wrote:
> Stefano Martini <[EMAIL PROTECTED]> wrote:
>
> >Hi all,
> >I'm using freeradius-1.0.2 on a debina 3.1 i386 platform with
> >gcc-3.3.5.
> >I compiled the radius server
[EMAIL PROTECTED] wrote:
> Stefano Martini <[EMAIL PROTECTED]> wrote:
>
>> When I start the radiusd (with -X) I get a segmentation fault
>> error:
>> By using gdb I found the error is in file libltdl/ltdl.c at line
>> 3330.
Can you post the error message?
Pos
Stefano Martini <[EMAIL PROTECTED]> wrote:
Hi all,
I'm using freeradius-1.0.2 on a debina 3.1 i386 platform with
gcc-3.3.5.
I compiled the radius server, without errors, and want to use
a postgres database for authentication.
Did you have the postgres libraries and include files i
Hi all,
I'm using freeradius-1.0.2 on a debina 3.1 i386 platform with
gcc-3.3.5.
I compiled the radius server, without errors, and want to use
a postgres database for authentication.
The tables of the database have been created with the file
modules/rlm_sql/drivers/rlm_sql_postg
wrote:
> > I am using Freeradius 1.0.0 on Redhat Enterprise 3 I also have it
> > installed on Suse 9.2. I am connecting to Postgres 7.4.6. I can
> > authenticate to a users file. But when I try to use radcheck in
> > postgres I get login incorrect. I am trying to upgrade fr
I appreciate the quick response.
Thanks
Kevin
At 05:12 PM 1/21/2005, you wrote:
On Fri, 2005-21-01 at 13:52 -0800, [EMAIL PROTECTED] wrote:
> I am using Freeradius 1.0.0 on Redhat Enterprise 3 I also have it
> installed on Suse 9.2. I am connecting to Postgres 7.4.6. I can
> authenti
Dear folks,
Just wondering if someone can help me. I'm using freeradius 1.01 and
Postgres 7.4.5 for accounting. (On Fedora Core2)
The NAS is a VoIP SIP server. I've tested everything works fine with flat
file, but when I used postgres, I get a segmentation fault and radius server
d
On Mon, Oct 25, 2004 at 01:31:06PM +1000, Tech wrote:
> Does anybody have a modified .rules file for building a 1.0.1 .deb with
> Postgres support? Thanks in advance.
You'll find one in the freeradius 1.0.1 release on the FreeRADIUS
website.
--
Paul "TBBle" Hampson,
Does anybody have a modified .rules file for building a 1.0.1 .deb with
Postgres support? Thanks in advance.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Kostas Kalevras wrote:
> Please also include the updated nas table info. Also it would be
> better to move this to freeradius-devel. Thanks for your efforts in
> any case though.
>
> ps=It would be even nicer to open a bug report for these patches.
For postgresql, I've sent to devel list for bug 1
"Thor Spruyt" <[EMAIL PROTECTED]> wrote:
> Someone asked to supply patches, so I did... but they've never been applied.
I also asked you to submit the patches on bugs.freeradius.org.
I don't know why you're not doing that.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.fre
On Sun, 10 Oct 2004, Thor Spruyt wrote:
> Hi,
>
> Someone asked to supply patches, so I did... but they've never been applied.
>
> So here they are again:
>
> For Postgres:
> http://www.thor-spruyt.com/new-rlm-sql-db_postgresql-sql.diff
> http://www.thor-s
I had been using freeradius 0.9.3 for a while and now
for a larger deployment I am choosing pre3 with
postgres option. However, there are some discrapencies
I have noticed while I wanted to build it with
pgsql-voip with cisco vsa hack.
The database schema provided on
src/billing/cisco_xxx.sql file
Hiya
have been getting a few odd errors since we started directing Cisco
accounting traffic to freeradius and using postgres.
I am seeing error message:
Tue Jun 8 16:51:46 2004 : Error: rlm_sql (sql): failed after re-connect
Tue Jun 8 16:51:46 2004 : Error: rlm_sql (sql): Couldn&#
79 matches
Mail list logo
