Importing S/MIME certificate fails

[Anna Christina Naß]

Hallo,

I've created a personal certificate via cacert.org, which was imported  
into Firefox. There I saved it to a .p12-file.

Then I navigated to "Settings -> Webmail -> S/MIME" and tried to  
import my personal certificate into Horde IMP.

It does seem okay and it tells me that my certificate has been  
imported via the green bubble, but I do not see it.

After importing the certificate it should show up in "Settings ->  
Webmail -> S/MIME" under "Your personal S/MIME certificate", should it?
But there only "No personal certificate" is shown.

My configuration:

Horde 5.1.1, IMP 6.1.2
APC cache, no memory cache. Prefs via SQL. VFS via local file system.
$conf[openssl][path] = '/usr/bin/openssl' and it exists.
$conf[openssl][cafile] = '/etc/ssl/certs/ca-certificates.crt' and it  
exists and contains CAcerts root.crt and class3.crt.

And ideas?

Thank you!

Kind regards,
Anna Christina Naß
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Jan Schneider]

Zitat von Anna Christina Naß <[hidden email]>:

> Hallo,
>
> I've created a personal certificate via cacert.org, which was  
> imported into Firefox. There I saved it to a .p12-file.
>
> Then I navigated to "Settings -> Webmail -> S/MIME" and tried to  
> import my personal certificate into Horde IMP.
>
> It does seem okay and it tells me that my certificate has been  
> imported via the green bubble, but I do not see it.
>
> After importing the certificate it should show up in "Settings ->  
> Webmail -> S/MIME" under "Your personal S/MIME certificate", should  
> it?

Yes.

> But there only "No personal certificate" is shown.
>
> My configuration:
>
> Horde 5.1.1, IMP 6.1.2
> APC cache, no memory cache. Prefs via SQL. VFS via local file system.
> $conf[openssl][path] = '/usr/bin/openssl' and it exists.
> $conf[openssl][cafile] = '/etc/ssl/certs/ca-certificates.crt' and it  
> exists and contains CAcerts root.crt and class3.crt.
>
> And ideas?

Is it in your prefs backend?
--
Jan Schneider
The Horde Project
http://www.horde.org/

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Anna Christina Naß]

Zitat von Jan Schneider <[hidden email]>:

Hallo Jan,

>> But there only "No personal certificate" is shown.
>>
>> My configuration:
>>
>> Horde 5.1.1, IMP 6.1.2
>> APC cache, no memory cache. Prefs via SQL. VFS via local file system.
>> $conf[openssl][path] = '/usr/bin/openssl' and it exists.
>> $conf[openssl][cafile] = '/etc/ssl/certs/ca-certificates.crt' and  
>> it exists and contains CAcerts root.crt and class3.crt.
>>
>> And ideas?
> 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ß
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[lst_hoe02]

Zitat von Anna Christina Naß <[hidden email]>:

> Zitat von Jan Schneider <[hidden email]>:
>
> Hallo Jan,
>
>>> But there only "No personal certificate" is shown.
>>>
>>> My configuration:
>>>
>>> Horde 5.1.1, IMP 6.1.2
>>> APC cache, no memory cache. Prefs via SQL. VFS via local file system.
>>> $conf[openssl][path] = '/usr/bin/openssl' and it exists.
>>> $conf[openssl][cafile] = '/etc/ssl/certs/ca-certificates.crt' and  
>>> it exists and contains CAcerts root.crt and class3.crt.
>>>
>>> And ideas?
>> 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ß

Not sure if this could really cause the problem, but do you have set a  
very small $conf[prefs][maxsize] value?

Regards

Andreas



--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Jan Schneider]

Zitat von Anna Christina Naß <[hidden email]>:

> Zitat von Jan Schneider <[hidden email]>:
>
> Hallo Jan,
>
>>> But there only "No personal certificate" is shown.
>>>
>>> My configuration:
>>>
>>> Horde 5.1.1, IMP 6.1.2
>>> APC cache, no memory cache. Prefs via SQL. VFS via local file system.
>>> $conf[openssl][path] = '/usr/bin/openssl' and it exists.
>>> $conf[openssl][cafile] = '/etc/ssl/certs/ca-certificates.crt' and  
>>> it exists and contains CAcerts root.crt and class3.crt.
>>>
>>> And ideas?
>> 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.
--
Jan Schneider
The Horde Project
http://www.horde.org/

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Anna Christina Naß]

Zitat von Jan Schneider <[hidden email]>:

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ß
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Jan Schneider]

Zitat von Anna Christina Naß <[hidden email]>:

> Zitat von Jan Schneider <[hidden email]>:
>
> 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/

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Anna Christina Naß]

Zitat von Jan Schneider <[hidden email]>:

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ß
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Jan Schneider]

Zitat von Anna Christina Naß <[hidden email]>:

> Zitat von Jan Schneider <[hidden email]>:
>
> 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/

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Anna Christina Naß]

Zitat von Jan Schneider <[hidden email]>:

Hallo Jan,

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

So, why is it missing?

What information do you need to track this issue down?

Regards,
Anna Christina Naß
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]

[Jan Schneider]

Zitat von Anna Christina Naß <[hidden email]>:

> Zitat von Jan Schneider <[hidden email]>:
>
> Hallo Jan,
>
>>>>> 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.
>
> So, why is it missing?
>
> What information do you need to track this issue down?
>
> Regards,
> Anna Christina Naß

You need to track this down on your own. The storing happens in  
Horde_Prefs_Storage_Sql::store().
--
Jan Schneider
The Horde Project
http://www.horde.org/

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [hidden email]