Help: Reset the admin account

Next topic

Author	Message
Andreas Widerøe Andersen	Saturday 10 April 2004 4:04:18 am I played around with some settings in my EZ installation and I somehow disallowed the admin account to log in. I change the password and I think I place the account in some very wrong location. Anyway, how can I reset the admin account with it's default "publish" password and original roles? I have access to phpMyAdmin so I can run SQL code. Thanks! Andreas
Marco Zinn	Thursday 15 April 2004 2:11:06 pm Hi, can you sucessfully log in with that account? I mean: do you know the password? If you just moved the user to some other group, you should be able to move him back to the "administrator users" group. Quick idea: You need the node id of the "administrator users" group (from the ezcontentobject_tree table). When you have this Node ID, you must find the node "administrator user" (not the content object, but the node!) and fix the "parent node" field and the path fields (one with numbers and one with the URL string). Maybe this will do. You could of course import an SQL dump of a fresh installation, but you will loose all your content, when you do this! The "problem" is, that users and user groups are just "objects", just like an article. So, they they in the same table... Just the password stuff is in a seperate table, but i think, that's not your problem. Marco http://www.hyperroad-design.com

Author

Message

Saturday 10 April 2004 4:04:18 am

I played around with some settings in my EZ installation and I somehow disallowed the admin account to log in. I change the password and I think I place the account in some very wrong location.

Anyway, how can I reset the admin account with it's default "publish" password and original roles? I have access to phpMyAdmin so I can run SQL code.

Thanks!
Andreas

Marco Zinn

Thursday 15 April 2004 2:11:06 pm

Hi,
can you sucessfully log in with that account? I mean: do you know the password?
If you just moved the user to some other group, you should be able to move him back to the "administrator users" group.
Quick idea:
You need the node id of the "administrator users" group (from the ezcontentobject_tree table). When you have this Node ID, you must find the node "administrator user" (not the content object, but the node!) and fix the "parent node" field and the path fields (one with numbers and one with the URL string).
Maybe this will do.
You could of course import an SQL dump of a fresh installation, but you will loose all your content, when you do this! The "problem" is, that users and user groups are just "objects", just like an article. So, they they in the same table... Just the password stuff is in a seperate table, but i think, that's not your problem.

Marco
http://www.hyperroad-design.com

eZ debug

Timing:	Jan 19 2025 00:10:39
Script start
Timing:	Jan 19 2025 00:10:39
Module start 'layout'
Timing:	Jan 19 2025 00:10:39
Module start 'content'
Timing:	Jan 19 2025 00:10:40
Module end 'content'
Timing:	Jan 19 2025 00:10:40
Script end

Main resources:

Total runtime	0.6244 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0051	587.9063	152.6250
Module start 'layout'	0.0051	0.0033	740.5313	39.4453
Module start 'content'	0.0084	0.6144	779.9766	523.9141
Module end 'content'	0.6228	0.0015	1,303.8906	8.1641
Script end	0.6243		1,312.0547

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0039	0.6300	16	0.0002
Check MTime	0.0014	0.2213	16	0.0001
Mysql Total
Database connection	0.0005	0.0826	1	0.0005
Mysqli_queries	0.5761	92.2639	54	0.0107
Looping result	0.0006	0.0893	52	0.0000
Template Total	0.5923	94.9	2	0.2961
Template load	0.0031	0.5026	2	0.0016
Template processing	0.5891	94.3551	2	0.2946
Template load and register function	0.0002	0.0336	1	0.0002
states
state_id_array	0.0010	0.1618	1	0.0010
state_identifier_array	0.0008	0.1351	2	0.0004
Override
Cache load	0.0027	0.4257	16	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0948	2	0.0003
Fetch class attribute name	0.0011	0.1690	3	0.0004
XML
Image XML parsing	0.0012	0.1898	2	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0011	3	0.0000
General
dbfile	0.0022	0.3595	16	0.0001
String conversion	0.0000	0.0016	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
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs