Changeset 775


Ignore:
Timestamp:
03/29/13 14:10:23 (11 years ago)
Author:
ramonb
Message:

jobarchived/jobarchived.conf:

  • added USER/PASSWORD for SQL

jobarchived/job_dbase.sql:

  • changed job primary key to varchar, due to job array ids
Location:
branches/0.4/jobarchived
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/0.4/jobarchived/job_dbase.sql

    r276 r775  
    44
    55CREATE TABLE jobs (
    6         job_id                  INT NOT NULL UNIQUE PRIMARY KEY,
     6        job_id                  VARCHAR(20) NOT NULL UNIQUE PRIMARY KEY,
    77        job_name                VARCHAR(100),
    88        job_queue               VARCHAR(50),
     
    2323
    2424CREATE TABLE job_nodes (
    25         job_id                  INT NOT NULL REFERENCES jobs ON DELETE CASCADE,
     25        job_id                  VARCHAR(20) NOT NULL REFERENCES jobs ON DELETE CASCADE,
    2626        node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
    2727        PRIMARY KEY ( job_id, node_id )
    2828);
    2929
    30 CREATE USER root;
    31 CREATE USER "www-data";
     30# modify me: set a password
     31#CREATE USER jobarchive WITH PASSWORD '';
    3232
    33 GRANT ALL ON jobs,nodes,job_nodes TO root,"www-data";
    34 GRANT ALL ON nodes_node_id_seq TO root,"www-data";
     33GRANT ALL ON jobs,nodes,job_nodes TO "jobarchive";
     34GRANT ALL ON nodes_node_id_seq TO "jobarchive";
  • branches/0.4/jobarchived/jobarchived.conf

    r771 r775  
    22# Wether or not to run as a daemon in background
    33#
    4 DAEMONIZE                       : 1
     4DAEMONIZE                       : 0
    55
    66# Specify debugging level here (only when _not_ DAEMONIZE)
     
    1616# default: 0
    1717#
    18 DEBUG_LEVEL                     : 0
     18DEBUG_LEVEL                     : 1
    1919
    2020# Enable logging to syslog?
     
    5151# Syntax: [ "<clustername>", "<clustername>" ]
    5252#
    53 ARCHIVE_DATASOURCES             : "My Cluster"
     53ARCHIVE_DATASOURCES             : [ "My Cluster" ]
    5454
    5555# Amount of hours to store in one single archived rrd
     
    6969# Where to store the archived rrd's
    7070#
    71 ARCHIVE_PATH                    : /var/lib/jobarch
     71ARCHIVE_PATH                    : /data/jobarch
    7272
    7373# Archive's SQL dbase to use
     
    7676#
    7777JOB_SQL_DBASE                   : localhost/jobarchive
     78JOB_SQL_USER            : jobarchive
     79
     80#JOB_SQL_PASSWORD        :
    7881
    7982# Timeout for jobs in archive
Note: See TracChangeset for help on using the changeset viewer.