Details

    • Type: New Feature New Feature
    • Status: Closed
    • Severity: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Target Release Version/s: None
    • Component/s: Applications/app_queue
    • Labels:
      None
    • SVN Revision Number:
      94615
    • Mantis ID:
      11625
    • Regression:
      No

      Description

      No more silly Perl scripts, store queue_log in your favorite RT engine directly.

                • ADDITIONAL INFORMATION ******

      Sample queue_log table for MySQL:

      CREATE TABLE `queue_log` (
      `id` int(10) unsigned NOT NULL auto_increment,
      `time` int(10) unsigned default NULL,
      `callid` varchar(32) NOT NULL default '',
      `queuename` varchar(32) NOT NULL default '',
      `agent` varchar(32) NOT NULL default '',
      `event` varchar(32) NOT NULL default '',
      `data` varchar(255) NOT NULL default '',
      PRIMARY KEY (`id`)
      );

      queue_log message consists of 2 parts: constant and variable. Constant part is splited among corresponding fields (time, callid, queuename, agent, event). Variable data is stored in `data` field as is, so you'll meet | there. Examples:

      mysql> select * from queue_log;
      -------------------------------------------------------

      id time callid queuename agent event data

      -------------------------------------------------------

      1 1198356717 1198356717.0 test NONE ENTERQUEUE   serg
      2 1198356719 1198356717.0 test NONE ABANDON 1 1 2

      -------------------------------------------------------

      I hope that asterisk community would love this patch.

        Activity

        Hide
        Sergey Tamkovich added a comment -

        to activate RT logging add a line like

        queue_log => mysql,asterisk

        to your extconfig.conf

        Show
        Sergey Tamkovich added a comment - to activate RT logging add a line like queue_log => mysql,asterisk to your extconfig.conf
        Hide
        Digium Subversion added a comment -

        Repository: asterisk
        Revision: 94782

        U trunk/CHANGES
        U trunk/configs/extconfig.conf.sample
        U trunk/main/logger.c

        ------------------------------------------------------------------------
        r94782 | mmichelson | 2007-12-26 09:54:52 -0600 (Wed, 26 Dec 2007) | 7 lines

        Adding support for storing the queue log entries in a realtime backend.

        (closes issue ASTERISK-11103, reported and patched by sergee)

        Thank you very much to sergee for adding this new feature!

        ------------------------------------------------------------------------

        http://svn.digium.com/view/asterisk?view=rev&revision=94782

        Show
        Digium Subversion added a comment - Repository: asterisk Revision: 94782 U trunk/CHANGES U trunk/configs/extconfig.conf.sample U trunk/main/logger.c ------------------------------------------------------------------------ r94782 | mmichelson | 2007-12-26 09:54:52 -0600 (Wed, 26 Dec 2007) | 7 lines Adding support for storing the queue log entries in a realtime backend. (closes issue ASTERISK-11103 , reported and patched by sergee) Thank you very much to sergee for adding this new feature! ------------------------------------------------------------------------ http://svn.digium.com/view/asterisk?view=rev&revision=94782

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development