Jump to content


Blocked from Manager

Started by Jonny_S, Jan 07 2005 05:30 PM

36 replies to this topic

#21 Guest_MrGreen_*

  • Guests

Posted 31 January 2005 - 10:35 PM

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

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... B)

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... B)

Thanks for the information, it was very helpful! I was getting tired of browsing through the tables on my extremely slow internet connection.

#22 mrruben5

    Likes Etomite Forums!

  • Member
  • PipPip
  • 255 posts

Posted 09 June 2005 - 06:35 PM

I tried to login into etomite today, typed the security code, and it said it was wrong. So i typed again, wrong, and again, wrong. I think my browser was caching the security image, because it was the same over and over again.

And now it says I've been blocked. I'm the root admin, how can I unblock myself?

#23 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,506 posts
  • Gender:Male

Posted 09 June 2005 - 11:08 PM

mrruben5, on Jun 9 2005, 03:35 PM, said:

I tried to login into etomite today, typed the security code, and it said it was wrong. So i typed again, wrong, and again, wrong. I think my browser was caching the security image, because it was the same over and over again.

And now it says I've been blocked. I'm the root admin, how can I unblock myself?
If you go back and read this entire thread you will find that your question has been answered on at least one previous occassion... You will also find a PHP script to assist you in the resolution... If you have this problem in the future you can remedy the problem regarding the Captcha code by clicking on it for a replacement code which should then work as predicted... Also, as stated elsewhere, it is a good idea to make an extra admin account for these "just in case" situations as you can then use it to unblock any blocked accounts... :eto:

#24 sandra-ch

    Etomite Forum Newbie

  • Member
  • 43 posts

Posted 02 March 2007 - 01:10 AM

hi

i have two problems, i can not log in to the manager (and no, i didn't create a second admin-account) and i get an error message on the website:

My Etomite Site
« Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT * FROM 'bamyan'.eto_site_content WHERE 'bamyan'.eto_site_content.id = '1';
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0006 s s (0 Requests)
PHP: 0.0092 s s
Total: 0.0098 s s

i have access to phpmyadmin and the mysql-database.
i did manually changed the password of the user in the 'eto_manager_users' table but i could still not log in.
i looked in the table 'eto_user_attributes' and the field blocked is set to 0

then i tried the script to unblock and got the following message:

Connection to eto_manager_users successful...
Authentication Failed... Aborting Update...

I tried also the script to change the password and got the following message:

Update failed: Incorrect table name ''

Anyone has an idea how i can get the website again to work?


phpMyAdmin - 2.8.2.4
MySQL - 4.0.24
Localhost via UNIX socket
MySQL Client-Version: 4.1.18


thanks
sandra-ch

#25 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,506 posts
  • Gender:Male

Posted 02 March 2007 - 03:27 AM

View Postsandra-ch, on Mar 1 2007, 08:10 PM, said:

<<< SNIP >>>
Anyone has an idea how i can get the website again to work?
thanks
sandra-ch
When you attempted to change your password using phpMyAdmin did you remember to set the function dropdown to MD5...??? Also, what release are you running...??? Older releases had a potential security issue which has been patched without exploiting the exploit... It's highly unlikely that you were a victim of this exploit, however... Feel free to PM me with server details if you can't get back up and running and I'll take a hands on look for you if you like...

#26 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,506 posts
  • Gender:Male

Posted 02 March 2007 - 03:23 PM

I have resolved the issues that sandra-ch was having with her site... I will allow her the opportunity to explain the details before posting any comments here...

#27 sandra-ch

    Etomite Forum Newbie

  • Member
  • 43 posts

Posted 02 March 2007 - 08:22 PM

thanks ralph for fixing my problem so quickly.

As i understand it was a problem in the config.inc.php with single quotes ' instead of backticks ` and i had a problem in the eto_manager_users table with the password encryption MD5.

Now i have created a backup-admin-account....

Thanks very much - i will donate some money to the Etomite Project

sandra-ch

#28 Checkerboard

    Etomite Forum Newbie

  • Member
  • 1 posts

Posted 22 February 2008 - 09:57 PM

The unblock-user script attachment download is no longer working. Could someone reattach it or just provide the SQL statement necessary to edit the user_attributes table for a known username?

Edited by Checkerboard, 22 February 2008 - 09:58 PM.

#29 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,506 posts
  • Gender:Male

Posted 23 February 2008 - 02:43 AM

View PostCheckerboard, on Feb 22 2008, 04:57 PM, said:

The unblock-user script attachment download is no longer working. Could someone reattach it or just provide the SQL statement necessary to edit the user_attributes table for a known username?


I'll have to see if I still have a copy kicking around... If not, and if nobody else posts one first, I'll write a new one...

#30 Ed Headset

    Likes Etomite Forums!

  • Developers
  • PipPip
  • 191 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Etomite, PHP, Ajax.
    3D imaging

Posted 23 February 2008 - 08:06 AM

I think this is the one :
Attached File  unblock_etomite_user.php   1.8K   18 downloads
:lol:

#31 Cris D.

    Loves Etomite Forums!

  • Developers
  • PipPipPipPip
  • 1,104 posts
  • Gender:Male

Posted 23 February 2008 - 09:37 PM

Shouldn't this be getting added to the snippet library so it does not get orphaned again? Anyone want to take credit for being the submitter?

#32 Ed Headset

    Likes Etomite Forums!

  • Developers
  • PipPip
  • 191 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Etomite, PHP, Ajax.
    3D imaging

Posted 24 February 2008 - 08:33 AM

View PostCris D., on Feb 23 2008, 10:37 PM, said:

Shouldn't this be getting added to the snippet library so it does not get orphaned again? Anyone want to take credit for being the submitter?

Good idea, Done it :lol:


I didn't know where exactly I should place it, because it isn't a real snippet,
But I think this is a good choice.
Etomite Support Forums > Downloads > Snippets > Security > unblock_etomite_user


@Ralph;

Could you change the submitters name (mine) to yours ?
You are the original creator ;)

#33 Cris D.

    Loves Etomite Forums!

  • Developers
  • PipPipPipPip
  • 1,104 posts
  • Gender:Male

Posted 24 February 2008 - 08:47 AM

Hey Ed,
I suppose having one in miscellaneous and one in security should cover all bases, Ralph already posted it a couple of hours ago. At least that's one snippet that won't go missing again in a hurry!

#34 Ed Headset

    Likes Etomite Forums!

  • Developers
  • PipPip
  • 191 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Etomite, PHP, Ajax.
    3D imaging

Posted 24 February 2008 - 12:42 PM

View PostCris D., on Feb 24 2008, 09:47 AM, said:

Hey Ed,
I suppose having one in miscellaneous and one in security should cover all bases, Ralph already posted it a couple of hours ago. At least that's one snippet that won't go missing again in a hurry!
:blush: Oops :Whistle:

Note to myself: Check if it is already posted :lol:

I hadn't seen a reply here, so I just guessed it wasn't posted in the Snippets.

Better to check first :P

#35 stp69

    Etomite Forum Newbie

  • Member
  • 41 posts

Posted 25 March 2008 - 02:07 PM

Hello all

since a few day i can't go log into manager. I only read:
"Not Logged In!"

there is no loginscreen, only a blank site. I dont change anything....

whats up??

#36 Ralph

    Loves Etomite Forums!

  • Admin
  • 6,506 posts
  • Gender:Male

Posted 25 March 2008 - 07:04 PM

View Poststp69, on Mar 25 2008, 10:07 AM, said:

Hello all

since a few day i can't go log into manager. I only read:
"Not Logged In!"

there is no loginscreen, only a blank site. I dont change anything....

whats up??


Did your host make any server changes that you weren't notified of...??? This sounds familiar...

EDIT: I knew it sounded familiar... Here is correct thread for this issue... I found by searching for "not logged in", complete with quotes so it would be considered a phrase and not gag because the first word was less that 4 chars long... I can tell you right now that this is most likely a hosting issue and not one that can be fixed within the current release of Etomite... I think this is related to include paths but I can't say for sure... If you check with your host I'm almost 100% sure they made some changes in the global php.ini file...

#37 youngboy815

    Etomite Forum Newbie

  • Member
  • 3 posts

Posted 17 July 2010 - 02:04 AM

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...
Back to Etomite v0.x Support · Next Unread Topic →


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users