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

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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)
 

hbonath

Guru
Joined
Jan 24, 2012
Messages
147
Reaction score
36
Location
Columbus, OH
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!
 

hbonath

Guru
Joined
Jan 24, 2012
Messages
147
Reaction score
36
Location
Columbus, OH
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...
 

rjaiswal

Moderator
Joined
May 24, 2013
Messages
408
Reaction score
43
Location
New York
Have you configured the lines on the phone? Can you post the output of sccp show devices and sccp show lines?
 

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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
 

rjaiswal

Moderator
Joined
May 24, 2013
Messages
408
Reaction score
43
Location
New York
That's fine and all... It would be really helpful if you could post the results for sccp show devices and sccp show lines.
 

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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    --                                                |
+-------------------------------------------------------------------------------------------------------------------------------------+
 

rjaiswal

Moderator
Joined
May 24, 2013
Messages
408
Reaction score
43
Location
New York
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.
 

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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.
[[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] ~]#
 

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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
 

scurry7

Member
Joined
Jun 29, 2010
Messages
49
Reaction score
0
Location
Conroe, Texas
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"???
 

rjaiswal

Moderator
Joined
May 24, 2013
Messages
408
Reaction score
43
Location
New York
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.
 

Members online

PIAF 5 - Powered by 3CX

Forum statistics

Threads
22,274
Messages
136,540
Members
14,505
Latest member
athan