directories: /usr/local/jobster/bin/ mode=755 owner=root group=root files: /var/log/mysqlpurge mode=777 owner=bluegecko group=bluegecko action=create packages: ## # By default we'll install MySQL 5 unless the app specifically wants v4, # right now the main app that wants v4 is the older version of cacti, and # legacy workzoo stuff. ## centos_4.64_bit.!NEEDS_MYSQL_V4:: MySQL-server-community-5.0.45-0.rhel4 pkgmgr=rpm elsedefine=install_mysql5_server_rpm_rhel_64 # perl-DBD-MySQL # pkgmgr=rpm # elsedefine=install_perl_dbd_mysql5_rpm_rhel_64 centos_5.32_bit.!NEEDS_MYSQL_V4:: MySQL-server-community-5.0.45-0.rhel5 pkgmgr=rpm elsedefine=install_mysql5_server_rpm_rhel5_32 centos_4.64_bit.NEEDS_MYSQL_V4:: mysql-4.1.20-1.RHEL4.1 pkgmgr=rpm elsedefine=install_mysql4_rpm_rhel_64 # perl-DBI-1.40-8 # pkgmgr=rpm # elsedefine=install_perl_dbi_rpm_rhel_64 # perl-DBD-MySQL-2.9004-3.1 # pkgmgr=rpm # elsedefine=install_perl_dbd_mysql4_rpm_rhel_64 mysql-server-4.1.20-1.RHEL4.1 pkgmgr=rpm elsedefine=install_mysql_server4_rpm_rhel_64 centos_4.32_bit.NEEDS_MYSQL_V4:: # perl-DBI-1.40-8 # pkgmgr=rpm # elsedefine=install_perl_dbi_rpm_rhel_32 # perl-DBD-MySQL-2.9004-3.1 # pkgmgr=rpm # elsedefine=install_perl_dbd_mysql4_rpm_rhel_32 MySQL-server-standard-4.1.22-0.rhel4 pkgmgr=rpm elsedefine=install_mysql4_server_rpm_rhel_32 # we won't upgrade prod just yet since it's a fairly heavily used system with jobalerts and stuff fedora_4.32_bit.NEEDS_MYSQL_V4.!prod_mysql_2a_sea2_jobster_us.!prod_mysql_2b_sea2_jobster_us:: perl-DBI-1.48-4 pkgmgr=rpm elsedefine=install_perl_dbi_rpm_fc4_32 mysql-4.1.20-1.FC4.1 pkgmgr=rpm elsedefine=install_mysql4_rpm_fc4_32 perl-DBD-MySQL-2.9007-1 pkgmgr=rpm elsedefine=install_perl_dbd_mysql4_rpm_fc4_32 mysql-server-4.1.20-1.FC4.1 pkgmgr=rpm elsedefine=install_mysql4_server_rpm_fc4_32 copy: prod_mysql_1b_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/PROD/conf/prod-mysql-1b.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) prod_mysql_1c_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/PROD/conf/prod-mysql-1c.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) prod_mysql_3a_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/PROD/conf/prod-mysql-3a.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) prod_mysql_3b_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/PROD/conf/prod-mysql-3b.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) sand_mysql_1a_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/sand-mysql-1a.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) sand_mysql_1b_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/sand-mysql-1b.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) sand_mysql_1c_sea2_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/sand-mysql-1c.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) corp_app_2_sea1_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/corp-app-2.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) corp_mysql_1a_sea1_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/corp-mysql-1a.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) beta_mysql_1a_sea1_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/beta-mysql-1a.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) perf_mysql_1a_sea1_jobster_us:: $(cf_rootdir)/repository/misc/mysql/NONPROD/conf/perf-mysql-1a.cnf dest=/etc/my.cnf owner=root group=root mode=440 encrypt=true type=checksum server=$(policyhost) PROD:: $(cf_rootdir)/repository/misc/mysql/PROD/bin/optimize_database.sh dest=/usr/local/jobster/bin/optimize_database.sh mode=750 owner=root group=root type=checksum encrypt=true server=$(policyhost) $(cf_rootdir)/repository/misc/mysql_monitor/PROD/bg.jsdb dest=/usr/local/bg r=inf owner=bluegecko group=bluegecko type=checksum encrypt=true server=$(policyhost) $(cf_rootdir)/repository/misc/mysql_monitor/PROD/bg.jsdb dest=/usr/local/bg r=inf owner=bluegecko group=bluegecko type=checksum encrypt=true server=$(policyhost) $(cf_rootdir)/repository/misc/mysql_monitor/PROD/mysql-master-log-purge.sh dest=/usr/local/bg/bin/mysql-master-log-purge.sh owner=bluegecko group=bluegecko type=mtime encrypt=true server=$(policyhost) !PROD:: $(cf_rootdir)/repository/misc/mysql_monitor/NONPROD/mysql-master-log-purge.sh dest=/usr/local/bg/bin/mysql-master-log-purge.sh owner=bluegecko group=bluegecko type=mtime encrypt=true server=$(policyhost) $(cf_rootdir)/repository/misc/mysql_monitor/NONPROD/bg.jsdb dest=/usr/local/bg r=inf owner=bluegecko group=bluegecko type=checksum encrypt=true server=$(policyhost) $(cf_rootdir)/repository/misc/mysql/NONPROD/bin/optimize_database.sh dest=/usr/local/jobster/bin/optimize_database.sh mode=750 owner=root group=root type=checksum encrypt=true server=$(policyhost) ENV_JSDB_SERVER:: $(filesdir)/ujobs/COMMON/bin/jsearch-pause.sh dest=/usr/local/sbin/jsearch-pause.sh owner=root group=root mode=555 type=checksum $(filesdir)/ujobs/COMMON/bin/jsearch-unpause.sh dest=/usr/local/sbin/jsearch-unpause.sh owner=root group=root mode=555 mysql_seperate_log_dir:: $(filesdir)/mysql/COMMON/bin/mysql.init dest=/etc/init.d/mysql owner=root group=root mode=550 server=$(policyhost) type=checksum PROD:: $(filesdir)/mysql/COMMON/bin/mysql-snapshot-backup-host.sh dest=/usr/local/sbin/mysql-snapshot-backup-host.sh owner=root group=root mode=550 type=checksum server=$(policyhost) editfiles: { /usr/local/bg/bin/mysql-master-log-purge.sh LocateLineMatching "MAILTO=" ReplaceLineWith "MAILTO=\"$(mysqlAlias)\"" reset 1 LocateLineMatching "MASTER=" ReplaceLineWith "MASTER=\"$(crawlPurgeMaster)\"" } { /usr/local/bg/bin/mysql-local-log-purge.sh LocateLineMatching "MAILTO=" ReplaceLineWith "MAILTO=\"$(mysqlAlias)\"" } { /etc/pure-ftpd/pure-ftpd.conf LocateLineMatching "Quota.*5:100" ReplaceLineWith "Quota 5:500" DefineClasses restartPureFTP } prod_mysql_1c_sea2_jobster_us:: { /var/spool/cron/root ResetSearch "1" LocateLineMatching "##### BEGIN Mysql Optimize CRON $(EditHeader).*" BeginGroupIfNoMatch "##### BEGIN Mysql Optimize CRON $(EditHeader) Rev 4" DeleteToLineMatching "##### END Mysql Optimize CRON $(EditHeader).*" DeleteNLines "1" EndGroup CatchAbort BeginGroupIfNoLineMatching "##### BEGIN Mysql Optimize CRON $(EditHeader).*" ResetSearch "1" Append "" Append "##### BEGIN Mysql Optimize CRON $(EditHeader) Rev 4" Append "1 2 * * 0 /usr/local/jobster/bin/optimize_database.sh 1>/dev/null 2>&1" Append "##### END Mysql Optimize CRON $(EditHeader) Rev 4" EndGroup } restartMysql:: { /etc/my.cnf LocateLineMatching "server-id.*=.$" ReplaceLineWith "server-id = $(mysqlID)" } !PROD.!sand_mysql_3a_sea2_jobster_us.!BETA.!ENV_CORP.!DEVELOPMENT:: { /var/spool/cron/root AppendIfNoSuchLine "30 1 * * * /usr/local/bg/bin/mysql-local-log-purge.sh" } shellcommands: install_perl_dbi_rpm_rhel_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/centos_4.5_32/CentOS/RPMS/perl-DBI-1.40-8.i386.rpm" install_perl_dbd_mysql4_rpm_rhel_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/centos_4.5_32/CentOS/RPMS/perl-DBD-MySQL-2.9004-3.1.i386.rpm" install_mysql4_server_rpm_rhel_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/updates/rhel_4_32/mysql/MySQL-server-standard-4.1.22-0.rhel4.i686.rpm" "/sbin/chkconfig --level 2345 mysqld on" "/etc/init.d/mysqld restart" restartPureFTP:: "/etc/init.d/pure-ftpd restart" install_mysql5_server_rpm_rhel_64:: "/bin/rpm -e --nodeps --allmatches MySQL-server-*" "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/updates/generic/mysql/5.0.45/x86_64/MySQL-server-community-5.0.45-0.rhel4.x86_64.rpm" install_perl_dbd_mysql5_rpm_rhel_64:: #"/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/updates/centos4_4_64/centosplus/x86_64/RPMS/perl-DBD-MySQL-3.0008-1.el4.centos.x86_64.rpm" install_perl_dbi_rpm_rhel_64:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/updates/centos4_4_64/centosplus/x86_64/RPMS/perl-DBI-1.53-2.el4s1.x86_64.rpm" install_perl_dbd_mysql4_rpm_rhel_64:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/centos_4.4_64/CentOS/RPMS/perl-DBD-MySQL-2.9004-3.1.x86_64.rpm" install_mysql4_rpm_rhel_64:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/centos_4.4_64/CentOS/RPMS/mysql-4.1.20-1.RHEL4.1.x86_64.rpm" install_mysql_server4_rpm_rhel_64:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/centos_4.4_64/CentOS/RPMS/mysql-server-4.1.20-1.RHEL4.1.x86_64.rpm" "/sbin/chkconfig --level 2345 mysqld on" "/etc/init.d/mysql restart" install_perl_dbi_rpm_fc4_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/fc4_32/Fedora/RPMS/perl-DBI-1.48-4.i386.rpm" install_mysql4_rpm_fc4_32:: "/bin/rpm -e --nodeps MySQL-devel-4.1.13-0" "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/updates/fc4_32/mirrors.kernel.org/fedora/core/updates/4/i386/mysql-4.1.20-1.FC4.1.i386.rpm" install_perl_dbd_mysql4_rpm_fc4_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/kickstart/OS/fc4_32/Fedora/RPMS/perl-DBD-MySQL-2.9007-1.i386.rpm" install_mysql4_server_rpm_fc4_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/updates/fc4_32/mirrors.kernel.org/fedora/core/updates/4/i386/mysql-server-4.1.20-1.FC4.1.i386.rpm" "/sbin/chkconfig --level 2345 mysqld on" "/etc/init.d/mysqld restart" install_mysql5_server_rpm_rhel5_32:: "/bin/rpm -Uvh http://kickstart.sea2.jobster.us/updates/rhel_5_32/mysql/5.0.45/i686/MySQL-server-community-5.0.45-0.rhel5.i686.rpm" Hr14.NEEDS_MYSQL_V4:: "/sbin/chkconfig --level 2345 mysqld on 1>/dev/null 2>&1" Hr14.!NEEDS_MYSQL_V4:: "/sbin/chkconfig --level 2345 mysql on 1>/dev/null 2>&1"