RE: [cobalt-users] Postgresql, can users use it?

["Ahmad" <ahmad@xxxxxxxxxxxxx>]

There's an entry for this on the sun knowledge base (I recently looked
it up).

It goes like this:

--quote--

------------------------------------------------------------------------
--------
SUN COBALT PRODUCTS ARE SERVER APPLIANCES AND ARE DESIGNED TO PROVIDE
SERVICES SUCH AS WEB HOSTING, E-MAIL, AND FILE SHARING, WHICH ARE
ACCESSED VIA A WEB-BASED USER INTERFACE. DIRECT ACCESS OR MODIFICATION
OF THE UNDERLYING SOFTWARE OR HARDWARE OF THE SUN COBALT PRODUCT IS NOT
SUPPORTED BY SUN COBALT AND WILL VOID YOUR PRODUCT WARRANTY. THE
INFORMATION BELOW IS PROVIDED "AS IS," FOR INFORMATIONAL PURPOSES ONLY.
SUN COBALT WILL NOT BE LIABLE FOR ANY LOSSES OR DAMAGES SUFFERED AS A
RESULT OF YOUR USE OF THIS INFORMATION. PHONE AND WEB-BASED SUPPORT WILL
NOT BE AVAILABLE FOR SYSTEM ISSUES ARISING OUT OF THE USE OF THIS
INFORMATION. 
------------------------------------------------------------------------
--------


The following process will give the postgres user called "admin" the
super-user privilage. Once this is done, a user can log into postgres
using the admin account and modify itself to allow creation of users and
databases.



telnet in as admin 


use su - to switch to root 

[admin@raq3 admin]$ su - 
Password: *****


NOTICE TO ROOT USER: Changes to system files may affect your warranty.
Please consult your warranty card for details. 

http://www.cobaltnet.com 

*****************************************************************
[root@raq3 /root]# 


use an editor and open the file /home/pgsql/pg_hba.conf 
NOTICE On a RaQ3, this is the correct file. On a RaQ4, the file is
/var/lib/pgsql/data/pg_hba.conf 

[root@raq3 /root]# vi /home/pgsql/pg_hba.conf 


Change local all crypt to local all trust 


use su to switch to the user ID postgres 

[root@raq3 /root]# su postgres [postgres@raq3 /root]$ 


Now run the psql program to connect to the database server. 

[postgres@raq3 /root]$ psql cobalt
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66]

type ? for help on slash commands
type q to quit
type g or terminate with semicolon to execute query
You are currently connected to the database: cobalt

cobalt=> 

NOTE: This message will be slightly different on the RaQ4.


Enter the following commands to give super-user privilage to admin and
quit. 

cobalt=> update pg_shadow set usesuper='t' where usename='admin';
UPDATE 1
cobalt=> \q
[postgres@raq3 /root]$ 


Use the exit command to become "root" again. 


Now open the /home/pgsql/pg_hba.conf (on a RaQ4:
/var/lib/pgsql/data/pg_hba.conf) file and change "local all trust" back
to "local all crypt". 

It is now possible to access postgres using the postgres account
"admin". The password for this account is stored in the file
/etc/cobalt/.meta.id and should not be changed. If the password needs to
be changed, it must be changed in the pg_shadow table and the
/etc/cobalt/.meta.id file. Be sure to maintain file permissions on the
file or system security could be compromised.

--end quote--

Hope this helps,

Ahmad

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of Bruce
Timberlake
Sent: 15 January 2003 17:12
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] Postgresql, can users use it?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> Thx i now can connect to the database but can´t create one with
> createdb. It tells me no entry in  pg_hba.conf for localhost.
> Do i have to edit that file 

If that's what it's saying, then I guess so... :)

> and is it save to do so?

Yes. Just don't remove the existing line that refers to the 'cobalt' 
database.

- -- 
Bruce Timberlake

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+JZZDvLA2hUZ9kgwRAgYSAJ4pW8PCWV9689GxjuFo4rrBCLOTrwCbBlxh
MWIobMZxYjRsK3IZO0WBKkk=
=XKWR
-----END PGP SIGNATURE-----

_____________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To subscribe/unsubscribe, or to SEARCH THE ARCHIVES, go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users