Documentation Home

Installing Data Center Audit on UNIX/LINUX

 

1. Download the UNIX version of Data Center Audit. It should be a file named dca_setup<version>.tar.gz

Prerequisites

  • You FTP's file dca_setup_<version>.tar.gz to /tmp on your LINUX/UNIX machine.
  • Your APACHE document root is in /usr/local/apache/htdocs
  • Your APACHE user and group is "apache" and "www" (or something else that you know)
  • You have the ability to write and make changes to the apache htdocs directory. Specifically copy files, change permissions/etc.
  • The apache user has the ability to write files in the htdocs directory
  • You know your MySQL root (or admin) user account

If you do not know how to compile Apache,PHP,MySQL, there are many resources on the internet if you go to http://google.com and search on "apache,php,mysql".

CLICK HERE for an outline of how to compile apache, php, mysql on RedHat Linux

 

 


After you have your Web server with PHP,MySQL installed and running, here is how to proceed with Data Center Audit.

#cd /tmp
# gunzip dca.243.tar.gz
# tar -xvf dca.243.tar
dca
dca/dca/
dca/dca/docs/
dca/dca/docs/files.htm
dca/dca/docs/faq.htm
dca/dca/docs/index.html
dca/dca/docs/iis_setup.htm

dca/dca/docs/images/
dca/dca/docs/images/layout_rack1.jpg
dca/dca/docs/images/layout_rack2.jpg
dca/dca/docs/images/main_view_checked.jpg
dca/dca/docs/images/wamp_menu.jpg

....

# ls
dca README.TXT
# mv dca /usr/local/apache/htdocs
# cd /usr/local/apache/htdocs
# chmod -R 755 dca
# chown -R apache:www dca

Now it is time to test MySQL

For example: assming the ROOT password is 'password'

# mysql -u root -p password -e"show databases";

# mysql -u root -phitachi -e"show databases"

Now it is time to create the dca database.

# mysql -u root -ppassword -e"create database dca";

 

Now it is time to grant privileges to the user that dca will use to pull/extract and change information in the database.

In the below example it illustrates using user "labuser" with password "somepass"


# mysql -u root -ppassword -e"grant insert,update,select,delete on dca.* to labuser@'%' identified by 'somepass';flush privileges;"

mysql> show grants for labuser;


You need to verify the permissions were set by doing

# mysql -u root -ppassword -e"use mysql; select * from user where User='labuser';"

If the above do not show "Y" on the Select_priv, Insert_priv, Update_priv, Create_priv, and Delete_priv, then you may need to MANUALL set them by doing:

mysql> update user set Update_priv='Y',Select_priv='Y',Delete_priv='Y',Create_priv='Y',Insert_priv='Y' where User='labuser';
mysql>flush privileges;
mysql> show grants for labuser;


Now we can create the database

# cd dca
# mysql -u root -ppassword -Ddca < dca_db.sql
#
# mysql -u root -phitachi -Ddca -e" show tables";

 

Now it is time to launch Data Center Audit.

Go to your browser and put in the URL of your web server plus the "/dca"directory.

i.e. http://<somehost>/dca


The Database password "password" should already be filled out, and all other default fields should be provided.

Back to top





At this screen, be sure to:

  • Include a trailing slash "/" with the directory dca is installed with respect to the website document root directory.

  • If you choose NOT to accept the default of localhost, include the web server domain name.

    DO NOT place "http" or any slashes in the name. Only place the server name.

    For example:
    If your website URL is http://www.foobar.com, then place 'foobar.com' in this field.

  • You may enter the title of your lab in the Lab Title field.

  • If you have an SSL web site (i.e. https prefix), then select https

  • Enter the name of the database you wish to create. Or use the default

  • Select whether or not to create the database and tables
    *note: when re-running the setup for re-installation, if you already have the database created you may leave these fields unchecked.

  • Enter the user name and password of the user allowed to create the database

  • Select the graphical theme you wish to use.



When setup is complete you should see the following screen


This screen indicates that the dca_config.php and dca_db.php files have been built.

The config file contains all required configuration information for the product, and the db.php file contains mySQL database login information.

Now you may proceed with instructions from the Operations Guide