36 replies to this topic

[Jonny_S]

How can I unblock myself from the Etom Manager?

I was entering my password and username correctly, I know this for a fact... then on the 3rd attempt it told me I had been blocked.
Well, how can I unblock myself and attempt to access the manager again, which I know i was getting my password right.

Thanks for future support

Bud

[Ralph]

Jonny_S, on Jan 7 2005, 01:30 PM, said:

How can I unblock myself from the Etom Manager?

I was entering my password and username correctly, I know this for a fact... then on the 3rd attempt it told me I had been blocked.
Well, how can I unblock myself and attempt to access the manager again, which I know i was getting my password right.

Thanks for future support

Bud

This issue has been covered multiple times in other forum threads although it's not easy finding them by doing a Site Search... Check out the link below for the answer... It's always a good idea to create a backup admin account so that you don't get totally locked out when you don't have time to dig into the database... WIth the backup account you can unlock your main admin account under Manage Users

http://www.etomite.com/index.php?showtopic=1343&hl=

[Ralph]

rad14701, on Jan 7 2005, 02:16 PM, said:

This issue has been covered multiple times in other forum threads although it's not easy finding them by doing a Site Search... Check out the link below for the answer... It's always a good idea to create a backup admin account so that you don't get totally locked out when you don't have time to dig into the database... WIth the backup account you can unlock your main admin account under Manage Users

http://www.etomite.com/index.php?showtopic=1343&hl=

To give a better answer than I have been able to glean from the forums, here is a more detailed explanation of what needs to be done... This will entail using phpMyAdmin or another utility whcih will allow direct access to your MySQL database... What you need to do is open the name-of-your-etomite-database_user_attributes table and locate your admin record... Edit the record so that blocked = 0 and blockeduntil = 0... This will allow you to login again... Remember that the username and password are case sensitive...

EDIT:
I have attached a PHP script which you can modify and run which will perform the Un-Block without the need for a MySQL utility if you'd like to give it a try...

Attached Files

•  unblock_etomite_user.php   1.8K   521 downloads

[Jonny_S]

well, thank you very much for that file, apparently it worked like a charm...

BUT, Im still getting the incorrect password etc... any ideas how I can change my password, because its very strange, I know for a fact its correct.

[Ralph]

Jonny_S, on Jan 7 2005, 05:29 PM, said:

well, thank you very much for that file, apparently it worked like a charm...

BUT, Im still getting the incorrect password etc... any ideas how I can change my password, because its very strange, I know for a fact its correct.

Geez... You're gonna have all of my secret utilities...

NOTE: 2006-11-14 semi-colon added to line 16 to correct syntax error (Thanks Matt) after 856 previous downloads

Attached Files

•  change_etomite_admin_password.php   1.23K   125 downloads

[Jonny_S]

Thank you so much again...

only, its still doing it I run the scripts, all was successful, and its still telling me its incorrect, Even when i copy and paste the new password.

this is rather strange.

[jaredc]

Could it be a corrupted db table? I'm thinking a table repair wouldn't hurt.

[Ralph]

jaredc, on Jan 7 2005, 11:11 PM, said:

Could it be a corrupted db table? I'm thinking a table repair wouldn't hurt.

I just requested info to go in and check his MySQL to see if there may be corruption via PM while you were typing the previous post... That's what I'm suspecting...

[Jonny_S]

rad14701 has just fugured out my problem, it was nothing to do with corrupt db table or anything...
for some very strange reason, in the config.inc.php under manager/includes/, it was pointing to the wrong database, (it was in fact my password).

Yet I didnt change anything.

Thank you again Ralph

[Jonny_S]

ooooops, let me continue from my post above!

well, let me explain, I am currently just developing the site on StudioX's Development Server, now, as Sniper set up the MySQL for me, he tried to install my backup MySQL, but there was no luck from that.
so... I had to start a fresh etomite installation, I installed etomite and da daaa, everything was perfect.

Now, since this issue has happened with the manager, I have now pointed the congif.inc.php to the correct database, (remembering I only have one database anyway, dev_bud), and then the manager works perfect, BUT, for some strange reason, my OLD mysql backup is appearing, and not what it was a few days ago...
I cant find any of my site which I had made, only what was in the old mysql backup, the latest stuff from the new installation has vanished.

yet when I change the config.inc.php back to how it was before i corrected it, I then get an error returned to me on the site:

Quote

« Etomite Parse Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Redirection attempt failed - please ensure the document you're trying to redirect to exists. Redirection URL: index.php?id=1 »
 
Parser timing
  MySQL:  0.0248 s s (1 Requests)
  PHP:  0.0385 s s  
  Total:  0.0633 s s

so now even the way it was before has gone wacko.

[Jonny_S]

well, I have informed you of that problem, but Im not just telling you, Im starting agian anyway Ive had a quick cleaout.

[Deb]

rad14701, on Jan 7 2005, 12:33 PM, said:

MySQL database... What you need to do is open the name-of-your-etomite-database_user_attributes table and locate your admin record... Edit the record so that blocked = 0 and blockeduntil = 0... This will allow you to login again... Remember that the username and password are case sensitive...

I've also managed to lock myself out of both the admin and the one user I've input into the system. I've gone to myphpadmin looking for where to change the 'failedlonginaccount' to zero but mine already says zero. I have zero listed in the 'default' column in myphpadmin under these sections:

blocked
blockeduntil
logincount
lastlogin
thislogin
failedloginaccount

I cannot find the admin record. Can someone show me what it looks like in myphpadmin?

I cannot even say that I'm a basic user of myphpadmin, I know *very little* about it so I'm lost as to where/how to change this especially since I'm already showing zeros.

When I came here looking for the answer to this, I was hoping to find that this lockout was a timed thing and that after X number of minutes I would be able to login again, but apparently that's not the case, heh?

If there is not a timed lockout, might I suggest that it be implemented or SOMETHING implemented so that users like me who are not database wizards can get back into their sites? This seems to be on the extreme side of things to me, to be fully and totally locked out w/o a way back in other than to go into a database which for people like me is a risk of totally crashing a site because we don't know enough about myphpadmin. Ok, so you might say "learn" or "you have no business playing with this then." Maybe I deserve that. But I am not a total newbie to CMS's and have in fact installed a number of them and successfully customized them and being locked out totally and completely in this fashion has never been an issue before, so I'm more than just a little bit surprised.

I'm afraid to try anything of what I have found here on these boards in myphpadmin because whatever instructions I find on the boards here do not match exactly with what I find in myphpadmin. I've seen scripts to 'run' to fix this but haven't a clue how to 'run' the scripts. I've seen 'copy/paste this' but do not find enough other information along w/that to feel comfortable trying it because I can't match up in myphpadmin where to copy/paste it.

Any suggestions? I just downloaded and installed this w/in the past week so it would be the newest version of Etomite that I have. I don't know what 'Phase' is but I don't think it applies to me from what I've seen anyway.

Any help appreciated, thank you =)
Deb

[Dean]

Hi Deb - if you are willing to PM me details I'll have a look at your phpMyAdmin for you, if you like.

Phase is what Etomite used to be called - although it was "phased out" when eto 0.6 was launched.. for legal reasons.

Quote

If there is not a timed lockout, might I suggest that it be implemented or SOMETHING implemented so that users like me who are not database wizards can get back into their sites? This seems to be on the extreme side of things to me, to be fully and totally locked out w/o a way back in other than to go into a database which for people like me is a risk of totally crashing a site because we don't know enough about myphpadmin. Ok, so you might say "learn" or "you have no business playing with this then." Maybe I deserve that. But I am not a total newbie to CMS's and have in fact installed a number of them and successfully customized them and being locked out totally and completely in this fashion has never been an issue before, so I'm more than just a little bit surprised.

This maybe something that you could add to the wishlist forum?

[Deb]

Alex, on Jan 22 2005, 03:43 PM, said:

Nah, it's already in 07.
Fully configurable, of course

COOL! So when is 7 available and can one upgrade 6 to 7 and then be able to use this feature if one is currently locked out?

Deb

[Deb]

I had seen that mentioned here but not until after I was locked out and it sounds like a wonderful idea that I will implement once I get straightened back around.

Deb

[Dean]

The issue that Deb was having was actually a mistaken password, which has now been resolved.