Feb 2 2011

Installing Ofuz on shared hosting such as 1and1.com

After spending hours looking at different CRM’s and ERP’s trying to find the best one suited for my small IT shop, I found Ofuz.  They do not advertise themselves as a CRM, but have some of the important qualities.  Good integration with Facebook, Twitter, Google, etc.  And for those that want to host it on you own server, to make the data your own, I’ve provided the steps to do so.  Beware, that any poblems you have will not be fully supported as Ofuz would rather you keep it with them in the cloud.  It’s probably better that way.  But for those of us who are selfish with our data, and are willing to spend the time troubleshooting yourself, here  it is.

1) Download the latest version from Ofuz.com here: http://www.ofuz.com/releases/ofuz-bundle-0.6.2.tar.gz
Their documentation for server installs can be found here: http://www.ofuz.com/opensource/wiki/install

2) Upload the extracted folder (via ftp) to your domain.  My preferred ftp client is FileZilla

3) Create a MYSQL database from the MySQL administration section in the 1and1 control panel.

4) Change the permissions for the following files to read /write by all.  In FileZilla, you can right-click the directory in question, select ‘File Attributes’ , enter 777 for numeric value, and click OK.
invoice_pdf, contact_vcf, files, dbimage

5) From th 1and1 database information, enter the following into the config.php.sample…edited from Ofuz.com documentation:
Setup the database information in config.php.sample at the bottom of the file:
$conx = new sqlConnect(“database_user”, “database_password”) ;
$conx->setHostname(“database hostname”) ;
$conx->setDatabase(“database name”) ;

6) Rename config.php.sample to config.php

7) Add the following line to the top of htaccess.sample:
*AddType x-mapp-php5 .php”

8) Rename htaccess.sample to .htaccess

9) Add your database username to the following file:

on the following line:
function sqlConnect ($login=”database username”, $password=”database password”) 

It’s a good idea to modify the permissions for this file or password protect the root directory to keep hackers away from your database password. 

10) For the final step, you must populate the tables in the database yourself.  The easiest way to do this, without SQL commands is to use phpmyadmin. From the 1and1 control panel, go to MySQL Administration, and select phpmyadmin for the database used for OFuz. On the top-left, seleft the SQL icon for the ‘query window’. Then select Import Data, and browse for the following file, located in the extracted folder for Ofuz:


Click OK.

That’s it. Don’t forget to create a subdomain for ofuz. (ofuz.yourdomain.com). Otherwise, it won’t work.

“Open Source is free if your time is worth nothing” ; ) I kid, I kid!  Time spent finding a solution is worth the reward.

By the way, I didn’t catch-on until watching the video twice, it’s no Oh! fuz!,  It’s pronounced Awfuce.  Like “Office” with an English accent.