Postgres

[Sparkes, David]

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/share/doc/packages/freeradius/doc/examples/
psql -U radius radius < postgresql.sql

Of which I couldn't find the equivalent.  The closest I could find was
/usr/share/doc/freeradius-2.1.7/examples/postgresql_update_radacct_group
_trigger.sql, which caused all kinds of scary error messages, which put
me off.

It occurs to me in the cold light of day that maybe this section
probably just creates the example tables, and the above example file is
completely inappropriate, but, at the time, I was in black box mysticism
mode.  I wrote the SQL to create similar tables to those shown, but
stopped, because I thought that the basic database part was importing
something more clever into the database.  I've probably overthought it
and can just get on with the configuration, then.

Thanks,

Dave

  






-----Original Message-----
From:
freeradius-users-bounces+david.sparkes=keymile.com at lists.freeradius.org
[mailto:freeradius-users-bounces+david.sparkes=keymile.com at lists.freerad
ius.org] On Behalf Of Alan Buxey
Sent: Thursday, October 15, 2009 12:11 PM
To: FreeRadius users mailing list
Subject: Re: Postgres

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 issue - eg radiusd -X

alan
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html