Current time: 04-26-2024, 12:52 AM Hello There, Guest! (LoginRegister)


Post Reply 
Trigger to encrypt passwords on RC7
Author Message
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #1
Trigger to encrypt passwords on RC7
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.
02-24-2009 09:48 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: Trigger to encrypt passwords on RC7
ispCP does this on it´s own after the first Login as Admin in the Panel after the Upgrade.

Greez BeNe
02-24-2009 10:07 PM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #3
RE: Trigger to encrypt passwords on RC7
(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?
02-24-2009 10:15 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #4
RE: Trigger to encrypt passwords on RC7
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
02-24-2009 10:26 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Cube Offline
Member
***

Posts: 740
Joined: Apr 2007
Reputation: 9
Post: #5
RE: Trigger to encrypt passwords on RC7
You could try to set the database revision in the DB (ispcp -> config -> DATABASE_REVISION) to the previous one. Then login as admin again.
02-24-2009 10:54 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #6
RE: Trigger to encrypt passwords on RC7
Also i goog idea!
Never thought of it Rolleyes

Greez BeNe
02-24-2009 10:56 PM
Visit this user's website Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #7
RE: Trigger to encrypt passwords on RC7
Not DATABASE_REVISION but CRITICAL_UPDATE_REVISION. Delete or set value to 0
02-24-2009 11:00 PM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #8
RE: Trigger to encrypt passwords on RC7
(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?
02-24-2009 11:41 PM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #9
RE: Trigger to encrypt passwords on RC7
(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
02-25-2009 01:46 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)