ispCP - Board - Support
Trigger to encrypt passwords on RC7 - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: Trigger to encrypt passwords on RC7 (/thread-5807.html)



Trigger to encrypt passwords on RC7 - gilbert - 02-24-2009 09:48 PM

Hi,

Due to problems on the upgrade RC5 -- > RC7, no doubt our mistake somewhere Smile, we have our system running but we kept the passwords in clear-text.

Now we have tested the upgrade again on another server and are ready to implement the fixes.(we are running dovecot instead of courier)

Is there anyway we can trigger ispcp to encrypt all passwords stored in the mail_users table via script?

Thanks in advance,

Gilbert.


RE: Trigger to encrypt passwords on RC7 - BeNe - 02-24-2009 10:07 PM

ispCP does this on it´s own after the first Login as Admin in the Panel after the Upgrade.

Greez BeNe


RE: Trigger to encrypt passwords on RC7 - gilbert - 02-24-2009 10:15 PM

(02-24-2009 10:07 PM)BeNe Wrote:  ispCP does this on it´s own after the first Login as Admin in the Panel after the Upgrade.

Greez BeNe

Under normal circumstances I understand this is what is to be expected.

Because we couldn't get pop/imap auth working with encrypted passwords we restored the clear-text ones after the upgrade was finished encrypting them.

Now we need to encrypt them again, but the upgrade is already 1 1/2 weeks old.

Is there anyway?


RE: Trigger to encrypt passwords on RC7 - BeNe - 02-24-2009 10:26 PM

You can try the change the PW of the Mailbox again in ispCP.
If you have them in clear text, this should be no problem.

Greez BeNe


RE: Trigger to encrypt passwords on RC7 - Cube - 02-24-2009 10:54 PM

You could try to set the database revision in the DB (ispcp -> config -> DATABASE_REVISION) to the previous one. Then login as admin again.


RE: Trigger to encrypt passwords on RC7 - BeNe - 02-24-2009 10:56 PM

Also i goog idea!
Never thought of it Rolleyes

Greez BeNe


RE: Trigger to encrypt passwords on RC7 - sci2tech - 02-24-2009 11:00 PM

Not DATABASE_REVISION but CRITICAL_UPDATE_REVISION. Delete or set value to 0


RE: Trigger to encrypt passwords on RC7 - gilbert - 02-24-2009 11:41 PM

(02-24-2009 11:00 PM)sci2tech Wrote:  Not DATABASE_REVISION but CRITICAL_UPDATE_REVISION. Delete or set value to 0

ok so just to be sure that I understand

update config set value=0 where name='CRITICAL_UPDATE_REVISION';

Then login to the control panel as admin.

That's all?


RE: Trigger to encrypt passwords on RC7 - sci2tech - 02-25-2009 01:46 AM

(02-24-2009 11:41 PM)gilbert Wrote:  
(02-24-2009 11:00 PM)sci2tech Wrote:  Not DATABASE_REVISION but CRITICAL_UPDATE_REVISION. Delete or set value to 0

ok so just to be sure that I understand

update config set value=0 where name='CRITICAL_UPDATE_REVISION';

Then login to the control panel as admin.

That's all?
Yes Wink