1. start with basic ubuntu 9.10 install - select LAMP server as server type towards end of install.
(I used x32 version on a VMware box)
1.1 update - apt-get update
1.2 upgrade - apt-get upgrade
1.3 set root password - sudo passwd root
(type current user password, then new root password x2)
1.4 type exit to logout and log back in as root (remain as root at all times to admin for ease of use)
2. install ssh - apt-get install ssh (You can then use putty to connect to the box!)
3. install extras for php -
apt-get install libapache2-mod-auth-mysql
apt-get install php5-mysql (may not be needed)
apt-get install php5-gd
apt-get install php5-imap
4. Use winSCP & putty to control the box
Download
vtiger510.tar.gz source file from www.
vtiger.com
Copy the
vtigercrm file to the default root directory of the apache server. (/var/www)
Set file permissions:
Cd /var/www/
vtigercrm
Chmod 777 filename
(I USED the winSCP browser for this and applied to all child objects)
Ther is one that they don’t tell you about. It is the /var/www/
vtigercrm/cache/ images file. Change the permission on this one too. If you do not, you won’t be able to see the dashboard images
Use winSCP to navigate to /etc/php5/apache2/php.ini - Double click to open in a basic text editor.
change settings to recommended set (not the red default value) - save and REBOOT the server!
| Recommended PHP Settings: |
| Directive | Recommended | PHP.ini value |
| display_errors | On | Off |
| max_execution_time | 600 | 30 |
| error_reporting | E_WARNING & ~E_NOTICE | NOT RECOMMENDED |
| allow_call_time_pass_reference | On | Off |
| log_errors | Off | On |
memory_limit 32M |
REBOOT!!!! to refresh the new php changes.
5. navigate your browser to: (change the ip to match the new box...)
http://192.168.10.140/vtigercrm
Following the install you should get all green with no problems prior to install. (if not check above)
when all items are green. continue the installation specify the root username and password for mysql (provided during install of ubuntu)
fill in the rest of the boxes (mostly self explanitry - the admin and stdusers are the default users for the crm)
EXTRA for remote access to the mySql data- Check the "/etc/
mysql/my.cnf" file COMMENT OUT the bind address:
#bind-address = 127.0.0.1
This
allows access to the sql database directly from excternal source, useful if you are going to remote admin the data.
(You may have to use the
mysql GRANT command to enable full access.)
login...
mysql -u root -p
Then
GRANT ALL PRIVILEGES ON db_base.* TO db_user @'%' IDENTIFIED BY 'db_passwd';
eg
