+/*
+ 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 plus additions
+ that are listed 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
*
* 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 char *list_pool; /* in sql_cmds.c */
-
-/* Imported functions */
-void set_pooldbr_from_poolres(POOL_DBR *pr, POOL *pool, e_pool_op op);
-int 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);
/*
* Update a Pool Record in the database.
int update_cmd(UAContext *ua, const char *cmd)
{
static const char *kw[] = {
- N_("media"), /* 0 */
- N_("volume"), /* 1 */
- N_("pool"), /* 2 */
- N_("slots"), /* 3 */
+ NT_("media"), /* 0 */
+ NT_("volume"), /* 1 */
+ NT_("pool"), /* 2 */
+ NT_("slots"), /* 3 */
NULL};
- if (!open_db(ua)) {
+ if (!open_client_db(ua)) {
return 1;
}
{
POOL_MEM query(PM_MESSAGE);
const char *kw[] = {
- N_("Append"),
- N_("Archive"),
- N_("Disabled"),
- N_("Full"),
- N_("Used"),
- N_("Cleaning"),
- N_("Recycle"),
- N_("Read-Only"),
+ NT_("Append"),
+ NT_("Archive"),
+ NT_("Disabled"),
+ NT_("Full"),
+ NT_("Used"),
+ NT_("Cleaning"),
+ NT_("Recycle"),
+ NT_("Read-Only"),
+ NT_("Error"),
NULL};
bool found = false;
int i;
static void update_volmaxjobs(UAContext *ua, char *val, MEDIA_DBR *mr)
{
- POOLMEM *query = get_pool_memory(PM_MESSAGE);
+ POOL_MEM query(PM_MESSAGE);
char ed1[50];
Mmsg(query, "UPDATE Media SET MaxVolJobs=%s WHERE MediaId=%s",
val, edit_int64(mr->MediaId,ed1));
- if (!db_sql_query(ua->db, query, NULL, NULL)) {
+ if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) {
bsendmsg(ua, "%s", db_strerror(ua->db));
} else {
bsendmsg(ua, _("New max jobs is: %s\n"), val);
}
- free_pool_memory(query);
}
static void update_volmaxfiles(UAContext *ua, char *val, MEDIA_DBR *mr)
{
- POOLMEM *query = get_pool_memory(PM_MESSAGE);
+ POOL_MEM query(PM_MESSAGE);
char ed1[50];
Mmsg(query, "UPDATE Media SET MaxVolFiles=%s WHERE MediaId=%s",
val, edit_int64(mr->MediaId, ed1));
- if (!db_sql_query(ua->db, query, NULL, NULL)) {
+ if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) {
bsendmsg(ua, "%s", db_strerror(ua->db));
} else {
bsendmsg(ua, _("New max files is: %s\n"), val);
}
- free_pool_memory(query);
}
static void update_volmaxbytes(UAContext *ua, char *val, MEDIA_DBR *mr)
{
uint64_t maxbytes;
char ed1[50], ed2[50];
- POOLMEM *query;
+ POOL_MEM query(PM_MESSAGE);
if (!size_to_uint64(val, strlen(val), &maxbytes)) {
bsendmsg(ua, _("Invalid max. bytes specification: %s\n"), val);
return;
}
- query = get_pool_memory(PM_MESSAGE);
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, NULL, NULL)) {
+ if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) {
bsendmsg(ua, "%s", db_strerror(ua->db));
} else {
bsendmsg(ua, _("New Max bytes is: %s\n"), edit_uint64(maxbytes, ed1));
}
- free_pool_memory(query);
}
static void update_volrecycle(UAContext *ua, char *val, MEDIA_DBR *mr)
{
int recycle;
char ed1[50];
- POOLMEM *query;
- if (strcasecmp(val, _("yes")) == 0) {
- recycle = 1;
- } else if (strcasecmp(val, _("no")) == 0) {
- recycle = 0;
- } else {
- bsendmsg(ua, _("Invalid value. It must by yes or no.\n"));
+
+ POOL_MEM query(PM_MESSAGE);
+ if (!is_yesno(val, &recycle)) {
+ bsendmsg(ua, _("Invalid value. It must be yes or no.\n"));
return;
}
- query = get_pool_memory(PM_MESSAGE);
Mmsg(query, "UPDATE Media SET Recycle=%d WHERE MediaId=%s",
recycle, edit_int64(mr->MediaId, ed1));
- if (!db_sql_query(ua->db, query, NULL, NULL)) {
+ if (!db_sql_query(ua->db, query.c_str(), NULL, NULL)) {
bsendmsg(ua, "%s", db_strerror(ua->db));
} else {
bsendmsg(ua, _("New Recycle flag is: %s\n"),
mr->Recycle==1?_("yes"):_("no"));
}
- free_pool_memory(query);
+}
+
+static void update_volinchanger(UAContext *ua, char *val, MEDIA_DBR *mr)
+{
+ int InChanger;
+ char ed1[50];
+
+ POOL_MEM query(PM_MESSAGE);
+ if (!is_yesno(val, &InChanger)) {
+ bsendmsg(ua, _("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));
+ } else {
+ bsendmsg(ua, _("New InChanger flag is: %s\n"),
+ mr->InChanger==1?_("yes"):_("no"));
+ }
+}
+
+
+static void update_volslot(UAContext *ua, char *val, MEDIA_DBR *mr)
+{
+ POOL_DBR pr;
+
+ 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));
+ 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"),
+ pr.MaxVols);
+ return;
+ }
+ /*
+ * Make sure to use db_update... rather than doing this directly,
+ * 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));
+ } else {
+ bsendmsg(ua, _("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;
free_pool_memory(query);
}
+/* Modify the RecyclePool of a Volume */
+void update_vol_recyclepool(UAContext *ua, char *val, MEDIA_DBR *mr)
+{
+ POOL_DBR pr;
+ POOLMEM *query;
+ 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 */
+
+ query = get_pool_memory(PM_MESSAGE);
+ 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, NULL, NULL)) {
+ bsendmsg(ua, "%s", db_strerror(ua->db));
+ } else {
+ bsendmsg(ua, _("New RecyclePool is: %s\n"), pr.Name);
+ }
+ db_unlock(ua->db);
+ free_pool_memory(query);
+}
+
/*
* Refresh the Volume information from the Pool record
*/
}
}
+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)) {
+ bsendmsg(ua, _("Error updating media record Enabled: ERR=%s"), db_strerror(ua->db));
+ } else {
+ bsendmsg(ua, _("New Enabled is: %d\n"), mr->Enabled);
+ }
+}
+
+
/*
* Update a media record -- allows you to change the
POOLMEM *query;
char ed1[130];
bool done = false;
+ int i;
const char *kw[] = {
_("VolStatus"), /* 0 */
_("VolRetention"), /* 1 */
_("MaxVolFiles"), /* 4 */
_("MaxVolBytes"), /* 5 */
_("Recycle"), /* 6 */
- _("Pool"), /* 7 */
- _("FromPool"), /* 8 */
- _("AllFromPool"), /* 9 */
+ _("InChanger"), /* 7 */
+ _("Slot"), /* 8 */
+ _("Pool"), /* 9 */
+ _("FromPool"), /* 10 */
+ _("AllFromPool"), /* 11 !!! see below !!! */
+ _("Enabled"), /* 12 */
+ _("RecyclePool"), /* 13 */
NULL };
- for (int i=0; kw[i]; i++) {
+#define AllFromPool 11 /* keep this updated with above */
+
+ for (i=0; kw[i]; i++) {
int j;
POOL_DBR pr;
if ((j=find_arg_with_value(ua, kw[i])) > 0) {
- if (i != 9 && !select_media_dbr(ua, &mr)) {
+ /* If all from pool don't select a media record */
+ if (i != AllFromPool && !select_media_dbr(ua, &mr)) {
return 0;
}
switch (i) {
update_volrecycle(ua, ua->argv[j], &mr);
break;
case 7:
+ update_volinchanger(ua, ua->argv[j], &mr);
+ break;
+ case 8:
+ update_volslot(ua, ua->argv[j], &mr);
+ break;
+ case 9:
memset(&pr, 0, sizeof(POOL_DBR));
pr.PoolId = mr.PoolId;
if (!db_get_pool_record(ua->jcr, ua->db, &pr)) {
}
update_vol_pool(ua, ua->argv[j], &mr, &pr);
break;
- case 8:
+ case 10:
update_vol_from_pool(ua, &mr);
return 1;
- case 9:
+ case 11:
update_all_vols_from_pool(ua);
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;
}
}
for ( ; !done; ) {
- if (!select_media_dbr(ua, &mr)) {
- return 0;
- }
- bsendmsg(ua, _("Updating Volume \"%s\"\n"), mr.VolumeName);
start_prompt(ua, _("Parameters to modify:\n"));
- add_prompt(ua, _("Volume Status"));
- add_prompt(ua, _("Volume Retention Period"));
- add_prompt(ua, _("Volume Use Duration"));
- add_prompt(ua, _("Maximum Volume Jobs"));
- add_prompt(ua, _("Maximum Volume Files"));
- add_prompt(ua, _("Maximum Volume Bytes"));
- add_prompt(ua, _("Recycle Flag"));
- add_prompt(ua, _("Slot"));
- add_prompt(ua, _("InChanger Flag"));
- add_prompt(ua, _("Volume Files"));
- add_prompt(ua, _("Pool"));
- add_prompt(ua, _("Volume from Pool"));
- add_prompt(ua, _("All Volumes from Pool"));
- add_prompt(ua, _("Done"));
- switch (do_prompt(ua, "", _("Select parameter to modify"), NULL, 0)) {
+ add_prompt(ua, _("Volume Status")); /* 0 */
+ add_prompt(ua, _("Volume Retention Period")); /* 1 */
+ add_prompt(ua, _("Volume Use Duration")); /* 2 */
+ add_prompt(ua, _("Maximum Volume Jobs")); /* 3 */
+ add_prompt(ua, _("Maximum Volume Files")); /* 4 */
+ add_prompt(ua, _("Maximum Volume Bytes")); /* 5 */
+ add_prompt(ua, _("Recycle Flag")); /* 6 */
+ add_prompt(ua, _("Slot")); /* 7 */
+ add_prompt(ua, _("InChanger Flag")); /* 8 */
+ add_prompt(ua, _("Volume Files")); /* 9 */
+ 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, _("RecyclePool")), /* 14 */
+ add_prompt(ua, _("Done")); /* 15 */
+ 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 != 15) {
+ if (!select_media_dbr(ua, &mr)) { /* Get Volume record */
+ return 0;
+ }
+ bsendmsg(ua, _("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);
start_prompt(ua, _("Possible Values are:\n"));
- add_prompt(ua, N_("Append"));
- add_prompt(ua, N_("Archive"));
- add_prompt(ua, N_("Disabled"));
- add_prompt(ua, N_("Full"));
- add_prompt(ua, N_("Used"));
- add_prompt(ua, N_("Cleaning"));
- if (strcmp(mr.VolStatus, N_("Purged")) == 0) {
- add_prompt(ua, N_("Recycle"));
+ add_prompt(ua, NT_("Append"));
+ add_prompt(ua, NT_("Archive"));
+ add_prompt(ua, NT_("Disabled"));
+ add_prompt(ua, NT_("Full"));
+ add_prompt(ua, NT_("Used"));
+ add_prompt(ua, NT_("Cleaning"));
+ if (strcmp(mr.VolStatus, NT_("Purged")) == 0) {
+ add_prompt(ua, NT_("Recycle"));
}
- add_prompt(ua, N_("Read-Only"));
+ add_prompt(ua, NT_("Read-Only"));
if (do_prompt(ua, "", _("Choose new Volume Status"), ua->cmd, sizeof(mr.VolStatus)) < 0) {
return 1;
}
break;
case 7: /* Slot */
- int Slot;
-
- 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));
- return 0;
- }
bsendmsg(ua, _("Current Slot is: %d\n"), mr.Slot);
if (!get_pint(ua, _("Enter new Slot: "))) {
return 0;
}
- Slot = ua->pint32_val;
- if (pr.MaxVols > 0 && Slot > (int)pr.MaxVols) {
- bsendmsg(ua, _("Invalid slot, it must be between 0 and %d\n"),
- pr.MaxVols);
- break;
- }
- mr.Slot = Slot;
- /*
- * Make sure to use db_update... rather than doing this directly,
- * 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));
- } else {
- bsendmsg(ua, _("New Slot is: %d\n"), mr.Slot);
- }
+ update_volslot(ua, ua->cmd, &mr);
break;
-
+
case 8: /* InChanger */
bsendmsg(ua, _("Current InChanger flag is: %d\n"), mr.InChanger);
if (!get_yesno(ua, _("Set InChanger flag? yes/no: "))) {
case 12:
update_all_vols_from_pool(ua);
return 1;
+
+ case 13:
+ bsendmsg(ua, _("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)) {
+ bsendmsg(ua, _("Current RecyclePool is: %s\n"), pr.Name);
+ } else {
+ bsendmsg(ua, _("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"));
return 1;
/*
* 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;
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));
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) {
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;
+ return true;
}