SUGGESTIONS Using SCCP Manager Module not provisioning phones (not in realtime table 'sccpdevice')

Discussion in 'Endpoints' started by scurry7, Feb 17, 2014.

  1. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    I'm using chan-sccp-b with some Cisco phones. Also I'm using SCCP Manager Module. From what I can tell I've set it up properly, but obviously I'm missing something.

    The error:
    Code:
     SEP000DBCD92F62: is registering, Instance: 1, UserId: 0, Type: Cisco 7905 (20000), Version: 8 (loadinfo '')
    [2014-02-17 13:53:05] NOTICE[9154]: sccp_actions.c:517 sccp_handle_register: SEP000DBCD92F62: Rejecting device: Device Unknown
    
    I used these guides:

    my sccp.conf
    Code:
    cat /etc/asterisk/sccp.conf
    [general]
    servername = Asterisk
    keepalive = 60
    debug = core,event,device,channel
    context = from-internal
    dateFormat = D.M.Y
    bindaddr = 0.0.0.0
    port = 2000
    disallow=all
    allow=g722
    allow=alaw
    allow=ulaw
    firstdigittimeout = 16
    digittimeout = 8
    autoanswer_ring_time = 1
    autoanswer_tone = 0x32
    remotehangup_tone = 0x32
    transfer_tone = 0
    callwaiting_tone = 0x2d
    musicclass=default
    language=en
    permit=10.10.1.0/255.255.255.0
    deny=0.0.0.0/0.0.0.0
    dnd = off
    sccp_tos = 0x68
    sccp_cos = 4
    audio_tos = 0xB8
    audio_cos = 6
    video_tos = 0x88
    video_cos = 5
    echocancel = on
    silencesuppression = off
    private = off
    callanswerorder=oldestfirst
    meetme = on
    meetme = qxd
    hotline_enabled=no ; can devices without configuration register
    hotline_context=default ; context for hotline
    hotline_extension=2000 ; extension will be dialed on offHook
    devicetable=sccpdevice
    linetable=sccpline
    
    cat /etc/asterisk/extconfig.conf
    Code:
    sccpdevice => mysql,asterisk,sccpdevice
    sccpline => mysql,asterisk,sccpline
    
    I imported the mysql-v5.sql from sccp source successfully: (mysql ... asterisk < mysql-v5.sql)
    the database
    Code:
    mysql> select * from sccpdevice;
    +------+-------+-------------+----------+----------+---------+----------+-----------+--------------+------+--------+------------+-----------+----------+---------+-------                            ----+-------------+---------------+------------------+---------+---------+------+------------+-----------+-----------+-----------+-----------+------------+--------------                            --------------+-------------------------+--------------------+--------------------------+--------------------+--------+----------+-------+-----------------+----------+--                            ---------------+
    | type | addon | description | tzoffset | transfer | cfwdall | cfwdbusy | dtmfmode  | imageversion | deny | permit | dndFeature | directrtp | earlyrtp | mwilamp | mwionc                            all | pickupexten | pickupcontext | pickupmodeanswer | private | privacy | nat  | softkeyset | audio_tos | audio_cos | video_tos | video_cos | conf_allow | conf_play_gen                            eral_announce | conf_play_part_announce | conf_mute_on_entry | conf_music_on_hold_class | conf_show_conflist | setvar | disallow | allow | backgroundImage | ringtone | n                            ame            |
    +------+-------+-------------+----------+----------+---------+----------+-----------+--------------+------+--------+------------+-----------+----------+---------+-------                            ----+-------------+---------------+------------------+---------+---------+------+------------+-----------+-----------+-----------+-----------+------------+--------------                            --------------+-------------------------+--------------------+--------------------------+--------------------+--------+----------+-------+-----------------+----------+--                            ---------------+
    | 790X | NULL  | NULL        | NULL     | on       | on      | on       | outofband | NULL         | NULL | NULL   | on         | off       | progress | on      | on                                    | on          | NULL          | on               | on      | off     | off  | softkeyset | NULL      | NULL      | NULL      | NULL      | on         | on                                                     | on                      | off                | default                  | on                 | NULL   | NULL     | NULL  | NULL            | NULL     | S                            EP000DBCD92F62 |
    +------+-------+-------------+----------+----------+---------+----------+-----------+--------------+------+--------+------------+-----------+----------+---------+-------                            ----+-------------+---------------+------------------+---------+---------+------+------------+-----------+-----------+-----------+-----------+------------+--------------                            --------------+-------------------------+--------------------+--------------------------+--------------------+--------+----------+-------+-----------------+----------+--                            ---------------+
    1 row in set (0.00 sec)
    mysql> select * from sccpline;
    +------+------+-------+-------------+--------------------+---------------+----------+---------+-------+----------+---------+---------+---------------------------+-------------------------+------------+----------+-------------+------------+--------------------+-----------+-------------+----------+------+--------+------+
    | id   | pin  | label | description | context            | incominglimit | transfer | mailbox | vmnum | cid_name | cid_num | trnsfvm | secondary_dialtone_digits | secondary_dialtone_tone | musicclass | language | accountcode | echocancel | silencesuppression | callgroup | pickupgroup | amaflags | dnd  | setvar | name |
    +------+------+-------+-------------+--------------------+---------------+----------+---------+-------+----------+---------+---------+---------------------------+-------------------------+------------+----------+-------------+------------+--------------------+-----------+-------------+----------+------+--------+------+
    | 3000 | 3000 | 3000  | NULL        | from-internal-xfer | 2             | on       | 3000    | *97   | NULL     | 3000    | NULL    | NULL                      | NULL                    | default    | NULL     | NULL        | on         | off                | NULL      | NULL        | NULL     | on   | NULL   | 3000 |
    +------+------+-------+-------------+--------------------+---------------+----------+---------+-------+----------+---------+---------+---------------------------+-------------------------+------------+----------+-------------+------------+--------------------+-----------+-------------+----------+------+--------+------+
    1 row in set (0.00 sec)
    
     
  2. hbonath

    hbonath Guru

    Joined:
    Jan 24, 2012
    Messages:
    147
    Likes Received:
    36
    Did you define your extensions in FreePBX under Applications->Extensions?
    I believe that you need to have an extension in FreePBX first, even if you are not using SIP. Once it's created under the "Dial" section you need to change where it says SIP/3000 to SCCP/3000 so that when you point things like inbound routes to an extension it can actually dial your phone.

    Do you have /etc/asterisk/res_config_mysql.conf configured correctly? This should point to your "asterisk" database
    Should look like:
    Code:
    [general]
    ;dbhost = 127.0.0.1
    ;dbport = 3306
    dbsock = /var/run/mysqld/mysqld.sock
     
    [asterisk]
    dbname = asterisk
    dbuser = root
    dbpass = secretpassword
    
    Can you browse MySQL and see what's in the sccpdevice, sccpdeviceconfig, sccpdevmodel, and sccpline tables in the asterisk database?
    Code:
    pbx:~$ mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2589
    Server version: 5.5.35-0ubuntu0.12.04.1 (Ubuntu)
     
    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
     
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
     
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
     
    mysql> use asterisk;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
     
    Database changed
    mysql> select * from sccpline\G;
     
    *************************** 1. row ***************************
                          id: 2003
                          pin: NULL
                        label: Home Office
                  description: Ext 2003
                      context: from-internal-xfer
                incominglimit: 2
                    transfer: on
                      mailbox: 2003
                        vmnum: *97
    
    My assumption is that the tables are missing due to an issue with the res_config_mysql.conf or extension is missing from FreePBX.
    Either way, you are so close! I'm sure one of those is the ticket!
     
  3. hbonath

    hbonath Guru

    Joined:
    Jan 24, 2012
    Messages:
    147
    Likes Received:
    36
    Oops - I see you posted your MySQL output above! Missed that at the very bottom -
    Here's my /etc/asterisk/extconfig.conf

    Code:
    [settings]
    sccpdevice => mysql,asterisk,sccpdeviceconfig    ; make use of the sccpdeviceconfig view instead of sccpdevice
    sccpline => mysql,asterisk,sccpline
    
    Looks like mine is pointing sccpdevice to sccpdeviceconfig table - not sure the difference there...
     
  4. rjaiswal

    rjaiswal Moderator

    Joined:
    May 24, 2013
    Messages:
    408
    Likes Received:
    43
    Have you configured a hotline? Does the device register there?
     
  5. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    rjaiswal: yes hotline does register.
     
  6. rjaiswal

    rjaiswal Moderator

    Joined:
    May 24, 2013
    Messages:
    408
    Likes Received:
    43
    Have you configured the lines on the phone? Can you post the output of sccp show devices and sccp show lines?
     
  7. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    I did tinker with /etc/asterisk/res_config_mysql.conf and now I'm get this...think I'm getting closer:
    Code:
    [2014-02-18 10:59:47] WARNING[4608]: res_config_mysql.c:335 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf)
        -- SCCP: Device 'SEP000DBCD92F62' not found in realtime table 'sccpdevice'
    [2014-02-18 10:59:47] NOTICE[4608]: sccp_actions.c:517 sccp_handle_register: SEP000DBCD92F62: Rejecting device: Device Unknown
    


    my /etc/asterisk/res_config_mysql.conf
    Code:
    [general]
    dbhost = 127.0.0.1
    dbport = 3306
    dbsock = /var/run/mysqld/mysqld.sock
    dbname = asterisk
    dbuser = freepbxuser
    dbpass = w*******7
    



    when I connect to the database to show tables...

    mysql --user=freepbxuser --password=w*******7 asterisk
    Code:
    mysql> select * from sccpline\G;
    *************************** 1. row ***************************
                          id: 3000
                          pin: 3000
                        label: 3000
                  description: NULL
                      context: from-internal-xfer
                incominglimit: 2
                    transfer: on
                      mailbox: 3000
                        vmnum: *97
                    cid_name: NULL
                      cid_num: 3000
                      trnsfvm: NULL
    secondary_dialtone_digits: NULL
      secondary_dialtone_tone: NULL
                  musicclass: default
                    language: NULL
                  accountcode: NULL
                  echocancel: on
          silencesuppression: off
                    callgroup: NULL
                  pickupgroup: NULL
                    amaflags: NULL
                          dnd: on
                      setvar: NULL
                        name: 3000
    *************************** 2. row ***************************
                          id: 3001
                          pin: 3001
                        label: 3001
                  description: NULL
                      context: from-internal-xfer
                incominglimit: 2
                    transfer: on
                      mailbox: 3001
                        vmnum: *97
                    cid_name: NULL
                      cid_num: 3001
                      trnsfvm: NULL
    secondary_dialtone_digits: NULL
      secondary_dialtone_tone: NULL
                  musicclass: default
                    language: NULL
                  accountcode: NULL
                  echocancel: on
          silencesuppression: off
                    callgroup: NULL
                  pickupgroup: NULL
                    amaflags: NULL
                          dnd: on
                      setvar: NULL
                        name: 3001
    2 rows in set (0.00 sec)
     
    ERROR:
    No query specified
    
     
  8. rjaiswal

    rjaiswal Moderator

    Joined:
    May 24, 2013
    Messages:
    408
    Likes Received:
    43
    That's fine and all... It would be really helpful if you could post the results for sccp show devices and sccp show lines.
     
  9. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    Code:
    localhost*CLI> sccp show devices
     
    +--- Devices ----------------------------------------------------------------------------------------------------------------------------------+
    | Name                      Address                                      Mac              RegState  Token RegTime                  Act Lines |
    + ========================= ============================================ ================ ========== ===== ========================= === ===== +
    +----------------------------------------------------------------------------------------------------------------------------------------------+
    
    Code:
    localhost*CLI> sccp show lines
     
    +--- Lines ---------------------------------------------------------------------------------------------------------------------------+
    | Ext          Suffix    Label                          Device          MWI  Chs  Active Channel                                    |
    + ============= ========= ============================== ================ ==== ==== ================================================= +
    | Hotline                hotline                        --              OFF  0    --                                                |
    +-------------------------------------------------------------------------------------------------------------------------------------+
    
     
  10. rjaiswal

    rjaiswal Moderator

    Joined:
    May 24, 2013
    Messages:
    408
    Likes Received:
    43
    Ok. For some strange reason, chan-sccp is not reading from the database. Try putting spaces between the equal sign in the sccp.conf for sccpdevice and sccpline.


    Then do an amportal restart.

    Then post sccp show lines and sccp show devices.
     
  11. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    Think I should try to reinstall chan-sccp-b???

    I deleted form freepbx all sccp entries and the extensions from applications > extensions. Then re added everything and still asterisk -rx "sccp show lines" and show devices are empty.

    any ideas? (maybe a system reinstall..lol)

    Code:
    [[email protected] ~]# asterisk -rx "sccp show devices"
    Privilege escalation protection disabled!
    See https://wiki.asterisk.org/wiki/x/1gKfAQ for more details.
     
    +--- Devices ----------------------------------------------------------------------------------------------------------------------------------+
    | Name                      Address                                      Mac              RegState  Token RegTime                  Act Lines |
    + ========================= ============================================ ================ ========== ===== ========================= === ===== +
    +----------------------------------------------------------------------------------------------------------------------------------------------+
    [[email protected] ~]# asterisk -rx "sccp show line"
    Privilege escalation protection disabled!
    See https://wiki.asterisk.org/wiki/x/1gKfAQ for more details.
    SCCP CLI ERROR: LineName needs to be supplied
    Command 'sccp show line' failed.
    [roo[email protected] ~]# asterisk -rx "sccp show lines"
    Privilege escalation protection disabled!
    See https://wiki.asterisk.org/wiki/x/1gKfAQ for more details.
     
    +--- Lines ---------------------------------------------------------------------------------------------------------------------------+
    | Ext          Suffix    Label                          Device          MWI  Chs  Active Channel                                    |
    + ============= ========= ============================== ================ ==== ==== ================================================= +
    | Hotline                hotline                        --              OFF  0    --                                                |
    +-------------------------------------------------------------------------------------------------------------------------------------+
    [[email protected] ~]#
    
     
  12. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    Phone Registered! But its not able to make calls yet. I'll research this issue...but one step closer! (the problem was with my /etc/asterisk/res_config_mysql.conf)
    Code:
    [2014-02-18 14:55:45] NOTICE[4777]: sccp_actions.c:2195 sccp_handle_keypad_button: SEP000DBCD92F62: Could not find channel by callid 0 on line Undef                                        with instance 0! Using active channel 0 instead.
    [2014-02-18 14:55:45] NOTICE[4777]: sccp_actions.c:2202 sccp_handle_keypad_button: SEP000DBCD92F62: Device sent a Keypress, but there is no (active)                                        channel! Exiting
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2195 sccp_handle_keypad_button: SEP000DBCD92F62: Could not find channel by callid 0 on line Undef                                        with instance 0! Using active channel 0 instead.
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2202 sccp_handle_keypad_button: SEP000DBCD92F62: Device sent a Keypress, but there is no (active)                                        channel! Exiting
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2195 sccp_handle_keypad_button: SEP000DBCD92F62: Could not find channel by callid 0 on line Undef                                        with instance 0! Using active channel 0 instead.
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2202 sccp_handle_keypad_button: SEP000DBCD92F62: Device sent a Keypress, but there is no (active)                                        channel! Exiting
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2195 sccp_handle_keypad_button: SEP000DBCD92F62: Could not find channel by callid 0 on line Undef                                        with instance 0! Using active channel 0 instead.
    [2014-02-18 14:55:46] NOTICE[4777]: sccp_actions.c:2202 sccp_handle_keypad_button: SEP000DBCD92F62: Device sent a Keypress, but there is no (active)                                        channel! Exiting
    
    my working /etc/asterisk/res_config_mysql.conf
    Code:
     cat /etc/asterisk/res_config_mysql.conf
    [general]
    dbhost = localhost
    dbport = 3306
    dbsock = /var/run/mysqld/mysqld.sock
    [asterisk]
    dbname = asterisk
    dbuser = freepbxuser
    dbpass = w******7
    
     
  13. scurry7

    scurry7 Member

    Joined:
    Jun 29, 2010
    Messages:
    49
    Likes Received:
    0
    I assume my problem now is that asterisk -rx "sccp show lines" is empty except for hotline.

    From freepbx web interface: Doesn't the "sccp phones" create the entries I see in asterisk -rx "sccp show phones" then "sccp extensions" create the entries in asterisk -rx "sccp show lines"???
     
  14. rjaiswal

    rjaiswal Moderator

    Joined:
    May 24, 2013
    Messages:
    408
    Likes Received:
    43
    Ok. So, now the realtime database isn't seeing the sccplines table... Using the SCCP manager, have you assigned any lines to to the phone?

    With SCCP, you have to first add a custom extension using the extensions application. When creating the extension, under Device Options, you have put SCCP/(ext. number).

    After you create the extension in the Extensions Manger, you then Use the SCCP Manger and create a line. I'm not too familiar with the GUI, but if I remember correctly, You then have to use the SCCP Line manager and add the newly created extension to it.

    After that's done, you then use the SCCP button manager, and assign the newly created line to the device.

    It sounds long, but once you understand how SCCP works, it makes sense. SCCP will allow you to have the same extension on multiple phones. That's why there is a separate line database and device database. So, I could have extension 3000 on as many phones as I want, so when extension 3000 rings, every phone that has that extension assigned to it, will ring. I can then put a call on hold on phone one phone, and walk to another phone, and pick it up, without using parking lots....

    It's great for residential applications... :)

    If you're using only 1 or 2 SCCP devices, the configuration files are much easier to setup and get working. If you are provisioning a lot of phones, and making constant changes to those phones, then it makes sense to use the realtime database.