search for: res_config_sqlite3

I am using Realtime on Asterisk 11.5 with a SQLite3 backend. While everything seems to be working fine I keep getting this error on my log files: [2014-02-17 19:55:18] WARNING[20569] res_config_sqlite3.c: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = '5060', "regseconds" = '1392692118', "defaultuser" = '2012', "useragent" = 'Aastra 57i/3.2.2.2044', "las...

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT, "data3" > TEXT, "data4" TEXT, "dat...

I just finished migrating our web interface from Mysql to SQlite3 and everything seems to be working fine. I just have one detail. The following keeps appearing on my logs: [Apr 29 13:09:32] WARNING[30494]: res_config_sqlite3.c:520 realtime_sqlite3_execute_handle: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.0.52', "port" = '5060', "regseconds" = '1398795032', "defaultuser" = '112', "useragent" = 'Zo...

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

...d by Torrey Searle) * ASTERISK-28480 - json integer overflow in ssrc and timestamp (Reported by Salah Ahmed) * ASTERISK-28228 - res_pjsip: pjsip show contacts prints double entries (Reported by Ian Jones) * ASTERISK-28477 - Crash when not specifying "dbfile" in res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28478 - Crash performing "core reload" with modified res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28282 - AST_SCHED_REPLACE_UNREF causes wait-on-self deadlocks (in chan_sip) (Reported by Walter Doekes) New Fe...

...eported by Salah Ahmed) * ASTERISK-28228 - res_pjsip: pjsip show contacts prints double entries (Reported by Ian Jones) * ASTERISK-28483 - packet lost on UDPTL wrap around (Reported by Torrey Searle) * ASTERISK-28477 - Crash when not specifying "dbfile" in res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28478 - Crash performing "core reload" with modified res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-26968 - chan_pjsip: Transfer() does not result in TRANSFERSTATUS reflecting SIP response to transfer (Rep...

...eported by Salah Ahmed) * ASTERISK-28228 - res_pjsip: pjsip show contacts prints double entries (Reported by Ian Jones) * ASTERISK-28483 - packet lost on UDPTL wrap around (Reported by Torrey Searle) * ASTERISK-28477 - Crash when not specifying "dbfile" in res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28478 - Crash performing "core reload" with modified res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-26968 - chan_pjsip: Transfer() does not result in TRANSFERSTATUS reflecting SIP response to transfer (Rep...

...eported by Salah Ahmed) * ASTERISK-28228 - res_pjsip: pjsip show contacts prints double entries (Reported by Ian Jones) * ASTERISK-28483 - packet lost on UDPTL wrap around (Reported by Torrey Searle) * ASTERISK-28477 - Crash when not specifying "dbfile" in res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28478 - Crash performing "core reload" with modified res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-26968 - chan_pjsip: Transfer() does not result in TRANSFERSTATUS reflecting SIP response to transfer (Rep...

...ry (Reported by Filip Jenicek) * ASTERISK-26802 - [patch] Integrity Check Of PJSIP Download Fails (Reported by Michael L. Young) * ASTERISK-15858 - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) * ASTERISK-26057 - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) * ASTERISK-23457 - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) * ASTERISK-26794 - http: Crash on Reload Only in ast_tcptls_server_start (Reported by Joshua Elson)...

...eported by Nicholas John Koch) * ASTERISK-26802 - [patch] Integrity Check Of PJSIP Download Fails (Reported by Michael L. Young) * ASTERISK-15858 - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) * ASTERISK-26057 - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) * ASTERISK-23457 - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) * ASTERISK-26794 - http: Crash on Reload Only in ast_tcptls_server_start (Reported by Joshua Elson)...

...eported by Salah Ahmed) * ASTERISK-28228 - res_pjsip: pjsip show contacts prints double entries (Reported by Ian Jones) * ASTERISK-28483 - packet lost on UDPTL wrap around (Reported by Torrey Searle) * ASTERISK-28477 - Crash when not specifying "dbfile" in res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28478 - Crash performing "core reload" with modified res_config_sqlite3.conf (Reported by Dennis) * ASTERISK-28282 - AST_SCHED_REPLACE_UNREF causes wait-on-self deadlocks (in chan_sip) (Reported by Walter Doekes) * ASTE...

...y Michael L. Young) - [ASTERISK-15858 <https://issues.asterisk.org/jira/browse/ASTERISK-15858>] - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) - [ASTERISK-26057 <https://issues.asterisk.org/jira/browse/ASTERISK-26057>] - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) - [ASTERISK-23457 <https://issues.asterisk.org/jira/browse/ASTERISK-23457>] - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) - [ASTERISK-26794 <https://issues.asterisk.org/jira/b...

...y Michael L. Young) - [ASTERISK-15858 <https://issues.asterisk.org/jira/browse/ASTERISK-15858>] - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) - [ASTERISK-26057 <https://issues.asterisk.org/jira/browse/ASTERISK-26057>] - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) - [ASTERISK-23457 <https://issues.asterisk.org/jira/browse/ASTERISK-23457>] - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) - [ASTERISK-26794 <https://issues.asterisk.org/jira/b...

...by Filip Jenicek) * ASTERISK-26802 - [patch] Integrity Check Of PJSIP Download Fails (Reported by Michael L. Young) * ASTERISK-15858 - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) * ASTERISK-26057 - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) * ASTERISK-23457 - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) * ASTERISK-26794 - http: Crash on Reload Only in ast_tcptls_server_start (Reported...

...icholas John Koch) * ASTERISK-26802 - [patch] Integrity Check Of PJSIP Download Fails (Reported by Michael L. Young) * ASTERISK-15858 - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) * ASTERISK-26057 - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) * ASTERISK-23457 - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) * ASTERISK-26794 - http: Crash on Reload Only in ast_tcptls_server_start (Reported...

...icholas John Koch) * ASTERISK-26802 - [patch] Integrity Check Of PJSIP Download Fails (Reported by Michael L. Young) * ASTERISK-15858 - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) * ASTERISK-26057 - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) * ASTERISK-23457 - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) * ASTERISK-26794 - http: Crash on Reload Only in ast_tcptls_server_start (Reported...

...ng) - [ASTERISK-15858 <https://issues.asterisk.org/jira/browse/ASTERISK-15858>] - [patch] Fix query with double backslash in string literals and stop log warnings (Reported by Humberto Figuera) - [ASTERISK-26057 <https://issues.asterisk.org/jira/browse/ASTERISK-26057>] - res_config_sqlite3 uses incorrect query - unnecessary escape (Reported by Stepan) - [ASTERISK-23457 <https://issues.asterisk.org/jira/browse/ASTERISK-23457>] - SQlite3: Realtime queue loading fails after PRAGMA query result (Reported by Scott Griepentrog) - [ASTERISK-26794 <https://issues.aste...