[OGo-Users] FC6 Install - Database Questions

[Adam Tauno Williams]

>>> Download the packages to a folder and do a "rpm -Uvh *.rpm".
>That's what I've done..
>I found that the mod_ngobjweb package in the FC6 downloads directory =
was=20
>for pre V2 Apache so I used the FC7 package ->=20
>mod_ngobjweb-2.2.4-trunk_r1515.0.i386.rpm. It seems to be working this =
far.

Seems like it should work,  so long as the linked to libraries aren't =
wildly
divergent.

>For some reason FC6's etc/ hosts file has ::1 resolving as localhost =
and=20
>127.0.0.1 doesn't resolve. Arrgh! Once that was fixed OpenGroupware's=20
>web interface stopped complaining about not finding the database.

Hmm,  it is using IPv6 as default.  Probably PostgreSQL isn't listening =
on
the IPv6 socket.

>Thinking that the install's population of the database could have been=20
>screwed by the localhost resolution problem I reinstalled it all.
> (channel=3D<0x0x9305b0c[PostgreSQL72Channel]: connection=3D<0x0x989346
>c[PGConnection]:  connection=3D0x0x98731e0>>): ERROR:  relation =
"person"=20
> does not exist
=20
Yep, this means it couldn't find the table "person" which contains the
account.

> Using psql gives these results...
> OGo=3D# \dt
> No relations found.

Yep, your database is empty.

> :-( But, maybe, I don't know what I'm doing........

Looks like you do to me. :)

>When I re-installed the rpm's should have dropped the OGo database from =

>Postgres?

I've got no idea what would happen when you reinstalled that RPM;  meant =
to
be a one-show-wonder.

> How do I list the tables in Postgres? =20

"\dt" just like you did.

> Does the  .rpm  have a script  that  populates the database? Is there =
a=20
> bunch of sql somwhere that will  populate the database for me?=20

You should have a -
/usr/local/share/opengroupware.org-1.1/dbsetup/PostgreSQL/pg-build-schema=
.ps
ql - that will create the database for you.  Otherwise it looks like the
database connection, et al, was setup correctly.