[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,
>
>
>>> 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?

Theoretically, yes.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/