Bug#657680: realtime support for followme is underdocumented

[Clint Adams]

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 at 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 at magic-voicemail,u)
exten => 1000,n,Hangup



Am I missing anything?