This is a very large commit from Rodrigo Lazo (rlazo) for Google SoC This is the latest patch on the job execution series. As far as I could test it, now scire should be able to create, distribute, execute and gather the output of a job with the new models. Also the jobs register their status on the database (pending, downloaded, running, failed, finished or cancelled). So now all the backend code needed to "watch" a job is on its place. Right now a job gets executed but dies on the post processing stage (at least that is what I understand from the error message) Just move the GACL_functions.py from server/ to server/modules and apply this patch and you'll how myltiple entries are created for each member of the group in jobs_clients and on job_history. I've take some precautions regarding concurrency adding some locks, I'm not sure they are enough so please comment on that
adding seed data for the jobs and scripts sequences.
added sequences for jobs and scripts. make jobs and scripts not auto_increment anymore. this will require those who have the tables made to drop and rebuild.
changing the dyn_tags table to use scriptid instead of jobid fixing up the script creation section. still a work in progress.
adding back in the sequences DB code adding in some code that will hopefully allow clients to once-again be inserted.
adding changes from Rodrigo Lazo (rlazo) for Google SoC: modified add_job.php to make use of the new scheduling logic, plus other minor changes
adding a patch from rlazo to fix the scripts sample row was missing return_output
adding a comma
adding a default set of statuses from Rodrigo Lazo. changed the clients lines and jobs lines to use the statusid's instead of the words.
forgot to include additional patch from Rodrigo Lazo for SoC. this adds an additional client_status table similar to jobs_status, to save space and be more efficient.
committing some changes from Rodrigo Lazo for google SoC: fixed some typo errors
adding some lines to the sample seed data. removing old doc.
updating all the seed data values with the latest from a DB dump from my box. this adds a bunch of UI permissions I had been working on. it also cleans up the index numbers (start at reasonable values) added in insert lines for the sequences that are commented out the sequences don't appear to be needed currently, but may be necessary for oracle or other DBs without GET_LAST_INSERT_ID
bring the seed data a bit more up to date. permissions now sync'd with the phpgacl_seed data. clients and scripts updated.
removed clientid from job_conditions. changed run_interval to run_schedule added return_output to scripts table. will help with post-processing. added a few drop table if exists lines to the phpgacl code. added commented-out sequences should they prove necessary.
Flow charts for the current status of the jobs subroutines.
some larger structural changes here. userid, clientid, and permid are no-longer auto_increment values they instead will take their IDs from the gacl ids assigned. this makes linking between the tables much easier since the ids will always be the same. (no more lookups) also adding a bare_scire.sql file with a minimal setup this combines scire.sql and scire2.sql
adding sample scire.conf file for backend server use added initial phpgacl_seed file.
adding in default phpgacl db creation so as to avoid having those stupid setup.php pages.
updating the database schemas. the additions may be temporary tables.
removing old html and templates directories so they don't confuse adding screenshots for the user tour.
dunno what changed here but it must be better than it used to be!
adding proposed dyn_tags table. this is just an idea not sure how it'll actually end up
updating schema for last_run in jobs_conditions and adding recommended perm,priority to scripts revised sample sql as well.
updating sample sql with new meaning of status field in the clients table
adding in the permcategory line.
just adding more sample lines.
don't print cert digest in client
various updates around the board. mainly focusing on client and user pages. some DB updates and asthetic changes. preparing for user sessions
updated some scire database interface files fixed some queries fixed the exporter pages (as useless as they are now).
adding sample DB entries
updating svn with current copy from wiki
still totally a work in progress but here's an updated db design
forgot client key
adding first pass, working off of what codeman already has, will need much more thought though, since db structure is going to be a pain to change
update to moria.sql. add a svnignore to the templates directory for templates_c
add scire sql for sessions table
adding little doc I wrote on the train home
rename moria/ to docs/
adding a few documents to moria since that seems like a good place to put them
Adding current state of my webserver GIMLI directory includes phpGACL code and smarty, both of which are necessary to install. nothing works either without the database
|Powered by ViewVC 1.1.20|