[imp] Importing S/MIME certificate fails

[Jan Schneider]

Zitat von Anna Christina Naß <acn at annachristina.eu>:

> Zitat von Jan Schneider <jan at horde.org>:
>
> Hallo Jan,
>
>>>> Is it in your prefs backend?
>>>
>>> If I try
>>> SELECT * FROM `horde_prefs` WHERE pref_name like '%cert%'
>>> I do not get any results.
>>>
>>> I tried 'tail -f horde.log' (logging set to INFO), but nothing is  
>>> shown when importing the certificate.
>>>
>>> Kind regards,
>>> Anna Christina Naß
>>
>> Preference storing is logged at DEBUG level.
>
> I activated DEBUG logging and found the following lines containing "cert":
>
> 2013-07-18T08:20:01+00:00 DEBUG: HORDE [imp] SQL  (0.0000s)
>         SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid  
> = '<username>'
>           AND pref_scope = 'imp' [pid 25662 on line 558 of  
> "/usr/share/php/Horde/Db/Adapter/Base.php"]
> 2013-07-18T08:20:01+00:00 DEBUG: HORDE [imp] SQL  (0.0005s)
>         SHOW FIELDS FROM `horde_prefs` [pid 25662 on line 558 of  
> "/usr/share/php/Horde/Db/Adapter/Base.php"]
> 2013-07-18T10:20:05+02:00 DEBUG: HORDE Load config file (conf.php;  
> app: horde) [pid 25225 on line 401 of "/usr/share/php/Horde.php"]
> 2013-07-18T10:20:05+02:00 DEBUG: HORDE Horde_Registry: retrieved app  
> with cache ID horde_registry|app|1374063147|7402c06b537ecfcc610b
> d563dfec4c6d [pid 25225 on line 1987 of "/usr/share/php/Horde/Registry.php"]
> 2013-07-18T10:20:05+02:00 DEBUG: HORDE [imp] Load config file  
> (conf.php; app: imp) [pid 25225 on line 401 of  
> "/usr/share/php/Horde.ph
> p"]
> 2013-07-18T10:20:05+02:00 DEBUG: HORDE [imp] Horde_Prefs: Storing  
> preference value (smime_additional_cert) [pid 25225 on line 88 of  
> "/var/www/annachristina.eu/mail/imp/lib/Crypt/Smime.php"]
> 2013-07-18T10:20:05+02:00 DEBUG: HORDE [imp] Das  
> öffentliche/private SchlÌsselpaar wurde erfolgreich gespeichert.  
> [pid 25225 on line 27 of  
> "/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
>
> You can see more of the DEBUG output in the linked file, it contains  
> all DEBUG output from clicking "S/MIME" to saving the certificate:
>
> https://o.imzadi.de/public.php?service=files&t=a342461e6ed8d826eb08e860405bb4f7
>
> Ah, and I retried searching for the certificate in the database:
>
> mysql> SELECT * FROM `horde_prefs` WHERE pref_name like '%cert%';
> Empty set (0.00 sec)
>
>
> Thank you for your help!
>
> Regards,
> Anna Christina Naß

I assume that other preferences works fine? Obviously your preference  
backend doesn't report any errors back when storing the certs, so you  
need to debug those to find out what happened.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/