[OGo-Users] FC6 Install - Database Questions

[Ken Smith]

Ken Smith wrote:
> Peter Duda wrote:
>>>
>>> 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 
for pre V2 Apache so I used the FC7 package -> 
mod_ngobjweb-2.2.4-trunk_r1515.0.i386.rpm. It seems to be working this far.

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

Thinking that the install's population of the database could have been 
screwed by the localhost resolution problem I reinstalled it all.

Contrary to what the docs say, the web interface is demanding a password 
and the error log contains entries like this:

Oct 15 21:36:30 ogo-webui-1.1 [3805]: >DirectAction> access denied for 
user root.
Oct 15 21:36:30 ogo-webui-1.1 [3805]: <<0x0x98c198c[WOForm]>>D Note: 
session-id is requested, but no session is active?
Oct 15 21:49:04 ogo-webui-1.1 [3805]: OGoContextManager: could not fetch 
login information: (Exception name:PostgreSQL72Fatal
Error class:PostgreSQL72Exception reason:fatal pgsql error 
(channel=<0x0x9305b0c[PostgreSQL72Channel]: connection=<0x0x989346
c[PGConnection]:  connection=0x0x98731e0>>): ERROR:  relation "person" 
does not exist
 info:<nil>)

I suspect that my database is empty, I'm more familiar with MySQL than 
Postgres. I think the OGo database is actually there, but I suspect that 
the tables might not be. A pg_dump of the database contains very little. 
Using psql gives these results...

postgres=# \c OGo
You are now connected to database "OGo".
OGo=# \dt
No relations found.
OGo=#

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

When I re-installed the rpm's should have dropped the OGo database from 
Postgres?

How do I list the tables in Postgres?  Does the  .rpm  have a script 
that  populates the database? Is there a bunch of sql somwhere that will 
populate the database for me? If I need to manually set some admin/root 
password what SQL should I user to do that.

Many thanks in advance

:-)

Ken






-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.