Comdev - The Search For Scripts Is Over Reuse To Save Time and Cost
All Modules Under One Back-End
 
Home
Product
Support
Enquiry
Become Partner
Order Now

Browse Topics In
Knowledge Base


Back To Top

Installation

Troubleshooting

Tutorials

Upgrade To v3.1


Search for Answers
Intelligent FAQ Search. Type in your keywords to search for the answers you need.


Customer Helpdesk
Can't find the answers you need? Go to our Technical Support Helpdesk





Back Newsletter > Installation Showing 1 of 2 Next


Installing the Newsletter 3.1
Modified on 2005-06-02


You can choose to download only the Newsletter Component or the entire One Admin Suite. Before installing, we recommend you to take a look at System Requirements.

Your web host must have PHP installed and configured with the MySQL database support. Also, you should have FTP access to the web server where you wish to install the Newsletter on.

Step 1: Unzip File

Unzip the newsletter31.zip onto your local computer, making sure to preserve the directory structure contained in the zip. If you do not have a zip utility, you can download one for free, the Winzip program from


Step 2: Uploading Files

Using a FTP program, login to your web server and transfer the 'oneadmin' folder from your local computer into the web root. This is usually public_html or httpdocs folder, the same directory in which your homepage resides. However, the web root location could be different on your server.


Step 3: Set File Permissions

The Newsletter requires modification of files or create new files in directories. If you are using Unix-based web server, you will need to set file permissions - read, write and execute on these files and directories. Most FTP programs allow you to change file permissions.

Permissions are specified by 3 digit number, such as 644 or 755. Please CHMOD * these file and directory accordingly:

  • /oneadmin/_files : 777 (Owner: Read, Write, Execute; Group: Read, Write, Execute; Others: Read, Write, Execute)

  • /oneadmin/config.php : 777 (Owner: Read, Write, Execute; Group: Read, Write, Execute; Others: Read, Write, Execute)

Unix File Permissions
* CHMOD is a command responsible for changing file permissions.

To set file permissions with your FTP program, right click on a file or directory, and look for command such as 'File Attributes', 'Change File Permissions', or 'chmod'. From here you will be able to set 'read, write, execute' permissions for 'owner, group, others' via checkboxes. Anyway, the easiest way to set permission would be insert the appropiate number.

Windows File Permissions

Normally, PHP scripts is able to run on Windows environment with no need to set any file permissions.

However, in some cases, a server might not be setup to allow the PHP scripts to have 'write access' to it's file. As a result, the program will prompts you warning message stating that it is not able to write into it's data file.

Windows server users will not be able to set the file permissions via FTP. In this case, talk to your server administrator for help with this.


Step 4: Creating a MySQL Database

The Newsletter make use of MySQL database to store your data.  This database must be created before you run the Installation Wizard.

Most web hostings include an integrated control panel to let you manage your MySQL database easily.

Let's login to your MySQL database, and create a new database for your Newsletter, as well as a new user account with full permissions on that database. You can also use the existing database if you wish. Please jot down the MySQL details, as you will need them in the Installation Wizard.

If you do not have enough permission to create the database, you may need to ask your web hosting provider to create it for you, and grants you access.
 


Step 5: Run Installation Wizard

To run the Installation Wizard, open the /oneadmin with your web browser, for example: http://your-domain-name/oneadmin.

The Installation Wizard will appears, which will guides you through the final installation process. Simply follow 4 simple steps as described below:

(I) Checking Server Configurations

The Web Blogger performs PHP configuration checking, to ensure your web server meets the system requirements. If any incompatibilities take place, we advice you to adjust your server configuration before proceed to complete the installation.


(II) Directory Paths and Administrator Password

This section allows you to specify the locations of your /oneadmin directory, and the administrator login password. There are 4 text fields to fill in, from which 3 have been defined by the Newsletter program.

  • Web Address

    The complete URL to the /oneadmin folder on your web server, such as http://your-domain-name/oneadmin/. It is also the fully qualified URL to access your administrator panel, and you use it to request for your product activation key.


  • Document Path

    The complete path from root level to the /oneadmin folder on your web server, for example: '/home/sitename/public_html/oneadmin/', or
    '/var/www/httpdocs/sitename/oneadmin/'. If you unsure of the path, please ask your server administrator.

    By default, this text field should already contains values that the Newsletter has specified for you. However, in some special instances, you may need to enter the correct path as required:

    1. Value of document path consist only a single slash '/' character
    - This is caused when your server might not be setup to publish complete path.
    - It is advised that you make a request to your server administrator for the complete document path.


    2. Document path of Windows web server
    - Says the default value is 'E:\home\system\sitename\oneadmin\'.
    - Here's what to do: Replace all backslash '\' with double backslash '\\'. Your correct path should look something like this 'E:\\home\\system\\sitename\\oneadmin\\'


  • Administrator Login

    The Newsletter creates user 'admin' by default, and you will not be able to edit this username, nor delete this account. The admin will have full permission to access and maintain every part of the application.

    Create a password that will be used by admin to sign in to the control panel, and re-enter for confirmation.


(III) SMTP & Email Settings

In this section you'll require to enter the administrator email, and the related SMTP info.

  • Email Address
    - the email address of user 'admin'. Notifications will be emailed to this address.

  • Mail Server
    - the address or hostname of the mail server for admin's email.

  • Email Login
    - account name or login ID to access your mail account.

  • Email Password
    - the password to your mail account


(IV) MySQL Database Settings

This section allows you to enter the details MySQL database, which you have created ealier. There are 4 fields to complete:

  • MySQL Host
    - The host name of the server where MySQL is installed, such as localhost (the most common used name, and is specified by default)

  • MySQL Username
    - The user account of the MySQL database you created ealier.

  • MySQL Password
    - The password for the above user account.

  • MySQL Database
    - The name of the MySQL database you created to store the Newsletter's tables.


Once you have completed all sections, scroll down to the bottom of the page and click the 'Proceed To Install' button. Your Newsletter configuration is written to the /oneadmin/config.php file, also, the MySQL database will be created.

Now, you're ready to login to your One Admin panel, using the username 'admin' and the password your created just now. Proceed to install the Newsletter, and start running the mailing list subscription on your web page.


Step 6: Setting Up Cron (optional)

Cron is simply a Linux module that allows you to run a program or script at predetermined times (intervals). Using Cron, you will be able to setup scheduled sending. In Windows, it's called 'Scheduled Task'.

You may need to check with your hosting provider to see if you have Cron access. If you don't have access, you will not be able to run scheduled sending.

Many web hosts provide you a control panel to administer the Cron jobs. This can simplify the setting up of Cron jobs on your web server. In this tutorial, we'll look into cron setup using command line and CPanel. You will need to edit a PHP file first before proceed to setup cron.

(I) Modify PHP File

The PHP file responsibles for schedule and send newsletter is wce.sendcron.php. This file is located in /oneadmin/newsletter directory.

Open the file with your text editor. Look for the $configpath variable at the top of the file. Assign it with the Document Path of your /oneadmin directory, for example '/home/sitename/public_html/oneadmin/'. Now, the $configpath variable should look something like this:

$configpath = "/home/sitename/public_html/oneadmin/";

Tips: You can find the Document Path value from the /oneadmin/config.php file.

Save the wce.sendcron.php file.


(II) Setup Cron Using CPanel

Before you can setup the cron, you will need to find the following paths, and note them down:

  • The path to your PHP executable, such as '/usr/bin/php'
    - please ask your server administrator for this value.

  • The complete path to the wce.sendcron.php file, such as '/home/sitename/public_html/oneadmin/newsletter/wce.sendcron.php'

    Tips: Use the Document Path from /oneadmin/config.php file, and add 'newsletter/wce.sendcron.php' to the end.

Now, navigate to your CPanel via the web browser.

  1. Login to your CPanel, and click on Cron Jobs.

  2. On the next page, click on the 'Advanced (Unix Style)' button.

  3. In the Cron Jobs Manager section, enter '0' (zero) to the Minute text field on the first row. 

  4. Type in the following line to Command text field.


    /usr/bin/php /home/sitename/public_html/oneadmin/newsletter/wce.sendcron.php >/dev/null

    Substitute the path in green to your PHP executable, and the path in orange to the complete path to your wce.sendcron.php file.

  5. Click on the 'Commit Changes' button to save your setting.


(III) Setup Cron Using Command  Line

  1. Login to your web server via telnet or SSH.

  2. Use 'cd' command to change into your /oneadmin directory, such as

    -> cd /home/sitename/public_html/oneadmin/
  3. Type 'ls -a'. You should see the newsletter directory. Change into this directory

    -> cd newsletter

  4. Type 'ls -a'. There is a file called 'wce.sendcron.php'. Note down the complete path to the wce.sendcron.php file.

    Tips: Type 'pwd' to find the path to this directory, and from the response, add 'wce.sendcron.php' to the end.

    This is what the path might look like: '/home/sitename/public_html/oneadmin/newsletter/wce.sendcron.php'

  5. Now, you'll need to find the path to PHP executable. To do this type 'which php'. You should see a response such as '/usr/bin/php'. If you don't get a response, please ask your server administrator for assistance.

  6. Type 'crontab -e'. This command edits your Crontab file, and this loads the Crontab into a text editor. By default, Linux uses text editor Vi.

  7. Press 'i' key to change into Insert Mode. Enter the following line to the end of your Crontab file:

    0 * * * * /usr/bin/php -q /home/sitename/public_html/oneadmin/newsletter/wce.sendcron.php

    Substitute the path in green to the PHP executable you received in step 5, and the path in orange to the response you get in step 4.

  8. Finally, save your Crontab file : press escape, colon, w, q, enter

This Cron setting enables scheduled sending to run hourly (eg 2.00, 16.00), without a popup window.




Is this FAQ helpful? Ratings :
Printer Friendly Version
Tell A Friend


Related FAQs In This Category
Installing the Newsletter 3.1
Integrating Newsletter To Your Web Page



Copyright © 2002-2005 by Comdev Software Sdn Bhd. All Rights Reserved. License Agreement Privacy Policy Site Map