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 -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- [email protected] https://inverse.ca/sogo/lists
