How do I access the site as none of my passwords work anymore?

Next topic

Author	Message
Stuart Fenton	Thursday 27 March 2003 5:40:40 am I have installed the latest release of ez (3.0-1) fantastic!!. But I have locked myself out from using any of the usernames and passwords. How can I get access to the site by maybe removing md5_hash and resetting it.? Your help is appreciated. Thanks in advance. Stuart
Bård Farstad	Thursday 27 March 2003 5:50:30 am To generate a new password you need to do the following: Create a new md5 hash. This can be done with the command (linux): echo "mypassword" \| md5sum Which will print the md5sum: d84c7934a7a786d26da3d34d5f7c6c86 You then need to reset the values in the SQL database for your user. update ezuser set password_hash_type='1' , password_hash='d84c7934a7a786d26da3d34d5f7c6c86' where contentobject_id= 10; Replace 10 with the id of your user. PS: take backup of your database before you start. --bård Documentation: http://ez.no/doc
Sergiy Pushchin	Friday 28 March 2003 2:31:52 am If you aren't sick about security you can use more simple way to update password update ezuser set password_hash_type='5' , password_hash='your _plain_text_password' where contentobject_id= 10; Replace 10 with the id of your user. Password will be changed to md5_hash after your first login automatically.

Author

Message

Thursday 27 March 2003 5:40:40 am

I have installed the latest release of ez (3.0-1) fantastic!!.

But I have locked myself out from using any of the usernames and passwords. How can I get access to the site by maybe removing md5_hash and resetting it.?

Your help is appreciated.

Thanks in advance.

Stuart

Bård Farstad

Thursday 27 March 2003 5:50:30 am

To generate a new password you need to do the following:
Create a new md5 hash. This can be done with the command (linux):
echo "mypassword" | md5sum
Which will print the md5sum:
d84c7934a7a786d26da3d34d5f7c6c86

You then need to reset the values in the SQL database for your user.
update ezuser
set
password_hash_type='1' , password_hash='d84c7934a7a786d26da3d34d5f7c6c86'
where
contentobject_id= 10;

Replace 10 with the id of your user.

PS: take backup of your database before you start.

--bård

Documentation: http://ez.no/doc

Sergiy Pushchin

Friday 28 March 2003 2:31:52 am

If you aren't sick about security you can use more simple way to update password
update ezuser
set
password_hash_type='5' , password_hash='your _plain_text_password'
where
contentobject_id= 10;
Replace 10 with the id of your user.
Password will be changed to md5_hash after your first login automatically.

eZ debug

Timing:	Jan 18 2025 10:41:26
Script start
Timing:	Jan 18 2025 10:41:26
Module start 'layout'
Timing:	Jan 18 2025 10:41:26
Module start 'content'
Timing:	Jan 18 2025 10:41:27
Module end 'content'
Timing:	Jan 18 2025 10:41:27
Script end

Main resources:

Total runtime	1.1921 sec
Peak memory usage	4,096.0000 KB
Database Queries	59

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0090	588.1719	152.6563
Module start 'layout'	0.0090	0.0039	740.8281	39.5078
Module start 'content'	0.0129	1.1778	780.3359	575.8594
Module end 'content'	1.1907	0.0014	1,356.1953	12.0938
Script end	1.1921		1,368.2891

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0037	0.3129	16	0.0002
Check MTime	0.0015	0.1252	16	0.0001
Mysql Total
Database connection	0.0016	0.1348	1	0.0016
Mysqli_queries	1.1332	95.0546	59	0.0192
Looping result	0.0006	0.0492	57	0.0000
Template Total	1.1537	96.8	2	0.5769
Template load	0.0021	0.1744	2	0.0010
Template processing	1.1516	96.6028	2	0.5758
Template load and register function	0.0002	0.0169	1	0.0002
states
state_id_array	0.0008	0.0671	1	0.0008
state_identifier_array	0.0015	0.1295	2	0.0008
Override
Cache load	0.0018	0.1489	34	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0608	3	0.0002
Fetch class attribute name	0.0019	0.1579	5	0.0004
XML
Image XML parsing	0.0012	0.1008	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0010	5	0.0000
General
dbfile	0.0015	0.1257	23	0.0001
String conversion	0.0000	0.0013	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 14 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs