Creating passwords with md5 - how?

«

Previous topic

|

|

Next topic

»

Author	Message
K259	Friday 22 September 2006 2:02:32 am I have problems with user import. Don't get the correct hash_value for password_hash in ezuser table. I'm using md5_user for hashing. my $sql = uu{ update users set password=md5(login + "\n" + password) }; Anyone have an idea?
Claudia Kosny	Friday 22 September 2006 2:33:02 am Hi K259 I am not exactly sure what programming language your example code is in so here an example if you use PHP and raw SQL commands (without going through EZ) $password_hash = md5('mylogin' . "\n" . 'foobar'); $query = 'UPDATE ezuser ' . ' SET password_hash = "' . $password_hash . '"' . ' WHERE login = "mylogin"'; works fine Greetings from Luxembourg Claudia
K259	Friday 22 September 2006 3:07:36 am Hi and thanks for your answer! I'm using perl..the sql statement concatenates login and password, but I get the wrong hash_value for password_hash. Guess I've tried almost everything: concatenate just password in plaintext, concat login+password in plaintext, concat login,password in plaintext + site + hash_type, but I know the md5_user function I shall use, only concatenate login and password in plaintext, but I don't know why the hash is not correct :(
Claudia Kosny	Friday 22 September 2006 5:23:47 am Thread continued here: http://ez.no/community/forum/developer/documentation_not_correct_for_md5_hashing

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 00:34:39
Script start
Timing:	Jan 31 2025 00:34:39
Module start 'layout'
Timing:	Jan 31 2025 00:34:39
Module start 'content'
Timing:	Jan 31 2025 00:34:39
Module end 'content'
Timing:	Jan 31 2025 00:34:39
Script end

Main resources:

Total runtime	0.0253 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.1328	151.2109
Module start 'layout'	0.0055	0.0052	739.3438	220.6875
Module start 'content'	0.0107	0.0129	960.0313	997.6953
Module end 'content'	0.0236	0.0016	1,957.7266	33.9922
Script end	0.0253		1,991.7188

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	10.2858	14	0.0002
Check MTime	0.0010	4.0580	14	0.0001
Mysql Total
Database connection	0.0009	3.5963	1	0.0009
Mysqli_queries	0.0035	13.7247	3	0.0012
Looping result	0.0000	0.0989	1	0.0000
Template Total	0.0012	4.6	1	0.0012
Template load	0.0010	3.7584	1	0.0010
Template processing	0.0002	0.8338	1	0.0002
Override
Cache load	0.0006	2.3234	1	0.0006
General
dbfile	0.0003	0.9921	8	0.0000
String conversion	0.0000	0.0424	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs