(→Installation) |
(→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''' to define the path in which the result files will be stored. An example line is defined at the top of the file. | ||
*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. | ||
*Type: "<tt>source <base_path>/gpmdb/create_local_gpmdb_users.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 users needed by the Perl scripts to both display and add information to the database. | *Type: "<tt>source <base_path>/gpmdb/create_local_gpmdb_users.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 users needed by the Perl scripts to both display and add information to the database. | ||
+ | *Type: "<tt>source <base_path>/gpmdb/populate_paths_table.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 add a path value for all GPM result files created by search software on your installation. | ||
=== Automation Configuration === | === Automation Configuration === | ||
*Schedule the execution of the '''\thegpm\scripts\processArchives.pl''' script, which parses the XML files created by the search software and adds them to the database. This can be done in the Windows Control Panel, under Scheduled Tasks. | *Schedule the execution of the '''\thegpm\scripts\processArchives.pl''' script, which parses the XML files created by the search software and adds them to the database. This can be done in the Windows Control Panel, under Scheduled Tasks. |
Contents |