3 Bacula® - The Network Backup Solution
5 Copyright (C) 2003-2010 Free Software Foundation Europe e.V.
7 The main author of Bacula is Kern Sibbald, with contributions from
8 many others, a complete list can be found in the file AUTHORS.
9 This program is Free Software; you can redistribute it and/or
10 modify it under the terms of version two of the GNU General Public
11 License as published by the Free Software Foundation and included
14 This program is distributed in the hope that it will be useful, but
15 WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
17 General Public License for more details.
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
24 Bacula® is a registered trademark of Kern Sibbald.
25 The licensor of Bacula is the Free Software Foundation Europe
26 (FSFE), Fiduciary Program, Sumatrastrasse 25, 8006 Zürich,
27 Switzerland, email:ftf@fsfeurope.org.
30 * Bacula Catalog Database routines specific to Ingres
31 * These are Ingres specific routines
33 * Stefan Reddig, June 2009
34 * based uopn work done
35 * by Dan Langille, December 2003 and
36 * by Kern Sibbald, March 2000
41 /* The following is necessary so that we do not include
42 * the dummy external definition of DB.
44 #define __SQL_C /* indicate that this is sql.c */
53 /* -----------------------------------------------------------------------
55 * Ingres dependent defines and subroutines
57 * -----------------------------------------------------------------------
60 /* List of open databases */ /* SRE: needed for ingres? */
61 static BQUEUE db_list = {&db_list, &db_list};
63 static pthread_mutex_t mutex = PTHREAD_MUTEX_INITIALIZER;
66 * Retrieve database type
75 * Initialize database data structure. In principal this should
76 * never have errors, or it is really fatal.
79 db_init_database(JCR *jcr, const char *db_name, const char *db_user, const char *db_password,
80 const char *db_address, int db_port, const char *db_socket,
81 int mult_db_connections)
86 Jmsg(jcr, M_FATAL, 0, _("A user name for Ingres must be supplied.\n"));
89 P(mutex); /* lock DB queue */
90 if (!mult_db_connections) {
91 /* Look to see if DB already open */
92 for (mdb=NULL; (mdb=(B_DB *)qnext(&db_list, &mdb->bq)); ) {
93 if (bstrcmp(mdb->db_name, db_name) &&
94 bstrcmp(mdb->db_address, db_address) &&
95 mdb->db_port == db_port) {
96 Dmsg2(100, "DB REopen %d %s\n", mdb->ref_count, db_name);
99 return mdb; /* already open */
103 Dmsg0(100, "db_open first time\n");
104 mdb = (B_DB *)malloc(sizeof(B_DB));
105 memset(mdb, 0, sizeof(B_DB));
106 mdb->db_name = bstrdup(db_name);
107 mdb->db_user = bstrdup(db_user);
109 mdb->db_password = bstrdup(db_password);
112 mdb->db_address = bstrdup(db_address);
115 mdb->db_socket = bstrdup(db_socket);
117 mdb->db_port = db_port;
118 mdb->have_insert_id = TRUE;
119 mdb->errmsg = get_pool_memory(PM_EMSG); /* get error message buffer */
121 mdb->cmd = get_pool_memory(PM_EMSG); /* get command buffer */
122 mdb->cached_path = get_pool_memory(PM_FNAME);
123 mdb->cached_path_id = 0;
125 mdb->fname = get_pool_memory(PM_FNAME);
126 mdb->path = get_pool_memory(PM_FNAME);
127 mdb->esc_name = get_pool_memory(PM_FNAME);
128 mdb->esc_path = get_pool_memory(PM_FNAME);
129 mdb->allow_transactions = mult_db_connections;
130 qinsert(&db_list, &mdb->bq); /* put db in list */
135 /* Check that the database correspond to the encoding we want */
136 static bool check_database_encoding(JCR *jcr, B_DB *mdb)
138 /* SRE: TODO! Needed?
142 if (!db_sql_query(mdb, "SELECT getdatabaseencoding()", NULL, NULL)) {
143 Jmsg(jcr, M_ERROR, 0, "%s", mdb->errmsg);
147 if ((row = sql_fetch_row(mdb)) == NULL) {
148 Mmsg1(mdb->errmsg, _("error fetching row: %s\n"), sql_strerror(mdb));
149 Jmsg(jcr, M_ERROR, 0, "Can't check database encoding %s", mdb->errmsg);
151 ret = bstrcmp(row[0], "SQL_ASCII");
154 _("Encoding error for database \"%s\". Wanted SQL_ASCII, got %s\n"),
155 mdb->db_name, row[0]);
156 Jmsg(jcr, M_WARNING, 0, "%s", mdb->errmsg);
157 Dmsg1(50, "%s", mdb->errmsg);
166 * Check for errors in DBMS work
168 static int sql_check(B_DB *mdb)
172 if ((errorcode = INGcheck()) < 0) {
173 /* TODO: fill mdb->errmsg */
174 Mmsg(mdb->errmsg, "Something went wrong - still searching!\n");
175 } else if (errorcode > 0) {
176 /* just a warning, proceed */
182 * Now actually open the database. This can generate errors,
183 * which are returned in the errmsg
185 * DO NOT close the database or free(mdb) here !!!!
188 db_open_database(JCR *jcr, B_DB *mdb)
194 if (mdb->connected) {
198 mdb->connected = false;
200 if ((errstat=rwl_init(&mdb->lock)) != 0) {
202 Mmsg1(&mdb->errmsg, _("Unable to initialize DB lock. ERR=%s\n"),
203 be.bstrerror(errstat));
209 bsnprintf(buf, sizeof(buf), "%d", mdb->db_port);
215 mdb->db = INGconnectDB(mdb->db_name, mdb->db_user, mdb->db_password);
217 Dmsg0(50, "Ingres real CONNECT done\n");
218 Dmsg3(50, "db_user=%s db_name=%s db_password=%s\n", mdb->db_user, mdb->db_name,
219 mdb->db_password==NULL?"(NULL)":mdb->db_password);
221 if (sql_check(mdb)) {
222 Mmsg2(&mdb->errmsg, _("Unable to connect to Ingres server.\n"
223 "Database=%s User=%s\n"
224 "It is probably not running or your password is incorrect.\n"),
225 mdb->db_name, mdb->db_user);
230 mdb->connected = true;
232 if (!check_tables_version(jcr, mdb)) {
237 //sql_query(mdb, "SET datestyle TO 'ISO, YMD'");
239 /* check that encoding is SQL_ASCII */
240 check_database_encoding(jcr, mdb);
247 db_close_database(JCR *jcr, B_DB *mdb)
252 db_end_transaction(jcr, mdb);
254 sql_free_result(mdb);
256 if (mdb->ref_count == 0) {
258 if (mdb->connected && mdb->db) {
261 rwl_destroy(&mdb->lock);
262 free_pool_memory(mdb->errmsg);
263 free_pool_memory(mdb->cmd);
264 free_pool_memory(mdb->cached_path);
265 free_pool_memory(mdb->fname);
266 free_pool_memory(mdb->path);
267 free_pool_memory(mdb->esc_name);
268 free_pool_memory(mdb->esc_path);
275 if (mdb->db_password) {
276 free(mdb->db_password);
278 if (mdb->db_address) {
279 free(mdb->db_address);
281 if (mdb->db_socket) {
282 free(mdb->db_socket);
289 void db_check_backend_thread_safe()
294 void db_thread_cleanup()
298 * Return the next unique index (auto-increment) for
299 * the given table. Return NULL on error.
301 * For Ingres, NULL causes the auto-increment value SRE: true?
304 int db_next_index(JCR *jcr, B_DB *mdb, char *table, char *index)
306 strcpy(index, "NULL");
312 * Escape strings so that Ingres is happy
314 * NOTE! len is the length of the old string. Your new
315 * string must be long enough (max 2*old+1) to hold
316 * the escaped output.
320 db_escape_string(JCR *jcr, B_DB *mdb, char *snew, char *old, int len)
325 PQescapeStringConn(mdb->db, snew, old, len, &error);
327 Jmsg(jcr, M_FATAL, 0, _("PQescapeStringConn returned non-zero.\n"));*/
328 /* error on encoding, probably invalid multibyte encoding in the source string
329 see PQescapeStringConn documentation for details. */
330 /* Dmsg0(500, "PQescapeStringConn failed\n");
335 * Submit a general SQL command (cmd), and for each row returned,
336 * the sqlite_handler is called with the ctx.
338 bool db_sql_query(B_DB *mdb, const char *query, DB_RESULT_HANDLER *result_handler, void *ctx)
342 Dmsg0(500, "db_sql_query started\n");
345 if (sql_query(mdb, query) != 0) {
346 Mmsg(mdb->errmsg, _("Query failed: %s: ERR=%s\n"), query, sql_strerror(mdb));
348 Dmsg0(500, "db_sql_query failed\n");
351 Dmsg0(500, "db_sql_query succeeded. checking handler\n");
353 if (result_handler != NULL) {
354 Dmsg0(500, "db_sql_query invoking handler\n");
355 if ((mdb->result = sql_store_result(mdb)) != NULL) {
356 int num_fields = sql_num_fields(mdb);
358 Dmsg0(500, "db_sql_query sql_store_result suceeded\n");
359 while ((row = sql_fetch_row(mdb)) != NULL) {
361 Dmsg0(500, "db_sql_query sql_fetch_row worked\n");
362 if (result_handler(ctx, num_fields, row))
366 sql_free_result(mdb);
371 Dmsg0(500, "db_sql_query finished\n");
377 * Close database connection
379 void my_ingres_close(B_DB *mdb)
381 INGdisconnectDB(mdb->db);
382 //SRE: error handling?
385 INGRES_ROW my_ingres_fetch_row(B_DB *mdb)
388 INGRES_ROW row = NULL; // by default, return NULL
390 Dmsg0(500, "my_ingres_fetch_row start\n");
392 if (!mdb->row || mdb->row_size < mdb->num_fields) {
393 int num_fields = mdb->num_fields;
394 Dmsg1(500, "we have need space of %d bytes\n", sizeof(char *) * mdb->num_fields);
397 Dmsg0(500, "my_ingres_fetch_row freeing space\n");
400 num_fields += 20; /* add a bit extra */
401 mdb->row = (INGRES_ROW)malloc(sizeof(char *) * num_fields);
402 mdb->row_size = num_fields;
404 // now reset the row_number now that we have the space allocated
408 // if still within the result set
409 if (mdb->row_number < mdb->num_rows) {
410 Dmsg2(500, "my_ingres_fetch_row row number '%d' is acceptable (0..%d)\n", mdb->row_number, mdb->num_rows);
411 // get each value from this row
412 for (j = 0; j < mdb->num_fields; j++) {
413 mdb->row[j] = INGgetvalue(mdb->result, mdb->row_number, j);
414 Dmsg2(500, "my_ingres_fetch_row field '%d' has value '%s'\n", j, mdb->row[j]);
416 // increment the row number for the next call
421 Dmsg2(500, "my_ingres_fetch_row row number '%d' is NOT acceptable (0..%d)\n", mdb->row_number, mdb->num_rows);
424 Dmsg1(500, "my_ingres_fetch_row finishes returning %p\n", row);
430 int my_ingres_max_length(B_DB *mdb, int field_num) {
432 // for a given column, find the max length
439 for (i = 0; i < mdb->num_rows; i++) {
440 if (INGgetisnull(mdb->result, i, field_num)) {
441 this_length = 4; // "NULL"
443 this_length = cstrlen(INGgetvalue(mdb->result, i, field_num));
446 if (max_length < this_length) {
447 max_length = this_length;
454 INGRES_FIELD * my_ingres_fetch_field(B_DB *mdb)
458 Dmsg0(500, "my_ingres_fetch_field starts\n");
460 if (!mdb->fields || mdb->fields_size < mdb->num_fields) {
464 Dmsg1(500, "allocating space for %d fields\n", mdb->num_fields);
465 mdb->fields = (INGRES_FIELD *)malloc(sizeof(INGRES_FIELD) * mdb->num_fields);
466 mdb->fields_size = mdb->num_fields;
468 for (i = 0; i < mdb->num_fields; i++) {
469 Dmsg1(500, "filling field %d\n", i);
470 strcpy(mdb->fields[i].name,INGfname(mdb->result, i));
471 mdb->fields[i].max_length = my_ingres_max_length(mdb, i);
472 mdb->fields[i].type = INGftype(mdb->result, i);
473 mdb->fields[i].flags = 0;
475 Dmsg4(500, "my_ingres_fetch_field finds field '%s' has length='%d' type='%d' and IsNull=%d\n",
476 mdb->fields[i].name, mdb->fields[i].max_length, mdb->fields[i].type,
477 mdb->fields[i].flags);
481 // increment field number for the next time around
483 Dmsg0(500, "my_ingres_fetch_field finishes\n");
484 return &mdb->fields[mdb->field_number++];
487 void my_ingres_data_seek(B_DB *mdb, int row)
489 // set the row number to be returned on the next call
490 // to my_ingres_fetch_row
491 mdb->row_number = row;
494 void my_ingres_field_seek(B_DB *mdb, int field)
496 mdb->field_number = field;
500 * Note, if this routine returns 1 (failure), Bacula expects
501 * that no result has been stored.
503 * Returns: 0 on success
507 int my_ingres_query(B_DB *mdb, const char *query)
509 Dmsg0(500, "my_ingres_query started\n");
510 // We are starting a new query. reset everything.
512 mdb->row_number = -1;
513 mdb->field_number = -1;
518 INGclear(mdb->result); /* hmm, someone forgot to free?? */
522 Dmsg1(500, "my_ingres_query starts with '%s'\n", query);
524 /* TODO: differentiate between SELECTs and other queries */
526 if ((cols = INGgetCols(query)) <= 0) {
528 Dmsg0(500,"my_ingres_query: neg.columns: no DML stmt!\n");
530 Dmsg0(500,"my_ingres_query (non SELECT) starting...\n");
532 mdb->num_rows = INGexec(mdb->db, query);
534 Dmsg0(500,"my_ingres_query (non SELECT) went wrong\n");
537 Dmsg0(500,"my_ingres_query (non SELECT) seems ok\n");
542 Dmsg0(500,"my_ingres_query (SELECT) starting...\n");
543 mdb->result = INGquery(mdb->db, query);
544 if ( mdb->result != NULL ) {
545 Dmsg1(500, "we have a result\n", query);
547 // how many fields in the set?
548 mdb->num_fields = (int)INGnfields(mdb->result);
549 Dmsg1(500, "we have %d fields\n", mdb->num_fields);
551 mdb->num_rows = INGntuples(mdb->result);
552 Dmsg1(500, "we have %d rows\n", mdb->num_rows);
554 mdb->status = 0; /* succeed */
556 Dmsg0(500, "No resultset...\n");
557 mdb->status = 1; /* failed */
561 Dmsg0(500, "my_ingres_query finishing\n");
565 void my_ingres_free_result(B_DB *mdb)
570 INGclear(mdb->result);
586 int my_ingres_currval(B_DB *mdb, const char *table_name)
592 #ifdef HAVE_BATCH_FILE_INSERT
594 int my_ingres_batch_start(JCR *jcr, B_DB *mdb)
600 /* set error to something to abort operation */
601 int my_ingres_batch_end(JCR *jcr, B_DB *mdb, const char *error)
607 int my_ingres_batch_insert(JCR *jcr, B_DB *mdb, ATTR_DBR *ar)
613 #endif /* HAVE_BATCH_FILE_INSERT */
616 * Escape strings so that Ingres is happy on COPY
618 * NOTE! len is the length of the old string. Your new
619 * string must be long enough (max 2*old+1) to hold
620 * the escaped output.
622 char *my_ingres_copy_escape(char *dest, char *src, size_t len)
624 /* we have to escape \t, \n, \r, \ */
627 while (len > 0 && *src) {
662 #ifdef HAVE_BATCH_FILE_INSERT
663 const char *my_ingres_batch_lock_path_query =
664 "BEGIN; LOCK TABLE Path IN SHARE ROW EXCLUSIVE MODE";
667 const char *my_ingres_batch_lock_filename_query =
668 "BEGIN; LOCK TABLE Filename IN SHARE ROW EXCLUSIVE MODE";
670 const char *my_ingres_batch_unlock_tables_query = "COMMIT";
672 const char *my_ingres_batch_fill_path_query =
673 "INSERT INTO Path (Path) "
674 "SELECT a.Path FROM "
675 "(SELECT DISTINCT Path FROM batch) AS a "
676 "WHERE NOT EXISTS (SELECT Path FROM Path WHERE Path = a.Path) ";
679 const char *my_ingres_batch_fill_filename_query =
680 "INSERT INTO Filename (Name) "
681 "SELECT a.Name FROM "
682 "(SELECT DISTINCT Name FROM batch) as a "
684 "(SELECT Name FROM Filename WHERE Name = a.Name)";
685 #endif /* HAVE_BATCH_FILE_INSERT */
687 #endif /* HAVE_INGRES */