(→Database Configuration) |
(→Database Configuration) |
||
Line 73: | Line 73: | ||
=== Database Configuration === | === Database Configuration === | ||
*Edit the file '''\gpmdb\create_local_gpmdb_users.sql''' to define the username and password for both a read-only user and a read/write user. They must match what you entered as the usernames and passwords in the '''\thegpm\thegpm-cgi\dbcommon.pl''' file. | *Edit the file '''\gpmdb\create_local_gpmdb_users.sql''' to define the username and password for both a read-only user and a read/write user. They must match what you entered as the usernames and passwords in the '''\thegpm\thegpm-cgi\dbcommon.pl''' file. | ||
- | *Edit the file '''\gpmdb\populate_paths_table.sql''' | + | *Edit the file '''\gpmdb\populate_paths_table.sql''' the values that define the path in which the result files will be stored. An example line is defined at the top of the file, with the values to use defined in the bottom line. |
*Log into MySQL as the root user you defined during its installation, not the read/write user defined in '''\thegpm\thegpm-cgi\dbcommon.pl''' and '''\gpmdb\create_local_gpmdb_users.sql'''. | *Log into MySQL as the root user you defined during its installation, not the read/write user defined in '''\thegpm\thegpm-cgi\dbcommon.pl''' and '''\gpmdb\create_local_gpmdb_users.sql'''. | ||
*Type: "<tt>source <base_path>/thegpm/scripts/create_localgpm_databases_tables.sql;</tt>" (without the quotes), where <base_path> is the location where gpm-software.zip was extracted; e.g., '''D:''' or '''F:/sites'''. This will create the GPMDB database and table structure that will be populated after data files are submitted to the identification software. | *Type: "<tt>source <base_path>/thegpm/scripts/create_localgpm_databases_tables.sql;</tt>" (without the quotes), where <base_path> is the location where gpm-software.zip was extracted; e.g., '''D:''' or '''F:/sites'''. This will create the GPMDB database and table structure that will be populated after data files are submitted to the identification software. |
Contents |