9 replies to this topic

[m0rt1l]

Hi there im having problems with all of my etomite sites after moving to another host. The problem comes when you try and login to the manager with your username and pass, the system will give you a username or password incorrect even though its right. After hours and hours trying to rectify the problem i found that the problem comes from the MYSQL database somewhere. If i force it to use the origional DB not the new imported one it works fine, but using the new imported db you cannot gain access even though all the data is the same. All file permissions are the same as before on the new server. Im missing something

I really love using etomite but this issue is becoming a nightmare when i try to move to a new host. Could you tell me where the problem lays.

[Cris D.]

Have you set up a DB account with the same credentials as the old one? That's a common error. Also, you may have to tweak the config.inc.php file to match exactly the new database name and user etc if there are any changes.

[m0rt1l]

Have you set up a DB account with the same credentials as the old one? That's a common error. Also, you may have to tweak the config.inc.php file to match exactly the new database name and user etc if there are any changes.

Yeye all thats easy enough stuff, its something within the db thats causing the error. if you replace the db with a fresh sql rewrite it will work fine, its as if there is a sql cache or something going on.

[Cris D.]

OK, before getting into the database connectivity, lets get back to basics, can you provide your server stats?
Have you made sure that both the old server and new server environments are compatible?
Also, I'm not entirely sure what error you ar getting... Is it the manager log-in error (Pop-up alert box) or is it server execution error (html page)?

Try the following in the order below...

For execution error (and some pop-up errors):
Have you made sure that both the old server and new server environments are compatible and meet the minimum required to run etomite and deleted the cache files (they shouldn't have been brought accross really). Go in to the assets / cache and delete the etomiteCache.idx.php (actually it's probably better to delete everything in there except the index.html file. Everything in there will be re-created automatically when you get to log in and save the configuration settings.

Pop-up error:
Also, have you got CAPTCHA turned on? For CAPTCHA to work, you will need GD Library on the server. You can disable CAPTCHA directly in the etomite_system_settings at use_captcha to eliminate this as the problem if you still can't log into the manager.

Now, not being able to log in even though the password is correct after a server move sounds familiar and I think has actually been covered off somewhere in this forum. At the end of the day, you should be able to get into the database tables and re-enter the MD5 version of your password in etomite_manager_users table. It may be a character encoding or similar issue.

[m0rt1l]

Hi and thanks for your reply. With regards to the DB all the specs etc are all the same. The problem is with the manager login, basically you will enter the correct admin login etc and then a box with incorrect username and password even though they are correct. I have also gone into the users table and changed the current md5 hash to another one which i generated elsewhere, having done this, logins still dont work. The only way i could make it work without losing all my content/template etc was to replace all the tables with a fresh set except the content and template tables. Having done this i can login! so this tell me somewhere in one of those tables lays the problem. Maybe i need to go through each one and cancel each out to find out exactly what the login issues manifest from.

Thanks again for your help

[Ralph]

Are you saying that the site will work with default resources but not with yours...??? For example, does it work with a fresh install...??? Is it possible that in the process of moving sites you are also upgrading the release of Etomite...??? It's possible that you need to run the database update patch built into the installer/upgrader...

Or, as Cris noted, it may be a server level application upgrade... Problems with PHP 5.3.x are known and we are in the process of releasing Etomite v1.2 which will resolve them... All deprecation issues will be addressed...

[m0rt1l]

Nah basically i needed to move my website. Setup with 1.1 to another cheaper host ( like we do ) ok so like childs play all we do is, ftp everything to the new ftp, export the data base to an sql file, we load the sql file into our new database, change the params in the config to match our new database server and WE SHOULD GET OUR SITE BACK UP AGAIN.
CORRECT!!! We do, BUT!!!!!

When we navigate to the /manager we try and login with what we used to login with on the old server and you get a popup saying incorrect username and password.
Everything else works, the website works great but you just cannot access the manager because of this.

After some playing around i changed the config so it connected to the old origional database server, i navigated to the manager and voila it works!!
Ok i now know its something in the DB thats causing the problem. I then changed my config back to the new server and tryed some other methods.
I ran the installer again and installed the site as a fresh on the new server with all the same details/SQL etc i then via PHPMYADMIN delete the template and content table and re imported my old sql data to replace the two i just removed. Now the website is back with all my template and content and now i can access the manager.

I do think somewhere in one of those tables something is bugging the manager login when you move to a new DB server. I have had this problem with numerous sites ive done not just this.
I will go through replacing table by table to try and narrow down what is actually causing it and ill post back.

Thanks for your efforts.

[Cris D.]

My guess is the system_settings table that I mentioned above that stores all sorts of server-specific information on the first save of the config settings like absolute paths etc... Youdid not mention if you removed the system cache file.

[Ralph]

Sounds like a potential PHP 5.3.x deprecation issue...

What version of PHP is the new server running...???

[m0rt1l]

im on the lastest php version.... i tryed removing the idx file and still had no joy on the login...