(→Script Configuration) |
(→Database Configuration) |
||
Line 69: | Line 69: | ||
=== Database Configuration === | === Database Configuration === | ||
- | *Log into MySQL as the root user you defined during its installation | + | *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. |
- | * | + | *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>/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. | ||
+ | |||
=== Automation Configuration === | === Automation Configuration === | ||
#Schedule the execution of the '''\thegpm\scripts\popGPMDB.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\popGPMDB.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 |