METHOD 1 - Root Directory Install | If you want to devote your entire web server to Nomad (i.e. http://www.yourserver.edu/ points directly to Nomad), choose this method. |
METHOD 2 - Sub-directory Install | If you want Nomad to be a part of your server, but have other things on your server you'd like to keep in place, choose this method. |
Open up the NOMAD.SQL file with an editor that can handle big files (emacs worked for me), and insert the following two statments right at the top:
CREATE DATABASE NOMAD; USE NOMAD;Note: Since this file is so big, you could use a simple text editor to create a file with the two statements above, and then "cat" the big NOMAD.SQL file onto the end of that file using the UNIX command for concatenating files (type: man cat for more info).
Now that you have MySQL running, you can create and populate/initialize the Nomad database by executing the following command (make sure you are in the same directory as the NOMAD.SQL file):
mysql -uroot -pfriday < NOMAD.SQL |
This example assumes you've configured your MySQL server for pasword access. Substitute your own password for 'friday'.
create_user2.pl
query_builder.pl
select_lib.pl
Within each of these files is a line specificying connection parameters for connecting to the database. For example, from create_user.pl:
my $dbh_mysql = DBI->connect("DBI:mysql:mysql:localhost",'root',''); ##### SECURITY ISSUE!!!! #####
You can clear up the security issue by requiring a password (setting a password as outlined in the MySQL installation guide above). If you have set the root pasword then simply modify the above scripts by adding your password between the single quotes after the 'root' option:
my $dbh_mysql = DBI->connect("DBI:mysql:mysql:localhost",'root','friday');
Again, 'friday' is only an example, you must choose your own password. Once the scripts above are modified, everything should be set for you to run NOMAD!