General discussion on installation and configuration of SOGo

Text archives Help


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


Chronological Thread 
  • From: Robert Bilbrey < >
  • To:
  • Subject: Re: [SOGo] How to get schema for postgres sql
  • Date: Tue, 29 Jul 2014 09:45:58 -0500

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.
>
> * http://pastebin.com/mXJXmxYX: Line 3 and 4 are wrong, missing host.
>
> * Please check your pg_hba.conf, e.g.
> http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
>
> # 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).
> #
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> local all all trust
>
> # The same using local loopback TCP/IP connections.
> #
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> host all all 127.0.0.1/32 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:
>> http://pastebin.com/0eiiB1vf , 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
>> http://pastebin.com/mXJXmxYX. 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