Getting Started with yaapi - Administration

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