General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Address Book on Postgresql


Chronological Thread 
  • From: Dario Carbone < >
  • To:
  • Cc: André Schild < >
  • Subject: Re: [SOGo] Address Book on Postgresql
  • Date: Thu, 07 Feb 2013 09:45:39 +0100

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 ?

Thanks


Il 06/02/2013 22:13, André Schild ha scritto:
" type="cite">Am 06.02.2013 19:25, schrieb Francis Lachapelle:
Hi Dario

On 2013-02-06, at 6:21 AM, Dario Carbone ">< > wrote:

Hi, thanks for the reply.
I've see it on the doc, but don't work for me.

My configurations :

POSTGRESS
i've creted another db called sogo_gab and a table (t_gab) with this columns :

Field name        Type        Array?        Allow nulls?
     c_uid     varchar(255)     No     No
     c_name     varchar(255)     No     No
     c_password     varchar(255)     No     Yes
     c_cn     varchar(255)     No     Yes
     mail     varchar(255)     No     No
     company     varchar(255)     No     Yes


SOGO :
<dict>
                 <key>canAuthenticate</key>
                 <string>NO</string>
                 <key>displayName</key>
                 <string>Primeur GAB</string>
                 <key>id</key>
                 <string>Primeur_GAB</string>
                 <key>isAddressBook</key>
                 <string>YES</string>
                 <key>type</key>
                 <string>sql</string>
                 <key>viewURL</key>
                 <string>postgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab</string>
</dict>


But dosen't work.
On the log file i saw nothing
Do you see the addressbook in the Web interface? If so, notice that you need to perform a search (or type a dot ".") on global addressbooks. No entry will be shown by default.

Any chance we get a solution for this?

http://www.sogo.nu/bugs/view.php?id=438

André

--

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