X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fdird%2Fua_update.c;h=f5bd5ee164810e58102d8a3a68e30002f36bbcdc;hb=31c964aebd944229306e310da0a223124673c550;hp=75a1a3489d59c3ed52930c9eb6626ac689431f81;hpb=8e1a4eeb2bdc80c9ab45a822a8da1cfa0ece1a6d;p=bacula%2Fbacula diff --git a/bacula/src/dird/ua_update.c b/bacula/src/dird/ua_update.c index 75a1a3489d..f5bd5ee164 100644 --- a/bacula/src/dird/ua_update.c +++ b/bacula/src/dird/ua_update.c @@ -1,3 +1,30 @@ +/* + Bacula® - The Network Backup Solution + + Copyright (C) 2000-2007 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 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 + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA + 02110-1301, USA. + + Bacula® is a registered trademark of John Walker. + 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 @@ -7,35 +34,14 @@ * * Version $Id$ */ -/* - Copyright (C) 2000-2006 Kern Sibbald - - This program is free software; you can redistribute it and/or - modify it under the terms of the GNU General Public License - version 2 as amended with additional clauses defined in the - file LICENSE in the main source directory. - - This program is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - the file LICENSE for additional details. - - */ #include "bacula.h" #include "dird.h" -/* External variables */ -extern const char *list_pool; /* in sql_cmds.c */ - -/* Imported functions */ -void update_slots(UAContext *ua); - - - /* Forward referenced functions */ static int update_volume(UAContext *ua); -static int update_pool(UAContext *ua); +static bool update_pool(UAContext *ua); +static bool update_job(UAContext *ua); /* * Update a Pool Record in the database. @@ -55,9 +61,10 @@ int update_cmd(UAContext *ua, const char *cmd) NT_("volume"), /* 1 */ NT_("pool"), /* 2 */ NT_("slots"), /* 3 */ + NT_("jobid"), /* 4 */ NULL}; - if (!open_db(ua)) { + if (!open_client_db(ua)) { return 1; } @@ -72,6 +79,9 @@ int update_cmd(UAContext *ua, const char *cmd) case 3: update_slots(ua); return 1; + case 4: + update_job(ua); + return 1; default: break; } @@ -108,6 +118,7 @@ static void update_volstatus(UAContext *ua, const char *val, MEDIA_DBR *mr) NT_("Cleaning"), NT_("Recycle"), NT_("Read-Only"), + NT_("Error"), NULL}; bool found = false; int i; @@ -119,16 +130,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); } } } @@ -138,15 +149,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))); } } @@ -157,15 +168,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))); } } @@ -177,9 +188,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); } } @@ -190,9 +201,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); } } @@ -203,15 +214,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)); } } @@ -219,21 +230,18 @@ static void update_volrecycle(UAContext *ua, char *val, MEDIA_DBR *mr) { int recycle; char ed1[50]; + POOL_MEM query(PM_MESSAGE); - if (strcasecmp(val, _("yes")) == 0) { - recycle = 1; - } else if (strcasecmp(val, _("no")) == 0) { - recycle = 0; - } else { - bsendmsg(ua, _("Invalid value. It must be yes or no.\n")); + if (!is_yesno(val, &recycle)) { + 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"), + ua->info_msg(_("New Recycle flag is: %s\n"), mr->Recycle==1?_("yes"):_("no")); } } @@ -244,20 +252,16 @@ static void update_volinchanger(UAContext *ua, char *val, MEDIA_DBR *mr) char ed1[50]; POOL_MEM query(PM_MESSAGE); - if (strcasecmp(val, _("yes")) == 0) { - InChanger = 1; - } else if (strcasecmp(val, _("no")) == 0) { - InChanger = 0; - } else { - bsendmsg(ua, _("Invalid value. It must be yes or no.\n")); + if (!is_yesno(val, &InChanger)) { + 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"), + ua->info_msg(_("New InChanger flag is: %s\n"), mr->InChanger==1?_("yes"):_("no")); } } @@ -270,12 +274,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; } @@ -284,17 +288,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)); @@ -305,26 +309,49 @@ 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]; + + 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 */ + + 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"), pr.Name); + } + db_unlock(ua->db); } /* @@ -342,9 +369,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); } } @@ -353,26 +380,43 @@ 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_volenabled(UAContext *ua, char *val, MEDIA_DBR *mr) +{ + mr->Enabled = get_enabled(ua, val); + if (mr->Enabled < 0) { + return; + } + if (!db_update_media_record(ua->jcr, ua->db, mr)) { + ua->error_msg(_("Error updating media record Enabled: ERR=%s"), db_strerror(ua->db)); + } else { + ua->info_msg(_("New Enabled is: %d\n"), mr->Enabled); } } + /* * Update a media record -- allows you to change the * Volume status. E.g. if you want Bacula to stop @@ -382,24 +426,28 @@ static void update_all_vols_from_pool(UAContext *ua) static int update_volume(UAContext *ua) { MEDIA_DBR mr; + POOL *pool; POOL_DBR pr; POOLMEM *query; + 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 !!! */ + 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 */ NULL }; #define AllFromPool 11 /* keep this updated with above */ @@ -408,6 +456,7 @@ static int update_volume(UAContext *ua) 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)) { return 0; } @@ -443,7 +492,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); @@ -452,8 +501,14 @@ 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; } done = true; } @@ -474,20 +529,22 @@ 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, _("Done")); /* 13 */ + add_prompt(ua, _("Enabled")), /* 13 */ + add_prompt(ua, _("RecyclePool")), /* 14 */ + add_prompt(ua, _("Done")); /* 15 */ i = do_prompt(ua, "", _("Select parameter to modify"), NULL, 0); - /* For All Volumes from Pool we don't need a Volume record */ - if (i != 12 && i != 13) { + /* For All Volumes from Pool and Done, we don't need a Volume record */ + if (i != 12 && i != 15) { 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")); @@ -505,7 +562,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; @@ -514,7 +571,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; @@ -523,7 +580,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; } @@ -531,7 +588,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; } @@ -539,7 +596,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; } @@ -548,7 +605,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; @@ -557,7 +614,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; } @@ -565,8 +622,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; @@ -575,25 +634,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; } } @@ -601,9 +660,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; @@ -612,10 +671,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; } @@ -626,10 +685,45 @@ 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: + ua->info_msg(_("Current Enabled is: %d\n"), mr.Enabled); + if (!get_cmd(ua, _("Enter new Enabled: "))) { + return 0; + } + if (strcasecmp(ua->cmd, "yes") == 0 || strcasecmp(ua->cmd, "true") == 0) { + mr.Enabled = 1; + } else if (strcasecmp(ua->cmd, "no") == 0 || strcasecmp(ua->cmd, "false") == 0) { + mr.Enabled = 0; + } else if (strcasecmp(ua->cmd, "archived") == 0) { + mr.Enabled = 2; + } else { + mr.Enabled = atoi(ua->cmd); + } + update_volenabled(ua, ua->cmd, &mr); + break; + + case 14: + 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->warning_msg(_("No current RecyclePool\n")); + } + if (!get_cmd(ua, _("Enter new RecyclePool name: "))) { + return 0; + } + update_vol_recyclepool(ua, ua->cmd, &mr); return 1; + default: /* Done or error */ - bsendmsg(ua, _("Selection terminated.\n")); + ua->info_msg(_("Selection terminated.\n")); return 1; } } @@ -639,7 +733,7 @@ static int update_volume(UAContext *ua) /* * Update pool record -- pull info from current POOL resource */ -static int update_pool(UAContext *ua) +static bool update_pool(UAContext *ua) { POOL_DBR pr; int id; @@ -649,26 +743,119 @@ static int update_pool(UAContext *ua) pool = get_pool_resource(ua); if (!pool) { - return 0; + return false; } 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 0; + return false; } set_pooldbr_from_poolres(&pr, pool, POOL_OP_UPDATE); /* update */ + set_pooldbr_recyclepoolid(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")); - return 1; + 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=%d jr.ST=%d delta=%d\n", (time_t)StartTime, + (time_t)jr.StartTime, (time_t)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; }