[imp] Importing S/MIME certificate fails

[Anna Christina Naß]

Zitat von Jan Schneider <jan at horde.org>:

Hallo Jan,


>> 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"]
[...]
>> mysql> SELECT * FROM `horde_prefs` WHERE pref_name like '%cert%';
>> Empty set (0.00 sec)

> 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.

Yep, all other prefs do work fine.
I'm using MySQL 5.5.31 (Debian Wheezy) and "MySQL/PDO" with persistent  
connections via UNIX Sockets as SQL backend in Horde.
$conf[prefs][maxsize] is unset.

Shouldn't the INSERT-statement where Horde tries to store the  
certificate into the database be part of the DEBUG output, too?

Thank you!

Regards,
Anna Christina Naß