Password recovery [Archive]

eon

02-16-2006, 12:56 PM

You have does days that everything goes wrong. For some reasons you can't log in you Pixelpost-admin and the email-recovery isn't working. Live sucks ;)

Place this file (password_recovery.php) in the root of your site and run it. Fill in all questions and you will have a totally new and fresh password!

Note: After testing your password don't forget to delete password_recovery.php.

http://www.pixelpost.org/v1/devfiles/?id=150

================================================== =========================
Update

password_recovery.php works perfect for PP1.4.3 and PP1.5beta.
For people who don't know how to use this tool, here a howto

password_recovery.php works like this:
1) put password_recovery.php next to index.php
2) run password_recovery.php (go to www.my_site_name.com/password_recovery.php or something)
3) Fill in all the require information.
TIP: all the information you need, you will find it in /admin/pixelpost.php

Host, your hostname, mostly is this localhost;
Database-user, fill in you database user (see tip);
Database-password, fill in the password (see tip);
Database-name, fill in the database name (see tip);
Database-prefix, fill in the database prefix, mostly this is pixelpost_ (see tip);
Name of admin, you need to know your admin name. This is your login name in the admin-section of Pixelpost. Don't fill in a new admin-name!
New password of admin, this one is easy, put here you new password.
Confirm new password, put here (again) your new password.

4) Press "Recover".
:( If you use the wrong database information you will see this:
Connect DB Error: Access denied for user 'pixelpost_user'@'localhost' (using password: YES)Select DB Error: Access denied for user ''@'localhost' to database 'pixelpost'Database error: No database selected
Updating the new password failed.
:( If you use 2 different passwords you will see this:
Passwords are different!
:) If you fill in everything correctly you will see this:
Password changed :D
NOTE: After testing your password don't forget to delete this file!
5) Now test is you can login with your new password.
6) If the password is oke:
DELETE password_recovery.php!!!

blinking8s

02-20-2006, 10:55 AM

i havent tested this, but if users post back with a thumbs up, this will get sticked over at pixelpost 101

se.nsuo.us

02-20-2006, 10:57 AM

Indeed! but the warning for deletion should in 1 mile high letters :)

blinking8s

02-20-2006, 09:42 PM

what about if it broke the use of the system, so that you cant view the front end until the file is deleted, even a warning generated warning in the admin or above the front end of the template to remove the file wouldbe a solid solution. We've tried 1 mile high letters before on things, people dont like to read, but if it's existence renders viewing the blog useless then it might work better.

Dkozikowski

02-20-2006, 10:21 PM

I was going to suggest that earlier blinging8s. PHPBB does the same thing. If PHPBB finds a few specific folders, it will not run until those folders are deleted.

eon

02-21-2006, 07:24 AM

blinking8s

02-21-2006, 09:11 AM

we'll, it's not on our current checklist, but a better password system should be available for sure.

in the future though, i would personally like to see the login set to email and password rather than username and password, so it is 100% set to somethign legit for password recovery.

eon

02-21-2006, 10:01 AM

The program is quite save. You need also to fill in the databasename, username and password of the database.

se.nsuo.us

02-21-2006, 10:21 AM

The program is quite save. You need also to fill in the databasename, username and password of the database.
I dont expect the person who lost his password to have that information handy... One usually uses the admin section more than the database itself

eon

02-21-2006, 12:05 PM

I dont expect the person who lost his password to have that information handy... One usually uses the admin section more than the database itself

They can find that information in /include/pixelpost.php. :) Of course it will be a problem when you don't know your ftp-accountinformation anymore.

joe_ob

03-05-2006, 11:22 AM

I've just used this password recovery tool and I found it to work wonderfully well.

I'm a monkey when it comes to this stuff so it might help others to know that they should place the password recovery file in the root, and then in the browser, go to www.yoursite.com/password_recovery.php

It worked wonderfully. Thank you all so much. I am so very grateful.

eon

03-05-2006, 11:26 AM

DON'T FORGET TO DELETE password_recovery.php AFTER USE!!!

No problem and good luck with your photoblog!

jaybussiere

03-31-2006, 05:33 AM

i tried but with no luck. copied the file to the root folder @

http://www.opticdesire.com/password_recovery.php

and tried to login

http://www.opticdesire.com/pixelpost/admin/index.php?x=login

no luck.

even though i get the message after i complete the recovery form.

"Password changed :D
NOTE: After testing your password don't forget to delete this file!"

any ideas?

eon

04-02-2006, 03:52 PM

First run the password_recovery and then try to login again.

jaybussiere

04-03-2006, 04:25 AM

First run the password_recovery and then try to login again.

yes i did run the script @ "http://www.opticdesire.com/password_recovery.php" and then would try to login with my newly defined login/password. With no luck.

I am using the 1.5 beta 1. could this be a problem?

GeoS

04-03-2006, 06:17 AM

Do you have enabled cookies??

eon

04-03-2006, 07:37 AM

Do you have enabled cookies??

PP1.5 works with sessions isn't it?

eon

04-03-2006, 07:38 AM

yes i did run the script @ "http://www.opticdesire.com/password_recovery.php" and then would try to login with my newly defined login/password. With no luck.

I am using the 1.5 beta 1. could this be a problem?

I will search it out.

================================================== =========================
Update

I have tested it again, and it works perfect for PP1.4.3 and PP1.5beta.

password_recovery.php works like this:
1) put password_recovery.php next to index.php
2) run password_recovery.php (go to www.my_site_name.com/password_recovery.php or something)
3) Fill in all the require information.
TIP: all the information you need, you will find it in /admin/pixelpost.php

Host, your hostname, mostly is this localhost;
Database-user, fill in you database user (see tip);
Database-password, fill in the password (see tip);
Database-name, fill in the database name (see tip);
Database-prefix, fill in the database prefix, mostly this is pixelpost_ (see tip);
Name of admin, you need to know your admin name. This is your login name in the admin-section of Pixelpost. Don't fill in a new admin-name!
New password of admin, this one is easy, put here you new password.
Confirm new password, put here (again) your new password.

4) Press "Recover".
:( If you use the wrong database information you will see this:
Connect DB Error: Access denied for user 'pixelpost_user'@'localhost' (using password: YES)Select DB Error: Access denied for user ''@'localhost' to database 'pixelpost'Database error: No database selected
Updating the new password failed.
:( If you use 2 different passwords you will see this:
Passwords are different!
:) If you fill in everything correctly you will see this:
Password changed :D
NOTE: After testing your password don't forget to delete this file!
5) Now test is you can login with your new password.
6) If the password is oke:
DELETE password_recovery.php!!!

GeoS

04-03-2006, 10:42 AM

Thx for it eon. We will add it to Wiki.

PS Yes, it uses sessions but you have store somewhere Session ID (in cookie or in URL).

raminia

04-04-2006, 01:47 PM

Thx for it eon. We will add it to Wiki.

PS Yes, it uses sessions but you have store somewhere Session ID (in cookie or in URL).
Pixelpost wiki (http://www.raminia.com/ppwiki) is ready for it. Could you please add it (http://www.raminia.com/ppwiki/index.php/PasswordRecovery)?

P.S: I've added. Please check it out and may additions/corrections/....

eon

04-05-2006, 02:14 PM

Pixelpost wiki (http://www.raminia.com/ppwiki) is ready for it. Could you please add it (http://www.raminia.com/ppwiki/index.php/PasswordRecovery)?

P.S: I've added. Please check it out and may additions/corrections/....

I want to, but I don't know my password of teh wiki any more. :S

Where did you add it in the wiki?

hindman

10-12-2006, 08:26 AM

It began that one day I could not log in anymore. When filled out the "forgot-your password?"-form so that I would be sent a new one, I was told that I wouldn't have entered any email-adress. But I certainly had put in the right one.
Then I tried the password recovery. It didn't work.
I did everything as written, but still I get an error:

"Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/.sites/92/site358/web/galerie/password_recovery.php on line 43

Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/.sites/92/site358/web/galerie/password_recovery.php on line 47

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/.sites/92/site358/web/galerie/password_recovery.php on line 47

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/.sites/92/site358/web/galerie/password_recovery.php on line 52

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.sites/92/site358/web/galerie/password_recovery.php on line 52
Connect DB Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)Select DB Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)Database error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Updating the new password failed."

Can anyone help me?
Thanks in advance

I will search it out.

================================================== =========================
Update

I have tested it again, and it works perfect for PP1.4.3 and PP1.5beta.

password_recovery.php works like this:
1) put password_recovery.php next to index.php
2) run password_recovery.php (go to www.my_site_name.com/password_recovery.php or something)
3) Fill in all the require information.
TIP: all the information you need, you will find it in /admin/pixelpost.php

Host, your hostname, mostly is this localhost;
Database-user, fill in you database user (see tip);
Database-password, fill in the password (see tip);
Database-name, fill in the database name (see tip);
Database-prefix, fill in the database prefix, mostly this is pixelpost_ (see tip);
Name of admin, you need to know your admin name. This is your login name in the admin-section of Pixelpost. Don't fill in a new admin-name!
New password of admin, this one is easy, put here you new password.
Confirm new password, put here (again) your new password.

4) Press "Recover".
:( If you use the wrong database information you will see this:

:( If you use 2 different passwords you will see this:

:) If you fill in everything correctly you will see this:

5) Now test is you can login with your new password.
6) If the password is oke:
DELETE password_recovery.php!!!

hindman

10-12-2006, 09:34 AM

Problem solved. I went into mydatabase/pixelpost_config and found that I hadn't set an Admin-email-adress.
Thanx anyway

GeoS

10-12-2006, 11:23 AM

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/.sites/92/site358/web/galerie/password_recovery.php on line 52

But it looks like not working MySQL server and not missing email address.

Helicoprion

06-07-2008, 07:49 PM

I was having similar problems, but mine was due to just forgetting the password after some time.

But following the instruct was able to reset my pass word (woot!) \o/

Thanks
-Q-

lmasyebra

02-22-2009, 08:29 AM

This addon does not seem to work for Pixelpost above 1.6.
Can anybody help for that version?
Thanks!!

Dkozikowski

02-22-2009, 02:45 PM

It should work for you...

What seems to be the problem?

Are you filling out all the required info correctly?

lmasyebra

02-23-2009, 08:01 AM

Yes, I am. At least, the php gives me a correct message. :(
Nevertheless, read my next post ;D

lmasyebra

02-23-2009, 08:11 AM

Hi there!

I finally got to recover my login/pass by accessing the table itself through the MySQL Management console. This shuld be available in your hosting control panel; the ones that installed the DB yourself, you know better thaqn me... ;D

The table that has that information on my DB is called 'pixelpost_config', being "pixelpost_" the prefix I set up during the installaion - you may have established another one. In that table you have three properties that are of interest:

'admin' - user name
'password' - where the password is saved. However, these values are encripted so DON'T use them as you see them.
'email' - where the messages are sent

I was able to see the admin table and so I remembered the password I used from the user information I had stored on that admin table. Please refer to your hositing service for more instructions on how to manage tables, see values, etc.

Hope this helps!!

Luis
www.masyebra.com

alexis

04-20-2009, 01:27 PM

THANK YOU so much for the password recovery.
Genius
Alexis