Re: [SOGo] Address Book on Postgresql

[Dario Carbone]

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: 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: dario.carb...@primeur.com URL: http://www.primeur.com Mobile: +39 3488960584