similar to: [DB] Using SQLite instead of AST?

Hi. Is it possible to override the standard DB function in Asterisk? My dialplan contains a lot of calls to "Set(DB(...))" and "${DB(...)} which of course use astdb to store/read data. I would like to stop using astdb and switch to Clustered MySQL (I don't suppose "clustered astdb" exists?). So instead of rewriting extensions.conf and replacing the DB calls with

Hi listers, We want to implement one call center with asterisk. The idea is it should be scalable, with openser as an dispatcher and bunch of asterisk servers to do ACD, Queues, Agents things... Easy to say :( Look closely to the current asterisk, we do see some problem: - SIP registrations was stored in astdb. - And queue members also was stored in astdb. - ... asterisk was built as

Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc files. Because any missing file exception is ignored when checking for --if-newer, the lack of the Package files was not properly noticed, so the appliance was always considered out out date. Check for the SQLite-based DB first, falling back to the old format. Signed-off-by: Pino Toscano <ptoscano@redhat.com> ---

On Wednesday, 26 August 2020 21:15:36 CEST Richard W.M. Jones wrote: > On Wed, Aug 26, 2020 at 06:57:43PM +0200, Pino Toscano wrote: > > Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc > > files. Because any missing file exception is ignored when checking for > > --if-newer, the lack of the Package files was not properly noticed, so > > the

Hi all, My question is related to the sqlite db I''m using with my rails app. I was thinking if its possible to save the file (ROR_DIR/db/development.sqlite) and then if somehow the db gets erased or if I do a rollback and then a migrate can I retrieve my information by copying the file back to the same location ? Since I''m hosting the app from my linux box and most of colleagues

I've been searching the Internet for information regarding the replacement of astdb with a modern sql engine. There are several reasons one would like to do this. First of all, external applications have a hard time reading/writing to the now-old astdb format. Also (and this is what interests me most), the sql astdb could easily be clustered throughout several servers (I'm looking for a

I''ve been reading up on Berkeley DB and I''ve been refelcting on the Rails philosophy and it just seemed to me like the two should go together hand in glove. Rails seeks to abstract the programer from squirrely database coding which is great. My only problem is that you''re still left with a large component, namely the databsase server (MySQL, PostgreSQL..etc) which

I''m running OS/X 10.5 Leopard. Although I have MySQL installed the rails command creates a database.yml file that defaults to SQLite. How do I get it to default to MySQL instead? TIA --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

Just wondering if anyone is using a backend database other than sqlite, and if so, how easy/hard it was to configure. I''m constantly receiving "SQLite3::BusyException: database is locked..." which I presume is due to sqlite''s relatively coarse locking method. Cheers, James -- Senior Linux Platform Engineer Midrange Services AXA Technology Services - Asia Pacific

Is there any way to return multiple values from functions defined in func_odbc.conf? It appears that you can only return one value. True? Hope not.... Doug. ____________________________________________________________________________________ Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/ -------------- next part

Bear with me, this is CentOS related. :) I have a python CGI that's behaving weirldy on Whitebox systems that've been switched over to CentOS 4 (ages ago, no other problems to speak of aside from this one). I've broken the problem down to a minimal test case... 1. Create a small database # sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary key unique, name

I'm trying to use func_odbc to write to a MS SQL db. Here's my func_odbc conf: [OPTIN] dsn=MSSQL-Optin write=INSERT into OptIn (orgID) values (${VAL1}) Dial Plan exten => +18665551212,n,Set(ODBC_OPTIN()=dave) When I do an odbc show, it shows that I am connected to the db. If I use isql, I can write to the db, however, when I use func_odbc, a record will not write. I'm using

How can I change SQLite cache size for R session? SQLite cache size can be set by a pragma, for the duration of the session - or by default. .pragma cache_size .pragma default_cache_size my questions are about RSQLite, version 0.4, running on Windows: - what is the cache size set to when SQLite is invoked from R? - if the page_size is set to 4096 what will be the cache size in bytes

On Wed, Aug 26, 2020 at 06:57:43PM +0200, Pino Toscano wrote: > Fedora 33 switched the DB of RPM to SQLite, so no more Packages/Name/etc > files. Because any missing file exception is ignored when checking for > --if-newer, the lack of the Package files was not properly noticed, so > the appliance was always considered out out date. > > Check for the SQLite-based DB first,

CentOS-5.7 SQLite-3.6.6 Ruby on Rails 3.1 Ruby-1.8.7 I have a situation wherein the version of SQLite-3 on CentOS-5 is too 'old' for the Ruby language sqlite3 DBMS adapter to successfully build against. I managed to obtain an rpm for ruby-1.8.7 but I cannot find one for sqlite-3.6.16 or later. Does anyone here have a lead on where such a beast, including the sqlite development headers,

Hi, I am using Centos 4.6 on x86-64. recently when I tried to do a yum -y check-update this is the output I get [root at amd64 ~]# yum check-update Setting up repositories update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

Hi All, I am working on a POC that I''d like to show a group of 10 to 15 folks. I was wondering if sqlite would do for db with about 20 people hitting on the application. Does sqlite locking the entire db while writing manifest itself in such scenario? Regards, Kashyap

HI, I got the problem. I use the following query to read table individually, how can I read all tables autimatically rather than typing "week42" "week33" in dbReadTable? library(RSQLite) library(sqldf) drv <- dbDriver("SQLite") con<-dbConnect(drv, "sqlite.db") dbListTables(con) #dbRemoveTable(con, "week39") dbDisconnect(con)

Hi everyone, I am trying to insert a row in sqlite table with my own unique id. I want to create unique id using sqlite internal function last_insert_rowid() which returns the next max rowid of the table which is always unique. I tested this using sqlite and it works fine but when i run the same query using RSQlite from r prompt, my query doesn't create new unique id. last_insert_rowid()