CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviCRM optimization: encryption class
Pages: [1]

Author Topic: CiviCRM optimization: encryption class  (Read 850 times)

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
CiviCRM optimization: encryption class
March 22, 2011, 08:32:20 am
Before I'm filing an issue,

this is something interesting I have noticed with Civi

Our servers which are all Debian based (Debian 5.x, Ubuntu 10.04), the PHP class mcrypt functions runs extremely slow. This is evident in the outbound SMTP configuration page as well as some other pages that requires the encryption/decryption routine to be run.

I'm wondering where else in Civi does the encryption class gets called and I believe by using a different encryption class it could help out speed up the performance of the site.


Let me know what you guys think


Cheers!

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: CiviCRM optimization: encryption class
March 22, 2011, 08:38:44 am
Hi,

How is the encryption used today in civi ?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: CiviCRM optimization: encryption class
March 22, 2011, 10:33:25 am
I don't know all the specifics but I what I'm sure is that

the encryption class is called when you are on the mailing configuration page because it encrypt/decrypt the password. Taking the same logic I would assume that a lot of configuration settings would use encrypt/decrypt to store configuration settings.


Cheers!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviCRM optimization: encryption class
March 22, 2011, 01:11:00 pm

did a grep on the code

we currently only encrypt the smtpPassword variable in the config (since keeping that in clear in the DB is not a great thing). we do not encrypt any other fields.

i did a search to see if we can get more info on why its slow on debian and could not find any info, which was a bit strange :( We are open to using some other faster symmetric encryption technique (however we'll still need to retain what we are currently using to allow a seamless upgrade :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: CiviCRM optimization: encryption class
March 23, 2011, 12:06:32 am
couldn't it be done as well for the imap accounts?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion (Moderator: Donald Lobo) »
  • CiviCRM optimization: encryption class

This forum was archived on 2017-11-26.