Am 2013-02-18 11:39, schrieb Dario Carbone: > 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. >> > 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 ? ) >
You should look at the specification for the ldap class inetOrgPerson. It has the attributes: description fax, facsimileTelephoneNumber interationaliSDNNumber l, localityName physicalDeliveryOfficeName postalAddress postalCode postOfficeBox registeredAddress st, stateOrProviceName street, streetAddress telephoneNumber telexNumber displayName departmentNumber homePhone, homeTelephoneNumber homePostalAddress jpegPhoto (deprecated) labeledURI mail mobile, mobileTelephoneNumber o, organizationName pager, pagerTelephoneNumber photo roomNumber I didn't test them all, but most of them should be shown in the address book. But be aware that multivalue entries (e.g. mail) are only shown once. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- [email protected] https://inverse.ca/sogo/lists
