Jump to content


Blocked from Manager

Started by Jonny_S, Jan 07 2005 05:30 PM

36 replies to this topic

#16 Guest_SniperX_*

  • Guests

Posted 23 January 2005 - 09:52 AM

Can I also suggest, in the interim, that you create a secondary Admin Account for use if the primary one ever gets locked out.

#17 Deb

    Likes Etomite Forums!

  • Member
  • PipPip
  • 253 posts

Posted 23 January 2005 - 10:08 AM

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

#18 Guest_Alex_*

  • Guests

Posted 23 January 2005 - 11:10 AM

07 won't be around for quite a while yet >.<
The settings you can then configure are how long you want the lock timeout to be (in minutes), and whether you want to use a timeout at all. Oh, and also the number of login attempts people can make before being locked out.

#19 Dean

    Loves Etomite Forums!

  • Admin
  • 4,746 posts
  • Gender:Male

Posted 23 January 2005 - 07:45 PM

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

#20 Guest_MrGreen_*

  • Guests

Posted 31 January 2005 - 09:51 PM

Deb, on Jan 22 2005, 02:17 PM, said:

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

Deb,

Edit: I just realized this is already resolved, but will leave this post in case it's helpful.

When you pull up that table in phpMyAdmin, it shows you what the fields are and their defaults (you don't need to know what those are). If you click on the "Browse" tab above all that, you will see a list of the table data where you will see admin and any other user in your database. Look for the one that has a "Full Name" of "Administration account" and click the little pencil to "edit" it.

Hope that helps!

-Philip

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


1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users