[OGo-Users] ogo-database-setup install on Fedora 7 (64 bit) stalls

[Adam Tauno WIlliams]

> This is my first OGo install, so I am on a steep learning curve.
> I have installed OGo 1.1.6 via Yum using:
>    yum install ogo-environment

I'd guess that ogo-meta is what you want to install.

> I don't know if this is the right package to call, but I couldn't find 
> any hint which package to call with Yum.  The yum install completed 
> successfully, and I also have Postgresql installed and working (I can 
> create databases and users from the command line).
> My problem:
> When I run:
>    yum install ogo-database-setup
> I get the following output:
> <snip>
> Running Transaction
>    Installing: ogo-database-setup           ######################### [1/1]
> PostgreSQL seems to be already initialized
> and I can see it running:
> PIDS used: 12170 12175 12177 12178
> We're on PostgreSQL 8 (8.2)
> checking /var/lib/pgsql/data/postgresql.conf
>    no patching needed for /var/lib/pgsql/data/pg_hba.conf
> checking /var/lib/pgsql/data/pg_hba.conf
>    no patching needed for /var/lib/pgsql/data/postgresql.conf
>    'port = 5432' already set.
> creating database user: OGo
> And there it stops.  The installation goes no further and eventually I 
> have canceled out of it (I have left it for over an hour with no 
> change).  I get no errors in /var/log/messages, and no errors in the 
> Postrgres log either.

My guess would be that for some reason the script in the package is
causing a prompt, waiting for input.  Either that or the createdb is
hanging (the daemon that is selinux?).

I'd recommend just skipping ogo-database-setup (there is no accounting
really for the x^n number of ways PostgreSQL may already be configured)
and just create the database manually.  Doing so is very simple and
described in WMOGAG
<http://www.whitemiceconsulting.com/system/files?file=WMOGAG.K.pdf>

Basically -
$ createuser OGo
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
CREATE ROLE
$ createdb -O OGo -E UTF-8 OGo
CREATE DATABASE
$ psql -U OGo OGo < pg-build-schema.psql

You can grab the schema file right from subversion
<http://svn.opengroupware.org/viewcvs/*checkout*/trunk/Database/PostgreSQL/pg-build-schema.psql>

That's really all the package does.

> Can anyone suggest how I can go about debugging this problem?