[Digital Grape]

I forgot my password, and I had three attempts of remembering it, and then it said that I have been blocked.

a) How long for
B) How can I reset it.

Thanks

[luke]

I am new to this and trying to get an answer as well, the only thing I have found which may be worth trying is on http://www.etomite.c...=590&hl=blocked

It says:
"Go to the ETOMITE_user_attributes table, and set failedlogins and blocked to 0 for your user, and also change the blockeddate to 0. Oh, and change the name of the system from SensibleCMS to Etomite. That'll help too. "

If I find anything of more use I will post it.

[jaredc]

I'd change the failedlogincount, blocked, AND blockeduntil to 0. Then you can take another shot at it. But if you've really forgotten your pasword, this is going to be a clumsy solution. You might consider changing those fields to 0 as mentioned, AND change your password to something you know in the prefixmanager_users table. You'll need phpMyAdmin or skills with mySQL from the command line to do this. If you don't have direct access to the database somehow, you're hurting.

[Digital Grape]

I thought I had an idea about what it was, but seeminly not.

Maybe a "I forgot my password.." feature in the next version?

I do have access to the database. I'll try your suggestions.

Thanks. :)

[Ralph]

If you have access to your Etomite database, try using the following script as a stand-alone program... It will generate a new password that you can then copy and paste into your admin record within the manager_user table...

<?php
# MD5 Password Creator
# Usage: call this script, passing the textual passowrd you desire
#        Example: md5-password.php?password=new_password
#
echo md5($password);
?>

[luke]

Jaredcs fix woirked for me. I am using phasecms, which is basically the same thing but probably a bit older and just used this SQL and I could reuse my old password:

UPDATE phase_user_attributes
SET blocked = 0, failedlogincount = 0, blockeduntil = 0
WHERE id=1

[jaredc]

luke, on Oct 8 2004, 09:44 AM, said:

I am using phasecms, which is basically the same thing but probably a bit older...

The name Phase was replaced by Etomite for trademark dispute reasons. It is the same project, under the same management (Alex), with the same user community. Etomite took over at the 0.6 release, the last version under the Phase name was 5.3 - 0.6 has MANY improvements. You might want to consider upgrading... :D

[Enkil]

rad14701, on Oct 8 2004, 02:06 PM, said:

If you have access to your Etomite database, try using the following script as a stand-alone program... It will generate a new password that you can then copy and paste into your admin record within the manager_user table...

<?php
# MD5 Password Creator
# Usage: call this script, passing the textual passowrd you desire
#        Example: md5-password.php?password=new_password
#
echo md5($password);
?>

Where can i find the

manager_user table

?

[Ralph]

Enkil, on Oct 16 2004, 11:24 PM, said:

Where can i find the

manager_user table

?

For a standard installation this would actually be called etomite_manager_users, and can be accessed using phpMyAdmin or any other MySQL administration software... Or, if you don't have access to a MySQL administration program, which everyone should have as a basic tool, you could create another small script which would make the password change for you... A working example of the script to perform this task would be:

<?
# MD5 admin password changer for Etomite
$host = "localhost";  # Name of MySQL host
$user = "user";  # MySQL username
$pass = "password";  # MySQL password
$db = "etomite";  # Etomite database name
$table = "etomite_manager_users";  # The etomite_manager_users table name with prefix
$admin_password = "your_new_password";  # The new password for the admin user

$md5_password = md5($admin_password);
$sql = "UPDATE `$table` SET `password` = '$md5_password' WHERE `username` = 'admin' LIMIT 1;";
if (!$conn = mysql_connect($host, $user, $pass)) die('Could not connect: ' . mysql_error());
if (!mysql_select_db($db)) die('Database select failed: ' . mysql_error());
if (!mysql_query($sql)) die('Update failed: ' . mysql_error());
else echo "Password successfully changed for admin...";
mysql_close($conn);
?>

Once you have regained access to your Etomite Manager, the very first thing you should do is to create an alternate Admin account using a password that you are sure not to forget... By doing this you will insure that you won't be locked out of Etomite Manager again... :eto:

Good Luck... B)

[Enkil]

rad14701, on Oct 17 2004, 04:01 PM, said:

For a standard installation this would actually be called etomite_manager_users, and can be accessed using phpMyAdmin or any other MySQL administration software... Or, if you don't have access to a MySQL administration program, which everyone should have as a basic tool, you could create another small script which would make the password change for you... A working example of the script to perform this task would be:

<?
# MD5 admin password changer for Etomite
$host = "localhost";  # Name of MySQL host
$user = "user";  # MySQL username
$pass = "password";  # MySQL password
$db = "etomite";  # Etomite database name
$table = "etomite_manager_users";  # The etomite_manager_users table name with prefix
$admin_password = "your_new_password";  # The new password for the admin user

$md5_password = md5($admin_password);
$sql = "UPDATE `$table` SET `password` = '$md5_password' WHERE `username` = 'admin' LIMIT 1;";
if (!$conn = mysql_connect($host, $user, $pass)) die('Could not connect: ' . mysql_error());
if (!mysql_select_db($db)) die('Database select failed: ' . mysql_error());
if (!mysql_query($sql)) die('Update failed: ' . mysql_error());
else echo "Password successfully changed for admin...";
mysql_close($conn);
?>

Once you have regained access to your Etomite Manager, the very first thing you should do is to create an alternate Admin account using a password that you are sure not to forget... By doing this you will insure that you won't be locked out of Etomite Manager again... :eto:

Good Luck... B)

So,i just go to notepad and paste that script? save and upload?

[Enkil]

Enkil, on Oct 30 2004, 07:24 PM, said:

So,i just go to notepad and paste that script? save and upload?

Hmm....i have downloaded...PhPMyAdmin, after i finish uploading it how do i enter my Database?

[Ralph]

Enkil, on Oct 30 2004, 03:11 PM, said:

Hmm....i have downloaded...PhPMyAdmin, after i finish uploading it how do i enter my Database?

Open the Documentation.html file within your phpMyAdmin subdirectory using your browser and follow the installation directions... B)

[uzz]

[quote=Ralph (rad14701),Oct 8 2004, 02:06 PM]If you have access to your Etomite database, try using the following script as a stand-alone program... It will generate a new password that you can then copy and paste into your admin record within the manager_user table...

<?php
# MD5 Password Creator
# Usage: call this script, passing the textual passowrd you desire
#        Example: md5-password.php?password=new_password
#
echo md5($password);
?>

[/quote]


I must say, forgetting your password is A B(@$(!

I've scoured these forums, and i cant get seem to get my password reset. Is this the only way to reset your password??

<?php
# MD5 Password Creator
# Usage: call this script, passing the textual passowrd you desire
#        Example: md5-password.php?password=new_password
#
echo md5($password);
?>

[/quote]


or would this work?

<?
# change_etomite_admin_password.php
#
# Created By: Ralph A. Dahlgren - rad14701@yahoo.com
#    Purpose: Allows the changing of an admin password without MySQL utility software
#        Use: Change the varaibles below to match your Etomite setup, save,
#             and point your browser to this script
#
# WARNING!!! Use at your own risk!!!
#
$host = "localhost";  # Name of MySQL host
$user = "";  # MySQL username
$pass = "";  # MySQL password
$db = "";  # Etomite database name
$table = "etomite_manager_users";  # The etomite_manager_users table name with prefix
$username = ""  # The username that needs a new password
$admin_password = "";  # The new password for the admin user

# Modifications should not be required below this point

$md5_password = md5($admin_password);
$sql = "UPDATE `$table` SET `password` = '$md5_password' WHERE `username` = '$username' LIMIT 1;";
if (!$conn = mysql_connect($host, $user, $pass)) die('Could not connect: ' . mysql_error());
if (!mysql_select_db($db)) die('Database select failed: ' . mysql_error());
if (!mysql_query($sql)) die('Update failed: ' . mysql_error());
else echo "Password successfully changed for ".$username."...";
mysql_close($conn);
?>

If so can i get a more detailed explanation on how this works, cause heh this isn't very NooB friendly.

Is there a place i can find my MYSQL username and password?

I've unblocked myself, but cant rememember my password, but i can only retry 1 time, then it resets back to you have been blocked mode...is there a way to make it stop resetting after 1 try?

Thanks,
Frustrated Mike

This post has been edited by uzz: 25 September 2005 - 11:40 PM

[Ralph]

Hi uzz...

Yes, the change_etomite_admin_password.php script should get you going... As for the MD5 encryption for your password, if you attempt to change it within phpMyAdmin you can simply enter your new plain text password and then select MD5 from the function drop-down... Once you save it phpMyAdmin will automatically MD5 encrypt the plain text password...

[uzz]

Ralph (rad14701), on Sep 26 2005, 01:19 AM, said:

Hi uzz...

Yes, the change_etomite_admin_password.php script should get you going... As for the MD5 encryption for your password, if you attempt to change it within phpMyAdmin you can simply enter your new plain text password and then select MD5 from the function drop-down... Once you save it phpMyAdmin will automatically MD5 encrypt the plain text password...

Thanks!...Wish i found this out earlier :rolleyes: phpmyadmin was nice and easy...