Installing QnECMS

The instructions on this page are for manual install only. The latest version has an installer. For the latest information - read the install file that comes with the scripts

Download the latest version of QnECMS from the link in the email sent after purchase. Extract the files, e.g. on Linux extract using the command:

e.g. tar -xzvf qnecms1.8.4.tar.gz

(Substitute the name of you the file you have downloaded in the above command).

Copy all of the files and folders from the folder called 'html' into the public root of your webserver. Do not copy the html folder - just the files in the folder.

Create the database

You can use phpMyAdmin to set up your database, tables and users - or use the Linux/Unix command line.

Using phpMyAdmin

Open phpMyAdmin in your browser and create a new database by typing the name of your database into the 'Create new database' input field and clicking the 'create' button.

Import the tables and data

Having created a database, click the database name (on the left column), click the SQL link near the top of the right hand column - you will be presented with a form to upload the contents of your sql file. Open the qnecms.sql file on your own computer and copy everything from that file into the 'Run SqL query form field'. Click the Go button and the tables and data will be set up for you.

Create a user

Click the home icon (top left column), click Privileges, click 'Add a new user', put in a users name, choose localhost (from drop down menu choose local), add a password of you choice (make a note of it) - and click Go. On the resulting screen scroll down to the bit that says 'Database-specific privileges' - and choose your database from the list. You will be taken to a screen where you can add the privileges for this user; check everything in the first two columns and click Go.

Using the command line to set up the database

Substitute your own account name and password in the following examples.

Login to mysql

mysql -u root -p

hit return and supply password.

create database qnecms;
exit

Populate the database with tables for CMS. You will find the .sql file in the configs folder.

mysql qnecms < qnecms_db.sql -u root -p

Hit return, type in your MySQL password and hit return.

Add an MySQL user for the CMS, e.g.,

Login to Mysql

grant select, insert, update, delete, create, drop, index, alter on qnecms.* to yourusersname identified by 'youruserspassword';
exit;

You should now have the details required to set up your config filem i.e., a database name, user and user password.

Edit the QnECMS config file

Find the configs folder you have dowloaded:

1. Open the configvalues.php file in you text editor and change the configuration details to suit your server. There are comments within the file relating to each variable.
2. Go back to the main public web directory - and modify the permissions and ownership of the fileuploads and imageuploads directories. These directories need to be writable by PHP if you want to upload images and files.

Change the file persmissions for the image and file upload directories.

chmod 775 imageuploads
chmod 775 fileuploads

Assuming the Apache user and group is httpd, change the owner and group. You may only need to change the owner - experiment:

Change owner and group

chown httpd.httpd imageuploads
chown httpd.httpd fileuploads

If you are going to use the built-in markup validator, you will have to change permissions and owner of the validator directory.

chmod 775 admin/validator
chown httpd.httpd admin/validator

If you don't have access to change folder ownership

Changing folder owner to apache owner is slightly more secure than providing access to your file uploads folders to everyone on your server. If you don't have root access to you server and don't know the php/apache owner - and you still want to use the image and file upload facilities - set the directories to 777 via your ftp client.

Often it is possible to made these permission changed via you ftp client program - if you don't not have access to the command line.

Load the index page of the CMS into your web browsers: http://www.yourdomainname.com/index.php

Login with the following details:

email: admin@qnecms.co.uk
password: test1234

IMPORTANT

The very first thing you should now do is change the administration email and password to your own.

When you login the first time, scroll down to the admin menu and click 'Edit profile' and replace the name and email address with your own. DON'T CHANGE THE PASSWORD YET. After clicking the submit button, click the link to take you back to the home page and you will see that you have been logged out.

Use your email address and the default admin password test1234 to log back in - and then change your password using the 'Change your password' link. Login again with your new email address and password.

If you are going to use the PERL based newsletter facility: You need to ensure that Perl can talk to your MySQL database. This will already be setup in most recent Linux distributions.

Chmod the cgi-bin directory and the file within it (sendanemail.pl) as 755. Also edit the /cgi-bin/sendanemail.pl file and ensure that the path to your config file is correct and that the path to sendmail is correct.

CMS template files

The template files are located in the /templates folder:

• Home page header:headerhome.php
• Home page footer: footerhome.php
• Header for all other pages: headermain.php
• Footer for all other pages: footermain.php

Prior to version 2.2.1 they were located in the /admin/include folder. If you are updating from an earlier version copy your home and main templates into the new folder location.

If you need to re-skin the administration interface the templates are headeradmin.php and footeradmin.php.

The stylesheets are in the stylesheets folder: admin.css is for the administration pages, likeowen.css relates to the public site design templates - you will replace this with you own.

You are done.

Use the support forum if you have any questions.

Disclaimer: you are fully responsible for installing and using these scripts. Use them at your own risk.

QnECMS copyright Jim Byrne 2003, 2004, 2005, 2006, 2007, 2008.
Special thanks to Rich Pedley (aka elfin) for much needed help developing this CMS.

Comments