23 replies to this topic

[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
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.com/index.php?showtopic=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]

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

[Enkil]

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]

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

Good Luck...

[Enkil]

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

Good Luck...

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

[Enkil]

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]

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

[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

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]

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 phpmyadmin was nice and easy...

[stefan333]

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);
?>

The script is fine but if you do not add
$password=$_GET['password'];
It will produce md5 for space

So, this worked for me:

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

Then copy the md5 string, go to table etomite_manager_user in database etomite and change the password field of the user of your choice to it. I suppose you can create new record for user in this table.

[Ralph]

The script is fine but if you do not add
$password=$_GET['password'];
It will produce md5 for space

So, this worked for me:

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

Then copy the md5 string, go to table etomite_manager_user in database etomite and change the password field of the user of your choice to it. I suppose you can create new record for user in this table.

You are correct... That omission stems from the fact that I had converted a snippet to a true PHP script... I also notice that I misspelled "passowrd" in the usage text... My bad X2...

[justPeachy]

I changed my password and know exactly what it is, but it won't allow me to log in. Are there characters you should not use in your password? When I changed my password it said it was changed and saved. I really need help getting in and I have to be honest, I have access to MySQL database, but I don't understand how to write or use the scripts. If someone could point me in the right direction it would be greatly appreciated. I'm sure it's easy, I just need a nudge to get me going. Thanks!!!

[justPeachy]

I tried this through MySQL queries. Please help. I'm not sure what I am doing.

$password=$_GET['password'];
echo md5($password);
?>

SQL query:

$password = $_GET[ 'password'];

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$password=$_GET['password']' at line 1

Edited by justPeachy, 18 February 2009 - 11:29 PM.

[PaulD]

Hi JustPeachy,

As far as I can see, Stefan is suggesting writing the code he has provided into a text file and saving it as something like passwordChange.php

Suppose you want your password to be Oranges. Then when you go to your website address www.yourwebsite.co.uk/passswordChange.php?password=oranges
it will 'echo' (print) to the screen your encoded password.

Then you can use that to copy and paste into the relevent row of the relevant etomite table, using phpMyAdmin and then you will know your password.

The code provided just takes the posted password, and encodes it for you.

I hope that helps.

Paul.

PS choose a straight forward password first, like BUCKET, you can always change it via the manager to something more secure later.

Edited by PaulD, 18 February 2009 - 11:47 PM.