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 17:05:29 +0200

No, but I would stop SOGo and drop and re-create the database.

Am 29.07.2014 um 16:45 schrieb Robert Bilbrey:
> Do you know of a switch to set to force SOGo to rerun it's scripts?
> On 07/29/2014 06:43 AM, Karsten Hoffmann wrote:
>> * As I know the schema is automatically created the first time you start
>> SOGo.
>> * 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