Archive for November, 2006

vTiger install notes

November 29th, 2006

1. Run the report field patch, located here to allow totals in reports:

http://mochabomb.com/software/Servers,PHP,Web/vTigerCRM/patches-vTiger/ReportFieldPatch

2. Fix the decimal places with this: http://forums.vtiger.com/viewtopic.php?t=10349
If you have an existing database, you will want to update the table structure manually. Table: vtiger_pricebookproductrel, Column: listprice, Format: N 11.2.

3. fix php.ini as noted in this post, here is the forum on it – a sample working file is attached.

http://forums.vtiger.com/viewtopic.php?t=10444&highlight=views

4. Invoices can be fixed here:

modules/Invoice/pdf_templates – for the header and footer, CreatePDF.php has the file calls for body.php, header.php and footer.php. The body is located in include/fpdf/ and this file is the body for all pages and must be modified – attached is the updated body.php
When editing the body.php, the font sizes are called as such and the line command has the abcissa and ordinate set, and the spaces determine the position of the number in the invoice boxes.

5. Company information that is on the invoices and terms/conditions are in settings. The logo is alow uploaded for application to the invoices.

6. Themes are edited in themes, the login image files are in themes/images and the login.php is in modules/Users/Login.php – this file has the contents of the login window. The login file is attached.
7. config.inc.php has the list entry default of 20, I updated to 50. It also sets the default theme

8. invoice auto-numbering – yet to be implemented, here is the file and fix for it.

9. Custom reports – files are attached.

Add remove programs broken

November 18th, 2006

Re: Re: I can’t open add/remove programs!!!!!!!!!!!!!!!

I ran into the same problem, and none of the recommended solutions worked. Finally I found the answer.

This is taken from MS Knowledge Base Article Q266668 which can be found at http://support.microsoft.com/kb/q266668/

I did not bother with steps 1-4 (checking registry entries).

The following command fixed it:

Follow the steps in one of the following procedures, as it applies to your computer, and then test to determine if this issue is resolved.

If the issue is resolved, skip the remaining steps.

If the issue is not resolved, go to step 5.

To resolve this issue with Internet Explorer 6.0 installed, repair Internet Explorer 6.0:

a. Click Start, and then click Run.

b. Paste the following command in the Open box, and then click OK:

rundll32 setupwbv.dll,IE6Maintenance “C:Program FilesInternet ExplorerSetupSETUP.EXE” /g “C:WINDOWSIE Uninstall Log.Txt

Because this command is case sensitive, Microsoft recommends that you copy the command from this article, and then paste the command in the Open box.

Killl spyware apps – can’t phone home

November 16th, 2006

This fix is quite simple in approach – lie about the true location of websites – how?

Every domain name is mapped to a number – its called domain name service – DNS. The internet equivalent of the phone book which maps a name to a phone number. The internet equivalent is to map a domain name to an Internet Protocol (IP) address – now imagine this:

Imagine I get a spyware/virus and it tricked my computer so instead of getting the right IP address for google or yahoo, I got an intentionally wrong answer – see below:

Correct addresses:

  • google.com 64.233.167.99
  • yahoo.com 66.94.234.13
  • WhenUClickOnMe Toolbar Search (evil) 208.13.12.145

Spoofed and faked addresses:

vTiger php.ini settings

November 15th, 2006

vtiger php.ini file settings

Option | Setting
===============
Safe Mode | Off
Display Errors | On
File Uploads | On
Register Globals | Off

Max Execution Time – 300

output_buffering – On

Change the memory limit – 16M

error_reporting – E_WARNING & ~E_NOTICE

allow_call_time_reference – On

output_buffering – On

log_error = off

GD Library support

extension=php_gd2.dll (remove the comments)

IMAP Support
extension=php_imap.dll (remove the comments)

For custom views to work, need to set in php.ini:

register_long_arrays – MUST be set to On. It is set to Off by default.

vTiger installation guide – ripped straight from vtiger.com

November 15th, 2006

Vtiger CRM 5 Beta – Installation Guide

From vtiger.com

Important Note: vtiger CRM 5 Beta is ready for end-users testing the product and post their suggestions and comments. This build is only for product testing purpose, hence users are strongly adviced not to use for deployment purpose.

You can access the v5 Beta demo from:

Contents

[hide]

System Requirements

  • Hardware: x486 and above with 256 MB RAM or higher with minimum 100 MB disk space.
  • Web Server: Apache 2.0.40 and above or Microsoft IIS 5/6
  • Database: MySQL 4.1.X or 5.1.x
  • PHP: 5.1.X version
  • Web Browser: Internet Explorer 5.5 and above, Netscape 7.0 and above, Mozilla Firefox 1.4 and above, or Opera 7.21 and above.
PHP 5 – Linux Dependecy Packages:

The dependency packages for php5.1.2 are as follows:

  • glibc-2.3.2
  • libxml2-2.6.11

Almost all the latest Linux distributions supports both the above versions. If the OS have the lower versions, then either you need to upgrade the packages or install the packages in another location. If the packages are installed in another location than the default, then you need to include the following path while compiling php.

For ex, if libxml2 is installed in /usr/local , then the script to be modified as

./configure –with-imap=/usr/local/vtiger/imap –with-imap-ssl=/usr –with-kerberos –with-mysql –with-apxs2=${installation_path}/vtigerCRM5_beta/apache/bin/apxs –with-gd=${installation_path}/vtigerCRM5_beta/gd2 –enable-static=yes –enable-ftp=yes –with-libxml-dir=/usr/local –prefix=${installation_path}/vtigerCRM5_beta/php >> ${LOGFILE} 2>&1

Another issue on php5 with imap is kerberos support. Since we are using imap-2001 and compiling imap without kerberos support, you have to remove this option “–with-kerberos” while compiling imap.

Note: If you are using Microsoft IIS, refer to Installation Procedure for IIS document.

Download URL

You can download vtiger CRM 5 Beta from the following URL:

http://prdownloads.sourceforge.net/vtigercrm/vtigercrm-5.0.0-beta2-source.tar.gz

PHP Settings

Please ensure that your php.ini settings support the following parameters, otherwise you may experience some problems while working with vtiger CRM:

Note: You must increase the value for max_execution_time in php.ini file as it takes about 300 seconds to execute the vtiger CRM installation script. By default the value is set as 30 seconds.

Safe Mode – Off

Display Errors – On

File Uploads – On

Register Globals – Off

Max Execution Time – 300

output_buffering – On

Change the memory limit – 16M

error_reporting – E_WARNING & ~E_NOTICE

allow_call_time_reference -On

output_buffering – On

log_error = off

GD Library support

extension=php_gd2.dll (remove the comments)

IMAP Support

extension=php_imap.dll (remove the comments)

Installation Procedure

Step 1: Download vtigercrm-5.0.0-beta_Source.tar.gz from the following URL:
http://prdownloads.sourceforge.net/vtigercrm/vtigercrm-5.0.0-beta2-source.tar.gz
Step 2: Extract the vtigercrm-5.0.0-beta_Source.tar.gz file into the document root of the Apache/IIS.

Step 3: Please ensure that following files/directories are having Read/Write permissions:

  • cache/
  • test/
  • storage/
  • install/
  • user_privileges/
  • Smarty/templates_c/
  • Smarty/cache/
  • modules/Emails/templates/
  • test/wordtemplatedownload/
  • config.inc.php
  • install.php
  • tabdata.php
  • parent_tabdata.php

Step 4: Start the MySQL database and create a database for vtiger CRM. The default database name is vtigercrm5_beta. If you want to use different database then modify according to your wish. You can also create a new database (if requred).

Step 5: Start Web Browser and follow the procedure given in the “Configuring vtiger CRM Server” section for completing the vtiger CRM installation.

Configuring RSS Feeds

To fetch RSS feeds from various Websites edit the Snoopy.class.inc file present under /include/magpierss/extlib/ directory and specify the following:

var $proxy_host = '';
var $proxy_port='
';
var $user = '';
var $pass = '
';

Configuring Companies Stock Information

Account’s Stock information (Public listed companies in NYSE) based on Ticker Symbol can be displayed in Account’s page. To fetch the account stock information, configure cetain parameters in class_http.php file present under /class_http directory at line no:166

$server =  //Specify the proxy server name
$port =  //Specify Port number
$user = //User Name to access through Proxy server
$pwd = //Password of the user name

Known Issues

In certain Linux operating systems, web mails (Incoming Email) do not work as IMAP support is not configured. In these system following error is displayed:

unknown function imap_open exception

Frequently Asked Questions

1. vtiger CRM 5 Beta is in tar.gz format. Whether I can use it in Windows OS?

Answer: Yes, you can use the vtiger CRM 5 Beta in Windows OS also. Just extract the file using any Zip utility (WinZip, WinRAR etc.,) and then follow the installation procedure. By the way, we are releasing Windows EXE also. You can choose Windows EXE if you don’t have WAMP setup ready.

2. Whether V 5 Beta is single installer or I need to install any additional software.

Answer: V 5 Beta is available in different formats, EXE, BIN, and tar.gz. Select the distribution that suites your Server requirements

3. Upgrade from Vtiger 4.2

Answer:

Installation Support

If you need any further support on installation please report your support queries at vtiger Discussions – Installation 5.x forum

Retrieved from “http://wiki.vtiger.com/index.php/Vtiger_CRM_5_Beta_-_Installation_Guide

This page has been accessed 1,084 times. This page was last modified 07:26, 28 August 2006.


Mochabomb is Digg proof thanks to caching by WP Super Cache