VTigerCRM
From Proxmox VE
Contents |
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
vtiger CRM - 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:
- Browse SVN vTiger 5.2.0 - Download vTigerCRM SVN 13311 Source Files (30 MB)
- dab.conf, vtigercrm.conf and Makefile along with the setup and mysql files for building the vTigerCRM template. This build file (Makefile) set has imap, zip, unzip, php-xsl and php-curl included.
- Latest build files for templates maintained by Ap.Muthu
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.
