On Wed, Feb 01, 2012 at 03:37:44AM +0200, Tzafrir Cohen wrote:
> However, could you please give a minimal example configuration that
> fails to work? Crashing is certainly something that should not happen.
extconfig.conf:
[settings]
followme => sqlite,asterisk,followme
followme_numbers => sqlite,asterisk,followme_numbers
res_config_sqlite.conf:
[general]
dbfile => /var/lib/asterisk/sqlite.db
config_table => ast_config
cdr_table => ast_cdr
sqlite2 schema:
CREATE TABLE 'ast_cdr' (
id INTEGER,
clid VARCHAR(80) NOT NULL DEFAULT '',
src VARCHAR(80) NOT NULL DEFAULT '',
dst VARCHAR(80) NOT NULL DEFAULT '',
dcontext VARCHAR(80) NOT NULL DEFAULT '',
channel VARCHAR(80) NOT NULL DEFAULT '',
dstchannel VARCHAR(80) NOT NULL DEFAULT '',
lastapp VARCHAR(80) NOT NULL DEFAULT '',
lastdata VARCHAR(80) NOT NULL DEFAULT '',
start DATETIME NOT NULL DEFAULT '0000-00-00
00:00:00',
answer DATETIME NOT NULL DEFAULT '0000-00-00
00:00:00',
end DATETIME NOT NULL DEFAULT '0000-00-00
00:00:00',
duration INT(11) NOT NULL DEFAULT 0,
billsec INT(11) NOT NULL DEFAULT 0,
disposition VARCHAR(45) NOT NULL DEFAULT '',
amaflags INT(11) NOT NULL DEFAULT 0,
accountcode VARCHAR(20) NOT NULL DEFAULT '',
uniqueid VARCHAR(32) NOT NULL DEFAULT '',
userfield VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
CREATE TABLE ast_config (
id INTEGER,
cat_metric INT(11) NOT NULL DEFAULT 0,
var_metric INT(11) NOT NULL DEFAULT 0,
commented TINYINT(1) NOT NULL DEFAULT 0,
filename VARCHAR(128) NOT NULL DEFAULT '',
category VARCHAR(128) NOT NULL DEFAULT 'default',
var_name VARCHAR(128) NOT NULL DEFAULT '',
var_val TEXT NOT NULL DEFAULT '',
PRIMARY KEY (id)
);
CREATE TABLE followme (
id INTEGER,
name varchar(20) NOT NULL,
musiconhold varchar(20) DEFAULT NULL,
context varchar(20) DEFAULT NULL,
takecall char(1) DEFAULT NULL,
declinecall char(1) DEFAULT NULL,
call_from_prompt varchar(35) DEFAULT NULL,
norecording_prompt varchar(35) DEFAULT NULL,
options_prompt varchar(35) DEFAULT NULL,
hold_prompt varchar(35) DEFAULT NULL,
status_prompt varchar(35) DEFAULT NULL,
sorry_prompt varchar(35) DEFAULT NULL,
commented tinyint(1) DEFAULT 0,
PRIMARY KEY (id),
UNIQUE (name)
);
CREATE TABLE followme_numbers (
id INTEGER,
name varchar(20) NOT NULL,
ordinal INTEGER NOT NULL,
phonenumber varchar(60) NOT NULL,
timeout INTEGER NOT NULL,
commented tinyint(1) DEFAULT 0,
PRIMARY KEY (id)
);
CREATE INDEX ast_config__idx__cat_metric ON
ast_config(cat_metric);
CREATE INDEX ast_config__idx__filename_commented ON ast_config(filename,
commented);
CREATE INDEX ast_config__idx__var_metric ON
ast_config(var_metric);
censored table contents:
sqlite> select * from followme;
1|clint|||||||||||0
sqlite> select * from followme_numbers;
1|clint|10|19876543210|30|0
censored dialplan:
exten => 1000,1,JabberSend(asterisk,xxx@xxx,${CALLERID(all)} is calling
extension 1000.)
exten => 1000,n,Dial(SIP/test1&SIP/test2,15)
exten => 1000,n,FollowMe(clint)
exten => 1000,n,Voicemail(1000@magic-voicemail,u)
exten => 1000,n,Hangup
Am I missing anything?
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
