Ubersmith Technical Support Options and Contact Information

Support Center » Knowledgebase » Migrating an Ubersmith instance

	Migrating an Ubersmith instance

Solution If you wish to move your Ubersmith install to a different server, please follow these instructions. Unless otherwise specified, commands will be executed by the system's root user.

Prepare your existing Ubersmith installation for the migration by following these steps:

Shut down the Database

Shut down your MySQL database server. Under most distributions of Linux, this can be achieved by the following means:

/etc/init.d/mysqld stop

or

/etc/init.d/mysql stop

Shutting down your database ensures that it remains in a consistent state during the migration process. Your Ubersmith instance will become unavailable to administrators and clients while the database is stopped.

Remove / Disable Cron Jobs

The cron jobs Ubersmith uses to perform monitoring and daily invoice runs must be stopped. By default, these cron jobs are run by the user associated with your Apache web server. Depending on the distribution of Linux you are running, these jobs could be associated with the nobody, apache, or www-data user. To disable the cron jobs, run

crontab -e -u apache

where apache is the name of the user account associated with Apache. The entries you wish to disable will look similar to the following:

*/5 * * * * php -q -f /var/www/html/cron/poll.php 'billing.yourcompany.com'
30 0 * * * php -q -f /var/www/html/cron/invoice.php 'billing.yourcompany.com'

You can disable the cron jobs by placing a pound sign/octothorpe (#) in front of them, or by removing them entirely. Removing the entries is suggested.

Remove Email Alias

Provided you are running a standard mail server, email alias entries are located in

/etc/aliases

You will want to look for the entry for the support user, which looks like this:

support: '|php -q /var/www/html/cron/gateway.php billing.domain.com 1'

You can delete the entry, and run

newaliases

as the root user to commit the change.

Create a Database Dump

You can create a dump of your MySQL database by executing

mysqldump --opt --quote-names -u ubersmith -p ubersmith > ubersmith_backup.sql

This assumes your database is called ubersmith and is accessed by the ubersmith user. You may want to examine the file config.ini.php (usually located one directory above the directory Ubersmith is installed under) to determine what credentials are being used to access your Ubersmith database.

Copy the database dump over to the new host, using whatever method you prefer (scp, sftp, ftp, rsync, etc.)

Note: Do not copy over any of the existing Ubersmith files. They are not needed.

Remove Existing License

Log into your account on

http://billing.ubersmith.com

and delete your existing instance from the License Manager.

Install the Ubersmith Database

On your new host, install the Ubersmith database, using the dump you created.

mysql -u root ubersmith < ubersmith_backup.sql

Make sure to create a MySQL user account that can access the Ubersmith database.

Setup on New Host

Download the current version of Ubersmith from

http://downloads.ubersmith.com/

to your new server. Run through the setup process as normal, however during the database configuration step specify the existing Ubersmith database.

The system will detect the existing tables in the database and perform any required database updates and registering the new instance with the licensing system.

Article Details

Article ID:

Created On:

24 Jul 2008 09:42 PM