[ElgertS]

Step 4: Insert SQL into database

Using PHPMyAdmin, select the phpgiftreg database and open the SQL tab. Select your edited “create-phpgiftregdb.sql” file to populate the database.

[ElgertS]

Step 3: Edit SQL code

Open the “create-phpgiftregdb.sql” file in an editor and scroll to the very bottom. Configure your default user information in the following line changing the values to be valid entries:

INSERT INTO users(username,password,fullname,email,approved,admin) VALUES (‘username’,’password’,’fullname’,’[email protected]’,1,1);

[ElgertS]

Step 2: Create a database for PHP Gift Registry

Using PHPMyAdmin, create a new database named “phpgiftreg” or whatever name you choose for the installation you are preparing.

[ElgertS]

Step 1: Download PHP Gift Registry

Download the project:

PHP Gift Registry 1.5.2

Decompress and move to directory you wish to host the site from.

[ElgertS]

Step 4: Edit PHP settings

At this point you can enable either you PHP4 or PHP5 module and save the settings within Server Admin.

Note that depending on what PHP software you are planning to use on your server you may need to edit your PHP settings concerning items such as register_globals and magic_quotes.

[ElgertS]

Step 3: Edit modules in Server Admin

Connect to your server in Server Admin and go to the modules tab for the web server.

Edit the php4_module entry by changing its Path to the following:

/usr/local/php/libphp4.so

Make a new module entry for PHP5 with the following information:

module=php5_module
C File=mod_php5.c
Path=/usr/local/php5/libphp5.so

[ElgertS]

Step 2: Edit httpd.conf file

Open your /etc/httpd/httpd.conf file in an editor and comment out the active lines inserted by the entropy.ch installer found at the bottom including:

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
DirectoryIndex index.php index.html

[ElgertS]

Step 1: Download PHP4 & PHP5 packages

Download the following delicious packages from entropy.ch:

PHP 4.3.11

PHP 5.1.2

Install both of these packages. Note, if you are only interested in one or the other, simply install the package that most interests you. At the time of this writing few PHP applications operate correctly under PHP5 but you may wish to install it for testing. The Entropy PHP 4.3.11 package is the latest PHP4 install and features a wide scope of additional features that are required by many PHP applications, primarily GD2 for generating graphics dynamically from MySQL database information.

[ElgertS]

Optional Step 4: Upgrade PHP w/GD

At this point Sugar will be functioning on your server and you are ready to begin playing with it. However, the version of PHP installed by default on Mac OS X Server does not include GD which is required for Sugar to display its graphing functionality. The easiest remedy for this is to install the latest PHP 5 release from the Entropy website.

[ElgertS]

Step 3: Configure Sugar

At this time you are ready to load Sugar from the website you copied it to. On first run Sugar will ask you information on your server including the website name, the name of the MySQL database, the MySQL user and password required for working with the Sugar database. Sugar’s interface will easily guide you through these steps and will load the SQL required to operate Sugar.

[ElgertS]

Step 2: Create Sugar Database

Using PHPMyAdmin, create a new database for Sugar.

[ElgertS]

Step 1: Download & Install

Download the latest version of Sugar:

Sugar 4.5.1

4.0 features the ability to monitor incoming email and add it into the system along with greatly improved marketing campaign management. It also now features a visual inline editor for creating html rich emails.

In addition, Sugar can now be integrated with a Joomla! website as your customer interface. In this way, new registrants to your Joomla! site become customer leads. Registered users on your Joomla! site can also place support requests within Joomla! and this will be sent to your Sugar interface where you can respond and it will be sent back out via Joomla! to the customer.

Copy the resulting folder to the web directory you wish to host your Sugar installation.

Set the owner of the sugar directory to “www”.

[ElgertS]

To take full advantage of Joomla! on Mac OS X you will want to download a copy of the Mozilla Firefox web browser along with JCE. JCE is an inline editor for Joomla.

Download JCE here:

JCE Mambot 1.1 beta 2

JCE Admin 1.1 beta 2

Log into your Joomla administration back end using Firefox or Safari and navigate under the “Installers” menu choose “Mambats”. Upload the Zip file for JCE. Do the same process for the admin module using the “Components” option.

You now can go under the “Components” menu to “JCE Admin” and to the submenu for “JCE Plugins”. Click on the “Install” button and you will have an opportunity to install additional plugins for JCE. Note that JCE has a mix of free as well as some Special Edition plugins that require payment. You can alternatively load the older JCE 1.0.5 version which has these features available for free.

Next go under the “Site” menu to “Global Configuration” and set your WIZIWYG editor to be “JCE”.

Other useful additions to Joomla! include a plethora of high quality templates, DocMan file download/upload systems, the Gallery integration module, SugarCRM, Events for calendaring, a6MamboHelpDesk, Awesom! Amazon store, and various BBS options including Loudmouth & Joomlaboard. Some of the more powerful solutions include Community Builder for integrating incredible features for driving a community based website. Community Builder also tightly integrates with other Joomla! components such as Joomlaboard, the YaNC Newsletter, private messaging systems for Joomla! and video and image components..

To turn Joomla! into a powerful rapid application development environment for interactive web applications, install Fabrik:

Fabrik

[ElgertS]

Step 5: Administer PHPList

You are now ready to log into the system and begin administering the site. PHPList will populate the MySQL database and log you in. It will then request you configure the system, changing the default admin password and the basic configuration options as well. You then can use the default “test” list and add some emails to it for testing. Click on the “send a message” link to create an email and send it. PHPList does not automatically sent messages and you must then click the “process queue” link for actual transmission. This last step can be scripted to happen automatically.

PHPList allows you to create subscription pages and templates to help customize your lists. To send an html email, you can create the email in an html editor and paste the raw code into PHPList.

If you would like to send attachments, you must go back to the config file and enable the attachments option along with specifying how many attachments should be allowed.

[ElgertS]

Step 4: Edit Configuration file

Within the “lists” directory, navigate to the “config” directory and open “config.php” in a text editor (I suggest SubEthaEdit).

At the top of the document, you need to edit these areas:

# what is your Mysql database server
$database_host = "localhost";

# what is the name of the database we are using
$database_name = "phplistdb";

# who do we log in as?
$database_user = "phplist";

# and what password do we use
$database_password = 'phplist';

# if you use multiple installations of PHPlist you can set this to
# something to identify this one. it will be prepended to email report 
# subjects
$installation_name = 'PHPlist'; 

By default, PHPList expects you to use the public_html as you root directory. However, I find this annoying and it is much more useful to go directly ot the “lists” folder as a I mentioned in step 2. If you followed my suggestion, you must edit the config.php at this point:

$pageroot = '/lists';
$adminpages = $pageroot . '/admin';

changing it to read:

$pageroot = '';
$adminpages = $pageroot . '/admin';

At this point you are ready to go. However, PHPList will be in test mode and not actually send any message. When you are ready to send messages in the system, you also must edit the following section:

# if test is true (not 0) it will not actually send ANY messages,
# but display what it would have sent
define ("TEST",1);

[Author]

Posts