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


--

Carbone Dario                                                                
Primeur Customer Services S.r.l. 
EMAIL: ">
URL: 
http://www.primeur.com
Mobile: +39 3488960584
image003.jpg




Archive powered by MHonArc 2.6.18.

Top of page