Webracer
|
| Posted: 09/12/2003, 12:41 AM |
|
I want to integrate my CCS applications with Mambo (CMS based on php & mysql). Mambo is using a table called "mos_users" to store his users.
So in the project settings I've set these values:
user table : mos_users
user id field : id
login field : username
password field : password
level group field: gid
However when I want to log, I always get the message that the password is incorrect. When I change the password field to another, this problem is solved.
The reason is simple. Mambo is using an "encrypted" field as password.
How can I solve this?
|
|
|
 |
DaveRexel
|
| Posted: 09/12/2003, 11:32 AM |
|
::
If you're using MD5 for encryption find the following code in common.php
$db->ToSQL($password, ccsText)
change it to
$db->ToSQL(MD5($password), ccsText)
Alternatively you could achieve the same result with event code in login page
Greetings
Dave
|
|
|
|
MD5
|
| Posted: 09/13/2003, 7:17 AM |
|
How do you create an MD5 encrypted feild in a mysql databse ?
|
|
|
|
feha
|
| Posted: 09/13/2003, 7:45 AM |
|
Tt doesn't need to be encrypted filed in MySQL ...
You just sotre the md5 hash as VARCHAR ...
regards
feha
[www.vision.to]
|
|
|
|
Jerry
|
| Posted: 09/13/2003, 8:49 AM |
|
The question I asked was "How do you create an MD5 encrypted feild in a mysql databse ? "
|
|
|
|
feha
|
| Posted: 09/13/2003, 11:18 AM |
|
sorry
visit
www.mysql.com
[manual]
|
|
|
|
Santa H Claus
|
| Posted: 09/13/2003, 2:27 PM |
|
ROFL ;)) feha that was the nicest RTFM I've ever seen
even if you jerry like many here are rude to those who try to help you I will explain this very carefully
*****************************************************************
to store an MD5 field you create a varchar(32)
to set or read this use the mySQL MD5 function in your SQL query
the field itself does not require any other special attributes
*****************************************************************
Please respond politely next time, remember that the advice may be from a person that does not speak english (you spelled field wrong in both your posts) so fehas answer to you was technically correct and your perception was unclear.
|
|
|
|
