Hi,
I'm new to Freeradius and i am trying to figure a way to use Freeradius to
Authenticate a user through a CISCO GGSN in where the GGSN will send the
IMSI to the Freeradius and the Freeradius will connect to a Postgresql DB
doing a SELECT on 2 tables and will receive a Language that the
On 24/05/11 13:44, Pedro Costa wrote:
Hi,
I'm new to Freeradius and i am trying to figure a way to use Freeradius
to Authenticate a user through a CISCO GGSN in where the GGSN will send
the IMSI to the Freeradius and the Freeradius will connect to a
Postgresql DB doing a SELECT on 2 tables and
Okay so I disabled the sql feature completely, actually I only need sort of a
proof-of-concept to measure some packets.
my /etc/freeradius/dictionary contains now these two custom attributes:
ATTRIBUTE Printing-Service-Name 3001string
ATTRIBUTE Printing-Color
On 21/01/11 11:58, slash13 wrote:
Okay so I disabled the sql feature completely, actually I only need sort of a
proof-of-concept to measure some packets.
As Alan says, this is a pretty expert use of RADIUS. You're essentially
defining a new use of the protocol, and lots of big companies get
thanks mr mayers, i think you explained that very well since i am neither an
expert on linux or c++ =)
actually my goal was to compare the accounting feature of RADIUS(freeradius)
to a protocol called LIFPEAR (Lightweight and Flexible Protocol to Exchange
Accounting Records) which I have
slash13 wrote:
thanks mr mayers, i think you explained that very well since i am neither an
expert on linux or c++ =)
The dictionaries are documented in raddb/dictionary, and man
dictionary. This includes explicit comments that attribute 3000 can't
go into a packet.
actually my goal was to
hello freeradius users
I managed to install freeradius together with a working postgresql database.
Does anybody know what would be the easiest way to add custom accounting
attributes both in configuration and database? So far I couldnt find any
fast solution!
looking forward hearing from you.
Are you talking about attribute sent by your NAS that are not included
in the default database template?
If so it's quite easy:
- Ensure attributes exist in a dictionnary
- Edit your database to create a field to store the attribute values
- Edit the $raddb/sql/postgresql/dialup.onf (or
On 20/01/11 16:16, slash13 wrote:
hello freeradius users
I managed to install freeradius together with a working postgresql database.
Does anybody know what would be the easiest way to add custom accounting
attributes both in configuration and database? So far I couldnt find any
fast solution!
okay let me explain a little bit more, I want to set up a scenario where for
example a printing service gets accounted.
i need to add custom attributes e.g. Printing-Service-Name or Printing-Color
or Printing-Pages etc. to freeradius. in which specific dictionary do i need
to add these
slash13 wrote:
okay let me explain a little bit more, I want to set up a scenario where for
example a printing service gets accounted.
i need to add custom attributes e.g. Printing-Service-Name or Printing-Color
or Printing-Pages etc. to freeradius. in which specific dictionary do i need
to
Just E. Mail wrote:
I have setup a working freeRADIUS server now want to add PostgreSQL as
backend for storage of data. I have read the freeRADIUS documentation
and researched the internet on this subject.
What I am looking for is any kind of Step-by-Step document detailing
sequential
Hi,
What I am looking for is any kind of Step-by-Step document detailing
sequential steps needed to setup a PostgreSQL back end for freeRADIUS.
Has someone written such a document? Is there such a writeup available?
just to reiterate Alans comments - the config file is self documenting.
I have setup a working freeRADIUS server now want to add PostgreSQL as
backend for storage of data. I have read the freeRADIUS documentation
and researched the internet on this subject.
What I am looking for is any kind of Step-by-Step document detailing
sequential steps needed to setup a
Hi,
On following the messages; this is what I get from running freeradius -X
but before point it to PostgreSQL it runs fine.
snip
rlm_sql (sql): Could not link driver rlm_sql_postgresql:
rlm_sql_postgresql.so: cannot open shared object file: No such file or
directory
rlm_sql (sql):
rlm_sql (sql): Could not link driver rlm_sql_postgresql:
rlm_sql_postgresql.so: cannot open shared object file: No such file or
directory
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the
search path of your system's ld.
radiusd.conf[11]: sql: Module instantiation
I install the freeradius from the Ubuntu repo.
With mysql support (freeradius-mysql)?
Ivan Kalik
Kalik Informatika ISP
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
: FreeRadius with Postgresql (a.l.m.bu...@lboro.ac.uk)
2. Re: MacOS X Leopard version of FR crashing with segmentation
fault (Alan DeKok)
3. Re: freeradius and mikrotik auth problem pppoe error 691
(t...@kalik.net)
4. Re: Adding users in the database from a client computer
(t
Hi,
I install the freeradius from the Ubuntu repo.
yep - and as explained in my message, you didnt install
all the required freeradius packages that ubuntu give you,
for example
http://packages.ubuntu.com/hardy/freeradius-postgresql
apt-get install freeradius-postgresql
..and for other
-requ...@lists.freeradius.org
You can reach the person managing the list at
freeradius-users-ow...@lists.freeradius.org
When replying, please edit your Subject line so it is more specific
than Re: Contents of Freeradius-Users digest...
Today's Topics:
1. Re: FreeRadius with Postgresql
Please link me to a resources on how to make FreeRadius to work with postgreSQL
on Ubuntu 8.04 LTS?
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Please link me to a resources on how to make FreeRadius to work with
postgreSQL on Ubuntu 8.04 LTS?
-
You configure raddb/sql.conf. And create the database with scripts in
raddb/sql/postgresql/. Then uncomment sql where you need it (authorize,
accounting, session, ...) in
Please link me to a resources on how to make FreeRadius to work with
postgreSQL on Ubuntu 8.04 LTS?
You configure raddb/sql.conf. And create the database with scripts in
raddb/sql/postgresql/. Then uncomment sql where you need it (authorize,
accounting, session, ...) in
I am currently looking into testing freeradius and started reading a couple
of wiki/doc/man pages on the subject and ended on that SQL_HOWTO page. One
of the prerequisite is to already have the NAS configured. Do you have any
suggestion for a NAS running on a linux box ?
radtest is installed
Hi,
Please link me to a resources on how to make FreeRadius to work with
postgreSQL on Ubuntu 8.04 LTS?
follow the usual MySQL/SQL stuff - just use postgres instead -
ie
1) install postgres
2) configure postgres
3) install FreeRADIUS with postgres support
4) configure FreeRADIUS
part 4
Please come back later and tell us your experience with postgre.. :)
On Tue, Mar 17, 2009 at 12:34 PM, t...@kalik.net wrote:
I am currently looking into testing freeradius and started reading a
couple
of wiki/doc/man pages on the subject and ended on that SQL_HOWTO page. One
of the
t...@kalik.net пишет:
rlm_sql (sql): sql_set_user escaped user -- 'testo'
expand: UPDATE radippool SET nasipaddress = '', pool_key = 0,
callingstationid = '', expiry_time = 'now'::timestamp(0) - '1
second'::interval # WHERE nasipaddress = '%{NAS-IP-Address}' # AND
pool_key =
Hello,
I have an error:
freeradius -X
...
rlm_sql (sql): sql_set_user escaped user -- 'testo'
expand: UPDATE radippool SET nasipaddress = '', pool_key = 0,
callingstationid = '', expiry_time = 'now'::timestamp(0) - '1
second'::interval # WHERE nasipaddress = '%{NAS-IP-Address}' #
Hello,
After configuring FreeRADIUS to use PostgreSQL, and adding a user
to the database, when doing a radtest for that user I see with
radiusd -X:
modcall[authorize]: module sql returns ok for request 2
modcall: group authorize returns ok for request 2
rad_check_password: Found Auth-Type
: FreeRADIUS with PostgreSQL fails to authenticate
Hello,
After configuring FreeRADIUS to use PostgreSQL, and adding a user to the
database, when doing a radtest for that user I see with radiusd -X:
modcall[authorize]: module sql returns ok for request 2
modcall: group authorize returns ok
On Sun, Nov 04, 2007 at 10:44:11PM -, Ivan Kalik wrote:
There is a DEFAULT entry setting Auth-Type System in users file. Comment it
out.
Thanks, it works now!
--
--Jos Vos [EMAIL PROTECTED]
--X/OS Experts in Open Systems BV | Phone: +31 20 6938364
--Amsterdam, The
as simple as that.
-Original Message-
From:
[EMAIL PROTECTED]
org
[mailto:[EMAIL PROTECTED]
eradius.org] On Behalf Of Alan DeKok
Sent: 28 November 2006 16:53
To: FreeRadius users mailing list
Subject: Re: Unable to authenticate freeradius using PostgreSQL
Ross McOwat [EMAIL PROTECTED] wrote
PROTECTED]
org
[mailto:[EMAIL PROTECTED]
eradius.org] On Behalf Of Ross McOwat
Sent: 29 November 2006 10:53
To: FreeRadius users mailing list
Subject: RE: Unable to authenticate freeradius using PostgreSQL
OK, I've made progress. I now appear to be connecting to my Postgres
database, as I'm
On Wednesday 29 November 2006 05:52, Ross McOwat wrote:
radius_xlat: 'SELECT id, UserName, Attribute, Value, Op
#?authorize_check_query = '
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op
#?authorize_check_query =
]
eradius.org] On Behalf Of Kevin Bonner
Sent: 29 November 2006 16:16
To: FreeRadius users mailing list
Subject: Re: Unable to authenticate freeradius using PostgreSQL
On Wednesday 29 November 2006 05:52, Ross McOwat wrote:
radius_xlat: 'SELECT id, UserName, Attribute, Value, Op
On Wednesday 29 November 2006 10:36, Ross McOwat wrote:
All sorted!
I copied a fresh-install postgresql.conf file from another server, and
bingo, all is working fine. Must have made a mistake while editing this
file - note to self, make copies of the file BEFORE editing it!
Thanks for
Hello all,
I'm running freeradius-1.0.1-3.RHEL4, and trying to authenticate using
postgresql-7.4.8-1.RHEL4.1. My freeradius daemon loads with no
problems, and everything appears ready-to-go. However I cannot
authenticate against data stored in my Postgres database. My database
is setup as
On Tuesday 28 November 2006 11:00, Ross McOwat wrote:
Other tables are empty. Running freeradius in debug mode, the following
output is given when attempting an authentication request using
NTRadPing:
That output is very brief for debug mode. You are using the -X flag, right?
If not, do so
is starting to hurt now!
Ross
-Original Message-
From:
[EMAIL PROTECTED]
org
[mailto:[EMAIL PROTECTED]
eradius.org] On Behalf Of Kevin Bonner
Sent: 28 November 2006 16:40
To: FreeRadius users mailing list
Subject: Re: Unable to authenticate freeradius using PostgreSQL
On Tuesday 28
Ross McOwat [EMAIL PROTECTED] wrote:
rlm_sql (sql): sql_set_user escaped user -- 'ROSStest4'
radius_xlat: ''
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql (sql): SQL query error; rejecting user
It looks like you haven't configured the SQL queries needed by the
server. The radius_xlat
On Tuesday 28 November 2006 11:53, Ross McOwat wrote:
Hi Kevin,
I am running debug with the -X flag - in this instance, I only included
the output I thought relevant (probably a mistake). Complete output
from the radius authentication request (with 3 attempts set) is as
follows:
Hi all
I have a couple of questions that I hope you guys can answer:
I have to use radius for a prepaid solution. The soft switch is going to
send radius authentication
messages and accounting messages. My idea is to use FreeRADIUS with
PostgreSQL. So my first question is
if that's a good idea
Good morning!
I have successfully configured freeradius server with using postgresql database
to storage users which i want to authenticate.
when i put it in debug mode to test he works well. But when I run it as deamon
the server radius don't see the postgresql server. In the radius's log
On Mon, 2005-26-09 at 11:22 +0100, [EMAIL PROTECTED] wrote:
Good morning!
I have successfully configured freeradius server with using postgresql
database
to storage users which i want to authenticate.
when i put it in debug mode to test he works well. But when I run it as deamon
the
and in the /etc/raddb directory the postgresql.conf file does not
contain this setting.
Are you using the correct configuration file?
My freeRADIUS server uses postgreSQL for Authentication/Accounting fine
and the postgresql.conf file looks very similar to the sql.conf and
mssql.conf and nothing like
PROTECTED] On Behalf Of
Shepherd, Dave
Sent: 15 June 2005 09:41
To: FreeRadius users mailing list
Subject: RE: FreeRadius and PostgreSQL configuration question
How much max_connections we should configure in a postgresql.conf
file?
[DLS ] I can't find this setting in the postgresql.conf file
-
From: [EMAIL PROTECTED]
[mailto:freeradius-
[EMAIL PROTECTED] On Behalf Of NECTIS NetVoice Sales
Sent: 15 June 2005 13:30
To: 'FreeRadius users mailing list'
Subject: RE: FreeRadius and PostgreSQL configuration question
You look wrong configurations.
That file you look is a Postgres
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Shepherd, Dave
Sent: 15 June 2005 15:13
To: FreeRadius users mailing list
Subject: RE: FreeRadius and PostgreSQL configuration question
Sorry, my mistake.
Mine is set to the default (32) and works fine
Dear Gurus!
We try to install Freeradius with PostgreSQL but got question
We expect about 100 concurrent calls and our switch sent 3 requests to
radius: Authorization, accounting start and accounting stop or update.
How much max_connections we should configure in a postgresql.conf file
Title: Freeradius with postgresql (Login incorrect)
Hi, all
I am trying to configure postgresql 7.4 as a backend of freeradius server.
After I run radtest radius radius 47.135.23.217 1812 testing123 The debug file shows:
rad_recv: Access-Request packet from host 47.135.123.217:32782
Brian Gao [EMAIL PROTECTED] wrote:
Login incorrect: [radius/radius] (from client 47.135.123.0 port 1812)
So... the password is wrong.
This looks to me like the connection is established already, the
error that is being thrown looks like it is coming from the
PostgreSQL.
No. It's coming
Title: Freeradius with postgresql (Login incorrect)
Please send mail in PLAIN TEXT!
I don't know where YOU see an error message, but I
don't see any.
I would suggest turning SQL traces on (see
postgresql.conf)
--Groeten, Regards, Salutations,
Thor SpruytM: +32 (0)475 67 22 65E: [EMAIL
Title: Integrating with freeradius and postgresql.
Just wondering if anyone has done integrating with freeradius and postgresql?
Brian
Brian Gao [EMAIL PROTECTED] wrote:
Just wondering if anyone has done integrating with freeradius and
postgresql?
IIRC, the docs talk about doing just that. Have you examined them?
Jim
--
Note: My mail server employs *very* aggressive anti-spam
filtering. If you reply to this email
Title: Integrating with freeradius and postgresql.
Where I can get this IIRC?
Thanks
Brian
Brian Gao [EMAIL PROTECTED] wrote:
Where I can get this IIRC?
Um... *cough* IIRC == If I Recall Correctly
Thanks
You're welcome.
Jim
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
'
Sent: Friday, April 01, 2005 7:43 PM
Subject: Integrating with freeradius and postgresql.
Just wondering if anyone has done integrating with freeradius and
postgresql?
Brian
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
I have installed freeRadius 1.0.1 with postgresql to receive accounting from
a cisco 2600.
When freeradius receive accounting from the cisco router I have an error and
I see that this error have already be reported to this mailing list but I
dont see the solution.
Thanks for help
Laurent
and linked
Tue Mar 30 01:47:47 2004 : Info: rlm_sql (sql): Attempting to connect to
[EMAIL PROTECTED]:/pnixon
So this is not the problem.
--- Jrme Warnier [EMAIL PROTECTED] wrote:
We are trying to set up FreeRADIUS with PostgreSQL
(7.4.2), and it seems
to refuse to log anything in the DB
right now,
with
PostgreSQL and MySQL versions making sure all my patches are working
correctly.
...snip...
Yuset Amado Calzadilla Cámbara wrote:
Can I install freeradius with postgresql using my own tables and not
the tables given in rlm_postgresql??
Yes, you will likely need to create your
Title: Untitled Document
Aniversario 40 de la CUJAE
Visite:
XII Convencin Cientfica de Ingeniera y Arquitectura
http://www.cujae.edu.cu/eventos/convencion/
Yuset Amado Calzadilla Cámbara wrote:
Can I install freeradius with postgresql using my own tables and not
the tables given in rlm_postgresql??
Yes, you will likely need to create your own queries in postgresql.conf
as well.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org
And the configuration is the same as MySql one??
- Original Message -
From: Guy Fraser [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 09, 2004 7:13 PM
Subject: Re: About use FreeRadius with postgresql
Yuset Amado Calzadilla Cámbara wrote:
Can I install freeradius
63 matches
Mail list logo