Clients & Profits Pro X and Job Tracker X can connect to any OS X-based MySQL 5.0.x database server. MySQL is cross-platform, and freely available for many different operating systems.
*UPDATED
Leopard Server ships with MySQL 5.0.45 Community pre-installed. Our initial test show that it performs as expected.
Please thoroughly test your installation before deploying it.
| Important Information MySQL is not a zero-maintenance database. It is much more difficult to install and manage than the built-in Clients & Profits X database. That’s why installing, configuring, and maintain MySQL requires experienced database administrator (or at least an experienced technician who is willing and able to learn MySQL). Your database administrator must know how to configure your hardware, operating system software, and the MySQL software. The Clients & Profits Helpdesk does NOT support installing, setting up, or maintaining your MySQL database. |
Preparing your Xserve for MySQL.
MySQL provides a freely available edition of their server software called MySQL Community. For more informtion, please click here
For more information regarding MySQL, or to purchase MySQL Enterprise, please call MySQL Sales at (425) 743-5635 to request a commercial license.
You will also need MySQL Administrator 1.0.9 (or greater) software Mac OS X. This application is needed to add databases (called “schemas”), manage your databases, and monitor the server’s performance.
Once downloaded, install the MySQL Administrator application onto your MySQL server.
To configure your Xserve for Clients & Profits X
To configure your Xserve server for Clients & Profits X and MySQL, you’ll first need to install the C&P X application onto the Xserve. It will be used to initially set up your Clients & Profits X database, then used only to maintain the database.
Before using Clients & Profits X, you’ll need to configure MySQL 5 Community for each database. There are two sample databases you’ll need to configure: (1) the tutorial database, which is used for new user training or evaluating the Clients & Profits X and (2) the sample database that you’ll use for testing reports.
To use these databases with Clients & Profits X, they need to be imported into the MySQL database. The import process is mostly automatic, but MySQL needs to be first configured to handle each database. Once imported, users can start working with these databases.
While most shops only have one database, an unlimited number of databases can be maintained by Clients & Profits Pro X. In some cases, companies with different businesses (such as an autonomous PR company) would create a separate database for each unit. Each database has a unique name and set of authorized users. All of the company’s databases would be store in MySQL and opened as needed. However, Clients & Profits X can only open one database at a time per workstation.
To install C&P X for MySQL on the Xserve
- Download the Clients & Profits X demo installer, Installation guide,
and Tutorial.df1 file from http://www.cnp-x.com/downloads.
- Un-zip and install Clients & Profits X, following the prompts.
Follow the instructions for installing and configuring the MySQL server here.
