COMP/CMSDIST/mysql-deployment.spec

### RPM external mysql-deployment 0.0.3

Source: mysql-deployment.sh
Requires: mysql
# Let's fake the fact that we have perl (DBI) so that rpm does not complain.
Provides: mysql-deployment.sh

%prep
mkdir -p %{i}/bin
cat << \EOF > %{i}/bin/mysql-deployment.sh
#!/bin/bash
set -e

#if [ -z ${VO_CMS_SW_DIR} ]; then
#    echo "+++ Your CMS environment is not setup, missing VO_CMS_SW_DIR environment"
#    exit 1
#fi
if [ -z ${MYSQL_ROOT} ]; then
    echo "+++ Your CMS MYSQL environment is not setup, MYSQL_ROOT environment"
    exit 1
fi
MYSQL_PATH=$MYSQL_ROOT/mysqldb
if [ ! -d ${MYSQL_PATH} ]; then
    echo "+++ Making ${MYSQL_PATH} directory ..."
    mkdir -p ${MYSQL_PATH}
fi
MYSQL_PORT=3316
MYSQL_SOCK=$MYSQL_PATH/mysql.sock
MYSQL_PID=$MYSQL_PATH/mysqld.pid
MYSQL_ERR=$MYSQL_PATH/error.log

pid=`ps -w -w -f -u ${LOGNAME} | grep mysqld_safe | grep $MYSQL_PORT | grep -v grep | tail -1 | awk '{print $1}'`
if [ ! -z ${pid} ]; then
    echo "CMS MySQL server is already running ..."
else
# may use --skip-networking for pure local MySQL

    if [ ! -d $MYSQL_ROOT/mysqldb/mysql ]; then
        echo "+++ Installing CMS MySQL accounts and DBs ..."
        $MYSQL_ROOT/bin/mysql_install_db --datadir=$MYSQL_PATH --port=$MYSQL_PORT --socket=$MYSQL_SOCK

        echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..."
        $MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \
        --socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID &
        
        sleep 10
        # create CMS MySQL root account
        echo "+++ Creating MySQL default root account ..."
        echo "+++ Account for localhost"
        $MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root password "cms"
        echo "+++ Account for `hostname`"
        $MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms"

        # create CMS MySQL DBS account
        echo "+++ Creating MySQL default dbs account ..."
        $MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "CREATE USER dbs@localhost IDENTIFIED BY 'cmsdbs';"
        $MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "UPDATE user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y' where User='dbs';"
    else
        echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..."
        $MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \
        --socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID &
        sleep 10
    fi
fi

EOF
chmod a+x %{i}/bin/mysql-deployment.sh

%build

%install
#cp /tmp/mysql-deployment.sh %{i}/bin
#cp %{i}/mysql-deployment.sh $RPM_SOURCE_DIR

%post
%{relocateConfig}/bin/mysql-deployment.sh

Revision:	1.12
Committed:	Tue Jul 21 21:00:29 2009 UTC (15 years, 9 months ago) by valya
Branch:	MAIN
CVS Tags:	bld_1366294257_wmagent-dev_slc5_amd64_gcc461, bld_1366220453_wmagent-dev_slc5_amd64_gcc461, bld_1365801108_wmagent-dev_slc5_amd64_gcc461, bld_1365189699_wmagent-dev_slc5_amd64_gcc461, bld_1365103387_wmagent-dev_osx106_amd64_gcc461, bld_1365103080_wmagent-dev_slc5_amd64_gcc461, bld_1365018384_wmagent-dev_slc5_amd64_gcc461, bld_1364985624_wmagent-dev_slc5_amd64_gcc461, bld_1364978618_wmagent-dev_slc5_amd64_gcc461, bld_1364898638_wmagent-dev_slc5_amd64_gcc461, bld_1364855420_wmagent-dev_slc5_amd64_gcc461, bld_1364477047_CmsTC_slc5_amd64_gcc434, bld_1363704737_wmagent-dev_slc5_amd64_gcc461, bld_1363624908_wmagent-dev_osx106_amd64_gcc461, bld_1363597235_CmsTC_slc5_amd64_gcc434, bld_1363027772_wmagent-dev_slc5_amd64_gcc461, bld_1362587917_t0_slc5_amd64_gcc461, bld_1362435765_wmagent-dev_slc5_amd64_gcc461, bld_1362086646_wmagent-dev_slc5_amd64_gcc461, bld_1362083383_wmagent-dev_slc5_amd64_gcc461, bld_1362004165_wmagent-dev_slc5_amd64_gcc461, bld_1361806174_wmagent-dev_slc5_amd64_gcc461, bld_1361397493_wmagent-dev_slc5_amd64_gcc461, bld_1361371766_wmagent-dev_slc5_amd64_gcc461, bld_1361358843_CmsTC_slc5_amd64_gcc434, bld_1361302144_wmagent-dev_slc5_amd64_gcc461, bld_1360935597_CmsTC_slc5_amd64_gcc434, davidlt_20130206_1149-62X, davidlt_20130206_0909-62X, davidlt_20130205_1939-62X, bld_1360063178_wmagent-dev_slc5_amd64_gcc461, bld_1359499209_wmagent-dev_slc5_amd64_gcc461, eulisse_20130128_1430-62X, eulisse_20130128_1043-62X, bld_1359365022_wmagent-dev_osx106_amd64_gcc461, bld_1359150370_wmagent-dev_slc5_amd64_gcc461, bld_1359148765_wmagent-dev_slc5_amd64_gcc461, bld_1358954381_wmagent-dev_slc5_amd64_gcc461, bld_1358942699_CmsTC_slc5_amd64_gcc434, bld_1358853292_CmsTC_slc5_amd64_gcc434, bld_1355848536_PHEDEX-combined-agents_slc5_amd64_gcc461, bld_1355846563_PHEDEX-combined-agents_slc5_amd64_gcc461, TW20121025a, bld_1350485088_PHEDEX-lifecycle_slc5_amd64_gcc461, bld_1350043664_T0DataSvc_slc5_amd64_gcc461, HG1210f, HG1210e, HG1210d, HG1210c, HG1210b, TW20120914a, TW20120913b, TW20120913a, TW20120829b, TW20120829a, HG1210a, T020120827, HG1208e, HG1208d, HG1208c, HG1207d, TW20120727a, TW20120726a, TW20120725a, HG1208a, TW20120724c, TW20120724b, TW20120724a, TW20120720a, TW20120719a, TW20120718a, HG1207c, TW20120704c, TW20120704b, TW20120704a, TW20120702c, TW20120702b, TW20120702a, TW20120621c, TW20120621a, TW20120620a, HG1207b, HG1207a, HG1206d, TW20120607a, TW20120606a, HG1206c, HG1206b, bld_1337784158_cmsweb-analytics_slc5_amd64_gcc461, bld_1337783687_cmsweb-analytics_slc5_amd64_gcc461, HG1206a, HG1205g, HG1205f, HG1205e, HG1205d, bld_1335521675_crabhb_slc5_amd64_gcc461, HG1205c, TW20120428p, TW20120421b, TW20120421a, bld_1334854417_PHEDEX-combined-agents_slc5_amd64_gcc461, HG1205b, bld_1334681121_PHEDEX-combined-agents_slc5_amd64_gcc461, TW20120417a, TW20120416a, HG1205a, TW20120410b, TW20120410a, HG1204h, HG1204g, TW20120327b, TW20120327a, TW20120326a, HG1204f, TW20120322a, HG1203i, HG1204e, TW20120321c, TW20120321b, TW20120321a, HG1204d, TW20120320b, TW20120320a, dieHG1204d, TW20120319k, TW20120319j, TW20120319i, TW20120319h, TW20120319g, TW20120319f, TW20120319e, TW20120319d, TW20120319c, TW20120319b, TW20120319a, HG1204c, TW20120313a, HG1204b, TW20120309h, TW20120309g, TW20120309f, TW20120309e, TW20120309d, TW20120309c, TW20120309b, TW20120309a, HG1204a, TW20120308b, TW20120308a, TW20120307a, HG1203h, TW20120305b, TW20120302a, HG1203g, HG1203f, HG1203e, HG1203d, HG1203c, HG1203b, TW20120216b, TW20120216a, HG1201d, HG1203a, TW20120210a, TW20120209a, TW20120207b, TW20120207a, HG1201c, bld_1328198772_crab_slc5_amd64_gcc461, TW20120130b, TW20120130a, TW20120127b, TW20120127a, TW20120125a, bld_1327424666_crab-client3_slc5_amd64_gcc461, HG1201b, bld_1327416353_crab-server3_slc5_amd64_gcc461, bld_1327397075_cmsbuilder_slc5_amd64_gcc461, TW20120123a, TW20120120a, TW20120119b, TW20120119a, bld_1326980038_cmsbuild_slc5_amd64_gcc461, TW20120118a, bld_1326280382_cmsBuilder_slc5_amd64_gcc461, bld_1326274893_cmsBuilder_slc5_amd64_gcc461, bld_1326273864_asyncstageout_slc5_amd64_gcc461, bld_1324281658_cmsweb_osx106_amd64_gcc461, HG1201a, HG1112d, bld_1323333807_CmsTC_slc5_amd64_gcc461, HG1112c, TW20111129e, TW20111129d, TW20111129c, TW20111129a, TW20111128c, TW20111128b, TW20111128a, HG1112b, TW20111122a, TW20111120a, TW20111118c, bld_1321637643_reqmon_slc5_amd64_gcc461, TW20111118b, TW20111118a, HG1111e, bld_1321455789_happyface_slc5_amd64_gcc461, bld_1321454935_happyface_slc5_amd64_gcc461, TW20111115d, TW20111115c, TW20111115b, TW20111115a, HG1112a, bld_1320341101_PHEDEX-combined-agents_slc5_amd64_gcc434, TW20111103a, bld_1320248863_PHEDEX-combined-agents_slc5_amd64_gcc434, TW20111101e, TW20111101d, TW20111101c, TW20111101b, TW20111101a, TW20111028a, bld_1319551575_PHEDEX-combined-agents_slc5_amd64_gcc461, HG1111d, TW20111017d, TW20111017c, TW20111017b, TW20111017a, TW20111016a, TW20111015a, bld_1318622241_wmagent_slc5_amd64_gcc434, TW20111014a, bld_1318524794_asyncstageout_slc5_amd64_gcc434, bld_1318523430_cmsweb_slc5_amd64_gcc434, HG1111c-gcc434, HG1111c, bld_1318424717_crab-server3_slc5_amd64_gcc434, bld_1318423430_asyncstageout_slc5_amd64_gcc434, LT20111012a, bld_1318410594_crab-server3_slc5_amd64_gcc434, TW20111010c, HG1111b, TW20111010b, TW20111010a, HG1111a-gcc434, HG1111a, builder_2011-10-04_16-25-49_das, bld_1317721310_stagemanager-agent_slc5_amd64_gcc434, builder_2011-09-30_15-50-42_PHEDEX-combined-agents, builder_2011-09-29_13-07-19_cmsweb, builder_2011-09-29_12-57-04_cmsweb, LT20110929b, HG1109e, builder_2011-09-29_09-05-43_crab-server3, builder_2011-09-29_09-05-42_asyncstageout, builder_2011-09-29_05-49-40_wmagent, LT20110928b, builder_2011-09-28_19-05-55_PHEDEX-combined-agents, builder_2011-09-28_16-45-33_das, builder_2011-09-28_16-05-45_das, TW20110928b, builder_2011-09-28_12-04-32_stagemanager-agent, builder_2011-09-28_12-04-32_stagemanager, TW20110928a, builder_2011-09-28_11-09-39_stagemanager-agent, builder_2011-09-27_17-51-30_reqmon, builder_2011-09-26_18-50-48_stagemanager-agent, builder_2011-09-26_18-50-48_stagemanager, HG1109d, builder_2011-09-25_13-08-30_CmsTC, builder_2011-09-23_12-46-40_cmsweb, builder_2011-09-23_12-37-00_cmsweb, builder_2011-09-23_12-09-06_wmagent, builder_2011-09-22_19-07-05_CmsTC, builder_2011-09-22_12-03-59_asyncstageout, builder_2011-09-22_11-25-57_crab-server3, builder_2011-09-22_11-24-38_asyncstageout, builder_2011-09-22_09-46-05_cmsweb, builder_2011-09-22_09-36-11_cmsweb, builder_2011-09-22_05-26-44_wmagent, builder_2011-09-21_19-43-30_CmsTC, builder_2011-09-21_18-06-30_asyncstageout, builder_2011-09-21_15-26-46_wmagent, builder_2011-09-21_12-53-09_crab-server3, builder_2011-09-21_12-53-09_asyncstageout, builder_2011-09-21_12-47-08_crab-server3, builder_2011-09-21_12-45-23_asyncstageout, builder_2011-09-21_10-25-16_CmsTC, builder_2011-09-20_21-03-55_regsvc, builder_2011-09-20_13-03-45_CmsTC, builder_2011-09-20_12-03-56_CmsTC, builder_2011-09-19_17-53-10_cmsweb, builder_2011-09-19_12-05-14_workqueue, builder_2011-09-15_17-45-48_PHEDEX-combined-agents, HG1109c-osx, builder_2011-09-14_13-06-06_cmsweb, builder_2011-09-13_22-04-02_filemover, TW20110913b, TW20110913a, builder_2011-09-13_12-46-32_cmsweb, HG1109c, LT20110913a, builder_2011-09-13_10-10-02_cmsweb, LT20110912a, TW20110911a, TW20110909d, TW20110909c, builder_2011-09-09_17-05-31_dbs3-client, TW20110909b, TW20110909a, builder_2011-09-08_22-46-50_reqmgr, HG1109b, builder_2011-09-07_19-00-35_cmsweb, builder_2011-09-06_22-45-07_globalmonitor, builder_2011-09-06_16-09-09_stagemanager-agent, builder_2011-09-06_15-53-16_stagemanager-agent, builder_2011-09-01_12-14-12_wmagent, HG1109a, builder_2011-08-29_19-08-40_cmsweb, builder_2011-08-27_00-05-05_asyncstageout, builder_2011-08-26_19-05-27_crab-server3, builder_2011-08-16_12-09-37_cmsweb, HG1108b, builder_2011-08-12_22-56-45_cmsweb, builder_2011-08-11_12-11-35_CmsTC, builder_2011-08-09_17-03-37_dbs-server, builder_2011-08-09_14-45-47_dbs-client, builder_2011-08-08_23-23-23_dbs-server, DBS_2_1_6-pre5, DBS_2_1_6-pre4, TW20110808a, DBS_2_1_6-pre3, builder_2011-08-04_18-42-50_stagemanager-agent, builder_2011-08-04_17-25-36_das, builder_2011-08-04_13-25-47_cmsweb, builder_2011-08-02_16-19-02_wmagent, TW20110729a, builder_2011-07-28_21-25-51_dbs-server, builder_2011-07-28_21-25-43_dbs-client, DBS_2_1_6-pre2, TW20110728d, TW20110728c, TW20110728b, TW20110728a, builder_2011-07-28_00-46-23_cmsweb, DBS_2_1_6-pre1, builder_2011-07-27_18-04-14_reqmgr, HG1108a, TW20110727a, TW20110726a, builder_2011-07-20_14-45-50_wmagent, builder_2011-07-18_15-32-58_wmagent, builder_2011-07-14_18-33-29_asyncstageout, builder_2011-07-13_17-03-17_stagemanager-agent, builder_2011-07-13_16-55-50_stagemanager-agent, builder_2011-07-13_16-52-30_wmagent, builder_2011-07-13_09-48-46_crab-server3, builder_2011-07-11_12-04-16_cmsweb, builder_2011-07-11_11-53-31_cmsweb, HG1107c, HG1108a-osx, builder_2011-07-08_16-07-44_cmsweb, TW20110707b, TW20110707a, builder_2011-07-05_11-26-58_cmsweb, HG1107b, builder_2011-07-04_15-53-33_cmsweb, TW20110704b, builder_2011-07-04_12-54-16_stagemanager, TW20110704a, builder_2011-07-02_17-25-15_dbs3-client, TW20110701a, builder_2011-07-01_14-15-56_cmsweb, builder_2011-07-01_12-35-36_cmsweb, builder_2011-06-30_17-06-37_crab-server3, builder_2011-06-29_20-56-28_cmsweb, TW20110629a, TW20110628a, TW20110627b, TW20110627a, builder_2011-06-24_21-18-43_cmsweb, builder_2011-06-24_15-28-33_workqueue, HG1107a, lat20110624a, builder_2011-06-23_18-03-57_CmsTC, TW20110623b, TW20110623a, HG1106e, builder_2011-06-17_14-52-14_cmsweb, builder_2011-06-16_19-08-24_wmagent, builder_2011-06-16_16-09-02_wmagent, builder_2011-06-15_16-54-18_wmagent, builder_2011-06-10_23-58-54_cmsweb, HG1106d, builder_2011-06-08_17-25-21_workqueue, builder_2011-06-07_22-07-15_reqmgr, builder_2011-06-04_17-45-11_dbs3, builder_2011-06-04_17-44-57_dbs3-client, builder_2011-05-31_01-23-03_cmsweb, builder_2011-05-31_00-51-28_cmsweb, HG1106c, TW20110530a, TW20110527b, TW20110527a, builder_2011-05-25_15-26-47_crab-server3, TW20110525a, TW20110524b, TW20110524a, builder_2011-05-24_10-10-21_cmsweb, HG1106b, builder_2011-05-23_17-26-34_crab-server3, builder_2011-05-20_16-46-52_crab-server, builder_2011-05-20_10-32-01_sitereadiness, builder_2011-05-19_15-09-56_wmagent, builder_2011-05-16_23-03-55_CmsTC, builder_2011-05-16_15-13-08_cmsweb, HG1106a, builder_2011-05-13_17-08-55_wmagent, builder_2011-05-11_13-24-46_dbs3-client, builder_2011-05-09_14-05-53_dqmgui, builder_2011-05-05_16-10-12_py2-sqlobject, builder_2011-05-05_13-16-07_dqmgui, builder_2011-05-02_19-33-26_cmsweb, builder_2011-05-02_18-58-25_cmsweb, HG1105c, builder_2011-04-27_19-30-26_cmsweb, builder_2011-04-26_15-14-44_cmsweb, HG1105b, TW20110421b, TW20110421a, builder_2011-04-19_17-22-40_T0PromptSkim, TW20110419c, TW20110419b, TW20110419a, TW20110418a, builder_2011-04-16_00-43-59_reqmgr, TW20110415a, builder_2011-04-15_14-49-10_wmagent, TW20110414c, TW20110414b, TW20110414a, builder_2011-04-12_17-09-48_cmsweb, HG1105a, builder_2011-04-11_19-04-03_workqueue, builder_2011-04-08_17-08-57_cmsweb, HG1104e, builder_2011-04-08_12-05-32_calendar-shift, builder_2011-04-08_11-26-43_wmagent, ge20110407-igprof-book, builder_2011-04-07_19-51-01_calendar-shift, builder_2011-04-07_17-11-58_calendar-shift, builder_2011-04-07_16-23-25_calendar-shift, builder_2011-04-07_15-45-05_calendar-shift, TW20110407a, HG1104d, TW20110331c, TW20110331b, builder_2011-03-31_13-06-26_crab-server, TW20110331a, TW20110330a, builder_2011-03-29_10-01-40_cmsweb, HG1104c, builder_2011-03-28_17-53-57_crab-server, TW20110328a, builder_2011-03-25_15-38-34_cmsweb, builder_2011-03-25_12-48-58_cmsweb, builder_2011-03-24_17-23-46_reqmgr, builder_2011-03-23_16-16-18_cmsweb, builder_2011-03-23_16-04-32_cmsweb, builder_2011-03-23_11-32-11_cmsweb, builder_2011-03-23_10-48-54_cmsweb, HG1104b, builder_2011-03-23_09-32-23_cmsweb, TW20110322e, TW20110322d, TW20110322c, TW20110322b, TW20110322a, builder_2011-03-21_16-11-33_calendar-shift, builder_2011-03-21_16-08-10_calendar-shift, builder_2011-03-21_15-53-32_calendar-shift, builder_2011-03-18_17-21-58_cmsweb, HG1104a, builder_2011-03-18_11-41-55_mechanize, builder_2011-03-17_16-27-25_das, HG1103e, TW20110316a, builder_2011-03-14_22-22-58_T0PromptSkim, builder_2011-03-14_16-24-26_calendar-shift, builder_2011-03-14_15-23-03_PHEDEX-combined-agents, builder_2011-03-14_13-03-29_PHEDEX-combined-agents, HG1103d, builder_2011-03-11_20-03-23_PHEDEX-combined-agents, DAS_20110311_slc5_amd64_gcc434, TW20110311a, HG1103c, builder_2011-03-10_20-36-50_dbs3, TW20110310a, DAS_20110309_slc5_amd64_gcc434, builder_2011-03-09_10-06-32_cmsweb, builder_2011-03-08_16-58-27_wmagent, HG1103b, builder_2011-03-08_11-38-13_cmsweb, builder_2011-03-07_23-56-56_cmsweb, TW20110307b, TW20110307a, FILEMOVER_20110304_slc5_amd64_gcc434, FILEMOVER_20110303_slc5_amd64_gcc434, DAS_20110303_slc5_amd64_gcc434_v4, DAS_20110303_slc5_amd64_gcc434_v3, DAS_20110303_slc5_amd64_gcc434_v2, builder_2011-03-03_13-50-13_cmsweb, HG1103a, FILEMOVER_20110302_slc5_amd64_gcc434_v3, FILEMOVER_20110302_slc5_amd64_gcc434_v2, FILEMOVER_20110302_slc5_amd64_gcc434, FILEMOVER_20110301_slc5_amd64_gcc434, builder_2011-02-28_14-23-32_wmagent, TW20110228a, CmsTC_0_0_4, WMCORE_0_6_12, CmsTC_0_0_3, CmsTC_0_0_2, TW20110210a, FILEMOVER_20110210_slc5_amd64_gcc434, builder_2011-02-09_14-27-53_crab-server, builder_2011-02-08_23-13-23_cmsweb, HG1102d, TW20110209a, TW20110208a, builder_2011-02-08_07-34-50_cmsweb, HG1102c, TW20110207c, TW20110207b, TW20110207a, TW20110204a, builder_2011-02-03_23-45-44_CmsTC, builder_2011-02-03_19-04-46_PHEDEX-combined-agents, builder_2011-02-02_21-14-00_cmsweb, builder_2011-02-02_16-24-27_T0Mon, TW20110202c, TW20110202b, TW20110202a, TW20110201a, builder_2011-02-01_18-11-58_cmsweb, builder_2011-01-31_16-44-33_dbs-client, builder_2011-01-31_15-26-15_T0DataSvc, TW20110128a, builder_2011-01-25_14-26-56_cmsweb, builder_2011-01-20_18-59-54_cmsweb, HG1102b, WMAGENT_0_6_9, TW20110117d, TW20110117c, TW20110117b, TW20110117a, TW20110116b, TW20110116a, TW20110106a, WMAGENT_0_6_8, WMAGENT_0_6_7, FILEMOVER_20110111_slc5_amd64_gcc434_v3, builder_2011-01-11_18-44-26_das, FILEMOVER_20110111_slc5_amd64_gcc434_v2, FILEMOVER_20110111_slc5_amd64_gcc434, builder_2011-01-07_19-51-48_wmagent, TW20110107a, tw20110106a, FILEMOVER_20101219_slc5_amd64_gcc434, FILEMOVER_20101217_slc5_amd64_gcc434_v4, FILEMOVER_20101217_slc5_amd64_gcc434_v3, FILEMOVER_20101217_slc5_amd64_gcc434_v2, FILEMOVER_20101217_slc5_amd64_gcc434, FILEMOVER_20101216_slc5_amd64_gcc434, FILEMOVER_20101215_slc5_amd64_gcc434_v3, builder_2010-12-15_18-43-30_dbs-web, DD_20101215_slc5_amd64_gcc434_v2, FILEMOVER_20101215_slc5_amd64_gcc434_v2, DD_20101215_slc5_amd64_gcc434, DD_20101214_slc5_amd64_gcc434, WMAGENT_0_6_3, builder_2010-12-07_11-03-17_dbs3, DD_20101206_slc5_amd64_gcc434, builder_2010-12-06_12-51-53_wmagent, builder_2010-12-06_12-09-48_wmagent, builder_2010-12-06_11-15-04_cmsweb, builder_2010-12-06_11-04-10_base, HG1102a, WMAGENT_0_6_2, builder_2010-12-03_12-25-37_wmagent, builder_2010-12-02_16-48-32_T0Mon, WMAGENT_0_6_0, builder_2010-12-01_12-37-20_das, builder_2010-11-22_10-12-52_cmsweb, builder_2010-11-22_09-56-39_base, builder_2010-11-21_19-58-50_cmsweb, HG1012b, builder_2010-11-19_02-05-02_reqmgr, DD_20101118_slc5_amd64_gcc434, builder_2010-11-18_15-59-24_plotfairy, builder_2010-11-16_21-02-45_fmws, DD_20101116_slc5_amd64_gcc434, builder_2010-11-15_13-43-19_cmsweb, builder_2010-11-15_13-30-17_base, HG1012a, builder_2010-10-26_11-57-34_cmsweb, HG1010b, builder_2010-10-14_21-05-56_dbs-web, builder_2010-10-14_19-27-10_cmsweb, builder_2010-10-14_16-43-12_dbs-web, DD_20101014_slc5_amd64_gcc434, builder_2010-10-14_13-05-47_cmsweb, builder_2010-10-13_22-48-08_cmsweb, builder_2010-10-13_17-02-42_dbs-web, DD_20101013_slc5_amd64_gcc434, builder_2010-10-13_13-04-14_dbs-apps, builder_2010-10-13_12-53-04_dbs-web, builder_2010-10-13_11-09-00_base, builder_2010-10-12_18-32-05_base, HG1010a, builder_2010-10-11_18-46-10_base, HG1010pre4, HG1010pre3, DD_20101007_slc5_amd64_gcc434, HG1010pre2, HG1010pre1, HG1009c, builder_2010-09-15_18-10-44_dbs-apps, HG1009b, HG1009a, dg-base-rev21, dg-base-rev20, dg-base-rev19, dg-base-rev18, DD_20100824_slc5_amd64_gcc434_v1, DD_20100824_slc5_amd64_gcc434, dg-base-rev17, FRONTEND_CONF_3_30_20100724, FRONTEND_CONF_3_29_20100723, dg-base-rev16, ge20100722-rpm-osx-64-bit, builder2010_07_08_1278582827-dbs-server, builder2010_07_08_1278582199-dbs-server, dg-base-rev15, ge20100621-bootstrap-rpm-4-8-macosx, dg20100617-dbs, dg20100617-dd, DD_20100615_slc5_amd64_gcc434, ge20100611-apt-rpm-4-8-gcc-4-5-0, MotT0_1_0_15, dg20100609-dd, MotT0_1_0_14, DD_20100609_slc5_amd64_gcc434, dg20100608-dd, dg20100608-dbs, MotT0_1_0_13, DD_20100607_slc5_amd64_gcc434, MotT0_1_0_12, MotT0_1_0_11, MotT0_1_0_10, MotT0_1_0_9, dg-base-rev14, MotT0_1_0_8, MotT0_1_0_6, MotT0_1_0_5, MotT0_1_0_4, MotT0_1_0_3, dg20100526-dd, dg-base-rev13, DD_20100525_slc5_amd64_gcc434, ge20100521b-new-rpm, dg20100521-dbs, ge20100521-new-rpm, DBS_20100520_slc5_amd64_gcc434, ge20100519-new-apt, dg20100504-dd, dg20100504-dbs, DD_20100503_slc5_amd64_gcc434, DBS_20100503_slc5_amd64_gcc434, ge20100427-rpm-on-linux, dg-base-rev12, ge20100422-rpm-4-8-0, dg20100416-dbs, dg-base-rev11, dg-base-rev10, dg-base-rev9, dg20100401-dbs, dg-base-rev8, DAS_20100302_slc5_amd64_gcc434, dg-base-rev7, dg20100226-dbs, dg-base-rev6, DBS_20100226_slc5_amd64_gcc434, DBS_20100217_slc5_amd64_gcc434, FILEMOVER_20100217_slc5_amd64_gcc434, FRONTEND_CONF_3_24_20100217, DAS_20100217_slc5_amd64_gcc434, DAS_20100216b_slc5_amd64_gcc434, DAS_20100216_slc5_amd64_gcc434, T0Mon_100204_2, dg20100201-dbs3, FILEMOVER_20100201_slc5_amd64_gcc434, FILEMOVER_20100128b_slc5_amd64_gcc434, dg20100129-dbs3, dg20100128-dbs3, FILEMOVER_20100128_slc5_amd64_gcc434, DAS_20100127_slc5_amd64_gcc434, DAS_20100126_slc5_amd64_gcc434, DBS-APP_20100122_slc4, FILEMOVER_20100122_slc5_amd64_gcc434, DBS-APP_20100121_slc4, DBS-WEB_20100120_slc4, DBS-APP_20100120_slc4, DAS_20100119_slc5_amd64_gcc434, DBS-APP_20100118_slc4, DBS-WEB_20100118_slc4, DAS_20100115_slc5_amd64_gcc434, dg20100115-security, DBS_20100115_slc5_amd64_gcc434, DBS-APP_20100114_slc4, DBS-WEB_20100113_slc4, dg20100112-security, DBS_20100112_slc5_amd64_gcc434, DBS_20100111_slc5_amd64_gcc434, dg20100111-security, dg20100107b-wmcore, dg20100107-wmcore, DAS_20100105_slc5_amd64_gcc434, DAS_20091221_slc5_amd64_gcc434, DAS_20091214_slc5_amd64_gcc434, dg20091211-couchdb, dg20091210-phedex, dg20091203c-comp-base, DD_20091208_slc5_amd64_gcc434, DAS_20091208_slc5_amd64_gcc434, FILEMOVER_20091208_slc5_amd64_gcc434, DBS_20091208_slc5_amd64_gcc434, dg20091203b-comp-base, dg20091203-comp-base, DQMCATTEST_0_0_1, FILEMOVER_20091118, DBS-APPS_20090929, DAS_20091117, BUILDBOT_01, CERNOIDv02, DBS-WEB_20091021, CouchDB_0_10_0, CERNOIDv01, WMCORE-before-refactor, DBS-WEB_20091012, PerfSuiteDB_20090930, DBS-WEB_20090921, PerfSuiteDB_20090916, FILEMOVER_20090910, PerfSuiteDB_20090904_almost_stable, DBS-WEB_20090817, PerfSuiteDB_20090904, FILEMOVER_20090828, PerfSuiteDB_20090901, DBS-APPS_20090706, forHEARTBEATr04, RPMVERIFY_0_2, forHEARTBEATr01, WEBTOOLS_APPS_20090817, DBS-APPS_20090804, DBS-APPS_20090730, HEAD
Changes since 1.11:	+4 -4 lines
Log Message:	Comment out VO_CMS_SW_DIR check since this package can be installed separetly from CMSSW.
#	Content
1	### RPM external mysql-deployment 0.0.3
2
3	Source: mysql-deployment.sh
4	Requires: mysql
5	# Let's fake the fact that we have perl (DBI) so that rpm does not complain.
6	Provides: mysql-deployment.sh
7
8	%prep
9	mkdir -p %{i}/bin
10	cat << \EOF > %{i}/bin/mysql-deployment.sh
11	#!/bin/bash
12	set -e
13
14	#if [ -z ${VO_CMS_SW_DIR} ]; then
15	# echo "+++ Your CMS environment is not setup, missing VO_CMS_SW_DIR environment"
16	# exit 1
17	#fi
18	if [ -z ${MYSQL_ROOT} ]; then
19	echo "+++ Your CMS MYSQL environment is not setup, MYSQL_ROOT environment"
20	exit 1
21	fi
22	MYSQL_PATH=$MYSQL_ROOT/mysqldb
23	if [ ! -d ${MYSQL_PATH} ]; then
24	echo "+++ Making ${MYSQL_PATH} directory ..."
25	mkdir -p ${MYSQL_PATH}
26	fi
27	MYSQL_PORT=3316
28	MYSQL_SOCK=$MYSQL_PATH/mysql.sock
29	MYSQL_PID=$MYSQL_PATH/mysqld.pid
30	MYSQL_ERR=$MYSQL_PATH/error.log
31
32	pid=`ps -w -w -f -u ${LOGNAME} \| grep mysqld_safe \| grep $MYSQL_PORT \| grep -v grep \| tail -1 \| awk '{print $1}'`
33	if [ ! -z ${pid} ]; then
34	echo "CMS MySQL server is already running ..."
35	else
36	# may use --skip-networking for pure local MySQL
37
38	if [ ! -d $MYSQL_ROOT/mysqldb/mysql ]; then
39	echo "+++ Installing CMS MySQL accounts and DBs ..."
40	$MYSQL_ROOT/bin/mysql_install_db --datadir=$MYSQL_PATH --port=$MYSQL_PORT --socket=$MYSQL_SOCK
41
42	echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..."
43	$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \
44	--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID &
45
46	sleep 10
47	# create CMS MySQL root account
48	echo "+++ Creating MySQL default root account ..."
49	echo "+++ Account for localhost"
50	$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root password "cms"
51	echo "+++ Account for `hostname`"
52	$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms"
53
54	# create CMS MySQL DBS account
55	echo "+++ Creating MySQL default dbs account ..."
56	$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "CREATE USER dbs@localhost IDENTIFIED BY 'cmsdbs';"
57	$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "UPDATE user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y' where User='dbs';"
58	else
59	echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..."
60	$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \
61	--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID &
62	sleep 10
63	fi
64	fi
65
66	EOF
67	chmod a+x %{i}/bin/mysql-deployment.sh
68
69	%build
70
71	%install
72	#cp /tmp/mysql-deployment.sh %{i}/bin
73	#cp %{i}/mysql-deployment.sh $RPM_SOURCE_DIR
74
75	%post
76	%{relocateConfig}/bin/mysql-deployment.sh
77