diff options
-rw-r--r-- | src/db.c | 10 | ||||
-rw-r--r-- | src/db.h | 2 | ||||
-rw-r--r-- | src/db_test.c | 2 | ||||
-rw-r--r-- | src/hlr.c | 2 | ||||
-rw-r--r-- | src/hlr_db_tool.c | 2 | ||||
-rw-r--r-- | tests/db/db_test.c | 4 | ||||
-rw-r--r-- | tests/db/db_test.err | 5 |
7 files changed, 13 insertions, 14 deletions
@@ -211,7 +211,7 @@ static int db_bootstrap(struct db_context *dbc) return 0; } -struct db_context *db_open(void *ctx, const char *fname) +struct db_context *db_open(void *ctx, const char *fname, bool enable_sqlite_logging) { struct db_context *dbc = talloc_zero(ctx, struct db_context); unsigned int i; @@ -233,9 +233,11 @@ struct db_context *db_open(void *ctx, const char *fname) has_sqlite_config_sqllog = true; } - rc = sqlite3_config(SQLITE_CONFIG_LOG, sql3_error_log_cb, NULL); - if (rc != SQLITE_OK) - LOGP(DDB, LOGL_NOTICE, "Unable to set SQLite3 error log callback\n"); + if (enable_sqlite_logging) { + rc = sqlite3_config(SQLITE_CONFIG_LOG, sql3_error_log_cb, NULL); + if (rc != SQLITE_OK) + LOGP(DDB, LOGL_NOTICE, "Unable to set SQLite3 error log callback\n"); + } if (has_sqlite_config_sqllog) { rc = sqlite3_config(SQLITE_CONFIG_SQLLOG, sql3_sql_log_cb, NULL); @@ -38,7 +38,7 @@ bool db_bind_text(sqlite3_stmt *stmt, const char *param_name, const char *text); bool db_bind_int(sqlite3_stmt *stmt, const char *param_name, int nr); bool db_bind_int64(sqlite3_stmt *stmt, const char *param_name, int64_t nr); void db_close(struct db_context *dbc); -struct db_context *db_open(void *ctx, const char *fname); +struct db_context *db_open(void *ctx, const char *fname, bool enable_sqlite3_logging); #include <osmocom/crypt/auth.h> diff --git a/src/db_test.c b/src/db_test.c index 0e823f9..7891c90 100644 --- a/src/db_test.c +++ b/src/db_test.c @@ -62,7 +62,7 @@ int main(int argc, char **argv) exit(1); } - g_hlr->dbc = db_open(NULL, "hlr.db"); + g_hlr->dbc = db_open(NULL, "hlr.db", true); if (!g_hlr->dbc) { LOGP(DMAIN, LOGL_ERROR, "Error opening database\n"); exit(1); @@ -460,7 +460,7 @@ int main(int argc, char **argv) exit(1); } - g_hlr->dbc = db_open(hlr_ctx, cmdline_opts.db_file); + g_hlr->dbc = db_open(hlr_ctx, cmdline_opts.db_file, true); if (!g_hlr->dbc) { LOGP(DMAIN, LOGL_FATAL, "Error opening database\n"); exit(1); diff --git a/src/hlr_db_tool.c b/src/hlr_db_tool.c index d8a3584..318308c 100644 --- a/src/hlr_db_tool.c +++ b/src/hlr_db_tool.c @@ -409,7 +409,7 @@ int main(int argc, char **argv) exit(EXIT_FAILURE); } - g_hlr_db_tool_ctx->dbc = db_open(g_hlr_db_tool_ctx, cmdline_opts.db_file); + g_hlr_db_tool_ctx->dbc = db_open(g_hlr_db_tool_ctx, cmdline_opts.db_file, true); if (!g_hlr_db_tool_ctx->dbc) { LOGP(DMAIN, LOGL_FATAL, "Error opening database\n"); exit(EXIT_FAILURE); diff --git a/tests/db/db_test.c b/tests/db/db_test.c index 389ed00..23b84cc 100644 --- a/tests/db/db_test.c +++ b/tests/db/db_test.c @@ -820,7 +820,9 @@ int main(int argc, char **argv) /* omit the SQLite version and compilation flags from test output */ log_set_log_level(osmo_stderr_target, LOGL_ERROR); - dbc = db_open(ctx, "db_test.db"); + /* Disable SQLite logging so that we're not vulnerable on SQLite error messages changing across + * library versions. */ + dbc = db_open(ctx, "db_test.db", false); log_set_log_level(osmo_stderr_target, 0); OSMO_ASSERT(dbc); diff --git a/tests/db/db_test.err b/tests/db/db_test.err index 0b09583..f7acfec 100644 --- a/tests/db/db_test.err +++ b/tests/db/db_test.err @@ -28,7 +28,6 @@ struct hlr_subscriber { } db_subscr_create(dbc, imsi0) --> -EIO -DDB (2067) abort at 18 in [INSERT INTO subscriber (imsi) VALUES ($imsi)]: UNIQUE constraint failed: subscriber.imsi DAUC IMSI='123456789000000': Cannot create subscriber: SQL error: (2067) UNIQUE constraint failed: subscriber.imsi db_subscr_get_by_imsi(dbc, imsi0, &g_subscr) --> 0 @@ -38,11 +37,9 @@ struct hlr_subscriber { } db_subscr_create(dbc, imsi1) --> -EIO -DDB (2067) abort at 18 in [INSERT INTO subscriber (imsi) VALUES ($imsi)]: UNIQUE constraint failed: subscriber.imsi DAUC IMSI='123456789000001': Cannot create subscriber: SQL error: (2067) UNIQUE constraint failed: subscriber.imsi db_subscr_create(dbc, imsi1) --> -EIO -DDB (2067) abort at 18 in [INSERT INTO subscriber (imsi) VALUES ($imsi)]: UNIQUE constraint failed: subscriber.imsi DAUC IMSI='123456789000001': Cannot create subscriber: SQL error: (2067) UNIQUE constraint failed: subscriber.imsi db_subscr_get_by_imsi(dbc, imsi1, &g_subscr) --> 0 @@ -52,11 +49,9 @@ struct hlr_subscriber { } db_subscr_create(dbc, imsi2) --> -EIO -DDB (2067) abort at 18 in [INSERT INTO subscriber (imsi) VALUES ($imsi)]: UNIQUE constraint failed: subscriber.imsi DAUC IMSI='123456789000002': Cannot create subscriber: SQL error: (2067) UNIQUE constraint failed: subscriber.imsi db_subscr_create(dbc, imsi2) --> -EIO -DDB (2067) abort at 18 in [INSERT INTO subscriber (imsi) VALUES ($imsi)]: UNIQUE constraint failed: subscriber.imsi DAUC IMSI='123456789000002': Cannot create subscriber: SQL error: (2067) UNIQUE constraint failed: subscriber.imsi db_subscr_get_by_imsi(dbc, imsi2, &g_subscr) --> 0 |