Re: [SOGo] Address Book on Postgresql

[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 ? Thanks Il 06/02/2013 22:13, André Schild ha scritto: Am 06.02.2013 19:25, schrieb Francis Lachapelle: Hi Dario On 2013-02-06, at 6:21 AM, Dario Carbone <dario.carb...@primeur.com> 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: dario.carb...@primeur.com URL: http://www.primeur.com Mobile: +39 3488960584