General discussion on installation and configuration of SOGo

Text archives Help

Re: [SOGo] How to get schema for postgres sql

Chronological Thread 
  • From: Karsten Hoffmann < >
  • To:
  • Subject: Re: [SOGo] How to get schema for postgres sql
  • Date: Tue, 29 Jul 2014 13:43:26 +0200

* As I know the schema is automatically created the first time you start

* Line 3 and 4 are wrong, missing host.

* Please check your pg_hba.conf, e.g.

# Allow any user on the local system to connect to any database under
# any database user name using Unix-domain sockets (the default for local
# connections).
local all all trust

# The same using local loopback TCP/IP connections.
host all all trust

Am 29.07.2014 um 13:18 schrieb Robert Bilbrey:
> I have followed a very detailed tutorial to setup
> postfix,spamassin,clamAV,Postgres as the user database.
> I then tried to overlay sogo onto this install following another
> tutorial. I get to the login page for sogo, but no combination of
> usernames and/or passwords work. in the logs I get the following errors:
> , if you look at the errors towards the end
> of the log,sogo is looking for a view that does not exist and a table
> that does not exits. I have scoured the web trying to find the sogo
> postgresql schema to no avail. I have installed the sope49 postgresql
> rpm, but I cannot see that it did anything. My sogo conf is at
> Any help or insight would be greatly
> appreciated. I want this to work, but will have to give up on it soon if
> I can't find some answers.
> Thanks, Bob

Archive powered by MHonArc 2.6.18.

Top of page