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 package that would include this or should I just create it from scratch? Looking at the examples that I've found, it seems to be a fairly straightforward file to understand, if large. If I'd known that the table name and SQL queries were defined in postgresql.conf, I wouldn't have bothered to recreate the tables according to the schema. ;) For the record, all of the configuration files are in /etc/raddb/postgresql in this install. Regards, Dave -----Original Message----- From: freeradius-users-bounces+david.sparkes=keymile....@lists.freeradius.org [mailto:[email protected] ius.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 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 > > See raddb/sql/postgresql/. Everything for postgres is there. Just for clarity, using the Red Hat packages (sice the OP did state this is RHEL) that would be /etc/raddb/sql/postgresql and requires the freeradius-postgresql subpackage to be installed. -- John Dennis <[email protected]> Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
