Lost my admin access to a site, need help

Next topic

Author	Message
Jorge estévez	Wednesday 18 May 2011 7:15:46 pm My site (developed with version 4.3 of eZ Publish) has suddenly stopped accepting my login/password as the administrator of the site, neither frontend or backend site will let me go beyond the login page. The frontend and backend logged out, I could noticed it because of a page refresh. I was working without problems a few hours earlier. Really strange, I have been developing this site for a few months with thousands of information and I was very happy because the 4.3 version works like a charm. I have not done any changes at all in users/roles or apache/mysql configuration, in fact I was working with CSS definitions for the past four days. If someone knows how to hack the database so I can login again… Thanks Diseño Web Cuba Web Design Cuba www.elfosdesign.com
Marko Žmak	Wednesday 18 May 2011 11:30:04 pm Are there any ohter accounts that can log in? Is this problem only with the admin user or with all the users? Turn on debug output and see if you get some usefull info there. As for chaning the forgotten password you can use the forgottpassword feature (usually located at yoursite.com/user/forgotpassword), or you can see here: http://ezpedia.org/fr/solution/reseting_the_admin_password_in_ez_publish (it's the 5th result when googling "ez publish retrieve password") -- Nothing is impossible. Not if you can imagine it! Hubert Farnsworth
Steven E. Bailey	Thursday 19 May 2011 1:25:32 am Did your site.ini change? If someone changed the [UserSettings] HashType you wouldn't be able to log in anymore. Or, if your HashType is not the default md5_user but md5_site and someone changed the SiteName, you also wouldn't be able to log in. If the forgotpassword doesn't work for you and you have access to the database then go to the ezuser table and you can change your password hash which will change the password. If the password_hash_type is 2, that's the default. then you can generate a new hash by doing this: <?php echo md5(<name>."\n".<password>); ?> If it's not the default then the string to generate the password will be different but easy to find out by looking at the code. Edit: putting the code in a literal tag to turn off the emoticon. Certified eZPublish developer http://ez.no/certification/verify/396111 Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

Author

Message

Wednesday 18 May 2011 7:15:46 pm

My site (developed with version 4.3 of eZ Publish) has suddenly stopped accepting my login/password as the administrator of the site, neither frontend or backend site will let me go beyond the login page.

The frontend and backend logged out, I could noticed it because of a page refresh. I was working without problems a few hours earlier.

Really strange, I have been developing this site for a few months with thousands of information and I was very happy because the 4.3 version works like a charm.

I have not done any changes at all in users/roles or apache/mysql configuration, in fact I was working with CSS definitions for the past four days.

If someone knows how to hack the database so I can login again…

Thanks

Diseño Web Cuba
Web Design Cuba
www.elfosdesign.com

Marko Žmak

Wednesday 18 May 2011 11:30:04 pm

Are there any ohter accounts that can log in? Is this problem only with the admin user or with all the users?

Turn on debug output and see if you get some usefull info there.

As for chaning the forgotten password you can use the forgottpassword feature (usually located at yoursite.com/user/forgotpassword), or you can see here:

http://ezpedia.org/fr/solution/reseting_the_admin_password_in_ez_publish

(it's the 5th result when googling "ez publish retrieve password")

--
Nothing is impossible. Not if you can imagine it!

Hubert Farnsworth

Steven E. Bailey

Thursday 19 May 2011 1:25:32 am

Did your site.ini change? If someone changed the [UserSettings] HashType you wouldn't be able to log in anymore. Or, if your HashType is not the default md5_user but md5_site and someone changed the SiteName, you also wouldn't be able to log in.

If the forgotpassword doesn't work for you and you have access to the database then go to the ezuser table and you can change your password hash which will change the password. If the password_hash_type is 2, that's the default. then you can generate a new hash by doing this:

<?php echo md5(<name>."\n".<password>); ?>

If it's not the default then the string to generate the password will be different but easy to find out by looking at the code.

Edit: putting the code in a literal tag to turn off the emoticon.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

eZ debug

Timing:	Jan 17 2025 23:40:42
Script start
Timing:	Jan 17 2025 23:40:42
Module start 'layout'
Timing:	Jan 17 2025 23:40:42
Module start 'content'
Timing:	Jan 17 2025 23:40:43
Module end 'content'
Timing:	Jan 17 2025 23:40:43
Script end

Main resources:

Total runtime	0.8211 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.0058	588.0391	152.6406
Module start 'layout'	0.0058	0.0034	740.6797	39.4688
Module start 'content'	0.0092	0.8106	780.1484	591.7813
Module end 'content'	0.8198	0.0012	1,371.9297	12.1406
Script end	0.8210		1,384.0703

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0044	0.5386	16	0.0003
Check MTime	0.0021	0.2554	16	0.0001
Mysql Total
Database connection	0.0007	0.0849	1	0.0007
Mysqli_queries	0.7688	93.6394	59	0.0130
Looping result	0.0005	0.0656	57	0.0000
Template Total	0.7877	95.9	2	0.3939
Template load	0.0032	0.3888	2	0.0016
Template processing	0.7845	95.5480	2	0.3923
Template load and register function	0.0001	0.0156	1	0.0001
states
state_id_array	0.0014	0.1762	1	0.0014
state_identifier_array	0.0008	0.0924	2	0.0004
Override
Cache load	0.0028	0.3442	25	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0722	3	0.0002
Fetch class attribute name	0.0009	0.1118	5	0.0002
XML
Image XML parsing	0.0013	0.1526	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0011	5	0.0000
General
dbfile	0.0009	0.1079	25	0.0000
String conversion	0.0000	0.0014	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
5	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
1	content/datatype/view/ezxmltags/strong.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/strong.tpl
1	content/datatype/view/ezxmltags/li.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/li.tpl
1	content/datatype/view/ezxmltags/ul.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/ul.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 16 Number of unique templates used: 9

Time used to render debug report: 0.0001 secs