V15 admin user password--different hash on WAMP vs hosted?

[randalrh]

I've got version 15 running on my WAMP server.  I installed in a non-standard way because I didn't want to copy and paste extensive changes, so I exported and imported my sql database rather than via the README file.  That more or less worked, except I don't have my media because I can't find where to update my file path configuration, but that I could figure out if I could solve my other problem--my admin user password doesn't work.  Should the hash in the database be the same on the hosted server as on my local WAMP server or is it salted differently or something like that?  If so, is there a fix?  The only thing I've thought of is editing the password update php file to temporarily disable the check whether I'm logged in or not, but I hate to do that even temporarily in the wild.

The behavior, in case it helps, if I use my admin user name and password from the WAMP server is a silent error--no failure message, but the page still says you are anonymous and there's no admin menu.

Any ideas?  Can I delete that entry in the tng_users table and use some php file to regenerate a new admin user?

Thanks, Randal

[theKiwi]

If you are the only user in the tng_users table, then delete your entry, and TNG should let you in to the Admin area but force you to create a new Admin user.

The paths you can fix without TNG Admin access by editing the file config.php directly.

Roger

[randalrh]

I feel like this should have worked, and in fact it probably did, but actually being able to do it was complicated by a redirect loop (my fault) and my site being overrun with bots.  Often, like right now, I can't get to my database to make the change I want because the max_database_connections limit has been exceeded by the bot traffic.  I'll search the forum for solutions to that, but I thought I would post what I'm trying to do if I get a chance, specifically UPDATE `tng_users` SET `password` = MD5('mynewpassword') WHERE `username` = 'myadminuser'.  Note that only works (should work) if your config.php file has $tngconfig['password_type'] = "md5";  If not, you would have to hash differently.  If someone thinks that won't work, please let me know.

Also, thanks for the reminder that the basic configuration is still in config.php, not in the database.  Updating to my hosted media path fixed my photo issues.

Randal

[randalrh]

This turned out to have more to do with my hosting service (iPage, which used to work OK but now is causing me trouble) than with TNG.  The place the page tried to write the session_id was not writable, nor was the place an error message told me to write it.  I wound up putting it in /tmp and that worked.