General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Address Book on Postgresql


Chronological Thread 
  • From: Christian Mack < >
  • To:
  • Subject: Re: [SOGo] Address Book on Postgresql
  • Date: Thu, 07 Feb 2013 10:40:29 +0100

Am 2013-02-07 09:45, schrieb Dario Carbone:
> Ok, thanks.
> But don't work too, the sogo.log report :
>
> 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT
> c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND
> c_folder_type = 'Contact'
> 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT *
> FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE
> '%testuser%' OR LOWER(mail) LIKE '%testuser%')
> Feb 07 09:31:19 sogod [28259]: [ERROR] <0x0x7ffcfcc813a0[SQLSource]>
> could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE
> '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE
> '%testuser%')': <PostgreSQL72Exception: 0x7ffcfcc722d0>
> NAME:PostgreSQL72FatalError REASON:fatal pgsql error
> (channel=<0x0x7ffcfccb2140[PostgreSQL72Channel]:
> connection=<0x0x7ffcfcc9bf00[PGConnection]:
> connection=0x0x7ffcfccbb460>>): ERROR: permission denied for relation t_gab
>
> But if I so the query with the command line psql, all work.
> Any ideas ?
>
< ... >
>>>>
>>>> <string>postgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab</string>
< cut >

Are you sure you used user "sogo" with password "sogo" for psql too?
That's what you instruct SOGo to use.


Kind regards,
Christian Mack

--
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz



Archive powered by MHonArc 2.6.18.

Top of page