Admin password retrieval

[Simon_Bryan]

Hi all,
How do I retrieve/reset the admin password? I cannot login as Admin at the moment as I seem to have lost or forgotten the password. I do have access to the server and the MySQL database. I don't see any options for password retrieval on the login page.

Cheers

PS Love the software and as soon as I finsh configuring and changinf the theme it will be going live for a very simple job to start with - second hand uniforms and books for the college I work in.

[Juan Ramón]

Hi Simon,

At the bottom of the login page there's a link to recover the password: "Lost your password?".

However, if there's no link, you can update your admin user with this sql sentence:

Code: [Select]

UPDATE osc_t_admin SET `s_password` = sha1('your password') WHERE `pk_i_id` = 1;
** NOTE: Maybe your table has another name, for see all your tables write in the command line: "SHOW TABLES;"

Regards,

[Simon_Bryan]

No joy.

There is no link to change password.

When I execute the SQL I can see that the pasword hash in the database has changed so that is working, however still can't login. Went digging in the Apache logs and came up with:

PHP Notice:  Undefined index:  locale in /var/www/html/Classifieds/oc-content/themes/modern/header.php on line 16, referer: http://www.mcdonald.nsw.edu.au/Classifieds/user.php?action=login


I get this no matter what theme I use including the default

Any ideas?

[Juan Ramón]

The login to the administration panel is http://www.mcdonald.nsw.edu.au/Classifieds/oc-admin/

Can you login now?

[Simon_Bryan]

DOH!
Done
Thanks - I forgot there was a separate admin login screen.

Cheers
Simon