[imp] Importing S/MIME certificate fails

[Anna Christina Naß]

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ß