2 Bacula® - The Network Backup Solution
4 Copyright (C) 2003-2010 Free Software Foundation Europe e.V.
6 The main author of Bacula is Kern Sibbald, with contributions from
7 many others, a complete list can be found in the file AUTHORS.
8 This program is Free Software; you can redistribute it and/or
9 modify it under the terms of version two of the GNU General Public
10 License as published by the Free Software Foundation and included
13 This program is distributed in the hope that it will be useful, but
14 WITHOUT ANY WARRANTY; without even the implied warranty of
15 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
16 General Public License for more details.
18 You should have received a copy of the GNU General Public License
19 along with this program; if not, write to the Free Software
20 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
23 Bacula® is a registered trademark of Kern Sibbald.
24 The licensor of Bacula is the Free Software Foundation Europe
25 (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zürich,
26 Switzerland, email:ftf@fsfeurope.org.
29 * Bacula Catalog Database routines specific to Ingres
30 * These are Ingres specific routines
32 * Stefan Reddig, June 2009
33 * based uopn work done
34 * by Dan Langille, December 2003 and
35 * by Kern Sibbald, March 2000
40 /* The following is necessary so that we do not include
41 * the dummy external definition of DB.
43 #define __SQL_C /* indicate that this is sql.c */
52 /* -----------------------------------------------------------------------
54 * Ingres dependent defines and subroutines
56 * -----------------------------------------------------------------------
59 /* List of open databases */ /* SRE: needed for ingres? */
60 static BQUEUE db_list = {&db_list, &db_list};
62 static pthread_mutex_t mutex = PTHREAD_MUTEX_INITIALIZER;
65 * Retrieve database type
74 * Initialize database data structure. In principal this should
75 * never have errors, or it is really fatal.
78 db_init_database(JCR *jcr, const char *db_name, const char *db_user, const char *db_password,
79 const char *db_address, int db_port, const char *db_socket,
80 int mult_db_connections)
85 Jmsg(jcr, M_FATAL, 0, _("A user name for Ingres must be supplied.\n"));
88 P(mutex); /* lock DB queue */
89 if (!mult_db_connections) {
90 /* Look to see if DB already open */
91 for (mdb=NULL; (mdb=(B_DB *)qnext(&db_list, &mdb->bq)); ) {
92 if (bstrcmp(mdb->db_name, db_name) &&
93 bstrcmp(mdb->db_address, db_address) &&
94 mdb->db_port == db_port) {
95 Dmsg2(100, "DB REopen %d %s\n", mdb->ref_count, db_name);
98 return mdb; /* already open */
102 Dmsg0(100, "db_open first time\n");
103 mdb = (B_DB *)malloc(sizeof(B_DB));
104 memset(mdb, 0, sizeof(B_DB));
105 mdb->db_name = bstrdup(db_name);
106 mdb->db_user = bstrdup(db_user);
108 mdb->db_password = bstrdup(db_password);
111 mdb->db_address = bstrdup(db_address);
114 mdb->db_socket = bstrdup(db_socket);
116 mdb->db_port = db_port;
117 mdb->have_insert_id = TRUE;
118 mdb->errmsg = get_pool_memory(PM_EMSG); /* get error message buffer */
120 mdb->cmd = get_pool_memory(PM_EMSG); /* get command buffer */
121 mdb->cached_path = get_pool_memory(PM_FNAME);
122 mdb->cached_path_id = 0;
124 mdb->fname = get_pool_memory(PM_FNAME);
125 mdb->path = get_pool_memory(PM_FNAME);
126 mdb->esc_name = get_pool_memory(PM_FNAME);
127 mdb->esc_path = get_pool_memory(PM_FNAME);
128 mdb->allow_transactions = mult_db_connections;
129 qinsert(&db_list, &mdb->bq); /* put db in list */
134 /* Check that the database correspond to the encoding we want */
135 static bool check_database_encoding(JCR *jcr, B_DB *mdb)
137 /* SRE: TODO! Needed?
141 if (!db_sql_query(mdb, "SELECT getdatabaseencoding()", NULL, NULL)) {
142 Jmsg(jcr, M_ERROR, 0, "%s", mdb->errmsg);
146 if ((row = sql_fetch_row(mdb)) == NULL) {
147 Mmsg1(mdb->errmsg, _("error fetching row: %s\n"), sql_strerror(mdb));
148 Jmsg(jcr, M_ERROR, 0, "Can't check database encoding %s", mdb->errmsg);
150 ret = bstrcmp(row[0], "SQL_ASCII");
153 _("Encoding error for database \"%s\". Wanted SQL_ASCII, got %s\n"),
154 mdb->db_name, row[0]);
155 Jmsg(jcr, M_WARNING, 0, "%s", mdb->errmsg);
156 Dmsg1(50, "%s", mdb->errmsg);
165 * Check for errors in DBMS work
167 static int sql_check(B_DB *mdb)
171 if ((errorcode = INGcheck()) < 0) {
172 /* TODO: fill mdb->errmsg */
173 Mmsg(mdb->errmsg, "Something went wrong - still searching!\n");
174 } else if (errorcode > 0) {
175 /* just a warning, proceed */
181 * Now actually open the database. This can generate errors,
182 * which are returned in the errmsg
184 * DO NOT close the database or free(mdb) here !!!!
187 db_open_database(JCR *jcr, B_DB *mdb)
193 if (mdb->connected) {
197 mdb->connected = false;
199 if ((errstat=rwl_init(&mdb->lock)) != 0) {
201 Mmsg1(&mdb->errmsg, _("Unable to initialize DB lock. ERR=%s\n"),
202 be.bstrerror(errstat));
208 bsnprintf(buf, sizeof(buf), "%d", mdb->db_port);
214 mdb->db = INGconnectDB(mdb->db_name, mdb->db_user, mdb->db_password);
216 Dmsg0(50, "Ingres real CONNECT done\n");
217 Dmsg3(50, "db_user=%s db_name=%s db_password=%s\n", mdb->db_user, mdb->db_name,
218 mdb->db_password==NULL?"(NULL)":mdb->db_password);
220 if (sql_check(mdb)) {
221 Mmsg2(&mdb->errmsg, _("Unable to connect to Ingres server.\n"
222 "Database=%s User=%s\n"
223 "It is probably not running or your password is incorrect.\n"),
224 mdb->db_name, mdb->db_user);
229 mdb->connected = true;
231 if (!check_tables_version(jcr, mdb)) {
236 //sql_query(mdb, "SET datestyle TO 'ISO, YMD'");
238 /* check that encoding is SQL_ASCII */
239 check_database_encoding(jcr, mdb);
246 db_close_database(JCR *jcr, B_DB *mdb)
251 db_end_transaction(jcr, mdb);
253 sql_free_result(mdb);
255 if (mdb->ref_count == 0) {
257 if (mdb->connected && mdb->db) {
260 rwl_destroy(&mdb->lock);
261 free_pool_memory(mdb->errmsg);
262 free_pool_memory(mdb->cmd);
263 free_pool_memory(mdb->cached_path);
264 free_pool_memory(mdb->fname);
265 free_pool_memory(mdb->path);
266 free_pool_memory(mdb->esc_name);
267 free_pool_memory(mdb->esc_path);
274 if (mdb->db_password) {
275 free(mdb->db_password);
277 if (mdb->db_address) {
278 free(mdb->db_address);
280 if (mdb->db_socket) {
281 free(mdb->db_socket);
288 void db_check_backend_thread_safe()
293 void db_thread_cleanup()
297 * Return the next unique index (auto-increment) for
298 * the given table. Return NULL on error.
300 * For Ingres, NULL causes the auto-increment value SRE: true?
303 int db_next_index(JCR *jcr, B_DB *mdb, char *table, char *index)
305 strcpy(index, "NULL");
311 * Escape strings so that Ingres is happy
313 * NOTE! len is the length of the old string. Your new
314 * string must be long enough (max 2*old+1) to hold
315 * the escaped output.
318 db_escape_string(JCR *jcr, B_DB *mdb, char *snew, char *old, int len)
345 * Submit a general SQL command (cmd), and for each row returned,
346 * the sqlite_handler is called with the ctx.
348 bool db_sql_query(B_DB *mdb, const char *query, DB_RESULT_HANDLER *result_handler, void *ctx)
352 Dmsg0(500, "db_sql_query started\n");
355 if (sql_query(mdb, query) != 0) {
356 Mmsg(mdb->errmsg, _("Query failed: %s: ERR=%s\n"), query, sql_strerror(mdb));
358 Dmsg0(500, "db_sql_query failed\n");
361 Dmsg0(500, "db_sql_query succeeded. checking handler\n");
363 if (result_handler != NULL) {
364 Dmsg0(500, "db_sql_query invoking handler\n");
365 if (mdb->result != NULL) {
366 int num_fields = sql_num_fields(mdb);
368 Dmsg0(500, "db_sql_query sql_store_result suceeded\n");
369 while ((row = sql_fetch_row(mdb)) != NULL) {
371 Dmsg0(500, "db_sql_query sql_fetch_row worked\n");
372 if (result_handler(ctx, num_fields, row))
376 sql_free_result(mdb);
381 Dmsg0(500, "db_sql_query finished\n");
387 * Close database connection
389 void my_ingres_close(B_DB *mdb)
391 INGdisconnectDB(mdb->db);
392 //SRE: error handling?
395 INGRES_ROW my_ingres_fetch_row(B_DB *mdb)
398 INGRES_ROW row = NULL; // by default, return NULL
403 if (mdb->result->num_rows <= 0) {
407 Dmsg0(500, "my_ingres_fetch_row start\n");
409 if (!mdb->row || mdb->row_size < mdb->num_fields) {
410 int num_fields = mdb->num_fields;
411 Dmsg1(500, "we have need space of %d bytes\n", sizeof(char *) * mdb->num_fields);
414 Dmsg0(500, "my_ingres_fetch_row freeing space\n");
417 num_fields += 20; /* add a bit extra */
418 mdb->row = (INGRES_ROW)malloc(sizeof(char *) * num_fields);
419 mdb->row_size = num_fields;
421 // now reset the row_number now that we have the space allocated
422 //mdb->row_number = 1;
426 // if still within the result set
427 //if (mdb->row_number <= mdb->num_rows) {
428 if (mdb->row_number < mdb->num_rows) {
429 Dmsg2(500, "my_ingres_fetch_row row number '%d' is acceptable (0..%d)\n", mdb->row_number, mdb->num_rows);
430 // get each value from this row
431 for (j = 0; j < mdb->num_fields; j++) {
432 mdb->row[j] = INGgetvalue(mdb->result, mdb->row_number, j);
433 Dmsg2(500, "my_ingres_fetch_row field '%d' has value '%s'\n", j, mdb->row[j]);
435 // increment the row number for the next call
440 Dmsg2(500, "my_ingres_fetch_row row number '%d' is NOT acceptable (0..%d)\n", mdb->row_number, mdb->num_rows);
443 Dmsg1(500, "my_ingres_fetch_row finishes returning %p\n", row);
449 int my_ingres_max_length(B_DB *mdb, int field_num) {
451 // for a given column, find the max length
458 for (i = 0; i < mdb->num_rows; i++) {
459 if (INGgetisnull(mdb->result, i, field_num)) {
460 this_length = 4; // "NULL"
462 this_length = cstrlen(INGgetvalue(mdb->result, i, field_num));
465 if (max_length < this_length) {
466 max_length = this_length;
473 INGRES_FIELD * my_ingres_fetch_field(B_DB *mdb)
477 Dmsg0(500, "my_ingres_fetch_field starts\n");
479 if (!mdb->fields || mdb->fields_size < mdb->num_fields) {
483 Dmsg1(500, "allocating space for %d fields\n", mdb->num_fields);
484 mdb->fields = (INGRES_FIELD *)malloc(sizeof(INGRES_FIELD) * mdb->num_fields);
485 mdb->fields_size = mdb->num_fields;
487 for (i = 0; i < mdb->num_fields; i++) {
488 Dmsg1(500, "filling field %d\n", i);
489 strcpy(mdb->fields[i].name,INGfname(mdb->result, i));
490 mdb->fields[i].max_length = my_ingres_max_length(mdb, i);
491 mdb->fields[i].type = INGftype(mdb->result, i);
492 mdb->fields[i].flags = 0;
494 Dmsg4(500, "my_ingres_fetch_field finds field '%s' has length='%d' type='%d' and IsNull=%d\n",
495 mdb->fields[i].name, mdb->fields[i].max_length, mdb->fields[i].type,
496 mdb->fields[i].flags);
500 // increment field number for the next time around
502 Dmsg0(500, "my_ingres_fetch_field finishes\n");
503 return &mdb->fields[mdb->field_number++];
506 void my_ingres_data_seek(B_DB *mdb, int row)
508 // set the row number to be returned on the next call
509 // to my_ingres_fetch_row
510 mdb->row_number = row;
513 void my_ingres_field_seek(B_DB *mdb, int field)
515 mdb->field_number = field;
519 * Note, if this routine returns 1 (failure), Bacula expects
520 * that no result has been stored.
522 * Returns: 0 on success
526 int my_ingres_query(B_DB *mdb, const char *query)
528 Dmsg0(500, "my_ingres_query started\n");
529 // We are starting a new query. reset everything.
531 mdb->row_number = -1;
532 mdb->field_number = -1;
537 INGclear(mdb->result); /* hmm, someone forgot to free?? */
541 Dmsg1(500, "my_ingres_query starts with '%s'\n", query);
543 /* TODO: differentiate between SELECTs and other queries */
545 if ((cols = INGgetCols(query)) <= 0) {
547 Dmsg0(500,"my_ingres_query: neg.columns: no DML stmt!\n");
549 Dmsg0(500,"my_ingres_query (non SELECT) starting...\n");
551 mdb->num_rows = INGexec(mdb->db, query);
553 Dmsg0(500,"my_ingres_query (non SELECT) went wrong\n");
556 Dmsg0(500,"my_ingres_query (non SELECT) seems ok\n");
561 Dmsg0(500,"my_ingres_query (SELECT) starting...\n");
562 mdb->result = INGquery(mdb->db, query);
563 if ( mdb->result != NULL ) {
564 Dmsg1(500, "we have a result\n", query);
566 // how many fields in the set?
567 mdb->num_fields = (int)INGnfields(mdb->result);
568 Dmsg1(500, "we have %d fields\n", mdb->num_fields);
570 mdb->num_rows = INGntuples(mdb->result);
571 Dmsg1(500, "we have %d rows\n", mdb->num_rows);
573 mdb->status = 0; /* succeed */
575 Dmsg0(500, "No resultset...\n");
576 mdb->status = 1; /* failed */
580 Dmsg0(500, "my_ingres_query finishing\n");
584 void my_ingres_free_result(B_DB *mdb)
589 INGclear(mdb->result);
605 int my_ingres_currval(B_DB *mdb, const char *table_name)
611 #ifdef HAVE_BATCH_FILE_INSERT
613 int my_ingres_batch_start(JCR *jcr, B_DB *mdb)
619 /* set error to something to abort operation */
620 int my_ingres_batch_end(JCR *jcr, B_DB *mdb, const char *error)
626 int my_ingres_batch_insert(JCR *jcr, B_DB *mdb, ATTR_DBR *ar)
632 #endif /* HAVE_BATCH_FILE_INSERT */
635 * Escape strings so that Ingres is happy on COPY
637 * NOTE! len is the length of the old string. Your new
638 * string must be long enough (max 2*old+1) to hold
639 * the escaped output.
641 char *my_ingres_copy_escape(char *dest, char *src, size_t len)
643 /* we have to escape \t, \n, \r, \ */
646 while (len > 0 && *src) {
681 #ifdef HAVE_BATCH_FILE_INSERT
682 const char *my_ingres_batch_lock_path_query =
683 "BEGIN; LOCK TABLE Path IN SHARE ROW EXCLUSIVE MODE";
686 const char *my_ingres_batch_lock_filename_query =
687 "BEGIN; LOCK TABLE Filename IN SHARE ROW EXCLUSIVE MODE";
689 const char *my_ingres_batch_unlock_tables_query = "COMMIT";
691 const char *my_ingres_batch_fill_path_query =
692 "INSERT INTO Path (Path) "
693 "SELECT a.Path FROM "
694 "(SELECT DISTINCT Path FROM batch) AS a "
695 "WHERE NOT EXISTS (SELECT Path FROM Path WHERE Path = a.Path) ";
698 const char *my_ingres_batch_fill_filename_query =
699 "INSERT INTO Filename (Name) "
700 "SELECT a.Name FROM "
701 "(SELECT DISTINCT Name FROM batch) as a "
703 "(SELECT Name FROM Filename WHERE Name = a.Name)";
704 #endif /* HAVE_BATCH_FILE_INSERT */
706 #endif /* HAVE_INGRES */