Changeset 905


Ignore:
Timestamp:
05/22/13 15:30:27 (11 years ago)
Author:
ramonb
Message:

jobarchived/job_dbase.sql:

  • changed to CREATE user and ALTER password: so that create may fail (if user exists) and password upate still succeeds

pkg/rpm/jobmonarch.spec.in, debian/jobmonarch.postinst:

  • changed CREATE to ALTER
Location:
branches/1.0
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/1.0/debian/jobmonarch.postinst

    r896 r905  
    1212    export DB_PASSWD=$(tr -dc A-Za-z0-9_< /dev/urandom |head -c 8 | xargs)
    1313    # Set the password in the SQL script
    14     sed -i -e '/^.*modify me:.*$/d' -e 's/^-- CREATE/CREATE/g' -e "s/'';/'$DB_PASSWD';/g" %{_datadir}/jobarchived/job_dbase.sql
     14    sed -i -e '/^.*modify me:.*$/d' -e 's/^-- ALTER/ALTER/g' -e "s/'';/'$DB_PASSWD';/g" %{_datadir}/jobarchived/job_dbase.sql
    1515    # Set the password in the jobarchived config.
    1616    sed -i -e "s/^#JOB_SQL_PASSWORD.*$/JOB_SQL_PASSWORD\t\t: $DB_PASSWD/g" %{_sysconfdir}/jobarchived.conf
  • branches/1.0/jobarchived/job_dbase.sql

    r860 r905  
    1 DROP TABLE jobs CASCADE;
    2 DROP TABLE nodes CASCADE;
    3 DROP TABLE job_nodes CASCADE;
    4 
    51CREATE TABLE jobs (
    62        job_id                  VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY,
     
    2824);
    2925
     26CREATE USER jobarchive;
     27
    3028-- modify me: set a password
    31 -- CREATE USER jobarchive WITH PASSWORD '';
     29-- ALTER USER jobarchive WITH PASSWORD '';
    3230
    3331GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive";
  • branches/1.0/pkg/rpm/jobmonarch.spec.in

    r899 r905  
    145145    export DB_PASSWD=$(tr -dc A-Za-z0-9_< /dev/urandom |head -c 8 | xargs)
    146146    # Set the password in the SQL script
    147     sed -i -e '/^.*modify me:.*$/d' -e 's/^-- CREATE/CREATE/g' -e "s/'';/'$DB_PASSWD';/g" %{_datadir}/jobarchived/job_dbase.sql
     147    sed -i -e '/^.*modify me:.*$/d' -e 's/^-- ALTER/ALTER/g' -e "s/'';/'$DB_PASSWD';/g" %{_datadir}/jobarchived/job_dbase.sql
    148148    # Set the password in the jobarchived config.
    149149    sed -i -e "s/^#JOB_SQL_PASSWORD.*$/JOB_SQL_PASSWORD\t\t: $DB_PASSWD/g" %{_sysconfdir}/jobarchived.conf
Note: See TracChangeset for help on using the changeset viewer.