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.
>>
>> * 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