2,187
edits
m (Added "Add Regional Servers to Federative") |
m (Added "Database Backup Scheduling") |
||
Line 7: | Line 7: | ||
# Add the names of the regional servers to the Federative's config file | # Add the names of the regional servers to the Federative's config file | ||
#* Open <code> S:\Program Files\vizioncore\vFoglight\config\federation.config </code> | #* Open <code> S:\Program Files\vizioncore\vFoglight\config\federation.config </code> | ||
#* Add to <code JndiURLs </code> section, eg <code> "jnp://DTCP-VIRFOGV01.GMI.DTC.REUINT.COM:1099" </code> | #* Add to <code> JndiURLs </code> section, eg <code> "jnp://DTCP-VIRFOGV01.GMI.DTC.REUINT.COM:1099" </code> | ||
#* Restart Foglight services | #* Restart Foglight services | ||
# Check status of new connection | # Check status of new connection | ||
Line 84: | Line 84: | ||
#* EG for DTCP-VIRFOGV01 create <code> -sVFOGDTCP-VIRFOGV01 </code> using something like | #* EG for DTCP-VIRFOGV01 create <code> -sVFOGDTCP-VIRFOGV01 </code> using something like | ||
#* <code> dsadd user "cn=-sVFOGDTCP-VIRFOGV01, cn=Users, dc=gmi, dc=dtc, dc=reuint, dc=com" - pwd "password-here" -pwdneverexpires yes -disabled no </code> | #* <code> dsadd user "cn=-sVFOGDTCP-VIRFOGV01, cn=Users, dc=gmi, dc=dtc, dc=reuint, dc=com" - pwd "password-here" -pwdneverexpires yes -disabled no </code> | ||
#* and make a member of the "SQL Service Accounts" group | |||
# Log into vFoglight (as foglight/foglight), and navigate to '''Dashboards | Users & Security | Configure Directory Services''' | # Log into vFoglight (as foglight/foglight), and navigate to '''Dashboards | Users & Security | Configure Directory Services''' | ||
# Configure AD integration using the table below, leave all other fields as is | # Configure AD integration using the table below, leave all other fields as is | ||
Line 118: | Line 119: | ||
| The LDAP context for user searching || Where to look for domain users || <code> DC=gmi,DC=dtc,DC=reuint,DC=com </code> | | The LDAP context for user searching || Where to look for domain users || <code> DC=gmi,DC=dtc,DC=reuint,DC=com </code> | ||
|- | |- | ||
|} | |||
== Database Backup Scheduling == | |||
Procedure to set-up backup of vFoglight MySQL database to local disk | |||
# Create scheduled task account on GMI domain | |||
#* EG for DTCP-VIRFOGV01 create <code> -jVFOGDTCP-VIRFOGV01 </code> using something like | |||
#* <code> dsadd user "cn=-jVFOGDTCP-VIRFOGV01, cn=Users, dc=gmi, dc=dtc, dc=reuint, dc=com" -pwd "password-here" -pwdneverexpires yes -disabled no </code> | |||
#* and make a member of the "Scheduling Clients" group | |||
# Create directory structure on the backup drive... | |||
#* <code> T:\backup\config </code> | |||
#* <code> T:\backup\data </code> | |||
# Within the config directory create two config files and one batch script; backup.conf, my.conf and DoBackup.bat; with contents as shown at bottom of procedure. | |||
#* As long as S: is your software/database drive, and T: is your backup drive there should be no reason to edit these files | |||
# From a command prompt, run the DoBackup.bat script and check that the following files are created | |||
#* <code> T:\backup\data\ibdata1 </code> | |||
#* <code> T:\backup\data\ibbackup_logfile </code> | |||
# Schedule the batch script to run at 07:00 and 19:00 hrs ''local'' time, using a command similar to (edit as suggested)... | |||
#* <code> schtasks /create /tn "vFoglight MySQL backup" /ru GMI\-jVFOGDTCP-VIRFOGV01 /rp Password /tr T:\backup\config\DoBackup.bat /sc hourly /mo 12 /st 07:00:00 </code> | |||
#* /ru - ''Service account username'' | |||
#* /rp - ''Service account password'' | |||
#* /st - ''First run start time'' | |||
#* Note that due to the GMI lock-down policy, this command must be run as a local admin | |||
{| cellpadding="4" valign="top" | |||
|- | |||
| '''backup.conf''' | |||
||<pre>datadir="T:\backup\data" | |||
innodb_data_home_dir="T:\backup\data" | |||
innodb_data_file_path=ibdata1:10M:autoextend | |||
innodb_log_group_home_dir="T:\backup\data" | |||
set-variable=innodb_log_files_in_group=2 | |||
set-variable=innodb_log_file_size=134217728 </pre> | |||
|- | |||
| '''my.conf''' | |||
||<pre>datadir="S:\Program Files\vizioncore\vFoglight\mysql\data" | |||
innodb_data_home_dir="S:\Program Files\vizioncore\vFoglight\mysql\data" | |||
innodb_data_file_path=ibdata1:10M:autoextend | |||
innodb_log_group_home_dir="S:\Program Files\vizioncore\vFoglight\mysql\data" | |||
set-variable=innodb_log_files_in_group=2 | |||
set-variable=innodb_log_file_size=134217728 </pre> | |||
|- | |||
| '''DoBackup.bat''' | |||
||<pre>REM vFoglight database back-up script | |||
REM Simon Strutt v1.1 11-Aug-09 | |||
if exist T:\backup\data\ibdata1.4 del /q T:\backup\data\ibdata1.4 | |||
if exist T:\backup\data\ibdata1.3 ren T:\backup\data\ibdata1.3 ibdata1.4 | |||
if exist T:\backup\data\ibdata1.2 ren T:\backup\data\ibdata1.2 ibdata1.3 | |||
if exist T:\backup\data\ibdata1.1 ren T:\backup\data\ibdata1.1 ibdata1.2 | |||
if exist T:\backup\data\ibdata1 ren T:\backup\data\ibdata1 ibdata1.1 | |||
if exist T:\backup\data\ibbackup_logfile.4 del /q T:\backup\data\ibbackup_logfile.4 | |||
if exist T:\backup\data\ibbackup_logfile.3 ren T:\backup\data\ibbackup_logfile.3 ibbackup_logfile.4 | |||
if exist T:\backup\data\ibbackup_logfile.2 ren T:\backup\data\ibbackup_logfile.2 ibbackup_logfile.3 | |||
if exist T:\backup\data\ibbackup_logfile.1 ren T:\backup\data\ibbackup_logfile.1 ibbackup_logfile.2 | |||
if exist T:\backup\data\ibbackup_logfile ren T:\backup\data\ibbackup_logfile ibbackup_logfile.1 | |||
"S:\Program Files\vizioncore\vFoglight\mysql\bin\ibbackup" T:\backup\config\my.conf T:\backup\config\backup.conf </pre> | |||
|} | |} | ||