This topic is locked
[SOLVED]

  Encryption algorithm - MD5

1/30/2010 2:32:51 PM
PHPRunner General questions
A
alandob author

Use: PHPRunner Enterprise Edition 5.1.0
I get my login data from another MYSQL database table that uses "Encryption algorithm - MD5" to encrypt the password and would like to know how I can "copy" this field to PHPRunner, so when a user changes their password in the other platform, this data is reflected in the PHPRunner field (I synchronise the 2 MYSQL databases every 5 minutes and if I synch the login & password fields I cannot login to PHPRunner because of MD5) and can use the same password.

J
Jepsen 1/30/2010

PHPRunner uses MD5 as its encryption algorithm
Consequentlu, you can jost copy the new password in one table to the password in the second table.
Very simple.
However, most portal systems like Joomla etc. uses more complicated algorithms. This is the main reason for the migration problems I and others have. A future feature of PHPR could be the possibility to choose encryption algorithm to match a system you whish to migrate with.

A
alandob author 1/31/2010

The problem I have is the "original" password is already encrypted with MD5 and I would like to know how I can copy this data into the PHPRunner password table so that it's still valid. I think PHPRunner encrupts an already encrypted field and I want to input this directly so that it doesn't do this.
Kind regards,

Admin 2/1/2010

You can move existing data creating a dump of this table in phpMyAdmin and running generated SQL query against your new database.
PHPRunner only applies encryption to new data added via PHPRunner-generated pages. If you transfer data behind the scene you'll be just fine.

A
alandob author 2/1/2010

If I run the PHPRunner login setup step, and link the password element to the MYSQL table (original data) with the MD5 data I cannot login. For example, using MD5 data field "e10adc3949ba59abbe56e057f20f883e" which equals "abcdefg" originally (it doesn't, just an example) then try to login using "abcdefg" as the password - it doesn't work.
I hope the above example explains my position.

J
Jane 2/2/2010

Hi,
please make sure you've set up Encrypt password option on the User login settings dialog on the Securitytab.

If it doesn't help publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.

A
alandob author 2/2/2010

Works!!! Many thanks