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] |
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] |
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] |
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] |
In reply to this post by Anna Christina Naß
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] |
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] |
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] |
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] |
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] |
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] |
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] |
Free forum by Nabble | Edit this page |