Installing SugarCRM on 1and1

Here are the steps I took to install SugarCRM CE 6.1 from http://www.sugarforge.org on a 1and1 linux developer package account.

– Start creation of MySQL DB on your 1and1 account since this takes a while.

– Create new URL on 1and1 server and point to directory that will hold SugarCRM.

– Download from http://www.sugarforge.org (An alternative version can be found here http://www.sugarcrm.com/crm/download/sugar-suite.html)

– Unzip the downloaded file in your new home directory

– Create a file in the home directory of your site called .htaccess with a single line: AddType x-mapp-php5 .php

– SugarForge documentation can be found here – http://www.sugarforge.org/frs/?group_id=6.  Search for the install guide.

– Browse to http://<url>/install.php

– Follow the screens, chose Typical install.

– During the install step, the config.php file is created.  Open the config.php file and file the lines that set dir_mode and file_mode.  Change their values as follows:

‘dir_mode’ => 1517,
‘file_mode’ => 420,

– You may also have to remove the cache directory if the webpage does not display correctly

– There are multiple postings out there on how to get email to work with 1and1 (as well as GoDaddy).  Here are the postings I ran across, only the first one worked for me:

SMTP Mail Server: mrelay.perfora.net (NOT smtp.1and1.com)
SMTP Port: 25
Use SMTP Authentication: checked
Enable SMTP over SSL or TLS?: -none-
Username: xxx@xxx.com
Password: xxxxxxxx

SMTP Mail Server: 74.208.5.2 (NOT smtp.1and1.com)
Use SMTP Authentication: Checked Yes
Username: XXXXX@s320849284.mialojamiento.XX
“From” Address: XXXX@XXXX.XX
SMTP Port: 587

SMTP Mail Server: smtp.1and1.com
Use SMTP Authentication: Checked Yes
Username: XXXXX@s320849284.mialojamiento.XX
“From” Address: XXXX@XXXX.XX
SMTP Port: 587
Enable SMTP over SSL or TLS? : None
Password: XXXXXXXXX

SugarCRM discussion forums can be found here – http://www.sugarforge.org/content/community/.  Most of the solutions to the  problems I encountered with the 1and1 install were solved on these forums.

Note: The logfile for Sugar problems is called sugarcrm.log in the home directory.

Note: To Setup Crontab Note: In order to run Sugar Schedulers, add the following line to the crontab file:
*    *    *    *    *     cd /homepages/27/d242477116/htdocs/prolin; php -f cron.php > /dev/null 2>&1

Duplicating a Joomla Website on 1and1

The first place to look for general steps to make a duplicate copy (at another directory and URL) of an existing Joomla site is here – http://docs.joomla.org/Copying_a_Joomla_website

This is intended to be a shorter version of what’s described above with some specific steps for 1and1.

I’m working with a 1and1 linux developer account which means I have ssh access.  Make sure there are no changes being made to the site during this process.

1. Use the 1and1 admin interface to create a new MySQL database for the new website. This can take 5-10 minutes so start it now.

2. Copy source directory contents to target directory.
cd <src-dir>
tar cvfz <target-dir>/sourcefiles.tgz *
cd <target-dir>
tar xvfz sourcefiles.tgz

3. Make a backup of the existing Joomla sites MySQL database. Use the 1and1 phpMyAdmin tool to do an export.  I choose the default no compression option and saved the results to an ascii file on my local PC (good to have a backup of the db – it saved me work the first time I did this – see below). If you’ve never done this before, 1and1 has an FAQ on how to export and import MySQL databases using phpMyAdmin.

4. Import the database you just exported to the newly created MySQL db.
– Remove the “CREATE DATABASE” and “USE” lines near the beginning of the exported database sql file
– Start phpMyAdmin on the new database
– Choose the icon for the SQL query window in the upper left hand corner (see the online help if you can’t find this)
– Paste the exported sql from the source database into the window and hit Go
– Watch for the status of the import in the main browser window, you should see the number of lines executed

5. Critical first step to using your new site. Login to the new Joomla sites’ admin interface (http://<site>/administrator). Browse to Site > Global Configuration and change the MySQL parameters Hostname, Username, Password. If you don’t do this first, you’ll be editing the old sites database from the new sites admin GUI.

You now should be all set to use your new site.