General discussion on installation and configuration of SOGo

Text archives Help

Re: [SOGo] Address Book on Postgresql

Chronological Thread 
  • From: Dario Carbone < >
  • To:
  • Cc: Christian Mack < >
  • Subject: Re: [SOGo] Address Book on Postgresql
  • Date: Mon, 18 Feb 2013 11:39:23 +0100

Ok, all worked.
I've reimposted the sogo password and used the patch for the address book.

So now i can view som data, but i need more clarifications

How can I store other datas ? ( Home Phone ? fax ? address and so on ? )

Thanks in advice

Il 07/02/2013 10:40, Christian Mack ha scritto:
" type="cite">
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
connection=0x0x7ffcfccbb460>>): ERROR:  permission denied for relation t_gab

But if I so the query with the command line psql, all work.
Any ideas ?

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


Carbone Dario                                                                
Primeur Customer Services S.r.l. 
Mobile: +39 3488960584

Archive powered by MHonArc 2.6.18.

Top of page