Password recovery

[eon]

Originally Posted by raminia

Pixelpost wiki is ready for it. Could you please add it?

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]

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

Originally Posted by eon

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]

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

[GeoS+]

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]

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]

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

[Dkozikowski+]

It should work for you...

What seems to be the problem?

Are you filling out all the required info correctly?

[lmasyebra]

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

[lmasyebra]

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]

THANK YOU so much for the password recovery.
Genius
Alexis