CMS Made Simple Forums

I moved a CMS install in an unconventional way, by using the CMS files from an FTP backup. Among the folder of the FTP, there was a directory called "sqldb". In there, there are three files:

maxdtc_client.sql
maxdtc_db.sql
maxdtc_endb.sql

I imported maxdtc_db.sql with phpmyadmin and I can access the website by going to index.php. Now I want to access the administration part of it, but it will not accept any username or password.

I've forcefully changed the user to admin and the password to admin by changing the password hash to "21232f297a57a5a743894a0e4a801fc3", but that was a no go. The password is not accepted and the box shakes to indicate this as well as the "username or password incorrect" message for admin/admin.

Can anyone help me troubleshoot? CMSMS version is 1.11.9. The only thing I can think of is that CMSMS is not accessing the database, but I thought I fixed that since now I can access index.php and it's not giving me a mysql error 1045 in the browser. Is there some sort of communication problem between admin.php and my database?

I am also wondering what those two other databases are, perhaps associated with some modules?

I figured out what the two other databases are. One is for a plugin that allows you to add logins for users to access private areas of the site, and the other is another cmsms database for a duplicate of the site in a different language.

So for the time being, I'm only interested in maxdtc_db.sql. I even tried manually removing the entire "users" (You have it as cms_users if your database is named cms -- in my case, it's "max_users"), and painstakingly re-added the table with phpmyadmin, making sure to duplicate the columns precisely, but still a no go.

Just for comparison, I have a brand new cms database installed in mysql, and when I point config.php to that database, it logs in fine.

So what other interaction does admin.php have other than with the cms_users table in determining login credentials? Is there any way I could get more verbose error messages that could help me solve this problem?

Thanks

I don't think changing the hash that way will work. You should use the query from http://docs.cmsmadesimple.org/troublesh ... d-recovery

Further, make sure to empty the cache folders under /tmp

You sir are a genius!

Thank you so much.

Now I have to iron out some other glitches and oddities that comes with transplanting.