Building a Barebones Content Management System: An Introduction - Getting Started with yaapi
(Page 3 of 5 )

Before I get started, here is a check list of the prerequisites required for the successful installation and implementation of the packages that I intend to use for my development:

• a web server, preferably Apache
• PHP, installed and configured on the server
• a MySQL database

Fortunately, most Linux-based hosting packages bundle the above software as a part of their standard hosting plan. But, if you have a dedicated box that you manage on your own, you can always download (and install) them from the following websites: 

• Apache from http://www.apache.org/
• PHP    from http://www.php.net/ 
• MySQL  from http://www.mysql.com/.

The next step is to download a copy of yaapi. Point your browser to the following URL: http://xhawk.net/projects/yaapi/. Next, I uncompress the archive file, i.e. yaapi-1.2.1.tar.gz, to a convenient location under my web server root as shown below.

$ tar -xzvf yaapi-1.2.1.tar.gz

$ mv yaapi-1.2.1 yappi

Next, I proceed to create a MySQL database that will be used by yaapi. Start up the MySQL client and fire the following commands, one by one.
Create a new database using the following SQL command (I've called mine "bb_cms").

mysql> CREATE DATABASE bb_cms;

Next, I create a MySQL user with the appropriate rights on the database that I’ve created above.

mysql> GRANT SELECT ,  INSERT ,  UPDATE , DELETE , CREATE , DROP , INDEX , ALTER ON `bb_cms`.* TO  " bb_cms_user "@"localhost" IDENTIFIED BY "password_comes_here";
Query OK, 0 rows affected (0.03 sec)

After the database and MySQL user have been created, it is time to set up the required database tables. And fortunately, the yaapi distribution contains a SQL file -- titled "yaapi.sql" -- with the required SQL instructions. Execute the following command: 

$ mysql -D yaapi -u bb_cmsuser -p < /usr/local/apache/htdocs/yaapi/yaapi.sql

Next: Setting it up >>
 

More Administration Articles
More By Harish Kamath

Comments On: Building a Barebones Content Management System: An Introduction

· Looking forward to the rest of the articles in this series. It would be great if you...    · Hi,:lol: This tutorial has excellent timings. Good work Harish..Regards    · Yes - this is a good point. By default, yaapi allows you to add a single image to...    · hi, I'm wondering what you mean by execute command in the 3 last line. what am I...    · Hi,With respect to your query, you have to execute the command from the command...    · Hi, thanks the help. I'm getting an error when I try to run that line. I've tried...   >>> Post your comment now!