[GENERAL] [General] beginner!!!

[Joana Camacho]

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

[Jean-Yves F. Barbier]

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."
*******
***

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[John R Pierce]

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;

[Jean-Yves F. Barbier]

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

--

[Scott Bailey]

> 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

[Mihamina Rakotomandimby]

> Joana Camacho <joan...@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