General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Address Book on Postgresql


Chronological Thread 
  • From: Christian Mack < >
  • To:
  • Subject: Re: [SOGo] Address Book on Postgresql
  • Date: Mon, 18 Feb 2013 16:38:08 +0100

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



Archive powered by MHonArc 2.6.18.

Top of page