Changeset 10311


Ignore:
Timestamp:
2005-07-26T12:02:55+12:00 (19 years ago)
Author:
kjdon
Message:

added passwords for mysql root, gsdl3admin and gsdl3reader users and removed the anonymous user

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/gsdl3/build.xml

    r10301 r10311  
    367367  </target>
    368368 
     369  <target name="setup-mysql-root-password" depends="init,init-mysql-vars" if="mysql.islocal">
     370     <condition property="ask.root.password">
     371      <or>
     372    <not>
     373      <isset property="mysql.root.password"/>
     374    </not>
     375    <equals arg1="" arg2="${mysql.root.password}"/>
     376      </or>
     377    </condition>
     378    <getuserandpassword message="Please specify a password for the root mysql user: this is to secure your database." if="ask.root.password" username="root" pwordproperty="mysql.root.password"/>
     379  </target>
     380  <target name="setup-mysql-gsdl3-passwords" depends="init">
     381    <condition property="ask.admin.password">
     382      <or>
     383    <not>
     384      <isset property="mysql.admin.password"/>
     385    </not>
     386    <equals arg1="" arg2="${mysql.admin.password}"/>
     387      </or>
     388    </condition>
     389     <condition property="ask.reader.password">
     390      <or>
     391    <not>
     392      <isset property="mysql.reader.password"/>
     393    </not>
     394    <equals arg1="" arg2="${mysql.reader.password}"/>
     395      </or>
     396    </condition>
     397    <getuserandpassword message="Please specify a password for the gsdl3admin mysql user: this is used by greenstone" if="ask.admin.password" username="gsdl3admin" pwordproperty="mysql.admin.password"/>
     398     <getuserandpassword message="Please specify a password for the gsdl3reader mysql user: this is used by greenstone" if="ask.reader.password" username="gsdl3reader" pwordproperty="mysql.reader.password"/>
     399 </target>
     400   
    369401 <!-- ========== Web app Targets ================================ -->
    370402 
    … …  
    408440  </target>
    409441 
    410   <target name="configure-web" depends="init"
     442  <target name="configure-web" depends="init,setup-mysql-gsdl3-passwords"
    411443    description="Configure only the web app config files">
    412444    <filter token="gsdl3home" value="${web.home}"/>
    413445    <filter token="mysql.port" value="${mysql.port}"/>
    414446    <filter token="mysql.server" value="${mysql.server}"/>
    415      <!-- need to prompt for passwords -->
    416     <filter token="mysql.admin.pword" value="greenstone"/>
    417     <filter token="mysql.reader.pword" value="greenstone"/>
    418     <copy file="${basedir}/resources/java/global.properties.in" tofile="${web.classes}/global.properties" filtering="true" overwrite="true"/> 
     447    <filter token="mysql.admin.pword" value="${mysql.admin.password}"/>
     448    <filter token="mysql.reader.pword" value="${mysql.reader.password}"/>
     449    <filter token="tomcat.server" value="${tomcat.server}"/>
     450    <filter token="tomcat.port" value="${tomcat.port}"/>
     451    <copy file="${basedir}/resources/java/global.properties.in" tofile="${web.classes}/global.properties" filtering="true" overwrite="true"/>
     452    <chmod file="${web.classes}/global.properties" perm="600"/>
    419453  </target>
    420454
    … …  
    573607
    574608  <!-- this is one target that we only want to run once. -->
    575   <target name="prepare-mysql" depends="init,init-mysql-vars,install-mysql,start-mysql,setup-mysql,stop-mysql"/>
     609  <target name="prepare-mysql" depends="init,init-mysql-vars,install-mysql,start-mysql-for-setup,setup-mysql,stop-mysql"/>
    576610
    577611  <target name="init-mysql-vars">
    … …  
    670704  <!-- is this just linux or both??. also we probably need to do this for external mysql -->
    671705  <!-- had unless mysql.present -->
    672   <target name="setup-mysql" depends="init,init-mysql-vars" if="mysql.islocal">
     706  <target name="setup-mysql" depends="init,init-mysql-vars,setup-mysql-root-password,setup-mysql-gsdl3-passwords" if="mysql.islocal">
     707    <!-- setup the gsdl3 mysql users -->
    673708    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
    674709      <arg value="--user=root"/>
    675       <arg value="--execute=GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@localhost;"/>
     710      <arg value="--execute=GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@localhost identified by 'greenstone';"/>
    676711    </exec>
    677712    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
    678713      <arg value="--user=root"/>
    679       <arg value="--execute=GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@'%'"/>
     714      <arg value="--execute=GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@'%';"/>
    680715    </exec>
    681716    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
    682717      <arg value="--user=root"/>
    683       <arg value="--execute=GRANT SELECT ON *.* TO gsdl3reader@localhost;"/>
    684     </exec>
     718      <arg value="--execute=GRANT SELECT ON *.* TO gsdl3reader@localhost identified by 'greenstone';"/>
     719    </exec>
     720    <!-- load in the demo collection database -->
    685721    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
    686722      <arg value="--user=root"/>
    … …  
    692728      <arg value="localsite_gs3mgdemo"/>
    693729    </exec>
     730    <!-- remove the anonymous user -->
     731    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
     732      <arg value="--user=root"/>
     733      <arg value="--execute=delete from mysql.user where Host='localhost' and User='';"/>
     734    </exec>
     735    <!-- finally, set the root password -->
     736     <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}">
     737      <arg value="--user=root"/>
     738      <arg value="--execute=set password for 'root'@'localhost' = PASSWORD('${mysql.root.password}'); flush privileges; "/>
     739    </exec>
    694740  </target>
    695741 
    696   <target name="start-mysql" depends="init,init-mysql-vars" if="mysql.islocal"
    697     description="Startup only mysql">
     742<!-- this one used initially for setup -->
     743  <target name="start-mysql-for-setup" depends="init,init-mysql-vars" if="mysql.islocal">
    698744    <exec executable="${mysql.home}/bin/mysqld_safe" dir="${mysql.home}"
    699745      spawn="true" os="${os.linux},${os.mac}">
    700       <arg value="--user=root"/>
    701746      <arg value="--datadir=./data"/>
    702747      <arg value="--basedir=."/>
    703748      <arg value="--pid_file=gsdl3.pid"/>
    704749      <arg value="--socket=/tmp/mysql.sock"/>
     750      <arg value="--port=${mysql.port}"/>
    705751      <arg value="--err-log=./var/log/mysql.log"/>
    706752    </exec>
    … …  
    709755    <sleep seconds="2"/>
    710756    <!-- need to test that the server has started up -->   
    711     <echo>testing mysql server</echo>
    712757    <exec executable="${mysql.home}/bin/mysql" dir="${mysql.home}"
    713758      failonerror="true" outputproperty="throw.away">
    … …  
    715760      <arg value="--execute=show databases;"/>
    716761    </exec>
    717     <echo>MYSQL database server started successfully</echo>
     762  </target>
     763
     764  <target name="start-mysql" depends="init,init-mysql-vars" if="mysql.islocal"
     765    description="Startup only mysql">
     766    <echo>Starting up the mysql server</echo>
     767    <exec executable="${mysql.home}/bin/mysqld_safe" dir="${mysql.home}"
     768      spawn="true" os="${os.linux},${os.mac}">
     769      <arg value="--datadir=./data"/>
     770      <arg value="--basedir=."/>
     771      <arg value="--pid_file=gsdl3.pid"/>
     772      <arg value="--socket=/tmp/mysql.sock"/>
     773      <arg value="--port=${mysql.port}"/>
     774      <arg value="--err-log=./var/log/mysql.log"/>
     775    </exec>
     776   <exec executable="${mysql.home}/bin/mysqld" dir="${mysql.home}" spawn="true" os="${os.windows}">
     777    </exec>
     778    <sleep seconds="2"/>
    718779  </target>
    719780
    720781    <target name="stop-mysql" depends="init" if="mysql.islocal"
    721782    description="Shutdown only mysql">
     783    <echo>Shutting down the mysql server. At the prompt, enter the mysql root password.</echo>
    722784    <exec executable="${mysql.home}/bin/mysqladmin" dir="${mysql.home}"
    723785      failonerror="true" os="${os.linux},{os.mac}">
    724786      <arg value="--user=root"/>
     787      <arg value="-p"/>
    725788      <arg value="--socket=/tmp/mysql.sock"/>
    726789      <arg value="shutdown"/>
    … …  
    729792      failonerror="true" os="${os.windows}">
    730793      <arg value="--user=root"/>
     794      <arg value="-p"/>
    731795      <arg value="shutdown"/>
    732796    </exec>
Note: See TracChangeset for help on using the changeset viewer.