I'm new - Is it seriously this tedious to reset the password?

11 Posts

estevancarlos Reply #11, 15 years, 7 months ago

Here is some of it. I’m not at a point where I know how to parse this information.

[2011-03-01 12:05:54] (ERROR in xPDO::connect @ /home/aug4th5/public_html/modxdev/core/xpdo/xpdo.class.php : 331) SQLSTATE[28000] [1045] Access denied for user 'aug4th5_estevan'@'localhost' (using password: YES)
[2011-03-01 12:05:54] (ERROR @ /modxdev/index.php) Error preparing statement for query: SELECT `modResource`.`id` AS `modResource_id`, `modResource`.`type` AS `modResource_type`, `modResource`.`contentType` AS `modResource_contentType`, `modResource`.`pagetitle` AS `modResource_pagetitle`, `modResource`.`longtitle` AS `modResource_longtitle`, `modResource`.`description` AS `modResource_description`, `modResource`.`alias` AS `modResource_alias`, `modResource`.`link_attributes` AS `modResource_link_attributes`, `modResource`.`published` AS `modResource_published`, `modResource`.`pub_date` AS `modResource_pub_date`, `modResource`.`unpub_date` AS `modResource_unpub_date`, `modResource`.`parent` AS `modResource_parent`, `modResource`.`isfolder` AS `modResource_isfolder`, `modResource`.`introtext` AS `modResource_introtext`, `modResource`.`content` AS `modResource_content`, `modResource`.`richtext` AS `modResource_richtext`, `modResource`.`template` AS `modResource_template`, `modResource`.`menuindex` AS `modResource_menuindex`, `modResource`.`searchable` AS `modResource_searchable`, `modResource`.`cacheable` AS `modResource_cacheable`, `modResource`.`createdby` AS `modResource_createdby`, `modResource`.`createdon` AS `modResource_createdon`, `modResource`.`editedby` AS `modResource_editedby`, `modResource`.`editedon` AS `modResource_editedon`, `modResource`.`deleted` AS `modResource_deleted`, `modResource`.`deletedon` AS `modResource_deletedon`, `modResource`.`deletedby` AS `modResource_deletedby`, `modResource`.`publishedon` AS `modResource_publishedon`, `modResource`.`publishedby` AS `modResource_publishedby`, `modResource`.`menutitle` AS `modResource_menutitle`, `modResource`.`donthit` AS `modResource_donthit`, `modResource`.`haskeywords` AS `modResource_haskeywords`, `modResource`.`hasmetatags` AS `modResource_hasmetatags`, `modResource`.`privateweb` AS `modResource_privateweb`, `modResource`.`privatemgr` AS `modResource_privatemgr`, `modResource`.`content_dispo` AS `modResource_content_dispo`, `modResource`.`hidemenu` AS `modResource_hidemenu`, `modResource`.`class_key` AS `modResource_class_key`, `modResource`.`context_key` AS `modResource_context_key`, `modResource`.`content_type` AS `modResource_content_type` FROM `modx_site_content` AS `modResource` WHERE  ( `modResource`.`id` = ? AND `modResource`.`deleted` = ? )   - 
[2011-03-01 12:05:54] (ERROR @ /modxdev/index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  - 
[2011-03-01 12:06:01] (ERROR @ /modxdev/manager/index.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  - 
[2011-03-01 12:06:01] (ERROR in xPDO::connect @ /home/aug4th5/public_html/modxdev/core/xpdo/xpdo.class.php : 331) SQLSTATE[28000] [1045] Access denied for user 'aug4th5_estevan'@'localhost' (using password: YES)
[2011-03-01 12:06:01] (ERROR @ /modxdev/manager/index.php) Error preparing statement for query: SELECT modUser.*, Profile.email, Profile.fullname FROM `modx_users` AS `modUser` JOIN `modx_user_attributes` `Profile` ON `modUser`.`id` =  `Profile`.`internalKey` WHERE `Profile`.`email` = ?  - 
[2011-03-01 12:06:01] (ERROR @ /modxdev/connectors/lang.js.php) Error preparing statement for query: SELECT `modSession`.`id` AS `modSession_id`, `modSession`.`access` AS `modSession_access`, `modSession`.`data` AS `modSession_data` FROM `modx_session` AS `modSession` WHERE `modSession`.`id` = ?  -

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #12, 15 years, 7 months ago

It’s having trouble connecting to your database server..

If this is a recent problem, perhaps your database connection is offline, or the password has change.d

Check the config files (core/config/config.inc.php) to see if the database connection details (and also server: localhost) are still valid for your setup.

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.

11 Posts

estevancarlos Reply #13, 15 years, 7 months ago

Thanks i’ll look into that although I tried to double check that aspect. Hm. Thanks a lot though.

1,161 Posts

Photowebmax Reply #14, 15 years, 7 months ago

What is the procedure for resetting the manager password in Revo?

The tables are so different from Evo...

☆ A M B ☆
3,141 Posts

Mark Hamstra Reply #15, 15 years, 7 months ago

prefix_users table I guess.

Never tried, but the password field seems like the right one. tongue

Currently it’s simply md5, but 2.1 will have better algorithms so that’ll change.

Mark Hamstra • Developer spending his days working on Premium Extras and a MODX Site Dashboard with the ability to remotely upgrade MODX and extras to make the MODX world a little better.

Tweet me @mark_hamstra, check my infrequent blog at markhamstra.com, my slightly more frequent ramblings at MODX.today or see code at Github.

☆ A M B ☆
2,475 Posts

Everett Reply #16, 15 years, 7 months ago

As the author of the original post you mentioned, NO, it is only under EXTREME circumstances that you have to go through a direct database edit to reset the password. It should only be done if you don’t have access to a site (as in the case where a dev abandoned the site and did not share the passwords with you) or in cases where the email address was never configured, or where the email delivery is not working.

If you never set up your email address, then of course the system can’t send you a new password because you’ll never get it. It’s unfortunately common with webservers that outgoing emails are either disabled (i.e. sendmail is disabled) or where email sending is crippled to a point as to be useless... in my experience it’s not uncommon to run into trouble there. But this has virtually nothing to do with MODx. I’ve had to hack into Expression Engine, Drupal, and WordPress sites for exactly the same reasons. If you want to evaluate MODx, I recommend getting a Bluehost account and using the SimpleScripts installer. It’s literally a one-click install. PM if you want to talk shop on strengths and weaknesses of various systems, but I got nothing but praise for MODx... these dudes are working hard, the forums are vibrant, and the underlying architecture is not only sensible, but f@!%ing elegant. Expression Engine is the only other system that’s in the same league in my opinion.

Hosting stuff: http://fireproofsocks.com/
Coding stuff: http://craftsmancoding.com/
Blog stuff: http://tipsfor.us/

11 Posts

estevancarlos Reply #17, 15 years, 7 months ago

I did have my email set up and verified in the DB however something random happened where it was no longer able to connect to my DB. I just uninstalled and reinstalled it. I really had no idea if it was something I was doing wrong, ModX or as it turns out, something with my DB or server or something.

☆ A M B ☆
2,475 Posts

Everett Reply #18, 15 years, 7 months ago

Well, it’s certainly possible that MODx had a glitch, but the things you’ve described I’ve witnessed on virtually every flavor of web app. *shrugs*

Hosting stuff: http://fireproofsocks.com/
Coding stuff: http://craftsmancoding.com/
Blog stuff: http://tipsfor.us/