[General] beginner!!!
Hi, I'm trying to set up a database with freeRADIUS server and I'm getting
some doubts.
I installed freeradius-postgresql package and nothing else. I've configured
all the files like it explains in the SQL How To on FreeRADIUS wiki. So far
so good, but at this part:
"
*Setting up the RADIUS database*
First, you should create a new empty 'radius' database in SQL and a database
user with permissions to that database. You could of course call the
database and the user anything you like but you probably should stick with
'radius' for both to keep things simple.
Next up, you need to create the schema for your database. There is an SQL
script file for each SQL type in doc/examples/ in your operating system's
doc directory (or where you untar'd FreeRADIUS). On SUSE this is under
/usr/share/doc/packages/freeradius/
Create PostgreSQL Database
su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P
createdb radius --owner=radius
exit
*Note:* choose a secure password when prompted for one by the
*createuser*command.
cd /usr/share/doc/packages/freeradius/doc/examples/
psql -U radius radius < postgresql.sql
"
My silly question is, do I needo to install a postgreSQL server or the
freeradius-postgresql package already takes care of it?!
My question it's because it doesn't recognize any user ids and the
createuser command.
Thanks
--
Joana Camacho
Joana Camacho a écrit :
...
su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P
^^^^^^^^^^^^^^
createdb radius --owner=radius
^^^^^^^^^^^^^^
There's a slight contradiction...
--
***
*******
*********
****** Confucious say: "Is stuffy inside fortune cookie."
*******
***
Jean-Yves F. Barbier wrote:
Joana Camacho a écrit :
...su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P^^^^^^^^^^^^^^
createdb radius --owner=radius
^^^^^^^^^^^^^^
There's a slight contradiction...
hmm? no there isn't. a role can be made the owner a database without
having the createdb priv himself. I do this all the time.
CREATE USER fred WITH PASSWORD 'fredisdead';
CREATE DATABASE freddb WITH OWNER fred;
John R Pierce a écrit :
Jean-Yves F. Barbier wrote:
Joana Camacho a écrit :
...su - postgres
createuser radius --no-superuser --no-createdb --no-createrole -P^^^^^^^^^^^^^^
createdb radius --owner=radius
^^^^^^^^^^^^^^
There's a slight contradiction...
hmm? no there isn't. a role can be made the owner a database without
having the createdb priv himself. I do this all the time.CREATE USER fred WITH PASSWORD 'fredisdead';
CREATE DATABASE freddb WITH OWNER fred;
I didn't knew that
--
My silly question is, do I needo to install a postgreSQL server or the freeradius-postgresql package already takes care of it?!
My question it's because it doesn't recognize any user ids and the createuser command.
Yeah, that's pretty much the way things work on unix-like systems.
Instead of building one uber system that does it all (like you typically
see in Windows), they build by leveraging smaller packages that do one
or two things really well. So I'm sure you will have to install postgres
server separately.
Scott
Joana Camacho <joanacmch@gmail.com> :
My silly question is, do I needo to install a postgreSQL server or the
freeradius-postgresql package already takes care of it?!
You have to install postgresql
http://packages.ubuntu.com/search?keywords=postgresql&searchon=names&suite=karmic&section=all
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34 / +261 33 11 207 36