TestDAQ Database Creation

Before creating a TestDAQ database, you need to have MySQL installed and running. The steps to do this are architecture-dependent and possibly also site-dependent (in that different sites have different policies for installing and running software.)

You also need a MySQL account with CREATE privileges, often known as the DBA (DataBase Administrator) account

Once you are ready, run the make-daq-db shell script, like this:

    make-daq-db -u dba name -p dba password

where dba name is the name of the DBA account (typically, this is root) and dba password is the password for the DBA account. If the MySQL server is on a different machine, you can also add -h dbhost.

The script will prompt you for a tester account name and password, which will be used by the daq-db software to access the database, and then the script will create the new domprodtest database.

The script will also generate the appropriate domprodtest.properties file for this machine. You'll need to use this generated file instead of the file in daq-db-common/resources. You can either install this properties file in /usr/local/etc or in the home directory of each user who uses the daq-db software.