How to Install PedigreePoint

(1) Web site To install PedigreePoint you need a web site that has PHP, PERL and MySQL. There are many WPPs/ISPs that provide web hosting with these facilities. Just use www.google.com with a search string of "Web hosting PHP PERL MySQL". When purchasing a hosting package ensure that you do have these facilities and that you have at least one MySQL database. Please note that even if you do have one database you can still host multiple breed databases as each of these is a "table" within the one database.
(2) Installation package Email us at support@NO_SPAM_PLEASEbreedmate.com (remove the NO_SPAM_PLEASE) and supply your name and address and we will email you the download links for the installation packages for PedPoint Lite and PedPoint Pro (PedPoint Lite is the simpler package).
(3) Customise Run the installer file. Its called InstallPedPointLite.exe or InstallPedPointPro.exe. Both installers will copy files to the C:\Program Files\PedPoint folder. They will create a sub folder called cgi-bin which conatins all the PERL scripts. In a later step all these files will be FTP'ed to your web site, but at this stage you need to modify one of the PERL scripts. The pp_config.pl file needs to be modified to suit your web site. In particular you need to set the following:

$DatabaseName = "pedpoint";
$DatabaseAccount = "web";
$DatabasePassword = "web";
$DatabaseHost = "localhost";

These four parameters should be supplied to you by your ISP/WPP. Additional parameters which you can set are:

$nMaxSearchResults = 100; #Number of search results returned per page
$szDateFormat = "%d %b %Y"; # see How To Set Date Formats
$szSearchPage = "../pp_search.htm";# URL for the search page lik at the bottom of reports
$szLoginPage = "../pp_login.htm";# URL for the lgoin page - displayed on invalid login
$nPictureGens = 2;# set to the number of generations (startring from parents) to include photo
$szPhotoPath = "../images/"; # this is prefixed to all photo paths
$nPhotoWidth = 150;# Pixel width of photo displayed in Pedigree
$szSuccessLoginPage = "../pp_search.htm";# page which is displayed after succesful login
$szFailLoginPage = "../pp_fail_login.htm";# page which is displayed after failed login
$szLoaderPassword = "set this";# Used for direct data upload from BreedMate

(4) Install tables You will need to login to your phpMyAdmin console, go to the SQL page and execute the script called "Create_Management_Tables.sql". How do I get to this page? Here is a typical screen shot:

Please note that this step will also create an default account guest with password guest123. After you get your accounts setup you should delete this account.

(5) Transfer scripts to web site FTP the .pl files to the cgi-bin folder on your web site. You may need to chmod the .pl files so they have execute permission. The .htm files should be FTPed to your main web site folder. The web site software is now installed. You will not need to repeat these steps again. To upload your data see the following section.
(6) Checking the installation Two of the PERL scripts, pp_test1.pl and pp_test2.pl can be used to check that you have correctly installed PedPoint.

First run pp_test1.pl by simply typing the complete URL into a browser. If your web site is "www.mydomain.com" then the URL you need to type is "www.mydomain.com/cgi-bin/pp_test1.pl". If this is test is succesful it will return "PedPoint Test1 successful". This indicates that you can run a PERL script on this site and that the cgi-bin and this file has the appropriate execute permission (set using chmod command in the FTP program).

Next run pp_test2.pl. If this is successful it will return something like "PedPoint Test2 successful - result=9346" where the number after 'result' is the number of records in the pedigree table. As you may not have uploaded any data this will probably be 0. If successful it indicates that 
- the database name, host, account and password are correct
- you have MySQL and the DBI installed correctly
- you have the pedigree table installed correctly

To find out how to transfer you files click here.

New - we now have a PDF file describing installation