[horde] public Key - adressbook error with 5.1.1

[pillul]

I tracked it down to the following query:

  SELECT object_id, owner_id, object_type, object_members, object_uid,
           object_firstname, object_lastname, object_middlenames,
           object_nameprefix, object_namesuffix, object_alias,
           object_yomifirstname, object_yomilastname, object_bday,
           object_anniversary, object_spouse, object_photo,  
object_phototype,
           object_homestreet, object_homepob, object_homecity,
           object_homeprovince, object_homepostalcode, object_homecountry,
           object_workstreet, object_workpob, object_workcity,
           object_workprovince, object_workpostalcode, object_workcountry,
           object_otherstreet, object_otherpob, object_othercity,
           object_otherprovince, object_otherpostalcode,  
object_othercountry,
           object_department, object_manager, object_assistant, object_tz,
           object_email, object_homephone, object_homephone2,  
object_homefax,
           object_workphone, object_workphone2, object_cellphone,
           object_carphone, object_radiophone, object_companyphone,
           object_assistantphone, object_fax, object_pager, object_title,
           object_role, object_company, object_logo, object_logotype,
           object_category, object_notes, object_url, object_freebusyurl,
           object_pgppublickey, object_smimepublickey, object_imaddress,
           object_imaddress2, object_imaddress3 FROM turba_objects WHERE
           (object_email = 'destination.email at adress.de' AND owner_id =
           'sender.email at adress.de')

this query gives you nothing back, beacause the "owner_id" of the turba  
entry is not the senders adress!
The owner_id ist the person who added it to the shared adressbook.
If i try the query for an old user the result is also empty but the mail  
gets encrypted (??).
If i change the owner_id by hand in the database it works for this  
specific sender.

I guess this is a bug? Can a dev give me a hint plz?




Am 23.07.2013, 10:58 Uhr, schrieb pillul <pillul at freenet.de>:

> Here the same logs with the language english, maybe this helps?
>
> Error in Frontend: could not retrieve public key for name.name at domain.de
>
> Debug Logging:
>
> 2013-07-23T08:54:35+00:00 DEBUG: HORDE [imp] PGPpublicKey: Could not  
> connect to public PGP keyserver [pid 6428 on line 248 of  
> "/path/to/my/htdocs/mail/imp/lib/Crypt/Pgp.php"]
> 2013-07-23T08:54:35+00:00 DEBUG: HORDE [imp] PGP Error: Could not  
> retrieve public key for name.name at domain.de. [pid 6428 on line 27 of  
> "/path/to/my/htdocs/pear/pear/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
>
>> Hey Guys,
>>
>> after the upgrade i have a major problem:
>> i use a shared adressbook where all public pgp keys are stored.
>> I can send mails to "old" contacts entered before the update.
>>
>> If i try to send a encrypted message to new contacts, added after the  
>> update i get a error message.
>>
>> "public key could not be read"
>>
>>
>>   SHOW FIELDS FROM `turba_objects` [pid 26291 on line 558 of  
>> "path/to/htdocs/pear/pear/php/Horde/Db/Adapter/Base.php"]
>> 2013-07-22T13:48:55+00:00 DEBUG: HORDE [imp] PGPpublicKey: Verbindung  
>> zum öffentlichen PGP-Server fehlgeschlagen [pid 26291 on line 248 of  
>> "path/to/htdocs/mail/imp/lib/Crypt/Pgp.php"]
>> 2013-07-22T13:48:55+00:00 DEBUG: HORDE [imp] PGP-Fehler: Öffentlicher  
>> Schlüssel für mail at adresss.com konnte nicht gelesen werden. [pid 26291  
>> on line 27 of  
>> "path/to/htdocs/pear/pear/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
>>
>> please help!


-- 
Erstellt mit Operas E-Mail-Modul: http://www.opera.com/mail/