Server Migration Troubles: Can;t Login After Copying DB

[wizzbangca]

Migrating from a test virtual machine to a live physical server. All went well until I copied the database over to the live server. Before copying the database, I made sure the otrs installation on both systems were exactly the same except for the database, versions of intalled components and otrs were also checked. Everything was working great on the live server. Then I go to copy the database from the test system to the live system. First, phpmyadmin wouldn't copy the entire database. Phpmyadmin always ignoring random tables, users was always one of them. Using a mysql dump always failed with the same problem. After increasing the max buffer size for data downloading from 32mb to 60 mb (10mb more than the databaase size), I still had the same problem. I decided to copy the physical files from one system to the other. I thought I had the problem solved.

Not really. All the tables copied, but I could no longer log into otrs. I would login in with the username and password from the test system and end up being thrown right back to the login screen with absolutely no error. All user accounts did this. I looked in mysql and found not only are the usernames in the user database, but the password fields for each account are exactly the same as the test server. I try to retrieve the password to one of the accounts. Instead of retrieving, i get "There is no account with that login name." when I click on the link in the sent email from the live system, which is a bunch of crap, the account is staring me in the face through phpmyadmin, the mysql command line, and a custom php script.

How do I get all the data migrated to the live server and still have a working otrs?

[crythias]

somehow it must be related to either config.pm or the database users table not accessible?

[wizzbangca]

I checked the file permissions and fount root owned the new database. Change to mysql for group and owner, and now I can log in. However, the crontab is empty for otrs. Any way to force otrs to load up the crontab?

[wizzbangca]

Got it all working. The otrs service needed running. On the test server I had problems running the service. Guess the recent update fixed the problem I was having with the service.

The server is now live and everything seems to be going just fine.

Thanks for the help.

[crythias]

The INSTALL docs say:

12) Cronjobs for the OTRS user:
---------------------------
There are several OTRS default cronjobs in $OTRS_HOME/var/cron/*.dist.
Make copies of all of the default cronjobs:

shell> cd var/cron
shell> for foo in *.dist; do cp $foo `basename $foo .dist`; done

Or if you are installing OTRS an a Windows system:

cd var/cron
copy *.dist *.


Use $OTRS_HOME/bin/Cron.sh {start|stop|restart} to start or stop this cronjo
bs
from $OTRS_HOME/var/cron/* (.dist will be ignored).

>> Note: Install this cronjobs as OTRS user. <<

EDIT: missed that you updated. Sorry for redundancy.