VTigerCRM

From Proxmox VE
Jump to: navigation, search

Appliance Details

Package: vtigercrm
Version: 5.2.0.svn.13311-1
Certified: no
Section: www
Location: http://www.gnuacademy.org/appliances/debian-5.0-vtigercrm_5.2.0.svn.13311-1_i386.tar.gz
Maintainer: Ap.Muthu
OS: debian-5.0

Introduction

vtigerCRM - Features

Sales Force Automation - Lead, Account & Contact, Opportunity Management, Sales Quotes

Customer Support & Service - Trouble Tickets, Knowledge Base, Customer Self Service, Online Knowledge Base

Marketing Automation - Campaign Management, Mass Mailing, E-mail Templates, Mail Merge Templates

Inventory Management - Products Catalog, Price Books, Vendor Management, Purchase Orders, Sales Orders, Invoices

Activity Management - To Dos, Meetings & Calls, Recurring Events, Shared Calendar, Activity History, E-mail Notifications, Notes

Productivity Add-ons - Email Client, Outlook Plug-in, Office Plug-in, Thunderbird Extension, Customer Portal, RSS Feeds

Reports & Dashboards - Key Metrics, Customizable Reports, 20 Pre-built Reports & Dashboards, Report Folders

Product Customization - Custom Fields (10 different data objects), Pick Lists, Custom List Views, Drag & Drop Modules, Currency customization

Security Management - User Management, Profiles, Roles, Groups, Organization-level Access Control

Virtual Appliances can be downloaded directly via the Central Web-based Management.

Recommended settings for Proxmox VE

  • Memory (MB): 512
  • Swap (MB): 512
  • Hard disk (GB): 8

Appliance specific settings

  • Mysql root password: admin

Please change this for security reason:

  • via command line after the first boot:
mysqladmin -u root -p password yournewpasswordhere
  • Set the server timezone via command line:
dpkg-reconfigure tzdata
  • Restart VM

vTigerCRM settings

  • Main software packages: Debian Lenny, vTigerCRM v5.2.0.svn.13099, MySQL 5, Postfix, Apache2, PHP5, imap, zip, unzip, cURL

First steps

Start the VM and open a VNC console and install the latest security updates.

apt-get update
apt-get dist-upgrade

Now, connect to the vTigerCRM web installer http://youripaddress/ and follow the instructions.

During the install, ignore the PHP errors - it is safer with our template settings. Also, use 127.0.0.1 as the host for your database and not the domain name or localhost. This is because, the domain name is not available before the container fully starts up and localhost will tend to use a socket and cause error in the connect routines.

Login to the fully pre-installed application as user: admin and password: vtiger123 and change the password and create other users. The First Boot Log on the VM at the Proxmox interface will show the root and vtigeruser mysql passwords.

BugFixes for vTiger SVN 13099

On a fresh install of SVN 13099, the Standard User creation is non functional pending code changes. This is detailed in Bug #6672.

Soon after a fresh installation of template SVN 13099, execute the following SQL statements:

UPDATE `vtigercrm520`.`vtiger_users_seq` SET `id`='1' WHERE 1;

Now login as admin and create the standarduser and other users as needed.

Building vTigerCRM

Download the following:

Upgrading VTigerCRM SVN

vTiger CRM v5.2.0 Password Hashing

Line 920 of /include/install/resources/utils.php:

\$application_unique_key = '".md5(time() + rand(1,9999999) + md5($this->rootDirectory)) ."';

generates a unique key to be stored in the config.inc.php file during installation. This is NOT used for password hashing.

Lines 278 to 303 in /modules/Users/Users.php:

	function encrypt_password($user_password, $crypt_type='')
	{
		// encrypt the password.
		$salt = substr($this->column_fields["user_name"], 0, 2);

		// Fix for: http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/4923
		if($crypt_type == '') {
			// Try to get the crypt_type which is in database for the user
			$crypt_type = $this->get_user_crypt_type();
		}

		// For more details on salt format look at: http://in.php.net/crypt
		if($crypt_type == 'MD5') {
			$salt = '$1$' . $salt . '$';
		} elseif($crypt_type == 'BLOWFISH') {
			$salt = '$2$' . $salt . '$';
		} elseif($crypt_type == 'PHP5.3MD5') {
			//only change salt for php 5.3 or higher version for backward
			//compactibility.
			//crypt API is lot stricter in taking the value for salt.
			$salt = '$1$' . str_pad($salt, 9, '0'); // PAD_RIGHT is default
		}

		$encrypted_password = crypt($user_password, $salt);
		return $encrypted_password;
	}
  • The crypt_type is stored in the user record in the users table.
  • The $salt for PHP < v5.3.0 is MD5 based.
  • $salt is a cocatenation of $1$ and First two chars of username and $.
  • Hashed Password is stored in DB as crypt($user_password, $salt) in the user_password field of the vtiger_users table.
  • It can be verified to be same as crypt(UserInputPassword, Hashed Pwd).
  • The vtiger_users.user_hash field stores the MD5 of the Plain Text Password.
  • The vtiger_users.accesskey field stores a 16 character alphanumeric random word which is cocatenated with a random challenge code and using it's MD5 for web services and checking the challenge response from the user's browser / service bot.

Indian Rupee Symbol in vTigerCRM

UPDATE `vtigercrm521`.`vtiger_currency_info` SET `currency_name`='India, Rupees',`currency_code`='INR',`currency_symbol`='रु' WHERE `id`='1'; 
UPDATE `vtigercrm521`.`vtiger_currencies` SET `currency_symbol`='रु' WHERE `currency_code`='INR'; 
# earlier it was: ₨
# but may have showed up as: Rp

Documentation and HowTo´s about vTigerCRM