X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fdird%2Fua_update.c;h=d430fda8cf50d64672f8df681c7eb85fad224f54;hb=a80e5ce0c2e9476c9ce7d8a641b6f3e56f5d3735;hp=5e2688c38dd5d20cec84775d199c452e08ad5ed7;hpb=cef1abc9d2270574d09e1e86de2ffb46615b809e;p=bacula%2Fbacula diff --git a/bacula/src/dird/ua_update.c b/bacula/src/dird/ua_update.c index 5e2688c38d..d430fda8cf 100644 --- a/bacula/src/dird/ua_update.c +++ b/bacula/src/dird/ua_update.c @@ -1,23 +1,14 @@ -/* - * - * Bacula Director -- Update command processing - * Split from ua_cmds.c March 2005 - * - * Kern Sibbald, September MM - * - * Version $Id$ - */ /* Bacula® - The Network Backup Solution - Copyright (C) 2000-2006 Free Software Foundation Europe e.V. + Copyright (C) 2000-2009 Free Software Foundation Europe e.V. The main author of Bacula is Kern Sibbald, with contributions from many others, a complete list can be found in the file AUTHORS. This program is Free Software; you can redistribute it and/or modify it under the terms of version two of the GNU General Public - License as published by the Free Software Foundation plus additions - that are listed in the file LICENSE. + License as published by the Free Software Foundation and included + in the file LICENSE. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of @@ -29,11 +20,20 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. - Bacula® is a registered trademark of John Walker. + Bacula® is a registered trademark of Kern Sibbald. The licensor of Bacula is the Free Software Foundation Europe (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zürich, Switzerland, email:ftf@fsfeurope.org. */ +/* + * + * Bacula Director -- Update command processing + * Split from ua_cmds.c March 2005 + * + * Kern Sibbald, September MM + * + * Version $Id$ + */ #include "bacula.h" #include "dird.h" @@ -41,6 +41,8 @@ /* Forward referenced functions */ static int update_volume(UAContext *ua); static bool update_pool(UAContext *ua); +static bool update_job(UAContext *ua); +static bool update_stats(UAContext *ua); /* * Update a Pool Record in the database. @@ -52,6 +54,8 @@ static bool update_pool(UAContext *ua); * changes pool info for volume * update slots [scan=...] * updates autochanger slots + * update stats [days=...] + * updates long term statistics */ int update_cmd(UAContext *ua, const char *cmd) { @@ -60,6 +64,9 @@ int update_cmd(UAContext *ua, const char *cmd) NT_("volume"), /* 1 */ NT_("pool"), /* 2 */ NT_("slots"), /* 3 */ + NT_("slot"), /* 4 */ + NT_("jobid"), /* 5 */ + NT_("stats"), /* 6 */ NULL}; if (!open_client_db(ua)) { @@ -75,8 +82,15 @@ int update_cmd(UAContext *ua, const char *cmd) update_pool(ua); return 1; case 3: + case 4: update_slots(ua); return 1; + case 5: + update_job(ua); + return 1; + case 6: + update_stats(ua); + return 1; default: break; } @@ -85,6 +99,7 @@ int update_cmd(UAContext *ua, const char *cmd) add_prompt(ua, _("Volume parameters")); add_prompt(ua, _("Pool from resource")); add_prompt(ua, _("Slots from autochanger")); + add_prompt(ua, _("Long term statistics")); switch (do_prompt(ua, _("item"), _("Choose catalog item to update"), NULL, 0)) { case 0: update_volume(ua); @@ -95,6 +110,9 @@ int update_cmd(UAContext *ua, const char *cmd) case 2: update_slots(ua); break; + case 3: + update_stats(ua); + break; default: break; } @@ -125,16 +143,16 @@ static void update_volstatus(UAContext *ua, const char *val, MEDIA_DBR *mr) } } if (!found) { - bsendmsg(ua, _("Invalid VolStatus specified: %s\n"), val); + ua->error_msg(_("Invalid VolStatus specified: %s\n"), val); } else { char ed1[50]; bstrncpy(mr->VolStatus, kw[i], sizeof(mr->VolStatus)); Mmsg(query, "UPDATE Media SET VolStatus='%s' WHERE MediaId=%s", mr->VolStatus, edit_int64(mr->MediaId,ed1)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Volume status is: %s\n"), mr->VolStatus); + ua->info_msg(_("New Volume status is: %s\n"), mr->VolStatus); } } } @@ -144,15 +162,15 @@ static void update_volretention(UAContext *ua, char *val, MEDIA_DBR *mr) char ed1[150], ed2[50]; POOL_MEM query(PM_MESSAGE); if (!duration_to_utime(val, &mr->VolRetention)) { - bsendmsg(ua, _("Invalid retention period specified: %s\n"), val); + ua->error_msg(_("Invalid retention period specified: %s\n"), val); return; } Mmsg(query, "UPDATE Media SET VolRetention=%s WHERE MediaId=%s", edit_uint64(mr->VolRetention, ed1), edit_int64(mr->MediaId,ed2)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New retention period is: %s\n"), + ua->info_msg(_("New retention period is: %s\n"), edit_utime(mr->VolRetention, ed1, sizeof(ed1))); } } @@ -163,15 +181,15 @@ static void update_voluseduration(UAContext *ua, char *val, MEDIA_DBR *mr) POOL_MEM query(PM_MESSAGE); if (!duration_to_utime(val, &mr->VolUseDuration)) { - bsendmsg(ua, _("Invalid use duration specified: %s\n"), val); + ua->error_msg(_("Invalid use duration specified: %s\n"), val); return; } Mmsg(query, "UPDATE Media SET VolUseDuration=%s WHERE MediaId=%s", edit_uint64(mr->VolUseDuration, ed1), edit_int64(mr->MediaId,ed2)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New use duration is: %s\n"), + ua->info_msg(_("New use duration is: %s\n"), edit_utime(mr->VolUseDuration, ed1, sizeof(ed1))); } } @@ -183,9 +201,9 @@ static void update_volmaxjobs(UAContext *ua, char *val, MEDIA_DBR *mr) Mmsg(query, "UPDATE Media SET MaxVolJobs=%s WHERE MediaId=%s", val, edit_int64(mr->MediaId,ed1)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New max jobs is: %s\n"), val); + ua->info_msg(_("New max jobs is: %s\n"), val); } } @@ -196,9 +214,9 @@ static void update_volmaxfiles(UAContext *ua, char *val, MEDIA_DBR *mr) Mmsg(query, "UPDATE Media SET MaxVolFiles=%s WHERE MediaId=%s", val, edit_int64(mr->MediaId, ed1)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New max files is: %s\n"), val); + ua->info_msg(_("New max files is: %s\n"), val); } } @@ -209,15 +227,15 @@ static void update_volmaxbytes(UAContext *ua, char *val, MEDIA_DBR *mr) POOL_MEM query(PM_MESSAGE); if (!size_to_uint64(val, strlen(val), &maxbytes)) { - bsendmsg(ua, _("Invalid max. bytes specification: %s\n"), val); + ua->error_msg(_("Invalid max. bytes specification: %s\n"), val); return; } Mmsg(query, "UPDATE Media SET MaxVolBytes=%s WHERE MediaId=%s", edit_uint64(maxbytes, ed1), edit_int64(mr->MediaId, ed2)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Max bytes is: %s\n"), edit_uint64(maxbytes, ed1)); + ua->info_msg(_("New Max bytes is: %s\n"), edit_uint64(maxbytes, ed1)); } } @@ -228,16 +246,16 @@ static void update_volrecycle(UAContext *ua, char *val, MEDIA_DBR *mr) POOL_MEM query(PM_MESSAGE); if (!is_yesno(val, &recycle)) { - bsendmsg(ua, _("Invalid value. It must be yes or no.\n")); + ua->error_msg(_("Invalid value. It must be yes or no.\n")); return; } Mmsg(query, "UPDATE Media SET Recycle=%d WHERE MediaId=%s", recycle, edit_int64(mr->MediaId, ed1)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Recycle flag is: %s\n"), - mr->Recycle==1?_("yes"):_("no")); + ua->info_msg(_("New Recycle flag is: %s\n"), + recycle==1?_("yes"):_("no")); } } @@ -248,16 +266,16 @@ static void update_volinchanger(UAContext *ua, char *val, MEDIA_DBR *mr) POOL_MEM query(PM_MESSAGE); if (!is_yesno(val, &InChanger)) { - bsendmsg(ua, _("Invalid value. It must be yes or no.\n")); + ua->error_msg(_("Invalid value. It must be yes or no.\n")); return; } Mmsg(query, "UPDATE Media SET InChanger=%d WHERE MediaId=%s", InChanger, edit_int64(mr->MediaId, ed1)); if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New InChanger flag is: %s\n"), - mr->InChanger==1?_("yes"):_("no")); + ua->info_msg(_("New InChanger flag is: %s\n"), + InChanger==1?_("yes"):_("no")); } } @@ -269,12 +287,12 @@ static void update_volslot(UAContext *ua, char *val, MEDIA_DBR *mr) memset(&pr, 0, sizeof(POOL_DBR)); pr.PoolId = mr->PoolId; if (!db_get_pool_record(ua->jcr, ua->db, &pr)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); return; } mr->Slot = atoi(val); if (pr.MaxVols > 0 && mr->Slot > (int)pr.MaxVols) { - bsendmsg(ua, _("Invalid slot, it must be between 0 and MaxVols=%d\n"), + ua->error_msg(_("Invalid slot, it must be between 0 and MaxVols=%d\n"), pr.MaxVols); return; } @@ -283,17 +301,17 @@ static void update_volslot(UAContext *ua, char *val, MEDIA_DBR *mr) * so that any Slot is handled correctly. */ if (!db_update_media_record(ua->jcr, ua->db, mr)) { - bsendmsg(ua, _("Error updating media record Slot: ERR=%s"), db_strerror(ua->db)); + ua->error_msg(_("Error updating media record Slot: ERR=%s"), db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Slot is: %d\n"), mr->Slot); + ua->info_msg(_("New Slot is: %d\n"), mr->Slot); } } /* Modify the Pool in which this Volume is located */ -static void update_vol_pool(UAContext *ua, char *val, MEDIA_DBR *mr, POOL_DBR *opr) +void update_vol_pool(UAContext *ua, char *val, MEDIA_DBR *mr, POOL_DBR *opr) { POOL_DBR pr; - POOLMEM *query; + POOL_MEM query(PM_MESSAGE); char ed1[50], ed2[50]; memset(&pr, 0, sizeof(pr)); @@ -304,26 +322,58 @@ static void update_vol_pool(UAContext *ua, char *val, MEDIA_DBR *mr, POOL_DBR *o mr->PoolId = pr.PoolId; /* set new PoolId */ /* */ - query = get_pool_memory(PM_MESSAGE); db_lock(ua->db); Mmsg(query, "UPDATE Media SET PoolId=%s WHERE MediaId=%s", - edit_int64(mr->PoolId, ed1), - edit_int64(mr->MediaId, ed2)); - if (!db_sql_query(ua->db, query, NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + edit_int64(mr->PoolId, ed1), edit_int64(mr->MediaId, ed2)); + if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Pool is: %s\n"), pr.Name); + ua->info_msg(_("New Pool is: %s\n"), pr.Name); opr->NumVols--; if (!db_update_pool_record(ua->jcr, ua->db, opr)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } pr.NumVols++; if (!db_update_pool_record(ua->jcr, ua->db, &pr)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } } db_unlock(ua->db); - free_pool_memory(query); +} + +/* Modify the RecyclePool of a Volume */ +void update_vol_recyclepool(UAContext *ua, char *val, MEDIA_DBR *mr) +{ + POOL_DBR pr; + POOL_MEM query(PM_MESSAGE); + char ed1[50], ed2[50], *poolname; + + if(val && *val) { /* update volume recyclepool="Scratch" */ + /* If a pool name is given, look up the PoolId */ + memset(&pr, 0, sizeof(pr)); + bstrncpy(pr.Name, val, sizeof(pr.Name)); + if (!get_pool_dbr(ua, &pr, NT_("recyclepool"))) { + return; + } + /* pool = select_pool_resource(ua); */ + mr->RecyclePoolId = pr.PoolId; /* get the PoolId */ + poolname = pr.Name; + + } else { /* update volume recyclepool="" */ + /* If no pool name is given, set the PoolId to 0 (the default) */ + mr->RecyclePoolId = 0; + poolname = _("*None*"); + } + + db_lock(ua->db); + Mmsg(query, "UPDATE Media SET RecyclePoolId=%s WHERE MediaId=%s", + edit_int64(mr->RecyclePoolId, ed1), edit_int64(mr->MediaId, ed2)); + if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) { + ua->error_msg("%s", db_strerror(ua->db)); + } else { + ua->info_msg(_("New RecyclePool is: %s\n"), poolname); + } + db_unlock(ua->db); } /* @@ -341,9 +391,9 @@ static void update_vol_from_pool(UAContext *ua, MEDIA_DBR *mr) } set_pool_dbr_defaults_in_media_dbr(mr, &pr); if (!db_update_media_defaults(ua->jcr, ua->db, mr)) { - bsendmsg(ua, _("Error updating Volume record: ERR=%s"), db_strerror(ua->db)); + ua->error_msg(_("Error updating Volume record: ERR=%s"), db_strerror(ua->db)); } else { - bsendmsg(ua, _("Volume defaults updated from \"%s\" Pool record.\n"), + ua->info_msg(_("Volume defaults updated from \"%s\" Pool record.\n"), pr.Name); } } @@ -352,25 +402,64 @@ static void update_vol_from_pool(UAContext *ua, MEDIA_DBR *mr) * Refresh the Volume information from the Pool record * for all Volumes */ -static void update_all_vols_from_pool(UAContext *ua) +static void update_all_vols_from_pool(UAContext *ua, const char *pool_name) { POOL_DBR pr; MEDIA_DBR mr; memset(&pr, 0, sizeof(pr)); memset(&mr, 0, sizeof(mr)); + + bstrncpy(pr.Name, pool_name, sizeof(pr.Name)); if (!get_pool_dbr(ua, &pr)) { return; } set_pool_dbr_defaults_in_media_dbr(&mr, &pr); mr.PoolId = pr.PoolId; if (!db_update_media_defaults(ua->jcr, ua->db, &mr)) { - bsendmsg(ua, _("Error updating Volume records: ERR=%s"), db_strerror(ua->db)); + ua->error_msg(_("Error updating Volume records: ERR=%s"), db_strerror(ua->db)); } else { - bsendmsg(ua, _("All Volume defaults updated from Pool record.\n")); + ua->info_msg(_("All Volume defaults updated from \"%s\" Pool record.\n"), + pr.Name); } } +static void update_all_vols(UAContext *ua) +{ + int i, num_pools; + uint32_t *ids; + POOL_DBR pr; + MEDIA_DBR mr; + + memset(&pr, 0, sizeof(pr)); + memset(&mr, 0, sizeof(mr)); + + if (!db_get_pool_ids(ua->jcr, ua->db, &num_pools, &ids)) { + ua->error_msg(_("Error obtaining pool ids. ERR=%s\n"), db_strerror(ua->db)); + return; + } + + for (i=0; ijcr, ua->db, &pr)) { /* ***FIXME*** use acl? */ + ua->warning_msg(_("Updating all pools, but skipped PoolId=%d. ERR=%s\n"), db_strerror(ua->db)); + continue; + } + + set_pool_dbr_defaults_in_media_dbr(&mr, &pr); + mr.PoolId = pr.PoolId; + + if (!db_update_media_defaults(ua->jcr, ua->db, &mr)) { + ua->error_msg(_("Error updating Volume records: ERR=%s"), db_strerror(ua->db)); + } else { + ua->info_msg(_("All Volume defaults updated from \"%s\" Pool record.\n"), + pr.Name); + } + } + + free(ids); +} + static void update_volenabled(UAContext *ua, char *val, MEDIA_DBR *mr) { mr->Enabled = get_enabled(ua, val); @@ -378,13 +467,30 @@ static void update_volenabled(UAContext *ua, char *val, MEDIA_DBR *mr) return; } if (!db_update_media_record(ua->jcr, ua->db, mr)) { - bsendmsg(ua, _("Error updating media record Enabled: ERR=%s"), db_strerror(ua->db)); + ua->error_msg(_("Error updating media record Enabled: ERR=%s"), + db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Enabled is: %d\n"), mr->Enabled); + ua->info_msg(_("New Enabled is: %d\n"), mr->Enabled); } } - +static void update_vol_actiononpurge(UAContext *ua, char *val, MEDIA_DBR *mr) +{ + POOL_MEM ret; + if (strcasecmp(val, "truncate") == 0) { + mr->ActionOnPurge = AOP_TRUNCATE; + } else { + mr->ActionOnPurge = 0; + } + + if (!db_update_media_record(ua->jcr, ua->db, mr)) { + ua->error_msg(_("Error updating media record ActionOnPurge: ERR=%s"), + db_strerror(ua->db)); + } else { + ua->info_msg(_("New ActionOnPurge is: %s\n"), + aop_to_str(mr->ActionOnPurge, ret)); + } +} /* * Update a media record -- allows you to change the @@ -395,25 +501,30 @@ static void update_volenabled(UAContext *ua, char *val, MEDIA_DBR *mr) static int update_volume(UAContext *ua) { MEDIA_DBR mr; + POOL *pool; POOL_DBR pr; POOLMEM *query; + POOL_MEM ret; + char buf[1000]; char ed1[130]; bool done = false; int i; const char *kw[] = { - _("VolStatus"), /* 0 */ - _("VolRetention"), /* 1 */ - _("VolUse"), /* 2 */ - _("MaxVolJobs"), /* 3 */ - _("MaxVolFiles"), /* 4 */ - _("MaxVolBytes"), /* 5 */ - _("Recycle"), /* 6 */ - _("InChanger"), /* 7 */ - _("Slot"), /* 8 */ - _("Pool"), /* 9 */ - _("FromPool"), /* 10 */ - _("AllFromPool"), /* 11 !!! see below !!! */ - _("Enabled"), /* 12 */ + NT_("VolStatus"), /* 0 */ + NT_("VolRetention"), /* 1 */ + NT_("VolUse"), /* 2 */ + NT_("MaxVolJobs"), /* 3 */ + NT_("MaxVolFiles"), /* 4 */ + NT_("MaxVolBytes"), /* 5 */ + NT_("Recycle"), /* 6 */ + NT_("InChanger"), /* 7 */ + NT_("Slot"), /* 8 */ + NT_("Pool"), /* 9 */ + NT_("FromPool"), /* 10 */ + NT_("AllFromPool"), /* 11 !!! see below !!! */ + NT_("Enabled"), /* 12 */ + NT_("RecyclePool"), /* 13 */ + NT_("ActionOnPurge"), /* 14 */ NULL }; #define AllFromPool 11 /* keep this updated with above */ @@ -421,6 +532,7 @@ static int update_volume(UAContext *ua) for (i=0; kw[i]; i++) { int j; POOL_DBR pr; + if ((j=find_arg_with_value(ua, kw[i])) > 0) { /* If all from pool don't select a media record */ if (i != AllFromPool && !select_media_dbr(ua, &mr)) { @@ -458,7 +570,7 @@ static int update_volume(UAContext *ua) memset(&pr, 0, sizeof(POOL_DBR)); pr.PoolId = mr.PoolId; if (!db_get_pool_record(ua->jcr, ua->db, &pr)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); break; } update_vol_pool(ua, ua->argv[j], &mr, &pr); @@ -467,16 +579,28 @@ static int update_volume(UAContext *ua) update_vol_from_pool(ua, &mr); return 1; case 11: - update_all_vols_from_pool(ua); + update_all_vols_from_pool(ua, ua->argv[j]); return 1; case 12: update_volenabled(ua, ua->argv[j], &mr); break; + case 13: + update_vol_recyclepool(ua, ua->argv[j], &mr); + break; + case 14: + update_vol_actiononpurge(ua, ua->argv[j], &mr); + break; } done = true; } } + /* Allow user to simply update all volumes */ + if (find_arg(ua, NT_("fromallpools")) > 0) { + update_all_vols(ua); + return 1; + } + for ( ; !done; ) { start_prompt(ua, _("Parameters to modify:\n")); add_prompt(ua, _("Volume Status")); /* 0 */ @@ -492,21 +616,25 @@ static int update_volume(UAContext *ua) add_prompt(ua, _("Pool")); /* 10 */ add_prompt(ua, _("Volume from Pool")); /* 11 */ add_prompt(ua, _("All Volumes from Pool")); /* 12 */ - add_prompt(ua, _("Enabled")), /* 13 */ - add_prompt(ua, _("Done")); /* 14 */ + add_prompt(ua, _("All Volumes from all Pools")); /* 13 */ + add_prompt(ua, _("Enabled")), /* 14 */ + add_prompt(ua, _("RecyclePool")), /* 15 */ + add_prompt(ua, _("Action On Purge")), /* 16 */ + add_prompt(ua, _("Done")); /* 17 */ i = do_prompt(ua, "", _("Select parameter to modify"), NULL, 0); - /* For All Volumes from Pool and Done, we don't need a Volume record */ - if (i != 12 && i != 14) { + /* For All Volumes, All Volumes from Pool, and Done, we don't need + * a Volume record */ + if ( i != 12 && i != 13 && i != 17) { if (!select_media_dbr(ua, &mr)) { /* Get Volume record */ return 0; } - bsendmsg(ua, _("Updating Volume \"%s\"\n"), mr.VolumeName); + ua->info_msg(_("Updating Volume \"%s\"\n"), mr.VolumeName); } switch (i) { case 0: /* Volume Status */ /* Modify Volume Status */ - bsendmsg(ua, _("Current Volume status is: %s\n"), mr.VolStatus); + ua->info_msg(_("Current Volume status is: %s\n"), mr.VolStatus); start_prompt(ua, _("Possible Values are:\n")); add_prompt(ua, NT_("Append")); add_prompt(ua, NT_("Archive")); @@ -524,7 +652,7 @@ static int update_volume(UAContext *ua) update_volstatus(ua, ua->cmd, &mr); break; case 1: /* Retention */ - bsendmsg(ua, _("Current retention period is: %s\n"), + ua->info_msg(_("Current retention period is: %s\n"), edit_utime(mr.VolRetention, ed1, sizeof(ed1))); if (!get_cmd(ua, _("Enter Volume Retention period: "))) { return 0; @@ -533,7 +661,7 @@ static int update_volume(UAContext *ua) break; case 2: /* Use Duration */ - bsendmsg(ua, _("Current use duration is: %s\n"), + ua->info_msg(_("Current use duration is: %s\n"), edit_utime(mr.VolUseDuration, ed1, sizeof(ed1))); if (!get_cmd(ua, _("Enter Volume Use Duration: "))) { return 0; @@ -542,7 +670,7 @@ static int update_volume(UAContext *ua) break; case 3: /* Max Jobs */ - bsendmsg(ua, _("Current max jobs is: %u\n"), mr.MaxVolJobs); + ua->info_msg(_("Current max jobs is: %u\n"), mr.MaxVolJobs); if (!get_pint(ua, _("Enter new Maximum Jobs: "))) { return 0; } @@ -550,7 +678,7 @@ static int update_volume(UAContext *ua) break; case 4: /* Max Files */ - bsendmsg(ua, _("Current max files is: %u\n"), mr.MaxVolFiles); + ua->info_msg(_("Current max files is: %u\n"), mr.MaxVolFiles); if (!get_pint(ua, _("Enter new Maximum Files: "))) { return 0; } @@ -558,7 +686,7 @@ static int update_volume(UAContext *ua) break; case 5: /* Max Bytes */ - bsendmsg(ua, _("Current value is: %s\n"), edit_uint64(mr.MaxVolBytes, ed1)); + ua->info_msg(_("Current value is: %s\n"), edit_uint64(mr.MaxVolBytes, ed1)); if (!get_cmd(ua, _("Enter new Maximum Bytes: "))) { return 0; } @@ -567,7 +695,7 @@ static int update_volume(UAContext *ua) case 6: /* Recycle */ - bsendmsg(ua, _("Current recycle flag is: %s\n"), + ua->info_msg(_("Current recycle flag is: %s\n"), mr.Recycle==1?_("yes"):_("no")); if (!get_yesno(ua, _("Enter new Recycle status: "))) { return 0; @@ -576,7 +704,7 @@ static int update_volume(UAContext *ua) break; case 7: /* Slot */ - bsendmsg(ua, _("Current Slot is: %d\n"), mr.Slot); + ua->info_msg(_("Current Slot is: %d\n"), mr.Slot); if (!get_pint(ua, _("Enter new Slot: "))) { return 0; } @@ -584,8 +712,10 @@ static int update_volume(UAContext *ua) break; case 8: /* InChanger */ - bsendmsg(ua, _("Current InChanger flag is: %d\n"), mr.InChanger); - if (!get_yesno(ua, _("Set InChanger flag? yes/no: "))) { + ua->info_msg(_("Current InChanger flag is: %d\n"), mr.InChanger); + bsnprintf(buf, sizeof(buf), _("Set InChanger flag for Volume \"%s\": yes/no: "), + mr.VolumeName); + if (!get_yesno(ua, buf)) { return 0; } mr.InChanger = ua->pint32_val; @@ -594,25 +724,25 @@ static int update_volume(UAContext *ua) * so that any Slot is handled correctly. */ if (!db_update_media_record(ua->jcr, ua->db, &mr)) { - bsendmsg(ua, _("Error updating media record Slot: ERR=%s"), db_strerror(ua->db)); + ua->error_msg(_("Error updating media record Slot: ERR=%s"), db_strerror(ua->db)); } else { - bsendmsg(ua, _("New InChanger flag is: %d\n"), mr.InChanger); + ua->info_msg(_("New InChanger flag is: %d\n"), mr.InChanger); } break; case 9: /* Volume Files */ int32_t VolFiles; - bsendmsg(ua, _("Warning changing Volume Files can result\n" + ua->warning_msg(_("Warning changing Volume Files can result\n" "in loss of data on your Volume\n\n")); - bsendmsg(ua, _("Current Volume Files is: %u\n"), mr.VolFiles); + ua->info_msg(_("Current Volume Files is: %u\n"), mr.VolFiles); if (!get_pint(ua, _("Enter new number of Files for Volume: "))) { return 0; } VolFiles = ua->pint32_val; if (VolFiles != (int)(mr.VolFiles + 1)) { - bsendmsg(ua, _("Normally, you should only increase Volume Files by one!\n")); - if (!get_yesno(ua, _("Continue? (yes/no): ")) || ua->pint32_val == 0) { + ua->warning_msg(_("Normally, you should only increase Volume Files by one!\n")); + if (!get_yesno(ua, _("Increase Volume Files? (yes/no): ")) || ua->pint32_val == 0) { break; } } @@ -620,9 +750,9 @@ static int update_volume(UAContext *ua) Mmsg(query, "UPDATE Media SET VolFiles=%u WHERE MediaId=%s", VolFiles, edit_int64(mr.MediaId, ed1)); if (!db_sql_query(ua->db, query, NULL, NULL)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); } else { - bsendmsg(ua, _("New Volume Files is: %u\n"), VolFiles); + ua->info_msg(_("New Volume Files is: %u\n"), VolFiles); } free_pool_memory(query); break; @@ -631,10 +761,10 @@ static int update_volume(UAContext *ua) memset(&pr, 0, sizeof(POOL_DBR)); pr.PoolId = mr.PoolId; if (!db_get_pool_record(ua->jcr, ua->db, &pr)) { - bsendmsg(ua, "%s", db_strerror(ua->db)); + ua->error_msg("%s", db_strerror(ua->db)); return 0; } - bsendmsg(ua, _("Current Pool is: %s\n"), pr.Name); + ua->info_msg(_("Current Pool is: %s\n"), pr.Name); if (!get_cmd(ua, _("Enter new Pool name: "))) { return 0; } @@ -645,11 +775,18 @@ static int update_volume(UAContext *ua) update_vol_from_pool(ua, &mr); return 1; case 12: - update_all_vols_from_pool(ua); + pool = select_pool_resource(ua); + if (pool) { + update_all_vols_from_pool(ua, pool->name()); + } return 1; case 13: - bsendmsg(ua, _("Current Enabled is: %d\n"), mr.Enabled); + update_all_vols(ua); + return 1; + + case 14: + ua->info_msg(_("Current Enabled is: %d\n"), mr.Enabled); if (!get_cmd(ua, _("Enter new Enabled: "))) { return 0; } @@ -665,14 +802,57 @@ static int update_volume(UAContext *ua) update_volenabled(ua, ua->cmd, &mr); break; + case 15: + memset(&pr, 0, sizeof(POOL_DBR)); + pr.PoolId = mr.RecyclePoolId; + if (db_get_pool_record(ua->jcr, ua->db, &pr)) { + ua->info_msg(_("Current RecyclePool is: %s\n"), pr.Name); + } else { + ua->info_msg(_("No current RecyclePool\n")); + } + if (!select_pool_dbr(ua, &pr, NT_("recyclepool"))) { + return 0; + } + update_vol_recyclepool(ua, pr.Name, &mr); + return 1; + + case 16: + pm_strcpy(ret, ""); + ua->info_msg(_("Current ActionOnPurge is: %s\n"), + aop_to_str(mr.ActionOnPurge, ret)); + if (!get_cmd(ua, _("Enter new ActionOnPurge (one of: Truncate, None): "))) { + return 0; + } + + update_vol_actiononpurge(ua, ua->cmd, &mr); + break; + default: /* Done or error */ - bsendmsg(ua, _("Selection terminated.\n")); + ua->info_msg(_("Selection terminated.\n")); return 1; } } return 1; } +/* + * Update long term statistics + */ +static bool update_stats(UAContext *ua) +{ + int i = find_arg_with_value(ua, NT_("days")); + utime_t since=0; + + if (i >= 0) { + since = atoi(ua->argv[i]) * 24*60*60; + } + + int nb = db_update_stats(ua->jcr, ua->db, since); + ua->info_msg(_("Updating %i job(s).\n"), nb); + + return true; +} + /* * Update pool record -- pull info from current POOL resource */ @@ -690,22 +870,115 @@ static bool update_pool(UAContext *ua) } memset(&pr, 0, sizeof(pr)); - bstrncpy(pr.Name, pool->hdr.name, sizeof(pr.Name)); + bstrncpy(pr.Name, pool->name(), sizeof(pr.Name)); if (!get_pool_dbr(ua, &pr)) { return false; } set_pooldbr_from_poolres(&pr, pool, POOL_OP_UPDATE); /* update */ + set_pooldbr_references(ua->jcr, ua->db, &pr, pool); id = db_update_pool_record(ua->jcr, ua->db, &pr); if (id <= 0) { - bsendmsg(ua, _("db_update_pool_record returned %d. ERR=%s\n"), + ua->error_msg(_("db_update_pool_record returned %d. ERR=%s\n"), id, db_strerror(ua->db)); } query = get_pool_memory(PM_MESSAGE); Mmsg(query, list_pool, edit_int64(pr.PoolId, ed1)); db_list_sql_query(ua->jcr, ua->db, query, prtit, ua, 1, HORZ_LIST); free_pool_memory(query); - bsendmsg(ua, _("Pool DB record updated from resource.\n")); + ua->info_msg(_("Pool DB record updated from resource.\n")); + return true; +} + +/* + * Update a Job record -- allows you to change the + * date fields in a Job record. This helps when + * providing migration from other vendors. + */ +static bool update_job(UAContext *ua) +{ + int i; + char ed1[50], ed2[50]; + POOL_MEM cmd(PM_MESSAGE); + JOB_DBR jr; + CLIENT_DBR cr; + utime_t StartTime; + char *client_name = NULL; + char *start_time = NULL; + const char *kw[] = { + NT_("starttime"), /* 0 */ + NT_("client"), /* 1 */ + NULL }; + + Dmsg1(200, "cmd=%s\n", ua->cmd); + i = find_arg_with_value(ua, NT_("jobid")); + if (i < 0) { + ua->error_msg(_("Expect JobId keyword, not found.\n")); + return false; + } + memset(&jr, 0, sizeof(jr)); + memset(&cr, 0, sizeof(cr)); + jr.JobId = str_to_int64(ua->argv[i]); + if (!db_get_job_record(ua->jcr, ua->db, &jr)) { + ua->error_msg("%s", db_strerror(ua->db)); + return false; + } + + for (i=0; kw[i]; i++) { + int j; + if ((j=find_arg_with_value(ua, kw[i])) >= 0) { + switch (i) { + case 0: /* start time */ + start_time = ua->argv[j]; + break; + case 1: /* Client name */ + client_name = ua->argv[j]; + break; + } + } + } + if (!client_name && !start_time) { + ua->error_msg(_("Neither Client nor StartTime specified.\n")); + return 0; + } + if (client_name) { + if (!get_client_dbr(ua, &cr)) { + return false; + } + jr.ClientId = cr.ClientId; + } + if (start_time) { + utime_t delta_start; + + StartTime = str_to_utime(start_time); + if (StartTime == 0) { + ua->error_msg(_("Improper date format: %s\n"), ua->argv[i]); + return false; + } + delta_start = StartTime - jr.StartTime; + Dmsg3(200, "ST=%lld jr.ST=%lld delta=%lld\n", StartTime, + (utime_t)jr.StartTime, delta_start); + jr.StartTime = (time_t)StartTime; + jr.SchedTime += (time_t)delta_start; + jr.EndTime += (time_t)delta_start; + jr.JobTDate += delta_start; + /* Convert to DB times */ + bstrutime(jr.cStartTime, sizeof(jr.cStartTime), jr.StartTime); + bstrutime(jr.cSchedTime, sizeof(jr.cSchedTime), jr.SchedTime); + bstrutime(jr.cEndTime, sizeof(jr.cEndTime), jr.EndTime); + } + Mmsg(cmd, "UPDATE Job SET ClientId=%s,StartTime='%s',SchedTime='%s'," + "EndTime='%s',JobTDate=%s WHERE JobId=%s", + edit_int64(jr.ClientId, ed1), + jr.cStartTime, + jr.cSchedTime, + jr.cEndTime, + edit_uint64(jr.JobTDate, ed1), + edit_int64(jr.JobId, ed2)); + if (!db_sql_query(ua->db, cmd.c_str(), NULL, NULL)) { + ua->error_msg("%s", db_strerror(ua->db)); + return false; + } return true; }